Excel hints and tips for business users

There are many Excel Hints and Tips available though searching Excel Help. There is also an Excel Hints and Tips tab on the Best STL website including many useful quick tips.

For example, learning and using shortcut keys saves time and can be easier when using a laptop computer or when a mouse is not available.

Some common shortcuts are:
Ctrl+S will Save
Ctrl+P will Print
Ctrl+W will close a workbook
Ctrl + X will Cut
Ctrl+C will Copy
Ctrl+V will Paste

For a full list of shortcuts Press F1 to display the Help. Search for "Key Tips", this will show a link to Shortcut Keys for Excel.

Other posts you might be interested in:

Keyboard shortcuts

Do you have a ready reference of common and helpful keyboard shortcuts?
Read forum post

The Key Settings In Excel 2003's Options Panel

Find out what the key Excel 2003 settings are within the Options panel.
Read article

How To Use Functions In Excel 2010

As Excel has evolved, functions have remained a core feature, and using them is even easier than ever. This article summarises different ways a user can add a function, covering the traditional Insert Function panel, the new Formulas tab or by selecting one from the new pop down functions list.
Read article

Edit Anywhere With Mobile Spreadsheets

Excel allows you to loosen the shackles at your desk and view/edit files while you're on the move or working remotely. Read on to find out how Office Web Apps and Microsoft Excel Mobile can bring you and your office, out of the office.
Read article

Create Buttons To Navigate Between Worksheets

If you have a workbook with so many sheets not all of the tabs are visible on the screen, you can create a main page with buttons that will take you to the desired page with a single click.
Read article

Training courses