NO PAYPAL, NO PROBLEM! Contact us at 09771031800 or www.facebook.com/InsightsManila for other payment methods.

The Basic to Advanced MS Excel course 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. Excel 2007, Excel 2010, Excel 2013, Excel 2016
Notes:
1. Bring own laptop
2. Lunch included
3. Handouts and certificate will be given

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

Related

---