spreadsheet-solutions-blog-icon-articles

Power Query - Deel 1 - De Basis

Tips & trucs Power Query - De Basis Voor veel Excel gebruikers klinkt…


De functie X.ZOEKEN

Tips & trucsDe functie X.ZOEKENMet de functie X.Zoeken kun je in lijsten,…


spreadsheet-solutions-blog-icon-articles

Building Dashboards in Excel > Part 5 - Slicers

Tips & trucsBuilding Dashboards in Excel - Part 5 - SlicersWhen you create…


spreadsheet-solutions-blog-icon-articles

Building Dashboards in Excel > Part 4 - Pivot charts

Tips & trucsBuilding Dashboards in Excel - Part 4 - Pivot ChartsWhen you…


spreadsheet-solutions-blog-icon-articles

Building Dashboards in Excel > Part 3 - Pivot tables

Tips & trucsBuilding Dashboards in Excel - Part 3 - Pivot TablesWhen you…


spreadsheet-solutions-blog-icon-articles

Building Dashboards in Excel > Part 2 - Tables

Tips & trucsBuilding Dashboards in Excel > Part 2 - TablesWhen you…


spreadsheet-solutions-blog-icon-articles

Building Dashboards in Excel > Part 1 - Valid data

Tips & trucsBuilding Dashboards in Excel > Part 1 - Valid dataWhen you…


Time registration with Day and Night shift hours

Tips & trucsTime registration with Day and Night shift hoursUse VBA to…


Empty cells and zero values

Tips & trucsEmpty cells and zero valuesUse CONDITIONAL FORMATTING to…


Inserting Unique entries

Tips & trucsInserting UNIQUE entriesUse DATA VALIDATION to restrict user…