- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Excel Stack - Gold
Issued by
Lumify Group
Earners of the Excel Stack Gold badge have extensive excel skills, including: creating complex formulas, develop dynamic charts and reports, using pivot tables, conditional formatting, defined names and data validation. Earners can automate repetitive tasks with Macros and understand data analysis. They can also clean data using Power Query and create smart, advanced data models using Power Pivot. Earners have mastered data modelling, analysis, and visual building for effective dashboards.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Chart Elements in Excel
- Charting performance against a target in Excel
- Complex Formulas
- Complex Formulas in Excel
- Conditional Formatting
- Controls in Excel
- Dashboard Design Principles
- Data Linking in Excel
- Data Types in Excel
- Date and Time Functions
- Defined Names in Excel
- Essential Functions
- Filling Data in Excel
- Financial Functions
- Formula auditing
- Formula Referencing
- Formula Referencing in Excel
- Functions for Analysis
- Get Data in Excel
- Goal Seeking in Excel
- GoTo Special in Excel
- Histograms in Excel
- Importing and Exporting in Excel
- Logical Functions
- LookUp Functions
- Lookup Functions in Excel
- Making an Interface
- Maths Functions
- Number Formatting Techniques
- Office Script in Excel
- Open Power Query
- PivotCharts
- PivotTables
- Power Automate Desktop
- Power Automate Online
- Power Pivot
- Protecting Data in Excel
- Recorded Macros in Excel
- Scenarios in Excel
- Slicers in Reports
- Solver in Excel
- Transform Data in Excel
- Trending Charts
- Using Sparklines to show trends
- Validating Data
- Working with Columns in Excel
- Working with Queries in Excel
- Worksheet Tables