Excel’s 3 Best Kept Secrets

/, Formatting, Functions, Productivity/Excel’s 3 Best Kept Secrets

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.

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!

More Information

If you are interested in training courses in Excel and Power BI please click here

In-house Courses

If these dates don’t suit you, why not just run a course in your office.

*Indicates Mandatory Field

Course Details

*Course

*Your Name

*Email

Phone

How should we contact you?
phoneemail

Enquiry