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
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 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