MICROSOFT OFFICE ESSENTIALS FOR SECRETARIES, ADMIN ASSISTANTS AND PERSONAL ASSISTANTS, 13-14 February 2023 @ Le Meridien Kota Kinabalu
This course will also cover some of the useful online resources, tools and applications specifically for Administrative Professionals.
This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.
[Remote Online Learning] Microsoft Office Essentials For Secretaries, Admin Assistants And PAs, 17-18 February 2021
This is a hands-on training whereby you will learn many unknown and yet powerful techniques, tips and tricks on how to work with various Microsoft applications effectively. Focusing on support roles, you’ll gain a sound understanding of spreadsheets, databases, word processing, and business document layouts. Most importantly, this course is to be delivered by a Microsoft Office trainer with over 20 years of teaching experience.
Public Training: Data Analysis Using Microsoft Excel, 25th – 26th November 2020 (Sarawak) / 30th November – 1st December 2020 (Selangor)
MS Excel is an important tool for data analysis. Many users had the impression that without using the Virtual Basic for Applicants (VBA), the data analysis cannot be worked. The statement above shall be proven inaccurate, as the data analysis job could still be done effectively and efficiently. It is important to possess the best skills in data collection before commencing data analysis jobs.
In this course, you will learn how to create a dynamic template to generate business reports for customers and to better understand your own data. You’ll learn steps by steps on how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive.
In this Excel data analysis course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform “what if” analyses, leverage features and apply functions, manipulate PivotTables to analyze large amounts of data, and present your results to make better business decisions. You also learn how to automate processes and enhance worksheet models.