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
- 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: Training 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
- 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
Our Excel Intermediate & Advanced Courses in Singapore.
Besides Microsoft excel 2016 training, we also offer excel 2013 and Excel 2010 training courses. Register Today to find here a range of courses from best excel course singapore.
*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.