Applicable to: Word and Excel 2019, 2016, 2013, 365. Microsoft and Apple Office versions. Latest update: October 2019 Chances are that from time to time you might want create forms using in Office in order to easily capture user feedback or document a standard operating process. In today’s tutorial, we’ll teach you pretty much everything … 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
If you use Excel to analyze large data sets, you might have encountered the need to find and remove duplicate rows from your data. In today’s post, we’ll provide a simple tutorial to help you find those duplicates and scrub them from your data. Although Excel 2016 is used to outline the steps below, they … Read more
Chances are that you might want to validate and standardize user input in Excel using drop down menus. In today’s tutorial we’ll take you through the process of creating the drop down, validating user input as well as showing an error message if a invalid data is entered. Read further for the entire step by … Read more
Few weeks ago we received a note from a reader: Every quarter, our team creates handouts for management meetings. The process of developing the handouts is pretty elaborated and requires to collaborate in development a series of workbooks, presentations and documents. In order to clearly determine the status of those documents we wanted to use … Read more
Applies to: Excel 2019, 2016, 2013; Office 365; Windows 10, 7 and macOS. 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 … 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