Intermediate Excel Course

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

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