Intermediate Excel Course

Course Start Date

Microsoft Excel Intermediate Training Course

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.

Duration: 1 Days

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

SkillsFuture Credit Eligible Training Center

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

Working with Functions

  • Work with Ranges name
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create a PivotTable
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and Pivot Charts

  • Create and Modify Tables
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers

Our Clients