Course Details

  • Course Code: OS-IT-XL3-1D
  • Mode of Delivery: Onsite
  • Duration: 1 Day
  • Price: On Request

Microsoft Excel L3

Course Overview

This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel®: Part 1 and Part 2 courses to help you get the most of your Excel experience. 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 right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

This course is intended for those who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

  • Microsoft Excel Level 1 & Level 2

Successful candidates will receive a certificate issued by National Training Institute LLC (NTI), attested by the Ministry of Higher Education

Other Details

Automating Worksheet Functionality

  • Update Workbook Properties
  • Create and Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Analyzing and Presenting Data

  • Create Sparklines
  • Create Scenarios  
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  •  Create Interactive Data with Power View
  • The Power View Add-In
  • How to Create a Power View Report
  • Crating a Power View Worksheet

Working with Multiple Workbooks

  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks

Exporting Excel Data

  • Export Excel Data
  • Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Crete a Web Query

By the end of the module the candidate will be able to:

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create spark lines and map data.
  • Forecast data.
Instructor led – Classroom training