UPCOMING COURSES
CONTACT US
₱ 5,040.00
Advanced MS Excel: Optimize Its Function to Ease and Simplify Data-driven Tasks
Why join the workshop?
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.
Objectives:
-
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
Who Should Attend:
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.
Outline:
A. MS Excel Functions
- Text Functions
- Combining Texts
- Changing Case
- Other Accessory Text Functions - Logical Functions
- Basic IF Statements
- Nested and Series IF Statements - Math Functions
- Basic Math Functions
- Named Ranges
- Conditional Math Functions - Date Functions
- Lookup Functions
- VLOOKUP
- Advanced Lookup Functions
B. Data Management Tools
- Text-to-Columns
- Delimited
- Fixed Width
- Conditional Formatting
- Basic Conditional Formatting
- Formula-Based Format - Data Validation
- Basic Dropdown Menus and Cell Validations
- Dependent Dropdown Menus - Subtotal
- Consolidate Tool
- Flash Fill
C. Charts
- Basic Charts
- Combination Charts
- Complex Charts
- Sparklines
D. PivotTables
- Basic PivotTable Features
- Tables
- Advanced PivotTable Features
E. Introduction to Macros
- Understanding Macro Security
- Macro Recording
- Assigning Macros to Images and Buttons
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)
Course Schedule:
Jun 9 - 9, 2021
Heather Nesbitt Heather Nesbitt Oct 17, 2022
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
Nov 29, 2022