HARTMANN software group

Advanced Microsoft Excel Training

We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  

The Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.

Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites
Intermedate Excel skills.

Course Outline

  
  1. Using PivotTables
    1. How PivotTables Work
    2. Timeline Filters
    3. Inserting Slicers
    4. Grouping Data
    5. Calculated Fields
    6. PivotCharts
    7. Working with PivotTables (Exercise)
  2. Advanced Functions
    1. Function Syntax
    2. ROWS, COLUMNS, INDEX, and XMATCH
    3. Arrays and Array Formulas
    4. Getting Unique Values (Exercise)
    5. SORT, FILTER, and SORTBY
    6. Lookup Functions
    7. Using the XLOOKUP Function (Exercise)
    8. The LET Function
    9. The TRANSPOSE Function
  3. Auditing Workbooks
    1. Inspecting a Workbook
    2. Tracing Precedents and Dependents
    3. Tracing Precedents and Dependents Practice (Exercise)
    4. Watch Window
    5. Evaluating Formulas
    6. Error Checking
  4. Data Tools
    1. Importing Data from online source
    2. Converting Text to Columns
    3. Converting Text to Columns (Exercise)
    4. Importing Files
    5. Importing Text Files (Exercise)
    6. Linking to External Data
    7. Controlling Calculation Options
    8. Data Validation
    9. Using Data Validation (Exercise)
    10. Consolidating Data
    11. Consolidating Data (Exercise)
    12. What-If Analysis
    13. Using Goal Seek (Exercise)
  5. Recording and Using Macros
    1. Recording Macros
    2. Recording a Macro (Exercise)
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
    6. Adding a Macro to the Quick Access Toolbar (Exercise)
  6. Working with Others
    1. Comments and Notes
    2. Protecting Worksheets and Workbooks
    3. Password Protecting a Workbook (Exercise)
    4. Marking a Workbook as Final
    5. Other Sharing Concerns

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.