MICROSOFT EXCEL (ADVANCED LEVEL)

By LIVE ONLINE TRAINING

Date:

24 & 25 Jun 2024 (Every Session 9am to 5pm)

MON & TUE

Venue:

LIVE ZOOM

Share:

INTRODUCTION FOR MICROSOFT EXCEL (ADVANCED LEVEL)

This course will give you a deep understanding of the useful Excel functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Focus on what each Functions does, hands-on, contextual examples designed to showcase why these Functions are awesome and how they can be applied in several ways and how to troubleshoot formulas. Manipulating data using analysis tools, password settings and record actions using macros.

 

COURSE OBJECTIVE

  • Mastering the use of some of Excel’s most popular and highly sought-after functions (VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
  • Audit Excel Worksheet formulas to ensure clean formulas
  • Worksheets and Workbooks protection
  • Usefulness of the What-If Analysis
  • Automate your day-to-day Excel tasks by mastering the power of Macros

 

COURSE CONTENT

Excel List Functions

  • Introduction to Excels Function: DSUM()
  • Excel DSUM Function Single Criteria   Continued
  • Excel DSUM Function with OR Criteria
  • Excel DSUM Function with AND Criteria
  • Excel Function: DAVERAGE()
  • Excel Function: DCOUNT()
  • Excel Function: SUBTOTAL()

 

Working with Excel’s Conditional Functions

  • Using Excel’s IF() Function
  • Excel’s IF() Function with a Name Range
  • Nesting Functions with Excel
  • Nesting Excels AND() Function within the IF() Function
  • Using Excel’s COUNTIF() Function
  • Using Excel’s SUMIF() Function
  • Using Excel’s IFERROR() Function

 

Working with Excel’s Lookup Functions

  • Microsoft Excel VLOOKUP() Function
  • Microsoft Excel HLOOKUP() Function
  • Microsoft Excel INDEX() Function
  • Microsoft Excel MATCH() Function
  • Microsoft Excel INDEX() and MATCH() Function Combined
  • Microsoft Excel INDEX() and MATCH() Function Combined Continued
  • Creating a Dynamic HLOOKUP() with the MATCH() Function

 

Auditing an Excel Worksheet

  • Tracing Precedents in Excel Formulas
  • Tracing Dependents in Excel Formulas
  • Working with the Watch Window
  • Showing Formulas

 

Protecting Excel Worksheets and Workbooks

  • Protecting Specific Cells in a Worksheet
  • Protecting the Structure of a Workbook
  • Adding a Workbook Password

 

Mastering Excel’s “What If?” Tools

  • Working with Excel’s Goal Seek Tool
  • Working with Excel’s Solver Tool
  • Building Effective Data Tables in Excel
  • Creating Scenarios in Excel

 

Automating Repetitive Tasks in Excel with Macros

  • Understanding Excel Macros
  • Activating the Developer Tab in Excel
  • Creating a Macro with the Macro Recorder
  • Creating Buttons to Run Macros

 

HOW TO ENQUIRY FROM US?

  1. Fill in the form below and submit to us.
  2. Initiate a conversation via live chat on the bottom left of our website by stating: “Hi, my name is [your-name], Ive already submitted the form for this training.”
  3. Well promptly reach out to you regarding the training youre interested in.

 

MICROSOFT EXCEL (ADVANCED LEVEL)

ENQUIRY form

    ORGANIZATION DETAILS






    PERSON-IN-CHARGE DETAILS




    FOR FURTHER INFORMATION, PLEASE CONTACT US!