Excel 2016 - Level 3

loading..

loading..
or GET IT WITH SATVs

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data

  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros

  • Topic A: Create Sparklines
  • Topic B: Map Data

  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecasting Data Trends

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.
After completing this course, students will be able to:

Register

In Class

    Show all

    In Class

      Show all

      In Class

        Show all

        In Class

          Show all

          OnlineLive

            Show all

            Connected Classroom

              Show all

              Not currently scheduled

              Fast track the availability of this course.
              Add to watch list or call 1300 794 006.

              Need your team upskilled?
              Request a Quote
              blah is false
              top