Advanced MS Excel 2007 2010 2013 2016's Enrollment Cover
Advanced MS Excel 2007 2010 2013 2016
Advanced MS Excel 2007 2010 2013 2016
Training Details

Contact us for other payment options: [email protected]

Or chat with live person: www.facebook.com/InsightsManila

Or send a text message: 0977.103.1800

The Advanced MS Excel Training will level up your skill in order to efficiently process data in the spreadsheet. This course goes beyond VLOOKUP-- you will learn to look up data regardless of data orientation. You will also learn how to make advanced pivot table features such as Calculated Fields, Slicers, etc.

Outline
  • Review of Basic Excel Functions
    • Text Functions
    • Math Functions
  • Advanced Excel Functions
    • Logical Functions
    • Lookup Functions
    • Array Functions
  • Data Management
    • Advanced Conditional Formatting
    • Data Validation
      • Basic Dropdowns
      • Advanced Dropdown Options
      • Other Data Validation Options
    • Subtotal Tool
  • PivotTables
    • Creating and Using PivotTables
    • Drill Down
    • Using Tables
    • Calculated Fields
Updates
  • Nov 01, 2017
    10:11 AM
    Insights Manila moved the schedule for Dec 07, 2017.
    ORIGINAL SCHEDULE
    Dec 07, 2017
    NEW SCHEDULE
    Nov 03, 2017
  • Nov 01, 2017
    10:07 AM
    Insights Manila moved the schedule for Nov 03, 2017.
    ORIGINAL SCHEDULE
    Nov 03, 2017
    NEW SCHEDULE
    Dec 07, 2017
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...