If you've been paying attention lately, you'll have noticed that Excel is evolving rapidly! In the last couple of years Microsoft have added new tools like Power Query and Power Pivot, just to name a few. These are amazing new tools, and it can be really easy to get comfortable with the tools that you already know without realising that there are tonnes of new tools and features designed to get the job done in a fraction of the time.
Embracing these new tools will not only enable you to get your work done more quickly, but also since less than 1% of Excel users know these tools you're going to have a huge competitive edge in the workplace!
It's easy to ignore these developments and continue doing things the way you always have, but if you ever find yourself thinking:
then you really should consider spending some time on learning these new tools. If you really want to dazzle your boss and colleagues, then here are some of the new tools you need to know:
Power Query is a free add-in built by Microsoft for Excel users like you and I. It’s available in all Desktop versions of Excel 2010, 2013* and 2016.
1. Power Query gets your data from almost anywhere – the web, databases, Excel files, Facebook, OData, SharePoint, Salesforce etc. and the list keeps on growing with new data sources being added all the time.
2. Power Query enables you to clean, transform, merge and append data with a point and click style GUI that’s easier to learn than formulas or VBA.
3. Load the data into Excel and or Power Pivot and consume it in your analysis, reports or export elsewhere.
Power Pivot for Excel fixes all that.
Leveraging “big data” in your business might be crunching sales patterns to plan inventory levels, cutting staff expenses by analysing employee overtime and rearranging work schedules or using social media data to gauge what customers think about your business and competitors.
Power Pivot for Excel enables you to transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds, all with the comfort of familiar Excel tools and features.
All without requiring IT assistance.