excel intermediate

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel intermediate

Excel intermediate

resolvedResolved · Medium Priority · Version 2007

Thain has attended:
Excel Introduction course
Excel Intermediate course

Excel intermediate

Where is the best look up place to learn formulas in a excel spreadsheet?

RE: excel intermediate

Hi Thain

Thanks for getting in touch.

There are many reference sites you can use to further your knowledge, though you would do well to start with your delegate manual you received during training, and you can access these via this website also.

For further reference I would recommend Microsoft MVPs Bill Jelen at MrExcel.com, C Pearson at cpearson.com, and John Walkenbach at spreadsheetpage.com.

Within Excel you can explore a great deal yourself by using the "Insert Function" button next to the formula bar. Browse the formulas and click "Help for this function" to dig deeper and see examples.

I hope this helps. If you have any particular formulas you'd like to know more about, please let us know.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 13 Nov 2012: Automatically marked as resolved.


 

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips


Server loaded in 0.09 secs.