Excel Courses
I have a passion for Excel.
It's a never ending source of new methods; learning and new ways of workings.
It can change your working life; reduce the drudgery of repetition and surprise you with possibilities.
It's like a river with many tributaries - there is always another way of completing a task; another method; another option.
I love the thrill of finding a shortcut; of discovering how incredibly powerful this programme is.
Come journey with me, bring an enquiring mind and enjoy the experience.
In Excel 2007 the number of rows on a worksheet has gone from 65,536 to 1,048,576. The number of columns has increased from 256 to 16,384. You can write longer formulas in the new resizable Formula Bar. And if you click large chunks of text in a cell, the Formula Bar no longer spills into the worksheet grid.
New shortcuts called Key Tips - Press ALT to make Key Tips appear. You'll see Key Tips for all the Ribbon Tabs, all commands on the tabs, the Quick Access Toolbar and the Microsoft Office Button. Press the key for the tab you want to display. This makes all the Key Tip badges for that tab's buttons appear. Then, press the key for the button you want
When anchoring cells in formulas click F4 to apply both anchors to the final cell reference in the formula. Continue to click F4 to change anchor position.