What are Excel’s 3 Best Kept Secrets?
Excel has seen great advancement in the last 10 years and every user who spends their days re-organising data can benefit hugely from Excel’s 3 best kept secrets.
1. Power Query
If you or members of your team use Excel a lot then you are missing out massively if you don’t find out about Power Query.
The efficiency gains are staggering.
No more copy paste between Excel data dumps, no more hours cleaning up messy CSV’s or applying complex VBA. Seriously, it’s amazing.
What is Power Query?
Want to find out more about Power Query? Click here
2. Power Pivot
Handle Millions of VLOOKUP style relationships in seconds
Load 100’s of millions of records into Excel.
Add massively useful formula to Pivot Tables such as Year To Date v Full Year Budget. Actuals this year v Last Year, YoY Growth % etc.
What is Power Pivot?
Want to find out more about Power Pivot? Click here
3. Last but by no means least…the simple Table (Ctrl+T)
I still find only 20-30% of Excel users have used Tables . They are one of the 3 best things to happen to Excel in the last 20 years!
If you are interested in training courses in Excel and Power BI please click here
If these dates don’t suit you, why not just run a course in your office.