Why not start the year with a powerful tutorial on Excel power queries. In just 8 minutes you’ll learn how to get data from folder with consistently added monthly files, saving yourself dozens of hours over the year.
Blog ›Tips
-
Excel Power Query from Updated Folders
20 January 2018 | Topic:Tips -
Create a Dynamic Dropdown Menu
21 July 2015 | Topic:TipsThere is a simple solution in Excel that prevents all kind of errors while copy-pasting data from one table to another. Essentially, you can easily create a dropdown menu that will correspond to the data in the first table, even if the data have been changed since. Watch a quick videotip above to see how.
-
Excel, Well.. Here We Go
25 March 2014 | Topic:TipsSo in the last couple of days, I've shown you many interesting things about PowerPoint and Word. It would be, of course, impossible to skip Excel. So today, I gathered the most interesting information from our blog and now posting it here in a new concise and accessible form:
Hide columns or rows that you wish to keep private, or avoid printing
Share a workbook over the cloud
There are thousands of tutorials on Excel online. However, it's very difficult to find a gem in gigabytes of information. I'm sharing these tips with you for the same reasons I wish someone had shared them with me when I was learning Excel. Let's get proficient together. Tomorrow, I will publish some original content, made right here in PowerConcepts!