FreeData & Analytics
Excel
Learn the exact Excel skills employers screen for: formulas, PivotTables, Power Query, and VBA automation, by building a personal budget tracker, a sales dashboard, and an interactive KPI dashboard you can put straight into a portfolio.
Learn the Excel interface, formatting, and basic formulas by building six real spreadsheet templates.
- Navigating the Excel interface, cells, and worksheets
- Formatting numbers, text, and cell styles
- Building a payroll sheet and a gradebook with formulas
- Sorting and filtering a sales database
- Using basic functions to solve real problems