How to Find and Remove Duplicates in Excel
In working with data from any source, you need to make sure you don't have duplicate values. In many systems, this can be particularly cumbersome. In my favorit...
Tips on how to use Microsoft Excel
In working with data from any source, you need to make sure you don't have duplicate values. In many systems, this can be particularly cumbersome. In my favorit...
We've already looked at how to use VLookup to return a corresponding value from another sheet here (VLookup Basics). Now we're going to expand upon that and add...
The VLookup is the most useful and powerful function in Excel. I don't say that lightly. I've been working in Excel for nearly 20 years and have not used any ot...
In my latest course, Business Dashboard Fundamentals, I cover step-by-step how to make Excel Dashboards. These Excel Dashboards are just one of the two practica...
Ever have problems using your standard keyboard shortcuts in Excel when running it on a Mac in VMFusion? Me too… So, after some digging and testing I foun...
If you are unfamiliar with web queries its OK, their easy, and I’m gonna explain how they work and how to manipulate them beyond their intended use to increase ...
If you've not heard of Gemini yet you're in for a treat. I found these videos on youtube yesterday of the Gemini demo from the BI conference last year that you ...
Below is a recent screencast I recorded showing how to build a project timeline (gannt chart style) using MS Excel. It's simple and easy and works great for por...
I was recently fighting with Excel because I was sick of it wanting to run in Compatibility Mode by default. Everything I found out there said that you simply n...
Recently I was on a call with a client and one of their IT guys asked if the Microsoft Business Intelligence stack can do everything Exclesius can do. In short,...