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

testing skills learnt

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Testing Skills learnt

Testing Skills learnt

ResolvedVersion 2016

Rebecca has attended:
Excel Intermediate course

Testing Skills learnt

Hi,

I was wondering if you could recommend any products or services that I could use to practice the skills learnt on the course? I would like to be given scenarios which I could essentially test myself if I could remember how to do it.

I learnt some new skills on this course which is great, but feel if I don't put them into practice I won't retain these new skills.

Any advice would be gladly appreciated, or directed to workbooks or anything of the sort.

Thanks,

Becky Lloyd, College of Optometrists

RE: Testing Skills learnt

Hi Rebecca,

Thank you for the forum question.

What works for me may not work for you, but Youtube is an amazing place to find Excel videos.

You can find everything you need. If I cannot remember things I have learned in Excel I find a video and many of the videos give you the option to download a practise file.

You also have access to download our handbooks from our website.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Sun 20 Oct 2019: Automatically marked as resolved.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.