Microsoft Excel 2016 (Intermediate to Advanced)
Introducing Excel
• What is an Electronic Spread sheet?
• What is Excel?
• Looking at the Screen
• Understanding Basic Terminology
• Mouse Symbols
• Using the Quick Access Toolbar
• Using the Ribbon
• Identifying Screen Symbols
• Entering Data in a Worksheet
• Types of Data
• Entering Text
• Entering Numbers
• Entering Dates and Time
• Inserting Symbols and Special Characters
• Moving Around the Worksheet
• Working with Workbooks
• Saving Workbooks
• Creating a New Workbook
• Switching Between Workbooks
• Opening a Workbook
• Closing a Workbook
• Working with the Compatibility Mode
• Managing Files and Folders
• Selecting Cells
-
Course Outline
- 1 Introducing Excel Preview
- 2 Constructing Cell Data Preview
- 3 Analyzing, Organizing and Sharing Workbooks Preview
- 4 Using Formulas Preview
- 5 Formatting the Worksheet Preview
- 6 Viewing and Printing Workbooks Preview
- 7 Working with Charts Preview
- 8 Working with Graphics Preview
- 9 Pivot Table & Macro Preview
- 10 Power BI Preview