Advanced Excel Training - Ortigas

This TRAINING IS FOR THOSE WHO ALREADY HAS AN EXISTING KNOWLEDGE OF BASIC MS EXCEL. (You may also join the Basic EXCEL TRAINING OF THE PREVIOUS DAY TO PREPARE YOURSELF FOR THE ADVANCED EXCEL TRAINING-- link here: Basic EXCEL IN MAKATI: https://www.eventbrite.com/e/basic-excel-training-makati-tickets-53778436752 [https://www.eventbrite.com/e/basic-excel-training-makati-tickets-53778436752] _____________________ The 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 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