Microsoft Excel Tutorials

“I have several CSV files with sales data that I need to import into Access for analysis. What’s the best…

I have a spreadsheet with full names in a single column cell in my Excel spreadsheet, but I need to…

User Question I’m managing a project timeline in Excel and need to calculate the duration in months between start and…

“Our company’s fiscal year begins on July 1st, which often leads to confusion when analyzing data across calendar years. Is…

Here’s a question from a colleague: I’ve received a spreadsheet containing employee information, including their start dates. However, these dates…

User Question I have an Excel 365 spreadsheet tracking customer orders with transaction dates, but I need to analyze sales…

Creating dynamic and automated chart titles in Excel can significantly enhance your data presentations, making them more interactive and easier…

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…

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…