practise excel exercises workboo

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Practise Excel exercises, workbooks

Practise Excel exercises, workbooks

resolvedResolved · Low Priority · Version 365

Lisa has attended:
Excel Introduction course
Excel Intermediate course

Practise Excel exercises, workbooks

Please can you advise if there are any EXCEL worksheets/workbooks or Exercises that I can practise formulas, concan, charts, formatting etc, either with STL or can you recommend any online, I have just completed beginners Excel course and Intermediate Excel course with yourselves, as I am afraid I will forget things, if I do not start to practise Tom was my trainer in both courses, Many Thanks Lisa

Edited on Wed 29 Jun 2022, 13:55

RE: Practise Excel exercises, workbooks

Hi Lisa,

Thank you for the forum question.

I have been running Excel courses for 22 years, and I always advice my clients to summarise the course not later than 2 weeks after the course.

Based on my many years as Excel trainer I find the best way of doing it like this.

Take some of your own files. Copy them so you will not need to worry about ruin working files. Your data make much more sense to your brain than getting an exercise file. When you did the feedback on the course, our website sent you an email with a link to our handbooks.

When we invited you to the virtual courses, we asked you to download the course material and in the course material, you also got a link to the handbook.

You can still from the email invitation download Tom's file and the handbook.

I tell my clients to go through the pages in the handbook. Not read the pages, but when you get to the page which explain, it could be conditional formatting, add conditional formatting to your own file copy.

Not only make your own data more sense to your brain, but by trying the tools in your own file, will give you ideas of how you with your new knowledge can work more efficient in the future.

If you still have Tom's file, you can use the file as a reference to what you did on the virtual course.

You can also redo what you did on the courses in Tom's files, but you will find it easier and more relevant, if you use your own data.

It is very important, that you summarise the course to remember the tools.

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

Wed 6 Jul 2022: Automatically marked as resolved.


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.