Basic
Lesson 1: Getting Started with Microsoft Excel 2016
Topic A: Identify the Elements of the Excel Interface
Topic B: Create a Basic Worksheet
Topic C: Use the Help System
Lesson 2: Performing Calculations
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Lesson 3: Modifying a Worksheet
Topic A: Manipulate Data
Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic C: Search For and Replace Data
Topic D: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Colors to Cells
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Cell Styles
Lesson 5: Printing Workbook Contents
Topic A: Define the Basic Page Layout for a Workbook
Topic B: Refine the Page Layout and Apply Print Options
Lesson 6: Managing Large Workbooks
Topic A: Format Worksheet Tabs
Topic B: Manage Worksheets
Topic C: Manage the View of Worksheets and Workbooks
Lesson 7: Customizing the Excel Environment
Topic A: Customize General and Language Options
Topic B: Customize Formula Options
Topic C: Customize Proofing and Save Options
Topic D: Customize the Ribbon and Quick Access Toolbar
Topic E: Customize the Functionality of Excel by Enabling Add-Ins
Topic F: Customize Advanced and Trust Center Options
Connect With Us!