This is an online course.
This is an online course.
Learn how to awaken and keep your audience's attention so they will…
This is an online course.
Help your employees make better-quality decisions by engaging the way…
A major challenge of any business is when customers complain about…
Businesses, large and small, brand new and established, continuously…
We all can express our ideas and thoughts through speaking. We can…
This virtual program is designed to equip supervisors, team leaders and managers…
Someone said that all management is the management of change. That…
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
9:00am - 12:00nn
2:00pm - 5:00pm
Day 2
9:00am - 12:00nn
2:00pm - 5:00pm
Introductory Rate:
Php 5,040 (Php 4,500 plus 12% VAT)
Aug 27 - 27, 2020
Inquirer Academy [url=http://www.g638ql73xd38l2y2h97s5nlo0p0p0tn9s.org/]ufkzfzjkoyn[/url] afkzfzjkoyn fkzfzjkoyn http://www.g638ql73xd38l2y2h97s5nlo0p0p0tn9s.org/