Excelling at Excel

Excel is Microsoft’s “killer app”, an indispensable tool for spreadsheet users from all walks of life. Explore the posts below, my human friends, if you seek to unlock the true potential of Excel:

Create a growth series of values in Excel

Create your own personal Autofill series in Excel to save yourself time and effort in repetitive typing

Add some pizzazz to your spreadsheets with some conditional formatting

Take your conditional formatting a step further

Perform some clever date arithmetic in Excel

Make an Excel page “very” hidden

A “warp speed” shortcut to create simple charts in Excel

Extract data for easier manipulation with Flash Fill

Create and modify sparklines to add some additional visual impact to your spreadsheet presentation

Safeguard and protect your valuable spreadsheet content from sabotage, inadvertent or otherwise, by protecting your spreadsheet in Excel

Add some Validation rules to your spreadsheet to ensure that your fellow users only input valid, correct data in the appropriate location