In today’s Excel Data Analysis tutorial, we’ll learn how to split cell containing date values into separated cells. In this tutorial, we will focus on accomplishing our tasks with simple Excel formulas, although in more advance scenarios we could use Power Query for Excel or a VBA macros as well. We also added an option … Read more
In today’s Data Analysis tutorial we’ll learn how to create a scatter plot with a regression line in Microsoft Excel. Create example data We’ll get started by creating a very simple data set that you can easily copy into an Excel spreadsheet and follow along. Sales Revenue 345 45.41088 312.0128 68.19295 234.7125 42.02261 248.6958 32.54282 … Read more
In today’s data analysis tutorial, we’ll learn how to use Microsoft Excel 365 / 2019 / 2016 to split a date cell into year, months and days values using formulas. In a nutshell, we’ll go through several cases in which we’ll convert a full date which format is mm/dd/yyyy hh:mm:ss into shorter date forms. Note: … Read more
Here’s a question from Georgia: I need to create a bar chart in which i would like to show metrics for two different series. For some reason i am not able to insert and additional y axis to my bar chart. Any ideas on how to go about showing a plot that has two y … Read more
Here is a question from Amanda: I use Excel in order to create a monthly report that contains some bar and scatter charts, all fed from data in another worksheet, once i insert my charts, i have noticed that none of them include axis titles. Any idea how to add those axes labels to the … Read more
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