- مدة الدورة التدريبية: 16 Hours
تفاصيل الدورة
This is one of our most popular classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running.
COURSE DETAILS
Getting Started
- Starting Excel
- Understanding the Display Screen
- Working with the Ribbon
- Working with the Quick Access Toolbar
- Exploring the File Tab
- Opening a Workbook
- Managing Open Workbooks
- Using Excel Help
Entering Data
- Moving the Cell Pointer
- Selecting a Range of Cells
- Creating a New Workbook
- Entering Constant Values
- Saving a Workbook
- Editing Cell Contents
- Clearing Cell Contents
- Working with Undo and Redo
- Closing a Workbook
- Exiting Excel
Using Formulas
- Entering Formulas
- Using the SUM Function
- Summing Columns or Rows Automatically
- Using Statistical Functions
- Working with the Range Finder
- Using Formula Error Checking
Working with Constant Values and Formulas
- Copying and Pasting Constant Values and Formulas
- Moving and Pasting Constant Values and Formulas
- Using Collect and Paste
- Using AutoFill
Formatting Worksheets
- Formatting Numbers
- Changing the Font Format
- Aligning Cell Contents
- Merging Cells
- Adding Borders
- Applying Cell Styles
- Modifying Columns and Rows
- Changing Column Width and Row Height
- Using AutoFit
- Inserting and Deleting Columns or Rows
- Hiding Columns or Rows
- Using Custom Worksheet Views
Editing Workbooks
- Working with AutoCorrect
- Checking Spelling
- Using Find and Replace
Printing Worksheets
- Using Print Preview
- Using Page Setup Tools
- Working in Page Layout View
- Creating a Header and Footer
- Using Page Break Preview
- Printing a Worksheet
المتطلبات
Excel 2013 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.
نبذة عن معهد Khawarizmi Training Solutions
The Continuing Education Center (CEC) at Al Khawarizmi International College (KIC) has been established since 1985 as a leading provider of training and development services for individuals and corporate groups in the UAE. The Continuing Education Center at KIC offers a wide range of courses in the fields of IT, Business and English Language. The training center has obtained partnerships with some of the most recognized training and testing organizations globally, such as Microsoft, Comptia, Adobe, Pearson Vue, Association of Business Practitioners (ABP), Project Management Institute (PMI), and King’s English School, which is currently running a branch at KIC.
Over the years, we have managed to build one of the strongest training methodologies in the region, which focuses on developing trainees on an individual basis, and making sure trainees are able to apply the knowledge they learn in their professional lives. To achieve this, some of the most qualified instructors globally have joined us, and today they play an integral role in providing our trainees with one-on-one attention.
عرض الجميع دورات Khawarizmi Training Solutions- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft 77-727-Microsoft Office - Excel 2016 Global Edulink137 USD
953 USDمدة الدورة التدريبية: Upto 17 Hours - Microsoft Office Excel 2016 One Education23 USD
343 USDمدة الدورة التدريبية: Upto 17 Hours
