Power of Excel: Business Fundamentals Badge 2.0

The Power of Excel: Business Fundamentals Badge 2.0 is awarded to individuals who have completed Levels 1 - 3 in a Power of Excel Series (excluding Financial Management) and solved an Excel Challenge since January 2021. Attendees have learned a combination of the functions noted below and applied their skills by solving a Challenge to reflect an understanding of visualizing data through the use of Pivot Tables, slicers, and other analytical tools in Excel. Some of the functions that are covered in these Bootcamps include: Level 1: Terms and shortcuts used in an Excel document Use formulas to create basic financial sheets Use cell referencing to quickly solve problems Static vs. dynamic formulas Use charts to analyze data Detailed cell formatting Conditional formatting Use tables to organize data Math and trig formulas (e.g., rounding, average, median, min, max, sum) Text formulas (e.g., upper, lower, proper, left, right) Date and time formulas (e.g., year, month, date) Lookup and reference formulas (e.g., vlookup, transpose, choose) Logic formulas (e.g., if, or, and) Level 2: *Level 2 builds on and uses the skills learned in Level 1* Terms and shortcuts used in an Excel document Using data validation to create dropdown menus Lookup and reference formulas (e.g., vlookup, indexmatchmatch) Intermediate logic formulas (e.g., combining several logic formulas to create one function) Math and trig formulas (e.g., sum, average) Statistical formulas (e.g., count, counta, countif) Using goal seek to perform a what-if analysis Creating a one-variable and two-variable data table to perform a what-if analysis Troubleshooting in Excel (e.g., circular references) Level 3: *Level 3 builds on and uses the skills learned in Level 2* Terms and shortcuts used in an Excel document Creating interactive and visually compelling dashboards Organizing large amounts of data using PivotTables, PivotCharts, tables, slicers, charts Using advanced formatting to analyze data (e.g., sparklines, conditional formatting) Introduction to VBA (Visual Basic for Applications), the programming language of Excel Introduction to PowerPivot and PowerQuery