Singapore Intermediate & Advanced Excel Course combo

About Intermediate & Advanced Excel Course Singapore:

In this Intermediate & Advanced excel training combo, you will learn advanced functions and formulas to accelerate and automate your work. This course will help you to teach charts, file and protection of data, VBA Functions, automate regular tasks and many more.

To automate your daily Excel Reports, participants will learn how to perform advanced spreadsheet functions like Pivot Table, Formulas, and Functions.

Intermediate & Advanced Excel Course Combo

Duration: 02 Days (1-Day for Intermediate & 1-Day for Advanced)

Day 1 : Course Content For Intermediate Excel Session

For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table.

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

Day 2 : Course Content For Advanced Excel Session

For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro.

Working With Multiple Worksheets And Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Using Lookup Functions And Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Sharing And Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Creating Sparklines And Mapping Data

• Create Sparklines
• Map Data

Forecasting Data

• Determine Potential Outcomes using Data Tables
• Determine Potential Outcomes using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends

Excel is the most powerful tool for all Professionals. This Intermediate & Advanced Excel Combo Course in Singapore is launched to deliver knowledge of the most commonly used Advanced Excel formulas and functions like Pivot Table, an in-depth understanding of Charts, Macros, and Working with multiple worksheets.

No matter on which position you’re currently working, you must need an excel Intermediate & Advanced training combo course to boost your career

Intermediate & Advanced Excel Training Benefits

• Unmatched Efficiency- Automate tasks with complex formulas and macros.
• Deep Data Analysis- Unlock insights with advanced statistical tools.
• Streamlined Processes- Optimize workflows with sophisticated data management techniques.
• Strategic Decision-Making- Create dynamic reports and models for informed choices.
• Career Advancement- Gain a competitive edge with sought-after skills.

*If you’re Singaporean and you have got $500 with Skillsfuture, you no got to pay direct fee and your fees are going to be paid by SkillsFuture upto $500.