Courses

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro.

Excel macro is a set of instructions that can be used to automate tasks in Microsoft Excel. Macros can be created using Visual Basic for Applications (VBA), which is a programming language that is built into Excel. VBA is used to create macros and automate tasks in a variety of Microsoft Office applications, not just Excel. With VBA, you can create macros that can automate repetitive tasks, create custom functions, and interact with other Office applications like Word and PowerPoint.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro.

Microsoft Power Automate provides the tools that you can use to improve productivity in your organization by automating repetitive, time-consuming tasks. Power Automate provides a better way to get things done across your organization through cloud flows and robotic process automation (RPA)

Power Automate can be operated in Cloud or Desktop. This course will focus on how to use the Power Automate Desktop.

What can you do with Power Automate Desktop?

Microsoft Power Automate Desktop can be used to automate tasks in your desktop and web applications.

MS Office Word is one of the leading applications for processing, creating, sharing, and editing Word documents on Windows PCs

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google

The focus of this course is the design process and template creation. I will take you by the hand through the process of creating an outstanding presentation. We will design using PowerPoint and make infographics, world maps, graphs, charts, features, processes, introduction and about us slides, and many things that are important to a well-prepared presentation. Whether you're looking to give a monthly report or impress prospective clients with your PowerPoint designs, learning the shortcuts and how to build unique themes is essential for crafting engaging and informative presentations.

This course is for beginners of Macro who want to automate tasks in Excel. The course will cover how to automate entry, move or copy properties or objects, calculate data based on condition, or do a task if triggered by an action. VBA requires basic knowledge in font, cell ranges, workbook and worksheet. However, the course is not intended to cover the advanced features (eg. for/next loop), sophisticated writing of codes, userforms and its controls. The objective of the course is to create template and populate data or vice versa (example, data encoded in template, such as invoice, must be stored in or retrieved from database without manually copy-paste) The student must follow the flow of lecture with provided template. The lectures revolve in building up the template with automated task.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro.