how to apply Conditional Formatting –Â helps to analyse data by highlighting cells in a specified range that meet applied condition or criteria.
What Our Happy Participants Say
Previous
Next
Intellisoft Training: WSQ Funded IT Training in Singapore
Upgrade Skills With WSQ & SkillsFuture Funding from Singapore Government
Practical
The Best Advanced Excel Course in Singapore
Advanced Excel 2019 & Office 365 Training: Course Overview
The Advanced Excel 2019 / Office 365 training is a high-level Excel certification program which will enhance your skills to another level.Upon completion, you will master the more advanced formulas & functions of Excel, and be able to produce more sophisticated reports, perform complex mathematical calculations, saving time & improving productivity.
We focus on teaching you how to use the Advanced tools of Excel: Conditional & custom formatting, Pivot Tables, Advanced Filters, using templates, VLOOKUP & HLOOKUP, worksheet protection, recording macros and more.
We also provide you with a dedicated Laptop for use in the Advanced Excel 2019 class in Singapore, which has the Excel 2019 software preloaded, along with the exercises for practice in the Advanced Excel 2019 / Office 365 class. The whole training program is very practical and hands-on.
Learn Advanced Features of Microsoft Excel.
In Just 3 Days,
Master Pivot Tables, Vlookup, Macros & More...
This training will give you opportunities to practice with real world scenarios.
Master Excel 2019 / Office 365 Easily, Today!
Advanced Excel 2019 Training: Course Objectives
- Learn
how to apply Conditional Formatting –Â helps to analyse data by highlighting cells in a specified range that meet applied condition or criteria. - Creating Pivot Reports – to organise & summarise large amounts of data into easy to read tables.
- Editing template, copying, hiding or unhiding worksheets, saving workbook as a template.
- Learn macros which is more useful for recording repetitive tasks.
- Charting features to display two data series, one in a column & second in a line chart type.
- Linking data within a spreadsheet or between multiple spreadsheets.
- Workbook sharing – View, change, save, highlight & review changes and merging shared workbooks.
- Using Advanced Functions – VLOOKUP, HLOOKUP and many more.
               See Detailed Course Outline Below.
Need a Course Brochure?
We'll send you one!
Advanced Excel 2019 Training / Office 365 Training in Excel
Advanced Excel is the most effective and popular training. It is used by almost every industry and department from Executive to Director level. Virtually all companies need a few people with effective Advanced Excel skills.
Â
On completion of Advanced Excel 2019 / Office Excel 365 Certification Training, you will be able to:
- Understand the main concepts of Advanced & Conditional Formatting.
- Analyse data with Excel.
- Creating, Filtering, Sorting and summarizing with Pivots.
- Making use of templates.
- Working on multiple sheets and workbook.
Course Outline
Advanced Excel 2019/Office 365 Training
Module 1: Advanced Formatting in
- Cells & Worksheets
- Transposing Cells
- Copying & Moving Sheets
Module 2: Advanced Functions & Formulas
- Additional Useful Functions & Formulas
- Date & Time Functions
- Lookup (Vlookup, Hlookup)
- Financial, Database & Nested Functions
Module 3: Charts
- Creating & Formatting Charts
- Line & Column Charts
- Inserting Images in Charts
- Creating Combination Charts in Excel
Module 4: Data Analysis With Excel
- Using Tables
- Sorting and Filtering
- Scenario Analysis using Excel
- Analysis with Data Tables
- Creating Outlines
Module 5: Pivot Table Analysis
- Creating Pivot Tables
- Filtering Pivot Data
- Automatic & Manual Grouping of Pivot
- Sorting Data in Pivot Tables
- Summarizing Information With Pivot Tables
Module 6: Validating and Auditing Data
- Validating Data
- Adding Custom Messages for Error Handling
- Auditing Data
Module 7: Enhancing Your Productivity
- Naming Cells
- Benefits of Using Paste Special
- Sorting Multiple Columns
- Creating Custom Lists & Sorts
- Custom Auto Filtering Techniques
- Advanced Filtering of Data
- Adding Sub-Totals
Module 8: Making Use of Templates
- Using Templates
- Expanding on in-built Templates
Module 9: Linking, Embedding & Importing Data
- Working With Multiple Sheets, Workbooks
- Automation
- Importing Delimited Data
- Linking & Embedding Hyperlinks
- Embed Excel Data in Microsoft Word
Module 10: Collaborative Editing
- Tracking and Reviewing
- File Security
- Protection of Cells, Worksheets
- Sharing of Workbooks
Target Audience
Course Duration: Â 3 Days full days (Weekdays or Weekends)
Course Timings: 8.45 am – 5.45 pm
Target Audience:Suitable to All Users who have Basic Knowledge of Excel.Â
Whether you are working or not, from any background Student, Professional, Executive, Manager, Retirees, Housewives, or any other profile, you are most welcome to Join the Advanced Excel Certification Training.Â
Skill Level: Â For those who are proficient in Basics of Excel in order to enhance their Excel skills and productivity can join this fun loving training.
Certification : Successful trainees will receive the internationally recognized Certificate upon completion of the course. Students must clear online assessments at the end of the course to qualify for this Certificate.
Prerequisites
- Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Advanced Excel Skills.
- We look for participants with Secondary education as a pre-requisite
- Participants should have completed the Basic Excel Certification Training in Singapore, or demonstrate the basic proficiency in using Spreadsheets – things like basic formatting, copying cells, opening spreadsheets, moving, renaming sheets, writing simple formulas to do basic arithmetic.
We also offer Basic / Intermediate Excel 2016 Certification training and
Advanced Excel 2016 Certification training.
Training Course Fees
The full course fees for this training is S$750, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.
Grant Information
WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).
Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.
Companies sending Locals & Foreign staff for training can avail SFEC Funding.Â
Use it to improve the skills of your entire department!
NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.
Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991
70% Grant
$525 Funding by SSG
Pay $225
-
Singaporeans Above 40 Years
-
Individuals
-
SME Companies
-
Individuals Can Use SkillsFuture
-
UTAP Funding*
50% Grant
$375 Funding by SSG
Pay $375
-
Below 40 Years
-
Individuals
-
SG / PR / MNC Companies
-
SkillsFuture (Singaporeans only)
-
UTAP Funding*
Do You Have Any Questions
on Course Fee, WSQ Grant or Funding?
Ask Us. We’ll be happy to assist you.
Course Dates
Learn With Intellisoft & Boost Your Career
How to Register for Advanced Excel 2019 Training
Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.
You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.
Our Training Officer will get in touch with you to confirm your seat shortly.
You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now
Get in Touch
Intellisoft Training Pte Ltd
190 Middle Road, #10-08 Fortune Centre,
Singapore 188979
