Contextures

Contextures News

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..

Quick File Open

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.

open excel files

Data Cleansing Videos

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 Combo Box

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.

dependent combo box

Excel Articles

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.

Excel Meal Plans

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!

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:51 AM