Excel 2016 - Level 3

loading..
(Course eligible for SATVs)

loading..

This course builds on the foundation knowledge gained from Microsoft 2016 Levels 1 and 2. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel at your fingertips. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 exam and the Excel 2016 expert 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 (create, edit and secure)

  • 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.

To ensure success, students should have practical, real world experience in creating and analyzing datasets using Excel 2016. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables, presenting data by using basic charts; creating and working with pivot tables, slicers and pivot charts; and customising the Excel environment.

After completing this course, students will be able to:

  • Work with multiple worksheets and workbooks simultaneously
  • Use Lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create sparklines and map data
  • Create, secure and edit macros
  • Forecast data
  • Present your data visually

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          OnlineLive   

            Show all

            Connected Classroom   

              Show all

              Connected Classroom   

                Show all

                Connected Classroom   

                  Show all

                  Connected Classroom   

                    Show all

                    Flexible Mentored Learning   

                      Show all

                      Flexible Mentored Learning   

                        Show all

                        Flexible Mentored Learning   

                          Show all

                          Flexible Mentored Learning   

                            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