As an EXCEL user, if you have been creating a lot of tables and have not yet been introduced to Pivot Tables, you are missing out on EXCEL’s most advanced & powerful business intelligence (BI) solution for data analysis. It comes with EXCEL and there is no need to pay for a plug-in.
Pivot Tables empowers you to visually & interactively slice & dice (BI’s jargon for filtering & segmenting your data repeatedly) your data to get to the level of data you require for reporting & analysis. And to further aid your analysis, present your results graphically as Pivot Charts which are linked to your Pivot Tables. They are dynamically updated as you work with the tables.
While this sounds rather complex, EXCEL’s implementation of this business intelligence solution is excellent while keeping it elegantly simple. You don’t have to spend too much time to master it. Once you have understood the concept & learnt Pivot Tables, you get to focus on the data analysis work at hand. Its intuitive software user interface is certainly appreciated. No longer will you be bothered & distracted by a badly designed user interface that encumbers your productivity.
Head on to this free tutorial by GCF (specially selected by yours truly to aid in your noble effort) to equip yourself with this new skill. It gets straight to the point and takes you through step-by-step. Watch the videos first. Then download the work file to practice as your learn.
You now have a new weapon. Your boss will be impressed. It will change your life. Promise!
If you want to know more about the history of Spreadsheet softwares, let me know. I would be more than happy to oblige. I have been using them since the introduction of PCs to the world.
As always, if you find this tip useful & helpful, do click Like and let me have your feedback in the comments.
Feel free to share if it will help others. Sharing is caring. 😉