Post updated: August 2021 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. Thanks for the question. … 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
Last updated: May 2020 Applicable to: Microsoft Office Excel 365, 2019, 2016, 2013, 2007. Windows 7 and 10 operating systems. Skyler set us a note about her Microsoft Excel spreadsheet not opening: “I work as an analyst and have a significant number of old .xls files were created in the previous versions of Excel. Now … Read more
Last updated: November 2021 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 … Read more
Here’s a question from Nanda: “I need to copy list of names available in spreadsheet into a simple text document to then import it into a legacy information system we use at work. But when I copy the Excel columns to the clipboard and then paste in Notepad, it all goes wrong. Can you help … Read more
Applies to: Windows 11, 10, 8 and 7 and macOS operating systems. Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe 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 … Read more
Updated: October 2019 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 … 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
Applicable to: Office 2019, 2016, 2013; 365 or standard Here’s a question that we have received from a reader who wanted to divide an Excel column vertically: I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value file into the A column and now need … Read more
Dave, who read my post on how to open a pptx file approached me with a similar question. Few days ago, a friend sent me a file with the xlsx suffix as an attachment on GMail. I access my email online via my Samsung Galaxy phone, iPAD and MAC OS X High Sierra computer. I … Read more