- +63 917 714 4350 or DUO: (02) 7971 5203
-
Main: 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
Satellite Office: 2nd Floor, Bonifacio Technology Center, 31st St. cor. 2nd Ave., Bonifacio Global City, Taguig City
- Courses
High Potential Leadership
Leadership, Professional and Personal Training
Customer Service
Sales
Business Etiquette
Business Communication
- Opportunities
Careers at Acumen
Trainer for Hire
MICROSOFT EXCEL 2019 ADVANCED
COURSE DESCRIPTION
This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to use functions such as those associated with logical, statistical or mathematical operations. New Formulas that are introduced in 2019 is also introduced here. Furthermore, the participant will be able to use available analysis and audit tools and to run and record simple macros.
COURSE OUTLINE
Module 1. Using Auditing Tools and Range Names
- Jumping to a Named Range
- Assigning Names
- Using Range Names in Formulas
- Creating Range Names from Headings
- Applying Range Names
- Deleting Range Names
- Using Range Names in 3-D Formulas
- Displaying/Removing Dependent Arrows
- Displaying/Removing Precedent Arrows
- Showing Formulas
- Labs
Module 2. Using Advanced Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the IF Function
- Using the IFS Function
- Using the ISERROR Function
- Using an AND Condition with IF
- Using an OR Condition with IF
- Using the ROUND Function
- Using COUNTIF Function
- Using SUMIF Functions
- Using SUMIFs Functions
- Using MAXIFS Functions
- Using MINIFS Functions
- Using RANK Function
- Using Text Functions (UPPER,LOWER, PROPER, TRIM, TEXTJOIN)
- Labs