- Home
- Excel
Context Menu Shortcut
This tip is aimed at people who already use keyboard shortcuts or are looking to try them out. You may already have noticed that when you use the right-click button on your mouse you get a different menu on screen depending on what you are clicking on. This is a context menu, if you right-click […]
Continue readingThe Alt Key Shortcuts
This tip is aimed at those of you who use keyboard shortcuts, or are interested in trying them out. My example below uses Excel 2010, but can be applied to other Office 2010 programs Whether they use them or not, a lot of people are at least aware of some of the basic “Ctrl+” shortcuts: […]
Continue readingQuick Access Toolbar
The Quick Access Toolbar (QAT) is a customizable toolbar that appears at the top of your screen in MS Office (Excel, Word, etc) versions 2007 and later. In older versions, it was possible to create your own toolbar. The toolbar allows you to add the commands that you use most frequently so that they always […]
Continue readingCombining Charts In Excel
One of the most common questions I get asked in relation to charts is how to combine two charts on one. The chart below shows actual sales numbers and target sales numbers. This is a common comparison of targets or expected numbers against actuals. The values can all be seen, the target numbers are blue […]
Continue reading& Let Us Begin! – Demonstrating Excel Logic
I am asked more and more often to give intermediate-advanced Excel classes. Aimed at people who are relatively comfortable with Excel and ready to go to the next level. Most of these students have made attempts at figuring out new formulae themselves, and usually ended up a bit frustrated! For the last year, I have […]
Continue reading