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.
Excel Power Query from Updated Folders20 January 2018 | Topic: Tips
Create a Dynamic Dropdown Menu21 July 2015 | Topic: Tips
There 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 Go25 March 2014 | Topic: Tips
So 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:
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!