The other day, i received the following email: Hey there, what would be the easiest way to save my Excel 2016 spreadsheet content into a “comma separated value” file that i can pass to a supplier i work with? All in all, it’s just one worksheet that i need to send out to them once … Read more
Here’s a typical data analysis question we get from time to time: I have a spreadsheet with over 100,000 rows Excel spreadsheet that has a bunch of customer information which i need to clean up for duplicates. I would estimate that it will take a me a few days to scrub the list manually. A … Read more
Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted to understand bit more about the procedure for exporting data from an existing table. I understand that if i am interested to apply some follow up analysis to the data using Python’s Pandas library, then … Read more
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. I am wondering where can i find Power Pivot? How can i add it to Excel? Thanks for the … Read more
Post updated: May 2020 Here’s a reader question: I have a coworker 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 Update: October 2019. Applicable to Excel 2019 and below. Windows and macOS A reader was asking about whether we know of a formula to highlight or shade every other row and column in Excel. Today, we’ll learn how to apply different color schemes to alternate rows or columns in Excel. There are several ways … Read more
Last updated: September 2020 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 Krithi: “I know that Excel has some cool capabilities for setting automatic formats (such as colors/fonts sizes / height / styles) of individual columns, rows, cells specially when it relates to dates and times. Can you provide more information about auto-formatting in Excel spreadsheets” Great question. In this post we will … Read more