how to apply Conditional Formatting –Â helps to analyse data by highlighting cells in a specified range that meet applied condition or criteria.
Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Advanced Excel Skills easily.What Our Happy Participants Say
Previous
Next
Intellisoft Training: WSQ Funded IT Training in Singapore
Upgrade Skills With WSQ & SkillsFuture Funding from Singapore Government
WSQ Funded Advanced Excel Course
Learn the Advanced Features of Excel for Your Data!
Now With WSQ, SFEC, SkillsFuture & UTAP Funding!
Learn Advanced Functions Pivot Tables Macros VLookup Advanced Formulas Advanced Charting in Just 3 Days!
Advanced Excel 2016 Course Overview: Certification Training
The Advanced Excel course with Microsoft Office 2016 training is a high-level Excel certification program in Singapore. Here, you will master the advanced formulas & functions of Microsoft Excel, and be able to produce more sophisticated reports, perform complex calculations, saving time & improving productivity.
We focus on teaching you Pivot Tables, Advanced Filters, VLOOKUP & HLOOKUP, Worksheet Protection, Macros, Working With Multiple workbooks & more…Â
SSG Approved Excel Courses: ICDL Certification in Excel Advanced Skills
A laptop is provided in class when you attend the Advanced Excel training course in Singapore. At the end of your training & assessment, you will be a Certified Advanced Excel Professional from SSG & ICDL.Â
Intellisoft ICDL Courses and training are funded by SSG through WSQ Grants & SkillsFuture Credits. These Microsoft IT courses lead to Certifications from worldwide recognized bodies like ICDL Asia.
Now With WSQ, SFEC, SkillsFuture & UTAP Funding!
Learn Advanced Features With Microsoft Excel Courses
In Just 3 Days,
Master Pivot Tables, Vlookup, Macros & More...
This training will give you opportunities to practice with real world scenarios.    Master Excel Easily, Today!
Course Objectives for this Microsoft Excel Advanced Course
- 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 organize & summarize 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, SUMIF, COUNTIF, DMAX, NPV, PMT, IF, and many more.
              Detailed Course Outline of Advanced Microsoft Excel Class
| Training Schedule |
|---|
Now With WSQ, SFEC, SkillsFuture & UTAP Funding!
Need a Course Brochure?
We'll send you one!
What Will You Learn in this Advanced Excel Course Workshop?
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 key people with effective Advanced Excel skills in VLookup function, Pivot table for analyzing data & macros to automate routine processes.
Upon Completion of Advanced Excel 2016 Certification Training, you will be able to:
- Apply the main concepts of Advanced & Conditional Formatting.
- Begin to Analyze data with Excel Functions & Formulas
- Create, Filter, Sort and Summarize Data Easily with Pivots.
- Learn to Make use of Excel templates to quickly make Cash Flow, Balance Sheets, Calendars & Management Reports.
- Work on multiple Excel sheets & workbooks to consolidate data, useful for Management Dashboards or Financial Reporting.
Workshop Course Outline
Advanced Excel 2016 Certification Training in Singapore
Module 1: Advanced Formatting in
- Cells & Worksheets
- Transposing Cells in Excel
- Copying & Moving Sheets Within Multiple Workbooks
Module 2: Advanced Functions & Formulas
- Additional Useful Functions & Formulas
- Date & Time Functions
- Master Lookup Functions like Vlookup & Hlookup
- Financial Functions of Excel,
- Database Functions of Microsoft Excel
- Logical Functions in Excel
- How to Write Nested Functions
Module 3: Create Enhanced Excel Charts
- Creating & Formatting Simple & Advanced Charts
- Line & Column Charts
- Inserting Images in Charts
- Create 2 Axis Combination Charts in Excel
Module 4: Data Analysis With Excel
- Use Tables For Better Organize Data
- Sorting and Filtering in Excel
- Scenario Analysis to Understand various situations & Play What-If using Excel
- Visualize What-if with Data Tables
- Creating Outlines with Automatic Grouping of Data in Microsoft Office.
Module 5: Master Pivot Table Creation & Analysis
- Create Pivot Tables in Excel
- Filter Pivot Data
- Automatic & Manual Grouping of Pivot Data
- Sort Data in Pivot Tables
- Summarizing Information With Pivot Tables
- Visualize Summarized Data for Deeper Insights using Microsoft Tools.
Module 6: Validating and Auditing Excel Data
- How to only allow Valid Data to avoid errors
- Adding Custom Messages for Error Handling
- Auditing Data in Worksheets with Excel
Module 7: Enhance Productivity With Microsoft Excel
- Naming a Cell or a Range in Excel
- Benefits of Using Excel Paste Special
- Sorting Multiple Levels of Columns easily
- Creating Custom Lists & Sorting Patterns
- Custom Auto Filtering Techniques
- Advanced Filtering of Data
- Adding Sub-Totals & Viewing Grand Totals
Module 8: Making Use of Templates
- How To Use Templates
- Expanding on in-built Templates
- Saving your own Templates
Module 9: Linking, Embedding & Importing Data
- Working With Multiple Sheets & Excel Workbooks
- Importing Delimited Data
- Linking & Embedding Data & Hyperlinks in Files
- Embed Excel Data in Microsoft Word, with automatic updating options.
Module 10: Collaborative Editing
- Tracking and Reviewing
- File Security
- Protection of Cells, Worksheets
- Sharing of Workbooks
Module 11: Record & Run Excel VBA Macros Easily
- Why Enable Macro Security
- How to Record a Macro
- Ways to Run a Macro
- How to Save a Macro enabled Workbook
- Where are Macros Stored
Now With WSQ, SFEC, SkillsFuture & UTAP Funding!
Target Audience
Course Duration: 3 full days (Weekdays or Weekends)
Course Timings for Excel Advanced Course is from  8:45am to 5:45pm.
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, any other industry or profile, you are most welcome to Join the Best Advanced Excel Certification Training with Intellisoft:Â Â
Benefit from the Top Quality Excel Training Courses & workshops in Singapore, where we teach you to develop your skills in Spreadsheets, topic by topic, step by step with ample exercises and hands-on practice in class.Â
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.
Pre-requisites: Advanced Excel Training Course Singapore
Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Advanced Excel Skills easily.- We look for participants with Secondary education as a pre-requisite.
- Advanced Excel Course Participants should have completed the Basic Excel training, 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.
ICDL Advanced Certification in Microsoft Excel: Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. You will also be getting a Certificate of Attainment from SSG after successfully passing the assessment. Â
For Excel Advanced Course certification, participants must pass a 1 hour online assessment test at the end of the training to qualify for the SSG Statement of Attainment & the ICDL International Certificate.
We also offer Excel at Basic / Intermediate Level. Check course outline Basic / Intermediate Excel 2016 training.
Training Course Fees
The full course fees for this training is S$695, 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
up to 70% Grant
$486.50 Funding by SSG
Pay $208.50
-
Singaporeans Above 40 Years
-
Individuals
-
SME Companies
-
Individuals Can Use SkillsFuture
-
UTAP Funding*
up to 50% Grant
$347.50 Funding by SSG
Pay $347.50
-
Below 40 Years
-
Individuals
-
SG / PR / MNC Companies
-
SkillsFuture (Singaporeans only)
-
UTAP Funding*
Join & Register Enquire Get Started Get Certified Be a Pro Use WSQ Grant Use SkillsFuture Today!
Do You Have Any Questions
on Course Fee, WSQ Grant or Funding?
Ask Us. We’ll be happy to assist you.
Advanced Excel Training in Singapore: Course Dates
| Training Schedule |
|---|
Now With WSQ, SFEC, SkillsFuture & UTAP Funding!
Learn With Intellisoft & Boost Your Career
How to Register for Advanced Excel Course Training ?
Simply fill this Online Registration Form to book your seat for the Advanced Excel Course Singapore
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
