Learn Microsoft Excel
Name:
Learn Microsoft Excel
Date:
May 2, 2018
Event Description:
Beginning Excel Basics Level I:
Creating and Opening Workbooks
Intro to Formulas
Saving and Sharing Workbooks
Working with Multiple Worksheets
Cell Basics
Using Find and Replace
Modifying Columns, Rows and Cells
Checking Spelling
Formatting Cells
Pay Layout and Printing
Understanding Number Formats
Creating More Complex Formulas
Beginning Excel and Design Basics Level II:
Intro to Formulas
Creating More Complex Formulas
Relative and Absolute Cell References
Functions
Basic Tips for Working with Data
Freezing Panes and View Options
Sorting/Filtering Data
Groups and Subtotals
Tables and Charts
Conditional Formatting
Beginning Excel and Design Basics Level III:
Tables and Charts
Conditional Formatting
Track Changes and Comments
Inspecting and Protecting Workbooks
Intro - Doing More with PivotTables
What-if Analysis
Solving Real-Life Problems in Excel
Use an Entire Column as a Cell Range
Creating and Opening Workbooks
Intro to Formulas
Saving and Sharing Workbooks
Working with Multiple Worksheets
Cell Basics
Using Find and Replace
Modifying Columns, Rows and Cells
Checking Spelling
Formatting Cells
Pay Layout and Printing
Understanding Number Formats
Creating More Complex Formulas
Beginning Excel and Design Basics Level II:
Intro to Formulas
Creating More Complex Formulas
Relative and Absolute Cell References
Functions
Basic Tips for Working with Data
Freezing Panes and View Options
Sorting/Filtering Data
Groups and Subtotals
Tables and Charts
Conditional Formatting
Beginning Excel and Design Basics Level III:
Tables and Charts
Conditional Formatting
Track Changes and Comments
Inspecting and Protecting Workbooks
Intro - Doing More with PivotTables
What-if Analysis
Solving Real-Life Problems in Excel
Use an Entire Column as a Cell Range
Event Media:
