Excel: Merge multiple files from a folder
Looking to combine multiple files with a similar structure? Achieve it effortlessly in just a few clicks using Power Query in Excel.
Category: Power Query
Excel: Import a table from a PDF file or website
Do you wish to import a table from a PDF file into Excel? Do this task effortlessly with Power Query in just a few clicks.
Power Query: Change the load options
In Power Query, have you loaded your data into a table when you only wanted to create the connection? Change your load options.
Power Query: Comments in steps
As you build your file, be sure to rename and comment out each step to keep a clear history of your thought process.
Multi-selection with CTRL and/or SHIFT
To select multiple items in a list, whether contiguous or not, use the CTRL and SHIFT keys on your keyboard.
- 1
- 2