- Duration: 36 Hours
Course details
Course Details
After completing this course, students will be able to:
- Customize the Excel environment.
- Create advanced formulas.
- Analyze data by using functions and conditional formatting.
- Organize and analyze datasets and tables
- Visualize data by using basic charts
- Analyze data by using PivotTables and PivotCharts
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
Eligibility / Requirements
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.
Job roles this course is suitable for:
Administrative Assistant , Administrative Officer-Computing Services Department , Account ExecutiveAbout Khawarizmi Training Solutions
Established in 1985, the Continuing Education Center (CEC) at Al Khawarizmi International College (KIC), now known as Khawarizmi Training Solutions (KTS) is a leading provider of training and professional development programs for individuals and corporate groups in the U.A.E. Continuing Education Center (CEC) at KIC offers a wide range of courses in the fields of IT, Business, and English. It is licensed by the Abu Dhabi Centre for Technical and Vocational Education and Training (ACTVET). Through challenging training courses, KTS Center contributes to the advancement and transformation of the UAE into a more skilled, diverse, and knowledge-based community. In turn, this raises the standards and the quality of life of our students and improves our community. Both individuals and industry professionals benefit from the high standards and good reputation of the KTS.
See all Khawarizmi Training Solutions courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Level 3 Apex LearningUSD 24
USD 480Duration: Upto 11 Hours - Microsoft Excel Complete Guide A-Z St. Paul's CollegeUSD 13Duration: Upto 2 Days
