Quick Excel File Open Tip
September 20, 2016
Fast way to open Excel files, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there..
If you have Excel on your Windows taskbar, right-click that icon to see a list of files that you opened recently. It's a quick way to get back to work on yesterday's project.
Did you already sign up for the FREE 3-part Data Cleansing video series from John and Oz at MyExcelOnline?
The second video is available now, and it will show you how to format and extract data using formulas and Excel's data tools. Download the Excel workbooks, and follow along with the video. If you ask questions, John or Oz will help you out!
Data entry is easier with a drop down list in Excel, but font size is tiny, and there are other limitations. So, in some workbooks I show a pop-up combo box, instead of that drop down list. That lets me change the font size, and when you start typing, the matching item is filled in (autocomplete).
Last week, I uploaded a new combo box sample file that shows a dependent list -- for example, get a list of cities based on the region selected in a different cell. The new example works for simple INDIRECT formulas, such as =INDIRECT(E2), where the region name is in cell E2
You can learn more about it on my website, and download the sample file.
Here are a couple of Excel articles I read recently, that you might find useful.
Excel World Champ - Even if you don't want to compete in the Excel World Champ event, there is a handy list of Excel training resources in the first comment. Take a look at the guides, hands-on labs, and other types of support and documentation. (Level - All)
Cool Chart - On Chandoo's blog, Hui shows how to make a cool type of chart -- stacked bar with an indicator arrow. Download the workbook to follow along. There are several steps, but nothing too complicated. (Level - Intermediate)
Also, see all my Excel products on my Contextures website.
Every weekend, I plan the next week's meals, using my Excel meal planner, of course! I've got a long list of recipes in that workbook, but occasionally we like to try something new. So, I dug out all the Canadian cookbooks in my collection, to see what local delicacies could be put into the meal rotation.
The covers look pretty good, but some of the pages inside are a bit worse for wear. It's easy to tell which recipes we enjoy -- just like your cookbooks, I'm sure!
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:51 AM