HARTMANN software group

Advanced Microsoft Excel Training in Somerville

Enroll in or hire us to teach our Advanced Microsoft Excel class in Somerville, Massachusetts by calling us @303.377.6176. Like all HSG classes, Advanced Microsoft Excel may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Advanced Microsoft Excel may be taught at one of our local training facilities.
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.