This is an online course.
This course aims to demonstrate the application of advanced MS Excel functions and tools on more data-driven tasks. Aside from reviewing the essential functions, this course will introduce less common functions which may be used to further ease and simplify spreadsheet tasks.
The course will also cover data management tools and their advanced usage, how to create special charts, a thorough discussion on Pivot Tables, and an introduction to macros.
This course is applicable to MS Excel 2007, 2010, 2013, 2016, and 2019.
Create general macro recordings to automate basic repetitive tasks in MS Excel
Introduce essential codes in VBA
Create decision and loop structures in VBA—which ultimately automates most tasks in MS Excel
Create user forms that can be used by the spreadsheet to interact with the users
Create user-defined functions that can be deployed in the workplace
The workshop is ideal for supervisors and managers who generate reports, forms, or trackers using MS Excel. Also for employers working with large amounts of data using the application, and those who want to learn more of its functions and tools.
A. MS Excel Functions
B. Data Management Tools
C. Charts
D. PivotTables
E. Introduction to Macros
Program Schedule:
Day 1 (June 7)
1:00pm-5:00pm
Day 2 (June 9)
1:00pm-5:00pm
Introductory Rate:
Php 5,040 (Php 4,500 plus 12% VAT)
Jun 9 - 9, 2021
67mm Metal Grinding Pad manufacturers, Prestressing Jacks and Pumps factory, Hydraulic Fence Post Puller factory, Piston Splitter suppliers, Portable Hydraulic Post Driver factory, Piston Type Rock Splitter factory, Hydraulic Mono Jack factory, Hydraulic Scarifier manufacturers, Rebar Tools factory, Single Strand Pulling Machine suppliers