Mar. 20, 2019 - 5:51 am

Advanced Excel Training - Ortigas

2019-03-16 09:30:00 2019-03-16 17:00:00 Asia/Manila Advanced Excel Training - Ortigas

This training is for those who already has an existing knowledge of Basic MS Excel.

_____________________

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Notes:

1. Bring own laptop

2. Lunch included

3. Handouts and certificate will be given

Outline:

Module 1: Quick Review of Basic Functions

Text Functions UPPER LOWER PROPER LEFT RIGHT MID CONCATENATEBasic Logical Statements IFBasic Math Functions SUM AVERAGEBasic Lookup Functions VLOOKUPCombining Functions

Module 2: Advanced Excel Functions

Text Functions TRIM, SUBSTITUTECombing Logical Tests using AND and ORAdvanced Math Functions SUMIFS, COUNTIFS, AVERAGEIFSAdvanced Lookup Functions: INDEX and MATCH

Module 3: Advanced Data Tools

Creating Own Conditional FormattingData Validation with FormulasSubtotal Tool

Module 4: Advanced PivotTables

Review of Basic PivotTablesGroupingSlicersCalculated FieldsPivotCharts

If time permits: Macro Recording

Unit 75-77 G/F Eton Cyberpod Corinthians, Ortigas Avenue Insights Manila info@insightsmanila.com
Starting On:
Mar. 16, 2019 | 09:30 am
Ending On:
Mar. 16, 2019 | 05:00 pm
Venue:
Bspot - G/F Eton Cyberpod Corinthians, Ortigas Avenue
Organizer:
Insights Manila
Event Description

This training is for those who already has an existing knowledge of Basic MS Excel.

_____________________

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Notes:

1. Bring own laptop

2. Lunch included

3. Handouts and certificate will be given

Outline:

Module 1: Quick Review of Basic Functions

  • Text Functions UPPER LOWER PROPER LEFT RIGHT MID CONCATENATE
  • Basic Logical Statements IF
  • Basic Math Functions SUM AVERAGE
  • Basic Lookup Functions VLOOKUP
  • Combining Functions

Module 2: Advanced Excel Functions

  • Text Functions TRIM, SUBSTITUTE
  • Combing Logical Tests using AND and OR
  • Advanced Math Functions SUMIFS, COUNTIFS, AVERAGEIFS
  • Advanced Lookup Functions: INDEX and MATCH

Module 3: Advanced Data Tools

  • Creating Own Conditional Formatting
  • Data Validation with Formulas
  • Subtotal Tool

Module 4: Advanced PivotTables

  • Review of Basic PivotTables
  • Grouping
  • Slicers
  • Calculated Fields
  • PivotCharts

If time permits: Macro Recording

Event Map Location

buy tickets

Advanced Excel Training - Orti ...
Regular: 1, 899.00 Php
Quantity:
Total: 0.00 Php
Voucher Code:
Handling Fees: 50
Net to Pay: 0.00 Php