Excel 2013

On Excel’s 30th Anniversary, Power Query is a Game-Changer

               

Today, September 30, 2015 is the 30th anniversary of Microsoft Excel. Version 1.0 debuted for the Mac on September 30, 1985. Excel, of course, was not the first spreadsheet program. It was not even the first spreadsheet program from Microsoft, who had released Multiplan a few years earlier. Eventually, though, Excel went on to become(…)

Learn Excel – “Self-Maintaing Lookup Table”: Podcast #1868

               

Enter a product on Sheet 1. You want a VLOOKUP Formula to grab the description from a Lookup Table on Sheet 2. However, if the product is missing from Back

Learn Excel – “Put Pages of Text in One Cell”: Podcast #1866

               

Mike asks how he can hide 100 lines of Text from Word in a single Excel Cell. When the Cell is selected, the Text will appear. Back

Learn Excel – “Password to Open Excel File”: Podcast #1862

               

Chuck from Florida asks how to require a Password to open an Excel file. Using Protect Workbook does NOT solve this question, but Back

Learn Excel – “Nested Functions with fx”: Podcast #1831

               

Rob asks for tips on entering Nested IF functions in Excel. Today in Episode #1831, Bill shows us how to use the Function Arguments dialog box to assist. Back

Learn Excel from MrExcel