Intermediate Excel Course

Physical Training Available, Fundings Applicable.

Singapore Microsoft Excel Intermediate Course

Intermediate Excel Course Objectives

Learn Formulas, Function, Validations, Forms & Controls and many advanced features of Excel in our Intermediate Excel Course.

Intermediate Excel Course Duration: 1 day

Course Content for This Intermediate Excel Training:

Lesson 1: Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions

Lesson 3: Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting

Lesson 5: Using PivotTables and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers

Lesson 2: Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data

Lesson 4: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features

Intermediate Excel Training Benefits

  • Enhanced Productivity- Streamline workflows and save time with advanced techniques.
  • Increased Accuracy- Ensure error-free spreadsheets with data validation and error checking.
  • Effective Data Analysis- Extract meaningful insights with PivotTables and statistical functions.
  • Professional Presentation- Create polished reports and presentations with advanced formatting.
  • Confidence in Complex Tasks- Tackle challenging projects confidently with advanced Excel skills.

We also offer excel 2013 and Excel 2010 training courses. Register Now for quick enquiry to Find here a range of courses from Microsoft excel intermediate course singapore.

*If you are Singaporean and you have $500 with Skillsfuture, you no need to pay upfront fee and your fees will be paid by SkillsFuture upto $500*.

phone icon+65 8421 2824
Send Enquiry
chat iconChat With Us
phone email enquiry whatsapp whatsapp