Contextures

Contextures News

More Excel Shortcuts

October 4, 2016

Excel shortcuts, 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.

Roll Through the Ribbon

If you like keyboard shortcuts, you probably use the F10 key to activate the Excel Ribbon. Then, type a letter, or use the arrow keys to roll though the Ribbon tabs, to find the command that you need. You can get a list of keyboard shortcuts on my website, or search for one in the interactive list

And if you prefer the mouse, you can use it to roll through the Ribbon tabs too. Click on any tab, to activate the Ribbon. Then, use the scroll wheel on the mouse, to move through the tabs. Turn the wheel up to move left, and down to go right.

It's a quick way to find a command, if you can't remember exactly where it is! Frequently, I look for the Name Manager on the Insert tab (it was there in Excel 2003), then have to go to the Formulas tab.

ribbon shortcuts

Make a Timetable

This weekend is our Canadian Thanksgiving, and we'll have 16 people here for dinner. To make sure everything is ready on time, I'll be using my Excel Holiday Dinner Planner. Pick the time that you want to serve dinner, then enter all the dinner items, and the times required for each step. The workbook calculates the timetable, and you can print a list, or a Gantt chart that shows the schedule.

It's not just for dinner planning though. You could use the same technique to plan other types of activities.

holiday dinner planner

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Power BI - If you've been pulling your hair out, trying to get Power BI to work, take a look at Dick Moffatt's technique. In part 1, he had detailed instructions for some of the obscure settings. (Level - Intermediate/Advanced)

Excel Fun - Excel is usually used for business, but Jan Karel Pieterse shows how to make a spinning wheel of fortune with it, for a little fun. (Level - Intermediate) And if you just want to relax, I posted a few videos for you to have an Excel sing-along. (Level - All)

Also, see all my Excel products on my Contextures website.

Blog Update

Last week, I had all kinds of computer problems, including a crash on my Contextures Blog. I did a quick fix during the week, then spent the weekend updating the blog, to get things running smoothly again.

For the new blog header, I used one of my flower photos, instead of something spreadsheet-themed. I hope nobody is confused, and looks for gardening tips!

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:52 AM