Advanced Excel Course at Intellisoft Singapore covers the most important, key features of Microsoft Excel.
Attend our Advanced Excel Training to master the following skills in Microsoft Excel:
- How to Create & Use Pivot Tables in Excel,
- Excel Functions like Vlookup, HLookup, Sumif, If, Countif
- Using Excel Macros – What are they and how to record a macro
- Advanced Sorting & Filtering using Advanced Excel functionality
- Advanced Conditional Formatting & Custom Formatting Techniques
- Applying Database Functions
- Creating & Using Range Names in Excel
- Sharing of Excel Files with multiple team members
- Combining data from numerous files & sheets easily
- Advanced Charting Techniques that go beyond bar and column charts
Microsoft Excel course participant at Intellisoft learn practical steps:
“The Advanced Excel course will help me get my job done quickly and easily. The things that I used to take many hours will now take only a few minutes using formulas, macros and other tricks I learnt in the Excel 2016 workshop” – Carmen Leow, Pan Pacific Hotel, Singapore.
Advanced Courses on Microsoft Excel in many Versions.
We also have Excel training on other versions
SDF Funding is available to Singapore Companies (company-sponsored). Call +65 6296-2995 for any support or training details.
Advanced Microsoft Excel Training Course Syllabus
Day 1 of Advanced Excel 2016 TrainingLesson 1: Custom & Conditional Formats
Lesson 2: Using Formulas & Functions
Lesson 3: Working with Range Names
Lesson 4: Using Advanced Functions of Excel
Lesson 5: Managing Tables in Excel
Lesson 6: Using Auto & Advanced Filters in Excel
|
Day 2 of Advanced Excel 2016 TrainingLesson 7: Getting Most from your Data
Lesson 8: Working with Excel Charts
Lesson 9: Working with Pivot Tables To Build Advanced Excel Skills
Lesson 10: Using Shared Workbooks
Lesson 11: Worksheet Protection
Lesson 12: Combining & Linking Multiple Workbooks in Excel
Lesson 13: Working with Excel Macros
|
We have created this Advanced Excel Course to make sure you pick the most important functions created by Microsoft.
You absolutely must know how to use Pivot tables in Excel, Record Macros in Excel, and Master Pivot Tables in Excel at a minimum.
The objective of our Excel courses
The main objective of attending an Advanced Excel course is to master the critical pro tips and tricks that will make you shine in your workplace as an analyst and get your job done in record time… boosting your productivity and employability.
We cover the Best Excel Training Topics that everyone wants to learn in Singapore.
Microsoft introduced lookup functions like VLOOKUP to speed up your checking of prices, employee grades from master tables using Excel. This is a huge time saver and is known to be the most helpful function of Microsoft Excel.
When looking for people to hire with Advanced Excel skills, employers in Singapore always look for knowledge of VLOOKUP & HLOOKUP, ADVANCED PIVOT TABLE TECHNIQUES, and EXCEL MACROS.
Understand how you can apply the Advanced functions of Microsoft Excel 2016 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work. Such functional IT training can help you move into an analyst career or data science.
With our SkillsFuture Excel Courses, Learn how you can:
- Automate common tasks like compiling reports and worksheets with Macros,
- Apply Advanced Data analytics techniques to generate insights from your data,
- Collaborate with multiple team members on Excel worksheets to save time, and
- Leverage Excel’s advanced formulas & functionality to simplify office work.
Learn Excel Functions to become Great at Financial Accounting.
Fundamental knowledge of Microsoft Excel functions is sufficient for this Excel course.
You must know how to start Excel, key in numbers, text, and do simple formatting. You should know the basic functions like Sum, Count etc.
The Advanced Microsoft Excel Courses by Intellisoft will teach you the skills to perform advanced spreadsheet skills with ease. The Excel exercises are very practical and hands-on. Be prepared to do a lot of exercises to hone your Excel spreadsheet software skills in the class.
Our Excel course will teach you to use VLookup, Pivot Tables, Macros, and tons of useful shortcuts, tips, tricks to improve your productivity and take your Excel skills to the next level in any industry. Adults and students both can benefit from our practical IT Training courses in Singapore.
Our Best Excel course in Singapore will help you if you are from an HR, financial analyst, data analyst, marketing, sales, services or manufacturing environment.
It is especially suitable for people from Services, Accounting, Finance, Sales in Health Care, Pharma, or any other business in Singapore.
Even college students have learnt many things from our Intermediate & Advanced courses on Excel.
This Advanced Excel Training Course is not for Excel beginners.
If you do not know how to copy information from one Excel worksheet cell to another, then this Advanced course is not for you. J
oin our Excel for Beginners / Intermediate training program first.
Join the Advanced Excel workshop only if you have been using Microsoft Excel for at least 2-3 months & know the basics of Excel.
Are you ready to learn the more advanced functions, tricks and techniques of Excel practically?
We will provide a certificate of attendance to all participants who complete the Advanced Excel Class at Intellisoft Training Singapore.
For any other questions about why you must learn Microsoft technologies, check out our detailed guide on How to Learn Excel fast.
We have created this Advanced Excel Course to make sure you pick the most important functions created by Microsoft.
You absolutely must know how to use Pivot tables in Excel, Record Macros in Excel, and Master Pivot Tables in Excel at a minimum.
The objective of our Excel courses
The main objective of attending an Advanced Excel course is to master the critical pro tips and tricks that will make you shine in your workplace as an analyst and get your job done in record time… boosting your productivity and employability.
We cover the Best Excel Training Topics that everyone wants to learn in Singapore.
Microsoft introduced lookup functions like VLOOKUP to speed up your checking of prices, employee grades from master tables using Excel. This is a huge time saver and is known to be the most helpful function of Microsoft Excel.
When looking for people to hire with Advanced Excel skills, employers in Singapore always look for knowledge of VLOOKUP & HLOOKUP, ADVANCED PIVOT TABLE TECHNIQUES, and EXCEL MACROS.
Understand how you can apply the Advanced functions of Microsoft Excel 2016 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work. Such functional IT training can help you move into an analyst career or data science.
With our SkillsFuture Excel Courses, Learn how you can:
- Automate common tasks like compiling reports and worksheets with Macros,
- Apply Advanced Data analytics techniques to generate insights from your data,
- Collaborate with multiple team members on Excel worksheets to save time, and
- Leverage Excel’s advanced formulas & functionality to simplify office work.
Learn Excel Functions to become Great at Financial Accounting.
This Advanced Excel Training Course is not for Excel beginners.
If you do not know how to copy information from one Excel worksheet cell to another, then this Advanced course is not for you. J
oin our Excel for Beginners / Intermediate training program first.
Join the Advanced Excel workshop only if you have been using Microsoft Excel for at least 2-3 months & know the basics of Excel.
Are you ready to learn the more advanced functions, tricks and techniques of Excel practically?
We will provide a certificate of attendance to all participants who complete the Advanced Excel Class at Intellisoft Training Singapore.
For any other questions about why you must learn Microsoft technologies, check out our detailed guide on How to Learn Excel fast.
Advanced Microsoft Excel Training Course Syllabus
Day 1 of Advanced Excel 2016 TrainingLesson 1: Custom & Conditional Formats
Lesson 2: Using Formulas & Functions
Lesson 3: Working with Range Names
Lesson 4: Using Advanced Functions of Excel
Lesson 5: Managing Tables in Excel
Lesson 6: Using Auto & Advanced Filters in Excel
|
Day 2 of Advanced Excel 2016 TrainingLesson 7: Getting Most from your Data
Lesson 8: Working with Excel Charts
Lesson 9: Working with Pivot Tables To Build Advanced Excel Skills
Lesson 10: Using Shared Workbooks
Lesson 11: Worksheet Protection
Lesson 12: Combining & Linking Multiple Workbooks in Excel
Lesson 13: Working with Excel Macros
|
Fundamental knowledge of Microsoft Excel functions is sufficient for this Excel course.
You must know how to start Excel, key in numbers, text, and do simple formatting. You should know the basic functions like Sum, Count etc.
The Advanced Microsoft Excel Courses by Intellisoft will teach you the skills to perform advanced spreadsheet skills with ease. The Excel exercises are very practical and hands-on. Be prepared to do a lot of exercises to hone your Excel spreadsheet software skills in the class.
Our Excel course will teach you to use VLookup, Pivot Tables, Macros, and tons of useful shortcuts, tips, tricks to improve your productivity and take your Excel skills to the next level in any industry. Adults and students both can benefit from our practical IT Training courses in Singapore.
Our Best Excel course in Singapore will help you if you are from an HR, financial analyst, data analyst, marketing, sales, services or manufacturing environment.
It is especially suitable for people from Services, Accounting, Finance, Sales in Health Care, Pharma, or any other business in Singapore.
Even college students have learnt many things from our Intermediate & Advanced courses on Excel.
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
Claim SDF Grant
Companies sponsoring their staff for training can claim from the Skills Development Fund.
How To Register
Register for the 2 Day Advanced Microsoft Excel Course With SkillsFuture Today.
To claim SDF Funding of $32 for this training, you must register for the training at our website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals – only available if you apply through your company.
Individual Singaporeans can use SkillsFuture credits funding to offset the cost of this training. Training seats are available in the Excel class in Singapore. Simply call us to enquire or register for the next Microsoft workshop.
Call us at +65 6296-2995 or email to training@intellisoft.com.sg for any questions, support, or to register for the upcoming Advanced Excel workshop in Singapore with SkillsFuture.
We also offer Customized Corporate Training for Microsoft Excel 2016 & Advanced Excel 2019 / 365 also. If you have a group of participants, we can conduct this training at your company office too. Contact us for details.
Some of the companies that experienced our trainings
