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
Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question we received from one of our readers: “I’ve just installed a new version of Office 365 in my system but it’s clearly not defined as the default program for viewing and editing of Microsoft Office … Read more
Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe that i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how can i insert Word files into Excel and in general how to embed file objects in Office? Just so you are … Read more
Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems. Here’s a question we got: Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i previously set. So … Read more
Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Here’s a question that we received a few days ago: I am currently using Excel 2016 on my Windows 10 based computer. As i am quite a fast typist, i often accidentally make quite a bit of spelling mistakes. For some reason i expected that Excel … Read more