Live Instructor-led Online Course

Mastering Advanced Excel Skills

Home / MS Office / Mastering Advanced Excel Skills

Course Fees: $289
Certificate : Yes
Course Type : Instructor-Led
Level : Essential
Subject : MS Office
Course Overview:

Microsoft Excel is a spreadsheet program. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. This course focuses on imparting the skills of using advanced Excel functions and formulas that are useful while working with values and cell references, analysing data. 

Learning Outcome:

Upon completion of this course, you will be able to do many types of arithmetic functions, data validation & analysis, What If analysis, and create VBA codes, among others. Key topics covered include:

  • Custom and Conditional Formats
  • Advanced Table Options
  • Using Formulas and Functions
  • Working with Name Range
  • Data Validation
  • Working with Pivot Table
  • What If Analysis
  • Array Functions
  • Working with Charts
  • Basics of working with Macros and VBA

Ideal for:

  • Anybody with basic exposure to computer
  • Ideal for those who use MS Excel for office and accounting purposes

 

Enquire now



Enquire Now



Straight from our learners' hearts.

It is always joyful to enable passionate learners in their journey to success. Catch our learners share their experience about learning on CloudKampus.

More videos