Intermediate Excel Course

Course Start Date

Microsoft Excel Intermediate Course is a 1-day training focusing on Advanced Features, Functions and Commonly Used Formulas of Microsoft Excel.

Specifically, this Intermediate Excel Training help participants to learn Pivot Table, Chart, Sorting and Filtering Data as well as using Functions.

This is a hands-on Excel training where you will be working on exercises of each topic.

Claim 100% Fees From SkillsFuture Credit, No Upfront fees for Singaporean

Course Duration: 1 Days

Prerequisites: Student should have basic knowledge of Microsoft Office Excel, including but not limited to how to create, edit, format, and print worksheets as well as insert and use basic formulas (like sum, autosum). Click Here to Register

 Intermediate Excel Course Outlines

Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions

Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls

Applying Conditional Logic

  • Apply Data Validation
  • Work with Forms and Controls

Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Our Clients