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/
Double Wall Flask Thermos Bottle factory Vacuum Flask Thermos Bottle Double walled stainless steel bottle manufacturers 304 Vacuum Insulated Water Bottle suppliers Non Smell Gallon Water Bottle With Time Marker suppliers Men Gallon Water Bottle With Time Marker in stock Gym gallon water jug in stock Camping Gallon Water Bottle With Time Marker Free Sample Plastic Drink Bottle manufacturers Flask Sport Water Bottle Free Sample 1 Gallon Sports Plastic Water Bottle in stock Half Gallon Outdoor Sport Water Bottle in stock Fitness plastic Water Bottle Free Sample Wholesale Double Wall Stainless Thermos Bottle Gallon Water Bottle With Straw Glass Drink Bottle Free Sample Sublimation Travel Coffee Mug Half Gym gallon water bottle Free Sample 500ML Double Walled Coffee Mug factory Gallon Plastic Water Bottle
Aerial Cam Unit manufacturers, Die Mounted Cam Unit suppliers, China Die Guide Components, Cam Slide Components, Die Setting Components suppliers, Aerial Cam Unit For Pierce, Punch Retainer factory, Aerial Cam Unit Long Life Type, Aerial Cam Unit Wide Type, Guide Post Set Movable Stopper manufacturers
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