This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.
The Basic program aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. While the Intermediate program is designed for those with basic knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2016.
The Advanced program is designed for those with intermediate knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2016.
This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.
PivotTables and PivotCharts are some of the Excel's most powerful features for analyzing data. This program takes PivotTables to the next level, teaching you how to use Power Pivot: a free add-in available only for Microsoft Excel 2010/2013/2016. Power Pivot links in with PivotTables, however the data used, can be manipulated and managed as though you were using a Relational Database (such as SQL or Access).
Power Query is the FREE Excel add-in from Microsoft that will help transform and manipulate your data into a format that is ready for PivotTables, reports, and so much more.
PivotTable and the VLOOKUP Function is the most popular and powerful feature in Microsoft Excel. PivotTable summarizes and analyses large amount of data; while VLOOKUP helps you to search and retrieve relevant information for your reporting. This course explores deeper into the usage of PivotTable and using VLOOKUP to obtain various complicated information.
The Personal Data Protection (Amendment) Act 2024 (PDPA 2024) in Malaysia, which was published in the Gazette on 17 October 2024, marks significant changes to Malaysia’s data protection framework. The significant amendments include mandatory data protection officer (DPO) appointment by controllers and processors, mandatory data breach notifications, data portability rights and requirements under the security principle. The PDPA 2024 also amends the rules relating to data transfers and increases penalties for non-compliance. These amendments to the current Personal Data Protection Act 2010 (PDPA 2010) aims to modernize the law, aligning more closely with internationally recognized standards, positioning Malaysia alongside its regional peers in Asia-Pacific, addressing the evolving challenges of data protection in the digital age. The PDPA 2024 will be implemented in stages starting 01 January 2025, with different sections coming into effect on 01 April and 01 June 2025, addressing inclusion of biometric data as sensitive personal data, security compliance, and international data transfer rules.
Decode the hidden tricks of Excel with our “ChatGPT & Artificial Intelligence for Microsoft Excel Course" by exploring the use of ChatGPT and artificial intelligence in the Microsoft Excel software. Learn the basic advantages of incorporating AI into Excel functions for better interaction with data. Also, delve into the art of automating tasks and unleash various insights on the data inputs. Besides that, through the ChatGPT & Artificial Intelligence for Microsoft Excel Course, you can learn to perform data cleaning and data analysis and streamline workflows in no time.
This 2-day hands-on training program is designed to enhance your professional capabilities in an increasingly competitive business world by focusing on key productivity-improving technologies. Throughout this comprehensive workshop, you will gain a deep understanding of Generative AI, including Large Language Models and popular AI and software automation tools to help you boost your work productivity. The training will provide practical skills in leveraging Generative AI for daily administrative tasks such as email management, meeting summaries, presentation creation, data analysis in spreadsheets, and content generation. Furthermore, you will also learn the fundamentals of Robotic Process Automation (RPA) and apply this knowledge to automate workflows within Microsoft 365 products, including Teams and Planner, using Power Automate, ultimately enabling you to identify and implement automation opportunities in your own work processes.