Details
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
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
Sat, Sun | 01:00 PM — 05:00 PM |
Mon, Tue | 08:30 AM — 12:00 PM |
Insights Manila (registered as Insights MLA Business Solutions) is a training services company based in Makati. The company believes that the country’s workforce requires ample training that is effective and insightful, yet affordable.
The consultants of Insights Manila are experienced professionals who had executed the courses several times for different companies under various training institutions.
Insights Manila mostly offers exclusive training for companies. The courses are customized to meet specific training needs. The company also offers public classes where individuals can enroll, and one-on-one training for people who wish focused training. Other than training, the company also accepts Excel automation projects and course development projects.
With Insights Manila, you are directly dealing with the consultants– no intermediary parties who just add costs to the training delivery.