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
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
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. Introduction to Excel 365 Macros Mastering Macro development … Read more
Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input into a database table, but as i have already gathered there a way to automatically import data from an Excel workbook into an Access database table instead”? Good question, Thanks. Yes, you can automatically import … Read more
Skyler set us a note about her Microsoft Excel spreadsheet not opening in Windows 11: “I work as an analyst and have a significant number of old .xls files were created in the previous versions of Excel. Now that i have upgraded to the new version, Excel 365 won’t open the existing files telling me … Read more