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

Intermediate Excel Training Benefits

Our Microsoft Excel Intermediate Courses in Singapore. Besides Microsoft Excel 2016 training, we also offer excel 2013 and Excel 2010 training courses. Register Now for quick enquiry to Find here a range of courses from 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*.