One Feature to Supercharge Your Excel in 2020

Excel has not changed much over the years despite massive disruptions in technology. However, the foundations of any Excel workbook start to quiver as we lean in and as we lean in and build complex solutions with larger and larger sets of data. We use formulas such as Index/Match or Vlookup to connect these tables and move toward our desired solutions. By the end of the day, your machine struggles to process the complexity of your workbook. There is one Excel feature that can solve all these issues and supercharge your Excel in 2020.

Get & Transform (Power Query)

Get & Transform (more commonly referred to as power query) is a user-friendly tool to get data from any number of different sources, build steps to transform the data, and load the data into a workbook. It is accessible in newer versions of Excel in the “Data” tab of the ribbon by clicking on “Get Data”. Older versions can download power query as a free add-in.

Power Query has the power to automate the entire back end of your Excel workbooks so that you can focus on the activities that drive value such as reporting and analysis. There are so many possibilities in power query that can streamline a data-driven Excel workbook, and minimize the possibility for human error.

This feature will supercharge your Excel in 2020 because you can:

Many Excel professionals consider this to be the most powerful feature in Excel. Few professionals are aware of this feature’s full potential. This is highlighted by the fact that few employers list this as a required skill for financial analyst positions at both the junior and senior levels. From my personal experience, Power Query has supercharged my career through the past three years. I have used it to build financial models, forecasting models, business cases, reports, and a double-entry accounting system using the ASPE accounting standard. The possibilities are endless.

Related posts:

As in previous Stage 2, I have tried to change the build options to improve the performance. Unfortunately, the performance after changes on both aarch64 and x86_64 did not meet my target 3% set up…

Ethereum experienced a big fall. Many think that will be the doomsday, including Nouriel Roubini “Dr. Doom”, said the value of Ethereum fell unexpectedly. Because, as a cryptocurrency and…

The last chapter in this story about the Planck, and a video at the end.