Advanced Excel Training Classes in Denver Colorado

This class covers advanced concepts in Microsoft Excel and is designed for those who are already comfortable writing different types of formulas, formatting spreadsheets and text, and working across multiple worksheets.

Training class Goal

Students will come from this class feeling confident using many advanced features within Microsoft Excel, including nested IF statements, VLookups, Hlookups, PivotTables, Charts, and Validations.

Prerequisites

Understanding of Excel fundamentals including formatting, navigation, basic formulas, basic functions, basic charts

Advanced Excel Training Topics

• Advanced Formulas
  • Viewing available Excel functions
  • Basic text functions
  • Basic “IF” conditional formulas
  • Nesting “IF” statements
  • Concatenate and “IF” statements with concatenate
  • Arrays
  • Using name ranges in formulas
  • Other classes covering Formulas and Functions
• Customizing Data Views
  • Lookups and Lookup functions
  • HLookup
  • VLookup
  • Transposing data
  • Pivot Tables
  • Filtering PivotTables
  • PivotTable Charts
  • Other classes covering Navigation and Views
• Advanced Chart Techniques
  • Multiple series charts
  • Moving charts in a spreadsheet
  • Layout, title & labels
  • Adding picture backgrounds
  • Other classes covering Excel charts
• Page Formatting Techniques
  • Validations
  • Custom views
  • Creating a default view
  • Filters and grouping
  • Embedding and linking
  • Editing and embedded object
  • Editing a linked object
  • Linking as an icon
• Additional Tools in Advanced Excel
  • Protecting worksheets
  • Locking cells
  • Protecting a workbook