Excel Advanced

Who should attend

This live online Excel training is for anyone looking to master complex functions, including VLOOKUP and SUMIFS, and to learn the fundamentals of creating and editing macros that can automate processes in Excel. Knowledge of Excel Introduction and Intermediate concepts preferred.

Team Pass by Learnit

Excel Advanced

From $0
Two, 2-hour Modules (9am - 11:30am PT)

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

Course ID
EXCELApYfL
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Module 5: Advanced Functions User testing.com

Learning Outcomes:

  1. Use Advanced Database Functions (Xlookup, Sumif, averageif)
  2. Manipulate text within cells with the use of functions
  3. Putting functions together, also known as Nesting for complex calculations
  • Creating And Applying Names In A Worksheet
  • Using The IF Function
  • Introduction To Nesting Functions
  • The ROUND function
  • Using the Formula Auditing Tools
  • VLOOKUP Function
  • Using the IFERROR Function
  • XLOOKUP Function
  • Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Text Functions: Left, Right & Mid 
  • Concat, Text-To-Columns
  • Other Useful Functions 

Module 6: Using the "What If" Analysis Tools & Recording Macros 

Learning Outcomes:

  1. Be able to consolidate multiple sheets of data to one sheet 
  2. Create and run basic macros for common repetitive tasks in excel.
  3. Make Macros and Commands easier to use by customizing the ribbon or adding macro buttons
  • Using the Consolidate Data commands 
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and Running Macros
  • Introductions to Editing Macros with the Visual Basic Editor
  • Creating Buttons to Run Macros
  • Customizing the Ribbon

Skills covered

No items found.