Microsoft Excel

One of the best ways you can represent numerical data is by using bar graphs. For instance, if you want to represent a trend that has been growing over time, using a bar graph will make it much easier for the audience to understand than leaving the numerical data in tables. Fortunately, it is very … Read more

Here’s a question from a reader: I use Microsoft 365 Excel for data entry purposes. Once i have the data ready in the spreadsheet i would like to create different charts: pie, bars and so forth, all based on my dataset. It seems that by default no labels are posted in my Excel chart making … Read more

Using a quick formula to combine multiple Excel columns into one is much quicker than doing it manually. In this quick post, we’ll show two methods to do this: the ampersand formula or the CONCAT function. They are both simple, so you can choose any of the two. I will share the step-by-step procedure for … Read more

The other day, i received the following email: Hey there, what would be the easiest way to save my Excel 2016 spreadsheet content into a “comma separated value” file that i can pass to a supplier i work with? All in all, it’s just one worksheet that i need to send out to them once … Read more

Here’s a typical data analysis question we get from time to time: I have a spreadsheet with over 100,000 rows Excel spreadsheet that has a bunch of customer information which i need to clean up for duplicates. I would estimate that it will take a me a few days to scrub the list manually. A … Read more

Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted to understand bit more about the procedure for exporting data from an existing table. I understand that if i am interested to apply some follow up analysis to the data using Python’s Pandas library, then … Read more

Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting.Looks like Power Pivot is missing in my system, as i don’t see it in my Excel 365 installation. How … Read more

Post updated: August 2021 Here’s a reader question: I have a co-worker that is using Excel VBA Macros to analyze a bunch of data. Can you explain how Macros work, and probably suggest a way for me to pick that skill up? Any simple tips for beginners are very much appreciated. Thanks for the question. … Read more