Course Details

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

Microsoft Excel L2

Course Overview

This course is intended to help you get up to speed on the different features of Excel and to become familiar with more advanced selection of features. It will cover how to create and use advanced formulas, analyse data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

This course is designed for those who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

  • Microsoft Excel Level 1

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

Other Details

Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Analyzing Data with Logical and Lookup Functions

  • Leverage Questions and Testing to Write
  • Formulas
  • Use Logical and Lookup Functions to Find
  • Answers to Questions

Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to
  • Calculate Data

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trend line
  • Create Advanced Charts

Analyzing Data with PivotTables, Slicers, and Pivot Charts

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using Pivot Charts

Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

​​​​​​​​​​​​​​Enhancing Workbooks

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files

 

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

  • Work with Functions
  • Work with Lists
  • Analyse Data Visualize Data with Charts
  • Create advanced formulas
  • Analyse Data with PivotTables and Pivot Charts
Instructor led – Classroom training