Everybody knows Excel to some extent.....want to go further..... Take this course to take your Excel skills to the next level.....
What I cover in this course ?
* Understanding and familiarizing yourself with the Excel 2016 environment and Ribbon * Start from Filtering Data with different techniques * Learn how to use subtotals to summarize large data sets * Master the commonly used formulas for summing thousands of rows * Understanding when and how to use Absolute Reference and Relative reference * Counting, Summing and Average Formulas with multiple criteria * Running Advanced Filter with multiple criteria * Extract unique entries from thousands of rows * Master Formulas, Audit them, Decode them, Build Formulas inside Formulas, Arrays * IF formulas, with AND criteria * Vlookup with single and multiple criterias * Text Formulas and its uses * How to use sparklines * Goal Seek, Data tables, Sensitivity Analysis * Use of Index, Match , Offset Formulas * Formula Auditing tools * Use of Pivot tables in depth * Slicers and how to use them effectively * Conditional Formatting in Excel * Flash Fill * Named Ranges and why and how to use them * Introduction to Macros * Effective use of Excel Tables * Using PasteSpecial and its features effectively * Tons of Excel shortcuts to make you an Excel Star * How to make effective Charts * Introduction to Macros, what they are, why use them with live examples.
Days and timings flexible as per your call. One to One training to get the maximum benefit.
Tag along a friend for the course and get yourself a 30% Discount!!
Other courses I offer: * Charts and Dashboards * PowerPoint Essentials * Mastering Pivot tables in 3 hours * MS Word for Beginners to Intermediate