CEBU Basic to Advanced Excel Training

• Cebu Philippines
• Start: Jul 19 2022 00:00
• Finish: Dec 01 2024 00:00
• Time zone: Asia/Manila

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