$799

Excel 2016 Bootcamp - All 3 Days Jan 5, 12, 26

Event Information

Share this event

Date and Time

Location

Location

Downtown Athletic Club

999 Willamette St.

Eugene, OR 97401

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This is a 3-day instructor led classroom based Excel 2016 bootcamp, hosted by Catalyst Technology Group and New Horizons of Portland. Lunch and classroom PC's will be provided by Catalyst. E-mail questions to: events@catalyst-itgroup.com


You can attend just a single day by following the links below:

Day 1 - Intro to Excel

Day 2 - Intermediate

Day 3 - Advanced

DAY 1 - JAN 5th, 2018

1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL 2016

Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help

2 - PERFORMING CALCULATIONS

Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

3 - MODIFYING A WORKSHEET

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

4 - FORMATTING A WORKSHEET

Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

5 - PRINTING WORKBOOKS

Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

6 - MANAGING WORKBOOKS

Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

DAY 2 - JAN 12th, 2018

1 - WORKING WITH FUNCTIONS

Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions

2 - WORKING WITH LISTS

Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data

3 - ANALYZING DATA

Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting

4 - VISUALIZING DATA WITH CHARTS

Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features

5 - ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS

Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

DAY 3 - JAN 26th, 2018

1 - WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS

Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

2 - USING LOOKUP FORMULAS AND FORMULA AUDITING

Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas

3 - SHARING AND PROTECTING WORKBOOKS

Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

4 - AUTOMATING WORKBOOK FUNCTIONALITY

Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

5 - CREATING SPARKLINES AND MAPPING DATA

Topic A: Create Sparklines
Topic B: Map Data

6 - FORECASTING DATA

Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends

Share with friends

Date and Time

Location

Downtown Athletic Club

999 Willamette St.

Eugene, OR 97401

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved