Excel 2016 Level 1 -- (05/28/19 to 5/29/2019)
Course DateTue May 28, 8:30 AM - Wed May 29, 5:00 PM (AKDT)
Course LocationAnchorage Extension, 3700 Centerpoint Dr. Ste. 102, Anchorage, AK
Course times are scheduled from 8am to 5pm
This includes a 30-minute lunch at 12pm.
Day 1: Microsoft Office Excel 2016 - Part 1.
Lesson 1: Getting Started with Microsoft Office Excel.
Navigate the Excel User Interface.
Use Excel Commands.
Create and Save a Basic Workbook.
Enter Cell Data.
Use Excel Help.
Lesson 2: Performing Calculations.
Create Worksheet Formulas.
Reuse Formulas and Functions.
Lesson 3: Modifying a Worksheet.
Insert, Delete, and Adjust Cells, Columns, and Rows.
Search for and Replace Data.
Use Proofing and Research Tools.
Day 2: Microsoft Office Excel 2016 -Part 1.
Lesson 4: Formatting a Worksheet.
Apply Text Formats.
Apply Number Formats.
Align Cell Contents.
Apply Styles and Themes.
Apply Basic Conditional Formatting.
Create and Use Templates.
Lesson 5: Printing Workbooks.
Preview and Print a Workbook.
Set up the Page Layout.
Configure Headers and Footers.
Lesson 6: Managing Workbooks.
Manage Workbook and Worksheet Views.
Manage Workbook Properties.