Excel - Level 3

Course Content

Excel - Level 3

• Lesson 1: Data Linking
  • Understanding Data Linking
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Updating Links Between Workbooks
• Lesson 2: Data Consolidation
  • Understanding Data Consolidation
  • Consolidating With Identical Layouts
  • Creating a Linked Consolidation
  • Consolidating From Different Layouts
  • Consolidating Data Using the SUM Function
• Lesson 3: Lookup Functions Functions
  • Understanding Data Lookup Functions
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using Match
• Lesson 4: Formula Auditing
  • 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
• Lesson 5: Sharing Workbooks
  • 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
• Lesson 6: Protecting Data
  • 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
• Lesson 7: Validating Data
  • 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
• Lesson 8: Recorded Macros
  • 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
• Lesson 9: Power Map
  • 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
• Lesson 10: Data Tables
  • 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
• Lesson 11: Scenarios
  • Understanding Scenarios
  • Creating a Default Scenario
  • Creating Scenarios
  • Using Names in Scenarios
  • Displaying Scenarios
  • Creating a Scenario Summary Report
  • Merging Scenarios
• Lesson 12: Chart Elements
  • Understanding Goal Seeking
  • Using Goal Seek
• Appendix A: Importing and Exporting
  • 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
• Appendix B: Controls
  • 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
• Appendix C: Setting Excel Options
  • 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

FAQs

• How do I enrol in this online training?

  You can enrol in this training on our website and make an online payment using any of the following option

  • Visa Credit or Debit Card
  • MasterCard
  • American Express
  • Diners Club
  • PayPal

  Once payment is received, you will automatically receive a payment receipt and access information via email.