Excel Boot Camp

Course Description

Excel Boot Camp Training in Denver & Phoenix

excel_tip

Class Price: $1,150

What’s included – a $3,000 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Workshop – get 1on1 help from an instructor on your own work projects to help you apply what you learned, up to 6 months after the class
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Quick Tip sheet – color reference card with the top tips from class
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

Our Microsoft Excel Boot Camp covers most of our Excel content in an action packed 3 days. This Excel training in Denver & Phoenix includes the content from the intermediate, advanced, pivot tables and charts, functions and formulas, and managing databases classes. 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

This class starts at the Intermediate level, so students should already have basic Excel skills, including navigation, basic formatting, basic formulas, and entering data into a spreadsheet.

Topics Covered

  • 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.

Upcoming Classes

Excel Boot Camp
Oct 24 - Oct 26 8:00 am - 4:00 pm Excel Boot Camp Phoenix Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,150 What’s included – a $3,000 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 24-10-2018T08:00 24-10-2018T16:00 Active
Active 24-10-2018 Active 1,150.00 24-10-2018
Register Now
Access Boot Camp
Oct 29 - Nov 2 8:00 am - 4:00 pm Access Boot Camp Tech Center Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,650 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 29-10-2018T08:00 29-10-2018T16:00 Active
Active 29-10-2018 Active 1,650.00 29-10-2018
Register Now
Excel Boot Camp
Nov 5 - Nov 7 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,150 What’s included – a $3,000 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 05-11-2018T08:00 05-11-2018T16:00 Active
Active 05-11-2018 Active 1,150.00 05-11-2018
Register Now
Access Boot Camp
Jan 21 - Jan 24 8:00 am - 4:00 pm Access Boot Camp Phoenix Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 21-01-2019T08:00 21-01-2019T16:00 Active
Active 21-01-2019 Active 1,620.00 21-01-2019
Register Now
Excel Boot Camp
Feb 4 - Feb 6 8:00 am - 4:00 pm Excel Boot Camp Phoenix Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 04-02-2019T08:00 04-02-2019T16:00 Active
Active 04-02-2019 Active 1,215.00 04-02-2019
Register Now
Excel Boot Camp
Feb 25 - Feb 27 8:00 am - 4:00 pm Excel Boot Camp Westminster Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 25-02-2019T08:00 25-02-2019T16:00 Active
Active 25-02-2019 Active 1,215.00 25-02-2019
Register Now
Access Boot Camp
Apr 22 - Apr 25 8:00 am - 4:00 pm Access Boot Camp Westminster Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 22-04-2019T08:00 22-04-2019T16:00 Active
Active 22-04-2019 Active 1,620.00 22-04-2019
Register Now
Access Boot Camp
May 6 - May 9 8:00 am - 4:00 pm Access Boot Camp Phoenix Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 06-05-2019T08:00 06-05-2019T16:00 Active
Active 06-05-2019 Active 1,620.00 06-05-2019
Register Now
Excel Boot Camp
May 21 - May 23 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 21-05-2019T08:00 21-05-2019T16:00 Active
Active 21-05-2019 Active 1,215.00 21-05-2019
Register Now
Excel Boot Camp
Jun 10 - Jun 12 8:00 am - 4:00 pm Excel Boot Camp Phoenix Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 10-06-2019T08:00 10-06-2019T16:00 Active
Active 10-06-2019 Active 1,215.00 10-06-2019
Register Now
Excel Boot Camp
Aug 6 - Aug 8 8:00 am - 4:00 pm Excel Boot Camp Westminster Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 06-08-2019T08:00 06-08-2019T16:00 Active
Active 06-08-2019 Active 1,215.00 06-08-2019
Register Now
Access Boot Camp
Oct 1 - Oct 4 8:00 am - 4:00 pm Access Boot Camp Phoenix Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 01-10-2019T08:00 01-10-2019T16:00 Active
Active 01-10-2019 Active 1,620.00 01-10-2019
Register Now
Excel Boot Camp
Oct 8 - Oct 10 8:00 am - 4:00 pm Excel Boot Camp Phoenix Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3,130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 08-10-2019T08:00 08-10-2019T16:00 Active
Active 08-10-2019 Active 1,215.00 08-10-2019
Register Now
Access Boot Camp
Oct 14 - Oct 17 8:00 am - 4:00 pm Access Boot Camp Tech Center Access Boot Camp Access Boot Camp Training in Denver & Phoenix Class Price: $1,620 What’s included – a $3,800 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 14-10-2019T08:00 14-10-2019T16:00 Active
Active 14-10-2019 Active 1,620.00 14-10-2019
Register Now
Excel Boot Camp
Nov 11 - Nov 13 8:00 am - 4:00 pm Excel Boot Camp Tech Center Excel Boot Camp Excel Boot Camp Training in Denver & Phoenix Class Price: $1,215 What’s included – a $3130 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 11-11-2019T08:00 11-11-2019T16:00 Active
Active 11-11-2019 Active 1,215.00 11-11-2019
Register Now
Excel Boot Camp Tech Center Nov 5 - Nov 7  8:00 am - 4:00 pm

1,150.00

Attendee 1