Are you looking to become a proficient Excel user? Professional Excel training from New Horizons can get you on the path to mastering this popular data spreadsheet software.

Course Overview

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

Course 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

Target Audience

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

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