Details
DATE: July 15, 2023, Saturday
TIME: 8:30AM-4:30PM
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Onsite:
Registration Fee: Php2,499 per person
Location: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
NOTE: Bring Own Laptop
INCLUSIONS:
- Snacks
- Printed Handout
- Printed Certificate
- Unlimited Coffee
- WIFI access
via Zoom:
Registration Fee: Php2,299 per person
INCLUSIONS:
- PDF Handout
- 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
- Combining IF with Other Functions
Math and Date Functions
- Basic Math Functions
- Named Ranges
- Conditional Math Functions
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
(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
_Combining IF with Other Functions
Math and Date Functions
_Basic Math Functions
_Named Ranges
_Conditional Math Functions
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
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.
