Course Name

Microsoft Excel 2019: Advanced Formulas – Level 3

  • Duration: 2 Day(s)
  • Date: On Request
  • Price: R3, 170.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. Excel is capable of doing so much more.

The ability to collaborate with colleagues and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.

Course Objectives

Upon successful completion of this course, you will be able to collaborate on workbooks with other users and use advanced functions.

You will:

  • Work with multiple worksheets and workbooks.
  • Work with logical, lookup, text, date and time functions.
  • Share and protect workbooks.
  • Determine potential outcomes using data tables

Course Content

  • Module 1: Working with Multiple Worksheets and Workbooks
    • Topic A: Use Links and External References
    • Topic B: Use 3-D References
    • Topic C: Consolidate Data
  • Module 2: Working with Functions
    • Topic A: Work with Ranges
    • Topic B: Use Specialized Functions
    • Topic C: Work with Logical Functions
    • Topic D: Work with Date and Time Functions
    • Topic E: Work with Text Functions
  • Module 3: Using Lookup Functions and Formula Auditing
    • Topic A: Use Lookup Functions
    • Topic B: Trace Cells
    • Topic C: Watch and Evaluate Formulas
  • Module 4: Sharing and Protecting Workbooks
    • Topic A: Collaborate on a Workbook
    • Topic B: Protect Worksheets and Workbooks
  • Module 5: Forecasting Data
    • Topic A: Determine Potential Outcomes Using Data Tables
    • Topic B: Use the Goal Seek Feature

Course Associated Exam and Certification

  • Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
  • Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
  • Appendix C: Microsoft Office Excel 2019 Common Keyboard Shortcuts
  • Appendix D: Financial Functions Appendix E: Using Array Formulas
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. Excel is capable of doing so much more.

The ability to collaborate with colleagues and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.

Course Objectives

Upon successful completion of this course, you will be able to collaborate on workbooks with other users and use advanced functions.

You will:

  • Work with multiple worksheets and workbooks.
  • Work with logical, lookup, text, date and time functions.
  • Share and protect workbooks.
  • Determine potential outcomes using data tables

Course Content

  • Module 1: Working with Multiple Worksheets and Workbooks
    • Topic A: Use Links and External References
    • Topic B: Use 3-D References
    • Topic C: Consolidate Data
  • Module 2: Working with Functions
    • Topic A: Work with Ranges
    • Topic B: Use Specialized Functions
    • Topic C: Work with Logical Functions
    • Topic D: Work with Date and Time Functions
    • Topic E: Work with Text Functions
  • Module 3: Using Lookup Functions and Formula Auditing
    • Topic A: Use Lookup Functions
    • Topic B: Trace Cells
    • Topic C: Watch and Evaluate Formulas
  • Module 4: Sharing and Protecting Workbooks
    • Topic A: Collaborate on a Workbook
    • Topic B: Protect Worksheets and Workbooks
  • Module 5: Forecasting Data
    • Topic A: Determine Potential Outcomes Using Data Tables
    • Topic B: Use the Goal Seek Feature

Course Exam And Certification

  • Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
  • Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
  • Appendix C: Microsoft Office Excel 2019 Common Keyboard Shortcuts
  • Appendix D: Financial Functions Appendix E: Using Array Formulas

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US