Excel Tips

Use Power Query to Load Many Web Pages »

February 24, 2023

I need to load data from a series of web pages. The Web Query technique from Excel 2003 rarely works with modern web pages.

Total Numbers From Data Alt-Entered »

February 23, 2023

I work for a bunch of people who don't know how to use Excel. They insist on treating an Excel like it is Microsoft Word, using Alt+Enter to put multiple things in one cell.

Use Power Query to Clean Data Already in Excel »

February 22, 2023

My data is already in Excel. I need to transform the data. I need to unpivot the month data.

Fill in Blanks with Values from Above »

February 21, 2023

I need to fill in all the blank cells with the value from above.

Load a Folder of CSV or Excel Files into a Single Excel Worksheet »

February 20, 2023

My I.T. department products a CSV file for every customer and I have to load all of those into Excel.

Load a List of File Names into Excel »

February 17, 2023

Windows Explorer will show you a list of files in a folder, You can sort by name, sort by date, sort by size. But sometimes it would be great to have this list in Excel.

Power Query is Easier to Learn than VBA Macros »

February 15, 2023

I could never figure out the macro recorder or VBA macros. Is Power Query just another macro recorder?

Load and Clean Data with Power Query »

February 14, 2023

I get a file from the ERP system that is formatted incorrectly. I routinely have to do the same formatting steps every week.

Know if You Have 32-Bit or 64-Bit Excel »

February 13, 2023

Microsoft has done their best to make sure you ended up with 32-bit Office. If you plan on loading 10 million rows into Power Pivot, you really need 64-bit Office.