Mastering Microsoft Excel Intermediate Level Features & Skills

This course provides you with the knowledge required to use Excel functions and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and Sparklines, organise table data and present data as charts, create chart template, discover how Excel spreadsheets are constructed and summarize data with PivotTable and PivotChart. 

• If you require an efficient way to analyze your data using Excel
• If you deal with budgets, P&L, Sales or other administrative data and need to display the information using interactive Excel charts and reports
• If you need to summarize massive data with PivotTable and PivotChart

Then this is the right course for you!

Upon completion of the course, learners will be able to:

• Gain Mastery, Confidence and Improve Productivity 
  • Using Simple Techniques to get the most out of Excel's statistical and financial functions to save valuable time and effort on 
• Formatting reports using conditional formatting rules and styles
• Using Flash Fill and Quick Analysis
• Quickly transform business data into informative reports using PivotTables
• Acquire Powerful Data Analysis Capability 
  • Leverage Excel’s amazing tools, including PivotTables and PivotCharts capability which helps you analyze trends in data without having to worry about what formulas to be written and transform data into small, concise reports that tell you exactly what you need to know and identify patterns to enhance other research effort.

This course is perfect for experienced Excel users who want to replace manual tracking of financial data with interactive Excel analysis and reports. It is intended for senior officers, executives and decision-makers in government, corporate and private organisations.

• Business owners who run small to medium-sized businesses will be able to replace manual business data tracking processes with interactive Excel analysis and reports
• Managers or new employees who want to learn how to summarize business data and pave the way to put it into meaningful and useful reports.
• Delegates who intend to increase their work productivity with effective and time-saving data analysis skills
• Experienced Excel users who wish to learn more about Excel's business analysis capabilities

Note: Learners are required to bring a laptop equipped with Windows version Microsoft Excel 2016 / 365 / 2019

“Yes, she is knowledgeable about the product and is able to answer questions in layman terms with illustrations. This course is very suitable for people who use the software to increase efficiency.” – Shirley Liao, Senior Executive, City Developments Limited

MS Excel Expert and Microsoft Certified Trainer: Valene Ang

Valene Ang is a Microsoft Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She brings with her 20 years experience in corporate training and consultancy. Valene has broad experience in customizing Microsoft Office training programs, developing customized course outlines and course material, assisting corporate clients in business data analysis, and providing dynamic report solutions.

She had conducted many Microsoft Office workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real-life Excel problems. As a Certified Trainer, Ms Ang has trained hundreds of executives, managers and directors from across medium-sized organizations, government offices and multinational companies. Some of her high profile clients including PSA International, DFS Galleria Singapore, Neptune Orient Lines Limited (NOL), National Environment Agency (NEA), Inland Revenue Authority of Singapore (IRAS), CPF Board, Public Utility Board (PUB), Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic, Baxter Healthcare Pte. Ltd, and many more.