Learning shortcuts is always a fun part of PowerPoint training. I like having a range of ways of accessing commands, opening programmes and files, and changing the view of my work – without constantly reaching for the mouse. Shortcuts are also called Key Tips – but whichever name you prefer, they are nifty little things. […]
Data changes result in recalculations of totals which are not always visible, depending on your spreadsheet layout. To keep an eye on how these totals are being affected without dashing around your spreadsheet, collect the important totals into a Watch Window. You can then see the collective effect of your new data from wherever you […]
There are many built in lists in Excel, numerical, date/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your […]