How to Reconcile Accounts using Power Query

How to Reconcile Accounts using Power Query! What? Did I hear you right? Reconciling accounts is a common task carried out by accountants on a regular and reoccurring basis.  Creditor statements and bank accounts are examples of accounts that need regular reconciliation. But what if you could create a model, within minutes, that you could […]

The Secret Power of SUMPRODUCT in Excel

SUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together.  However, SUMPRODUCT is a function that accepts arrays, making it a very powerful function beyond its basic use. In this video, you will learn the secret power of SUMPRODUCT as we work through 5 different examples Basic traditional use SUMPRODUCT […]

Tips for Analyzing Categorical Data in Excel

It is often necessary to analyze different data types in Excel, including analyzing categorical data in Excel. Having opened up some blog posts to questions from you, the reader and Excel learner, Jeff sent me on this question: ” I am new to Excel and using it to start my learning journey in basic data […]

Excel’s Map Charts

Map charts can be used to visually display values and category’s across the geographical area.  These charts can be worldwide, and they can also be much closers such as your state, county or city.  In Office 365 or Excel 2019, you now have the option to use Map visualizations to view your geographical data. How […]

The CHOOSE function in Excel

The CHOOSE function in Excel is very versatile.  It can be used as a lookup and it can be combined with many other functions that make it extremely useful. “Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index […]

quick charts in excel

4 Excel Tricks to Make Life Easier

Excel is an amazing tool that can do so much, from keeping basic lists to more complex data analysis and visualizations. In this article today you are going to learn 4 Excel tips that will make your life easier and you more efficient in Excel. In this article we are going to look at Simple […]

Excel Power Tools – The Future of Excel

For years now Accountants and bookkeepers around the globe have used Excel as their Spreadsheet  tool of choice.  It offers massive flexibility, speed and is as accurate and reliable as the users. But to this day, some Excel users never go beyond the basic totting and cross totting of rows and columns. Excel has come […]