The Magic word in Excel 2007 - PIVOT TABLES
21st May, 2014
How often are you asked to prepare reports? always!? and I bet one of the ways you retrieve the data is by importing or copying the raw data from your system and pasting it to Excel. then you insert rows, columns, move cells, highlight cells, delete some unneeded data, then...you are lost and you start over!!!
Pivot Tables comes to the rescue. I can truly say that Pivot Tables is the most efficient tool EXCEL has developed in the early years of 1990. This tool, once you know how to use it, professionally, will transform the way you manage, analyze, and report your data. I, personally was able to prepare a comprehensive budget variance reports, by department, in few seconds, among many other dynamic reports.
The newest news is Excel 2010. It comes packed with enhanced Pivot Table tools. Have you tried Excel 2010 yet?
Related Blogs
Why Finance Certifications Matter: An Experienced Perspective
In the realm of finance, I frequently field questions about the tangible value of professional certifications. Is there a discernible edge in holding a CFA, CMA, FP&A, ACCA, or CFE designation? Given the subst...
Adnan I. Akeel
14th August, 2023
Read More
Bitcoin: Is it a Ponzi Scheme?
Every country has probably had at some point in time its own Charles Ponzi, an influential con artist who lured investors to entrust him with their money and who paid quick returns to the first investors from money inv...
Facilitator/ Blogger
17th February, 2019
Read More
Building an All-Star Credit and Collections Team
Training opportunities, in less enlightened organizations, are handed around like chocolates in a box. In some instances, they are often chosen with only as much consideration. This approach is mostly the...
Facilitator/ Blogger
18th September, 2018
Read More
Turning the Credit and Collections Department into a Profit Earning Function
Below is a real-life case study by Jon Ray MICM. A few years ago, I was doing some consultancy work for one of the big European banks. This institution had some i...
Facilitator/ Blogger
22nd October, 2017
Read More