VLOOKUP Refresher

Lessen

Delen Volledig scherm afsluiten Terug naar cursus

Excel Intermediate

Intro
- Intake Excel Intermediate
- Bibliotheek en website
- Waarom Excel?
- Kwaliteit spreadsheets verbeteren
- Checklist onderwerpen Excel Intermediate
- Voorbeeld puntenverdeling examen
- Power Pivot Position
Interface
Functions & Formulas
- Essential Excel Functions
- Rounding numbers
- Excel practice test formulas
- Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
- Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
- VLOOKUP Refresher
- Must know functions for HR
- Conditional Formatting Formulas
- Oefening nieuwe Excel functions
- How to Use the XLOOKUP function (with 5 Examples)
- Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
- Properly Use Excel IFS Function
- 200 Functions for Finance
- Excel Cell Reference: Absolute, Relative or Mixed?
- A. 101 Ready-to-Use Excel Formulas - Michael Alexander
- Oefening SUMPRODUCT
- Must know functions 4 HR
Charts
Pivot tables & pivot charts
- Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)
- Oefening GDP
- Oefening Ziekteverzuim
- Checklist pivotcharts_tables_dashboard
- Wall of Boudreau
- Secrets to Building Excel Dashboards in Under 15 Minutes!
- Excel PivotTables Made Easy - And Why Things Go Wrong!
- Advanced Pivot Table Techniques (to achieve more in Excel)
- 5 Dashboard Design Tips - COMMON MISTAKES to avoid!
- Data Analysis for BEGINNERS in Excel in 2024 | No Python Required
Data Tools
Nested formulas
Automation
- Controls - VBA
- Office Scripts
Excel Books - Theorie
Quizzes
- McGrawHill Excel 2013 Quiz
- McGrawHill Excel 2010 Quiz
- Excel Test Functions & Formulas
- Quiz Excel Functions
Webbronnen
- Links naar websites
- Links naar Tips & Tricks
- Excel Help & Learning Microsoft
Extra's
Diversen
- Build a Dynamic 3 Statement Financial Model From Scratch
- Excel Advanced Quiz 1
- Infographic_'Meer_inzicht_dankzij_data'
- Vacatures