Microsoft Excel Courses
Are you looking for Microsoft Excel training courses in Singapore to increase your work productivity and achieve professional growth? As a SkillsFuture Singapore-certified Approved Training Organisation (ATO) since 2014, we offer an extensive range of Microsoft Excel training courses. By enrolling in these Excel training courses, you will pick up skills and competencies that are in demand and highly sought after by employers in Singapore.
*Eligible for Singaporeans, PRs, and Long Term Visitors Pass+ holders
*Eligible Courses Funded by SkillsFuture will have (*) stated on Course Name
Download All Microsoft Excel Course Brochure
Complete the form below to download the All Microsoft Excel Course Brochure and one of our course consultants will reach out to answer any questions you may have.
Download Course Brochure Form
"*" indicates required fields
Our Clients
Why Attend Microsoft Excel Training Courses?
Microsoft Excel is a leading spreadsheet software programme that doubles up as a powerful data visualisation and analysis tool. Here’s how mastering Excel will place you in a highly advantageous position in terms of your career and why you should attend our Microsoft Excel training courses in Singapore:
Increased Value to Employers
Even though Microsoft Excel skills are essential in today’s corporate environment, not everyone is equipped with those skills. By mastering Excel skills through our beginner and advanced courses, you can significantly increase your employability and chances at promotions. Excel skills are transferable and can be applied across many different industries, so you can be assured that these skills will come in handy wherever you decide to go in the next step of your career.
Improved Productivity & Efficiency
If your job requires you to deal with huge amounts of data, mastering Excel will help you save a substantial amount of time. By going for Microsoft Excel training courses, you will learn how to better organise and analyse data and obtain meaningful insights in a fraction of the time.
Hone Skills in Data Visualisation and Reporting
With our data analytics courses, you will gain insight into data visualisation techniques using Excel’s charting and graphing functions. You will learn how to create visually compelling graphs, charts, and dashboards to present data clearly. This skill is valuable for communicating insights and findings to stakeholders effectively. Should you also need help in improving how you communicate to stakeholders when presenting data, we also have communication skills courses to help you.
Get Practical Application of Data Analytics
To fully grasp data analytics and refine your skills, it’s important that you are exposed to real-world data analytics scenarios. With that, our data analytics with Microsoft Excel courses not only cover the different techniques through lectures. We refine your skills by applying what you’ve learned in practical exercises and case studies. With hands-on experience, you will be able to understand how data analytics can be implemented in different industries and job roles.
Gain Confidence in Continuous Learning and Growth
By building your foundation through our training courses, you can broaden your knowledge of data analytics and learn more techniques that will be an asset to your career growth. Our data analytics with Excel courses can help give you the drive to explore more advanced Excel functionalities and the latest trends in data analytics.
Popular Microsoft Excel Courses
Microsoft Excel 2019 – Basic Course
Learn the essential skills needed to create, edit and use basic formulas to extract data insights. In addition, learn page layout and format your spreadsheets for printing.
2 Days
Taught by Industry Experts
Microsoft Excel 2019 – Intermediate Course
Learn how to manage data ranges, protections, create tables and charts, insert formulas and functions, trace errors, manage names, and how to sort and filter data. In addition, learn how to create VLOOKUP formulas, IF functions and simple Pivot Tables to report or summarize your data for more impactful reporting.
2 Days
Taught by Industry Experts
Microsoft Excel 2019 – Advanced Course
Learn how to use advanced functions such as text formulas, date & time formulas, lookup functions, and understand formula errors.
You will be taught how to manage names, consolidate, organize and analyze data and to create pivot tables and record macros to automate repetitive formatting changes that you need to make to cells in your spreadsheet.
2 Days
Taught by Industry Experts
Microsoft Excel Courses
Microsoft Excel 2019 – Basic*
In our 2-day ‘Microsoft Excel 2019 – Basic’ course, you will gain the essential skills needed to create, edit and use basic formulas to extract data insights. In addition, you will learn page layout and format your spreadsheets for printing.
Microsoft Excel 2019 – Intermediate*
If you are looking to deepen your Excel knowledge, our 2-day ‘Microsoft Excel 2019 – Intermediate’ course will teach you how to manage data ranges, protections, create tables and charts, insert formulas and functions, trace errors, manage names, and how to sort and filter data. In addition, you will learn how to create VLOOKUP formulas, IF functions and simple Pivot Tables to report or summarize your data for more impactful reporting.
Microsoft Excel 2019 – Advanced*
In our 2-day ‘Microsoft Excel 2019 – Advanced’ course, you will learn how to use advanced functions such as text formulas, date & time formulas, lookup functions, and understand formula errors. Besides that, you will be taught how to manage names, consolidate, organize and analyze data. Last but not least, you will learn to create pivot tables and record macros to automate repetitive formatting changes that you need to make to cells in your spreadsheet.
1 Day Basic Excel Fast Track Workshop
Learners will get to learn the essential basics of how to work with formatting cell, values, worksheets and workbooks. You will also learn to use simple formulas like sum, average, count and auto sum confidently. Most importantly, you will be guided on how to do page setup for printing.
1 Day Intermediate Excel Fast Track Workshop
This 1 day workshop course is suitable for you, if you are looking beyond using basic features of Excel. You will be explored with more features of Excel to increase your productivity while working with data.
You’ll learn the popular features such as conditional formatting, sorting, filtering and data validation. Besides that, you will learn formulas like IF(), AND() and OR(), conditional and database formulas. Most importantly, you will learn to work with Charts confidently.
1 Day Advanced Excel Fast Track Workshop
The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios.
Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.
In this 1 day workshop, you will be guided to use Lookup Formulas, Match and Index Formulas, Text & Date Formulas and Financial Formulas. Besides that, you will learn to analyse data and appreciate the powerful feature in using Pivot Tables. You will have the opportunity to learn simple Macros.
Introduction to Microsoft Excel Power Query, Data Model, Power Pivot & DAX*
Introduction to Microsoft Excel Power Query, Data Model, Power Pivot and DAX is a highly recommended training course for individuals who want to get in-depth knowledge of handling significantly huge databases. This course introduces the most powerful data modelling and business intelligence tools. They are Power Query, Data Model, Power Pivot, and DAX (Data Analysis Expressions).
Power BI Course – Bridging Big Data Analytics*
In today’s corporate environment, fact-based data plays a big part in shaping key business decisions. We have seen reports, spreadsheets, and slide decks jostle for space in our email inboxes. Hence, it is demanding for our attention as part of our decision-making process. Are you feeling swamped by the huge volume of reports to be analysed before writing proposals to your bosses? Our 1-day ‘Bridging Big Data Analytics Using Power BI course, which is accredited by SkillsFuture Singapore (SSG), can help you streamline your data analysis process.
Visual Basic for Applications in Microsoft Excel – Fundamental*
This course, Visual Basic for Applications in Microsoft Excel – Fundamental, is designed with a practical approach towards unleashing the power of Spreadsheet through VBA programming. It aims to enhance productivity by equipping participants with the knowledge and skills to automate repetitive tasks or simplify a complex task. For example, if you have to copy certain rows and columns from a table into different tables in different excel sheets on a daily basis. Or you have to calculate the average, mean, median or carry out some statistical function of certain columns in few excel sheets every week. Learning VBA allows you to automate repetitive tasks or simplify a complex task easily.
Data Analysis with Microsoft Excel DASHBOARD Reporting for Management*
Data Analysis with Microsoft Excel DASHBOARD Reporting for Management is a specially designed course to provide an informative and interactive management tool. Therefore, it gives clear visual tracks and displays key performance indicators (KPI), metrics, and key data points for the management. Then, it allows management to monitor the health of a business, department, or specific process very quickly. They are customizable to meet the specific needs of a department and company. Through the use of data visualizations, dashboards simplify complex data sets to provide users with at a glance awareness of current performance.
Data Visualisation and Storytelling with Power BI*
You will be working with data from open-source websites, analysing trends that lie with that data, and creating visuals to communicate the results that are intuitive and interactive.
The two days workshop focuses on applied learning that helps you in mastering the art of using Power BI to design reports and charts that communicate data well to your key stakeholders.
Data Visualisation and Storytelling with Tableau*
Learning Tableau could give one a leg up on getting jobs and advancing one’s career in a data-driven business world. Whether in marketing, operations, strategic planning, product development, HR, or other aspects of business, data helps companies make smarter decisions.
The two days workshop focuses on applied learning that aims to enhance your ability to use Tableau in identifying which factors affect businesses and pinpoint areas that need to be improved or need more attention, including making data memorable with storytelling.
Microsoft Excel: Advanced Formulas and Functions*
Microsoft Excel: Advanced Formulas and Functions will cover how to perform advanced searching and data retrieval with Lookup functions, creation of statistic reports with criteria applied using Statistical functions, extraction of required text from given string using Text functions, and many more. The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios. Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.
Advanced Pivot Table Techniques in Microsoft Excel*
Excel’s most powerful analytical tool is the PivotTable. In this course, you’ll be taught how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. You will also learn how to navigate the complexity of PivotTables to take advantage of their power. By the end of the course, you will be able to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.
Microsoft Excel: 99 Pro Hacks and Tips
Microsoft Excel users use only a small percentage of what the application is really capable of. But, hidden within are loads of lesser known productivity hacks for a more efficient work experience with the application. Discover how to avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel.
Why Learn With Us?
Accredited Certification
Earn recognised certifications by Singapore’s Workforce Skills Qualifications (WSQ). Our courses offer a credible pathway to professional growth.
Learn from Industry Veterans
Our training courses are taught by seasoned experts in their respective fields, who bring years of practical experience to add to your learning journey.
Immersive Learning and Up-to-date Curriculum
Upskill with up-to-date courses to keep up with the fast-changing industry and gain latest industry insights. Dive into hands-on immersive learning experiences that are applicable to real-world scenarios.
Testimonials
Hear from some of our graduate trainees
Puay Suan Sia
“I attended 2 days course on Integrated Digital Marketing Strategy. Trainer Eugene Tan is very knowledgeable and shared many examples and experiences so that it is easier for us to understand. Staff at ASK training ( JTC Summit) are friendly and helpful.”
Candice Lum
“Trainer David is very knowledgeable with relevant industry knowledge and was able to answer all questions raised. ASK Training Centre is also a very well run centre with friendly and helpful staff and ensures safe distancing and all requests of students are met. I strongly recommend everyone to attend SEO class at ASK Training Centre. Kudos to ASK team!
I will return to attend other courses like Digital Marketing.”
Daniel Ariffin
“Trainer was very competent and trained the attendees well. There was a lot of banter going on as there were attendees of different levels with all Q&A attended to professionally , which made the learning process more interesting as compared to simply going by the books. Training syllabus and the manual provided were adequate and well laid out. Training facilities were excellent and the pantry well stocked for the rest breaks.”
Have Questions?
Speak to our programme consultants and have them answered!
Download Course Brochure Form
"*" indicates required fields