Microsoft Excel Tutorials

In today’s Data Analysis tutorial we’ll learn how to create a scatter plot with a regression line in Microsoft Excel….

In today’s data analysis tutorial, we’ll learn how to use Microsoft Excel 365 / 2019 / 2016 to split a…

Here’s a question from Georgia: I need to create a bar chart in which i would like to show metrics…

One of the best ways you can represent numerical data is by using bar graphs. For instance, if you want…

Here’s a question from a reader: I use Microsoft 365 Excel for data entry purposes. Once i have the data…

Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted…

Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel…

Here’s a reader question: I have a co-worker that is using Excel VBA Macros to analyze a bunch of data….

Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input…

Skyler set us a note about her Microsoft Excel spreadsheet not opening in Windows 11: “I work as an analyst…

Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question…

Here’s a question from Nanda: “I work as a marketing coordinator. I need to copy list of names available in…

Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe that i have seen a Microsoft…

Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems. Here’s a question we got: Dear Team – some time ago…

Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Here’s a question that we received a few days ago: I…

Applicable to: Office 2019, 2016, 2013; 365 or standard Here’s a question that we have received from a reader who…

Dave, who read my post on how to open a pptx file approached me with a similar question. Few days…