Give your kids a great start in tech. Get your 6 – 16 year old children registered for our 2-weeks practical ICT Classes and benefit from our massive discount this Easter season. REGISTER TODAY!

Basic & Advance Excel

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.

Download Brochure

DURATION:
2 Months
ID:
MS Excel 1, 2, 3

Address

Training @ any New Horizons Training Center   View map

Categories

Excel

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
  • 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.

Course Content

  • Getting Started with Microsoft Office Excel 2016
  • Modifying a Worksheet
  • Performing Calculations
  • Formatting a Worksheet
  • Printing Workbooks
  • Working With Functions
  • Working With Lists
  • Analyzing Data
  • Visualizing Data With Charts
  • Analyzing Data With PivotTables and PivotCharts
  • Working With Multiple Worksheets and Workbooks
  • Using Lookup Formulas and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data

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.

ENROLL NOW
×