Excel Boot Camp Levels 1-3 -- (03/23/20-03/26/20)

Course Date

Mon Mar 23, 8:00 AM - Thu Mar 26, 5:00 PM (AKDT)

Course Location

Anchorage Extension, 3201 C Street Suite 308, 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.
Insert Functions.
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 Worksheets.
Manage Workbook and Worksheet Views.
Manage Workbook Properties.# TRAINING SCHEDULE:

Day 3: Microsoft Office Excel 2016 -Part 2.

Lesson 1: Working with Functions.
Work with Ranges.
Use Specialized Functions.
Work with Logical Functions.
Work with Date & Time Functions.
Work with Text Functions.

Lesson 2: Working with Lists.
Sort Data.
Filter Data.
Query Data with Database Functions.
Outline and Subtotal Data.

Lesson 3: Analyzing Data.
Create and Modify Tables.
Apply Intermediate Conditional Formatting.
Apply Advanced Conditional Formatting.

Lesson 4: Visualizing Data with Charts.
Create Charts.
Modify and Format Charts.
Use Advanced Chart Features.

Lesson 5: Using PivotTables and Pivot Charts.
Create a PivotTable.
Analyze PivotTable Data.
Present Data with Pivot Charts.
Filter Data by Using Timelines and Slicers.

Day 4: Microsoft Office Excel 2016 -Part 3.

Lesson 1: Working with Multiple Worksheets and Workbooks.
Use Links and External References.
Use 3-D References.
Consolidate Data.

Lesson 2: Using Lookup Functions and Formula Auditing.
Use Lookup Functions.
Trace Cells.
Watch and Evaluate Formulas.

Lesson 3: Sharing and Protecting Workbooks.
Collaborate on a Workbook.
Protect Worksheets and Workbooks.

Lesson 4: Automating Workbook Functionality.
Apply Data Validation.
Search for Invalid Data and Formulas with Errors.
Work with Macros.

Lesson 5: Creating Sparklines and Mapping Data.
Create Sparklines.
Map Data.

Lesson 6: Forecasting Data.
Determine Potential Outcomes Using Data Tables.
Determine Potential Outcomes Using Scenarios.
Use the Goal Seek Feature.
Forecasting Data Trends.

Course Cost