Advanced MS Excel's Enrollment Cover
Advanced MS Excel
Advanced MS Excel
Training Details
This training aims to review and strengthen the basics of Excel and enhance this further with knowledge of advanced functions and tools of the program.

DATE: August 5, 2023, Saturday
TIME: 9AM-4PM

YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM

Onsite:

Registration Fee: Php1,999 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
  • lunch (fastfood)

via Zoom:
Registration Fee: Php1,499 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
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
Updates
  • Jul 02, 2023
    11:29 PM
    Insights Manila moved the schedule for Jul 15, 2023.
    ORIGINAL SCHEDULE
    Jul 15, 2023
    NEW SCHEDULE
    Aug 05, 2023
75 Courses

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.

Contact Us
7F Finman Centre, 131 Tordesillas St., Salcedo Village,
Makati, Metro Manila, Philippines 1227
72242056
Sending Message
Please wait...
Loading...