Course Overview:

Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more.

Learning Objectives

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Access to a Professional Trainer with 10+ years of Excel Training

Target Audience

  • This Microsoft Excel courses will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced).
  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

 

Excel Basic

  • Getting Started with Microsoft Office Excel 2016
  • Modifying a Worksheet
  • Performing Calculations
  • Formatting a Worksheet
  • Printing Workbooks

Excel Intermediate

  • Working With Functions
  • Working With Lists
  • Analyzing Data
  • Visualizing Data With Charts
  • Analyzing Data With PivotTables and PivotCharts

Excel Advanced

  • Working With Multiple Worksheets and Workbooks
  • Using Lookup Formulas and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data

WHAT CLIENT'S SAY

Testimonials

I am satisfied with the training offered here and the instructor. I look forward to having another training session with New Horizons.
Imanche Victor Adeniy
ATC Nigeria
The Excel training was well laid out and the facilitator was very versed, he used multiple scenarios to explain the concept. I am very glad to have chosen New Horizons for this training.
Christian Udeh
AMCON 
The training is very excellent and it will help me to identify and resolve some database problems.
Hammed MuritalaMIS
IITA