“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…
Here’s a question from a colleague: I’ve received a spreadsheet containing employee information, including their start dates. However, these dates…
How to insert a bar chart into Microsoft Excel 365 worksheets?
One of the best ways you can represent numerical data is by using bar graphs. For instance, if you want…
How to add data labels and callouts to Microsoft Excel 365 charts?
Here’s a question from a reader: I use Microsoft 365 Excel for data entry purposes. Once i have the data…
How to export data from Microsoft Access tables to .CSV, Excel and text formats?
Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted…
How to enable Power Pivot data analysis for Excel if it is missing?
Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel…
Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input…
How to access and open an Excel 97/2003 .xls file in Excel 2016, 2019 and 365?
Skyler set us a note about her Microsoft Excel spreadsheet not opening in Windows 11: “I work as an analyst…
How to make Office 2016 or 2019 or 365 your default Microsoft Office application?
Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question…
How to embed Word objects into an Excel 365 & 2019 workbooks?
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…