Home + Knowledge portals + Practice management + Toolkit + Practice management guides + Tips and tutorials for how to use Microsoft ® Excel 2007 and Excel 2010

Tips and tutorials for how to use Microsoft ® Excel 2007 and Excel 2010

Knowledge portals

Quickly and easily learn how to use Microsoft ® Excel versions 2010 and 2007 with Excel expert Neale Blackwood’s simple "how to" tutorials. Learn the tips, tricks and shortcuts to navigate Microsoft ® Excel when creating spreadsheets, handling data, building charts and formatting.

Charts

Including tips on data point labels and organisation charts.

Data entry

Including tips on filling blanks and data forms.

Data handling

Including tips on filtering unique entries.

Display

Including tips on hiding gridlines.

Formula

Including tips on phantom links and linking content.

Formatting

Including tips on finding formats and custom colours.

Keyboard

Including tips on shift key and the F4 function key.

Mouse

Including tips on the scroll wheel and double clicks.

Miscellaneous

Including tips on joining text and hiding zeroes.

Navigation

Including tips on hyperlinks and finding numbers.

INTHEBLACK

Tips published in issues of INTHEBLACK magazine.

Printing

Including tips on printing margins and page breaks.

Related pages

IT management for public practitioners

Related links

Computer spreadsheets forum

Contact

Neale Blackwood CPA, CPA Australia's excel expert can be emailed at:

E: a4@iinet.net.au

Get Adobe Flash player

Excel expert, Neale Blackwood on names and formulas

10:15 mins, 0.00 MB - INTHEBLACK resident Excel expert, Neale Blackwood, looks at the use of range names to make formulas easier to read and understand.