Microsoft Office Courses
Improve efficiency and increase productivity with our range of Microsoft Office training courses in Singapore, suitable for all skill levels.
Browse All Microsoft Office Courses
From mastering the basics to utilising advanced features of Microsoft Office, our hands-on training caters to all proficiency levels to ensure you’re equipped to excel in any professional environment and meet your learning objectives.
Select Your Preferred Category
Microsoft Excel Courses
Microsoft Word Courses
Microsoft Powerpoint Courses
Microsoft Outlook Courses
Microsoft Access Courses
WSQ Microsoft Excel Essentials
In our 2-day ‘WSQ Microsoft Excel Essentials’ course, you will gain the essential skills needed to apply business statistics, analytical skills, and quantitative techniques within the Excel environment. You will work with data sets, use formulas and functions, create charts and graphs, and apply conditional formatting to visually represent data.
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.
Microsoft Word 2019 – Basic and Intermediate
In this 2 day ‘Microsoft Word 2019 – Basic and Intermediate’ course, you will learn how to create, save and close documents, edit text, format documents, enhance them with WordArt, SmartArt, Charts, Pictures, Tables and mail out your work with the mail merge feature. You will ready to work confidently to create a variety of documents in proper layouts and formatting for tables, paragraphs, sections, headers, and page numbers for professional use.
Microsoft Word 2019 – Advanced
In this 1-day ‘Microsoft Word 2019 – Advanced’ course, you will learn how to leverage on more complex word processing features to improve your productivity when handling multiple documents and creating long documents and forms. The advanced formatting features taught can also help you to enhance the professional look and feel of your documents. You will also learn how to work with various themes, styles, document templates, create forms and format outlines, long documents and references.
Microsoft PowerPoint 2019 – Basic and Intermediate
In summary, this 2-day ‘Microsoft PowerPoint 2019 – Basic & Intermediate’ course will guide you on creating captivating and interesting presentation slides with transition elements, animations effects and objects (pictures, clipart, SmartArt, charts). You will be able to leverage on the features that Microsoft Office PowerPoint 2019 offers to bring your audiences’ attention to what matters most and leave a deep impression on their minds
Microsoft PowerPoint 2019 – Advanced
Microsoft PowerPoint 2019 – Advanced is designed for participants to spice up the Microsoft PowerPoint 2019 Slides with customised animations, multimedia (video & audio) clips, and customised show setup.
Creative Microsoft Powerpoint Designs Masterclass
Do you want to learn how to create engaging, well-designed, professional and sleek looking PowerPoint slides? Learn how to make use of the various features and functions that PowerPoint offers to augment your slides and bring your ideas to live today.
Microsoft Outlook 2019 – Basic and Intermediate
This course is designed for participants who want to gain the necessary skills to kick-start with the use of Microsoft Outlook 2019.
You will learn how Outlook manages all aspects of email communications, such as using the Outlook calendar to manage appointments and meetings, using Outlook’s People workspace to manage your contact information, creating Tasks and Notes for yourself in Outlook, and customizing the Outlook interface to serve your own personal needs.
Microsoft Outlook 2019 – Intermediate and Advanced
You will learn how to customize Outlook, use Quick Steps, create folder pane shortcuts, customize the Navigation bar, customize their messages and signatures, and set up automatic replies.
Microsoft Access 2019 – Basic and Intermediate
Upon completion of training, participants will develop essential knowledge and skills in using Microsoft Access. It allows the participants to understand the Database structure & concept with table relationships. You will also learn how to create and modify database objects such as tables, forms, reports, and queries, and subsequently apply intermediate skills to manage data entry, ensure data integrity, automate tasks and analyze data.
Microsoft Access 2019 – Advanced
Participants will further build their knowledge on Access 2019 in the course of Microsoft Access 2019 – Advanced.
Participants will be able to perform complex queries, design forms and reports, import and export data, and handle database security effectively.