Excel Boot Camp

Class Duration: 3 Days

Our Microsoft Excel Boot Camp covers most of our Excel content in an action packed 3 days. This Excel training includes the content from the Intermediate, Advanced, Pivot Tables and Charts, and Managing Databases classes, as well as some of the content from our Functions and Formulas class. This is not an overview class; instead, it will give you a thorough understanding of what you can do with this powerful spreadsheet application. Our instructors will lead you through this intensive Excel course, to take you from novice to master in just a few days.

Excel Boot Camp Goal

Students exiting the Microsoft Excel Boot Camp class will be comfortable using advanced features in Microsoft Excel to do a variety of tasks. They will understand formulas and functions in depth, will be able to expertly format spreadsheets, will know how to analyze and display data with pivot tables and charts, and will be able to share spreadsheets with others, as well as be able to create drop-downs and automation, and lock cells.

Prerequisites

Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.

Review of basic formulas
“IF” statement formulas
Conditional formatting
Using functions
Filling a series
Copying and pasting formulas
Organizing, copying, color coding
Using 3-D references and formulas
Hyperlinks
Screen tips
Formatting cells and appearance
Cell comments
Freezing panes
Grouping columns
Adding footers
Text functions
Arrays
Label formulas
Add ins
Look up values
Transposing data
Custom views
AutoFilters
Custom lists
Embedding
Linking and linking as icon
Locking cells, protecting worksheets and workbooks
Date and time
Mathematical functions
Text, database, financial functions
Informational, statistical, logic functions
Lookup and reference functions
Nesting IF statements
Data tables
Database functions
Reference Functions

PivotTables

Creating, sorting, and filtering data
Formatting styles, numbers, and layouts
Grouping data
Comparison and total options
Calculated fields and items
Combining multiple data sources
Conditional formatting
Pivot Charts

Excel Charts

Creating and modifying design, layout, and format
Creating charts from non-consecutive data
Drop-lines
Axis formatting
Replacing chart series with pictures or shapes
Analysis tools
Trending tools
Using secondary axis
Highlighting relationships differences with charts
Combining two charts into one

Database Management Tools

Arranging data
Filtering data
Conditional, formatting, sparklines
Watch window
Group and summarize data
Subtotal data
Removing duplicates
Custom views
Excel workspace
Page Break Preview

What-If Analysis Tools

Goal Seek
Solver
Scenarios

Macros

Planning and recording
Running
Viewing and editing VBA code
Saving

Collaboration Tools

Tracking changes
Sharing and merging workbooks

Our intensive Excel Boot Camp will enable you to master Excel’s features, so that you can have confidence in creating and manipulating spreadsheets. Our instructors are based in Denver and Phoenix, but can travel to any location in the nation. Our courses are designed specifically for companies and their employees.