Excel 2016 - Level 3

Excel 2016 - Level 3

loading..
(Course eligible for SATVs)

loading..

The skills and knowledge acquired in Microsoft Excel 2016 - Level 3 are sufficient to be able to work with multiple worksheets and workbooks, lookup functions, share workbook, protect worksheet data, automate workbook functionality, macros, mapping data and forecasting data.

  • Understanding Data Linking
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Updating Links Between Workbooks
  • Understanding Data Consolidation
  • Consolidating With Identical Layouts
  • Creating a Linked Consolidation
  • Consolidating From Different Layouts
  • Consolidating Data Using the SUM Function
  • Understanding Data Lookup Functions
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using Match
  • Understanding Tracing Precedents
  • Understanding Tracing Dependents
  • Tracing Precedents and Dependents
  • Showing Formulas and Cell Arguments
  • Common Error Messages
  • Understanding Error Checking
  • Checking for Errors
  • Tracing Errors
  • Evaluating Formulas
  • Using the Watch Window
  • Working With Circular References
  • Sharing Workbooks via the Network
  • Sharing Workbooks via OneDrive
  • Saving to OneDrive
  • Sharing Workbooks
  • Opening Shared Workbooks
  • Enabling Tracked Changes
  • Accepting or Rejecting Changes
  • Disabling Tracked Changes
  • Adding Worksheet Comments
  • Navigating Worksheet Comments
  • Editing Worksheet Comments
  • Deleting Comments
  • Understanding Data Protection
  • Providing Total Access to Cells
  • Protecting a Worksheet
  • Working With a Protected Worksheet
  • Disabling Worksheet Protection
  • Providing Restricted Access to Cells
  • Password Protecting a Workbook
  • Opening a Password Protected Workbook
  • Removing a Password From a Workbook
  • Understanding Data Validation
  • Creating a Number Range Validation
  • Testing a Validation
  • Creating an Input Message
  • Creating an Error Message
  • Creating a Drop Down List
  • Using Formulas as Validation Criteria
  • Circling Invalid Data
  • Removing Invalid Circles
  • Copying Validation Settings
  • Understanding Excel Macros
  • Setting Macro Security
  • Saving a Document as Macro Enabled
  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Cell References
  • Running a Macro With Relative References
  • Viewing a Macro
  • Editing a Macro
  • Assigning a Macro to the Toolbar
  • Running a Macro From the Toolbar
  • Assigning a Macro to the Ribbon
  • Assigning a Keyboard Shortcut to a Macro
  • Deleting a Macro
  • Copying a Macro
  • Understanding Power Map
  • Creating a Power Map Tour
  • Working With Location Fields
  • Working With Mapping Confidence
  • Working With Height and Category Fields
  • Filtering Data
  • Navigating a Data Map
  • Changing the Look
  • Working With Layers
  • Working With Scenes
  • Working With Scene Options
  • Working With Time Settings
  • Viewing and Editing a Tour
  • Exporting a Tour as a Video
  • Understanding Data Tables and What-If Models
  • Using a Simple What-If Model
  • Creating a One-Variable Table
  • Using One-Variable Data Tables
  • Creating a Two-Variable Data Table
  • Understanding Scenarios
  • Creating a Default Scenario
  • Creating Scenarios
  • Using Names in Scenarios
  • Displaying Scenarios
  • Creating a Scenario Summary Report
  • Merging Scenarios
  • Understanding Goal Seeking
  • Using Goal Seek
  • Understanding Data Importing
  • Importing From an Earlier Version
  • Understanding Text File Formats
  • Importing Tab Delimited Text
  • Importing Comma Delimited Text
  • Importing Space Delimited Text
  • Importing Access Data
  • Working With Connected Data
  • Unlinking Connections
  • Exporting to Microsoft Word
  • Exporting Data as Text
  • Inserting a Picture
  • Modifying an Inserted Picture
  • Understanding Types of Controls
  • Understanding How Controls Work
  • Preparing a Worksheet for Controls
  • Adding a Combo Box Control
  • Changing Control Properties
  • Using the Cell Link to Display the Selection
  • Adding a List Box Control
  • Adding a Scroll Bar Control
  • Adding a Spin Button Control
  • Adding Option Button Controls
  • Adding a Group Box Control
  • Adding a Check Box Control
  • Protecting a Worksheet With Controls
  • Understanding Excel Options
  • Personalising Excel
  • Setting the Default Font
  • Setting Formula Options
  • Understanding Save Options
  • Setting Save Options
  • Setting the Default File Location
  • Setting Advanced Options

Microsoft Excel 2016 - Level 3 assumes some knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.

Key Participants Benefit

Upon successful completion of this course, you will be able to:

  • use data linking to create more efficient workbooks
  • use the Data Consolidation feature modify Excel options
  • use VLOOKUP, Index and Match lookup functions
  • use the Formula Auditing tools to find and fix formula errors
  • share workbooks with other users
  • protect data in worksheets and workbooks
  • use a variety of data validation techniques
  • create and record macros in Excel
  • effectively create and work with data in Power Map
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • use goal seeking to determine the values required to reach a desired result

Upon successful completion of this course,you will be able to work with multiple worksheets and workbooks, lookup functions, share workbook, protect worksheet data, automate workbook functionality, macros, mapping data and forecast data.

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          NextTech Live   

            Show all

            Flexible Mentored Learning   

              Show all

              Flexible Mentored Learning   

                Show all

                Flexible Mentored Learning   

                  Show all

                  Flexible Mentored Learning   

                    Show all

                    blah is false