CEBU Basic to Advanced Excel Training
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
read more