Details
This training will review and strengthen Excel skills and enhance this further with knowledge of advanced functions and tools of the program. You will learn to create advanced formulas and use the advanced tools of MS Excel.
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Click the "ENROLL NOW" to find the Ticket Prices, Payment Methods (GCash, credit card, bank deposit, etc.)
Onsite:
INCLUSIONS:
- 1 AM snack
- 1 PM snack
- 1 lunch (fastfood)
- Handouts
- Certificate
- overflowing coffee
- WIFI access
BRING OWN LAPTOP
Where: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
via Zoom:
INCLUSIONS:
- PDF handouts
- PDF certificate
***
OUTLINE
Part 1. Advanced MS Excel Functions
(includes quick review of basics)
Text Functions
_Combining Texts (CONCATENATE)
_Changing Case (UPPER, LOWER, PROPER)
_Other Accessory Text Functions (SUBSTITUTE, TRIM, FIND, etc.)
Logical Functions
_Basic IF Statements
_Nested and Series IF Statements
_Using AND and OR
_Combining IF with Other Functions
Math and Date Functions
_Basic Math Functions
_Named Ranges
_Conditional Math Functions (SUMIF, COUNTIF, SUMIFS, etc.)
Shortening Long Formulas with Arrays
Advanced Lookup Functions
_VLOOKUP
_Advanced Usage of VLOOKUP
_INDEX and MATCH
_XLOOKUP
Part 2. Exploring the Data Tab Tools
Conditional Formatting
_Basic Conditional Formatting
_Formula-Based Formatting
_Creating Dropdown Menus and Cell Validations
_Summarizing using the Subtotal Tool
Part 3. Analyzing Data Using PivotTables
_Basic PivotTable Features
_Grouping Data
_Using Slicers
_Calculated Fields
_PivotCharts
Part 4: Introduction to Macro Recording
Outline
OUTLINE
Part 1. Advanced MS Excel Functions
(includes quick review of basics)
Text Functions
_Combining Texts (CONCATENATE)
_Changing Case (UPPER, LOWER, PROPER)
_Other Accessory Text Functions (SUBSTITUTE, TRIM, FIND, etc.)
Logical Functions
_Basic IF Statements
_Nested and Series IF Statements
_Using AND and OR
_Combining IF with Other Functions
Math and Date Functions
_Basic Math Functions
_Named Ranges
_Conditional Math Functions (SUMIF, COUNTIF, SUMIFS, etc.)
Shortening Long Formulas with Arrays
Advanced Lookup Functions
_VLOOKUP
_Advanced Usage of VLOOKUP
_INDEX and MATCH
_XLOOKUP
Part 2. Exploring the Data Tab Tools
Conditional Formatting
_Basic Conditional Formatting
_Formula-Based Formatting
_Creating Dropdown Menus and Cell Validations
_Summarizing using the Subtotal Tool
Part 3. Analyzing Data Using PivotTables
_Basic PivotTable Features
_Grouping Data
_Using Slicers
_Calculated Fields
_PivotCharts
Part 4: Introduction to Macro Recording
Part 1. Advanced MS Excel Functions
(includes quick review of basics)
Text Functions
_Combining Texts (CONCATENATE)
_Changing Case (UPPER, LOWER, PROPER)
_Other Accessory Text Functions (SUBSTITUTE, TRIM, FIND, etc.)
Logical Functions
_Basic IF Statements
_Nested and Series IF Statements
_Using AND and OR
_Combining IF with Other Functions
Math and Date Functions
_Basic Math Functions
_Named Ranges
_Conditional Math Functions (SUMIF, COUNTIF, SUMIFS, etc.)
Shortening Long Formulas with Arrays
Advanced Lookup Functions
_VLOOKUP
_Advanced Usage of VLOOKUP
_INDEX and MATCH
_XLOOKUP
Part 2. Exploring the Data Tab Tools
Conditional Formatting
_Basic Conditional Formatting
_Formula-Based Formatting
_Creating Dropdown Menus and Cell Validations
_Summarizing using the Subtotal Tool
Part 3. Analyzing Data Using PivotTables
_Basic PivotTable Features
_Grouping Data
_Using Slicers
_Calculated Fields
_PivotCharts
Part 4: Introduction to Macro Recording
Schedules
Apr 15, 2023 - Apr 16, 2023
ENDED
Sat, Sun | 01:00 PM — 05:00 PM |
Online Live
Platform: Zoom
Platform: Zoom
No. of Days: | 1 |
Total Hours: | 8 |
Reviews
Be the first to write a review about this course.
Write a Review
Mpower Learning focuses on improving the leadership and productivity skills of Filipinos through its value-driven training.