Share this content

Basic step by step excel

Junior with weak excel skills, needs some support tuition

Didn't find your answer?

n/a

Replies (15)

Please login or register to join the discussion.

avatar
By [email protected]
16th Nov 2016 10:49

Have a look at your local collages as many offer short courses (1 evening a week for 6 weeks) which are either fairly cheap or even free depending on the collage.

Thanks (0)
Replying to [email protected]:
paddle steamer
By DJKL
16th Nov 2016 12:48

steve.hughes-AT-seftoncvs wrote:

Have a look at your local collages as many offer short courses (1 evening a week for 6 weeks) which are either fairly cheap or even free depending on the collage.

That is obviously half the problem, their school has let the trainee play with glue rather than concentrate on excel.

Thanks (2)
avatar
By markmacullum
16th Nov 2016 12:30

If they are a member of AAT etc they can get free excel training from Filtered. Starts at the basics, and they work at their own pace, it uses videos and practice workbooks, as they start from the 2007 version upwards.

Thanks (0)
By Democratus
16th Nov 2016 12:40

I remember my training on Lotus 123 all those years ago.....
The IT manager said press the / key and have a go......

It was 3 days before I figured out that /FSreturn didn't save my files. Of course I had no typing skills, (still don't) so stared at the keyboard trying to find the letter I wanted instead of looking at what was onscreen.

Now, some 30 years later I know it should have been /FSYreturn.

Nothing beats practice.

There used to be books you could buy, e.g. Excel for Dummies which could help. Probably 2nd hand on Amazon. Try there.

Thanks (0)
avatar
By David Winch
17th Nov 2016 14:06

Have a word with Shelley Fishel at theittrainingsurgery.com

David Winch
Sales & Marketing Consultant
Cambridge

Thanks (0)
avatar
By Stargazer42
18th Nov 2016 09:14

Have a look at lynda.com - excellent courses on all manner of topics, including Excel.

Thanks (0)
avatar
By Cantona1
18th Nov 2016 10:53

I would not waste any money. You have hundreds of free Videos on you tube.
For instance, "Excel is fun" has over 1000s videos with working sample. In fact, he has materials on accounting.
I know some people prefer face-to-face learning, but I prefer visual.
The only issue you have is time.

Thanks (0)
Simon Hurst
By Simon Hurst
18th Nov 2016 12:28

I should state an interest, as I helped write some of the Excl with Business and Filtered courses a year or so ago, but although you can trawl through YouTube, given the low cost (or free) access to available structured courses, I would say, particularly for basic skills, it's worth the potential time saving over trying to work out what it is you don't know, and then work out what you need to know and then go and find it, and then filter out the good stuff from the 1,000s of videos.

Thanks (0)
avatar
By N.Krishnaswamy
18th Nov 2016 14:58

Already there is a Basic Excel tutorial that appeared in AccountingWEB sometime back. You can explore whether that will be help.ful

Thanks (0)
avatar
By fiairlieb1
18th Nov 2016 15:01

Before attending a course I would always recommend playing about with the product first. This means when you attend the course you will at least be aware of some of the functionality before being shown how to use it properly

Same goes for paid courses. Given the availability of some of the free content on Youtube (e.g. https://www.youtube.com/watch?v=1mNwJkUYS9A) I would recommend trying that out first before then looking at structured courses - I don't see the point in paying for someone to tell you the absolute basics of Excel (e.g. navigation). If I was paying for a course, I would want to pay for the higher value content

Thanks (0)
John Stokdyk, AccountingWEB head of insight
By John Stokdyk
18th Nov 2016 17:53

More declarations of interest, on behalf of both Simon Hurst and AccountingWEB. Our very own Excel page is a great place to start:
https://www.accountingweb.co.uk/tech/excel

Some of the key articles I would begin with are
20 Navigation tips: https://www.accountingweb.co.uk/tech/excel/twenty-top-excel-navigation-tips
10 quick range name tips: https://www.accountingweb.co.uk/any-answers/excel-tip-10-quick-range-nam...
EZ guide to Excel tables: https://www.accountingweb.co.uk/tech/excel/ez-guide-to-excel-tables
Excel 2010 - Simon Hurst's greatest tips: https://www.accountingweb.co.uk/article/excel-2010-simon-hurst-s-greates...
Formatting tips: https://www.accountingweb.co.uk/tech/excel/excelzone-compendium-formatting
Working with Accounts data - charts: https://www.accountingweb.co.uk/tech/excel/working-with-accounting-data-...
Working with text in Excel: https://www.accountingweb.co.uk/practice/skills/working-with-text-in-excel
Create a flexible P&L in Excel 2010/2013: https://www.accountingweb.co.uk/practice/skills/tutorial-create-a-flexib...

Also check the profile pages of our two main Excel contributors for their tips and tutorials (some of which start to get more complicated and cover pivot tables)
Simon Hurst - https://www.accountingweb.co.uk/profile/shurst
David Ringstrom - https://www.accountingweb.co.uk/profile/david-h-ringstrom

For more background, also explore the 20 ICAEW good spreadsheet practice principles: https://www.accountingweb.co.uk/tech/excel/icaew-addresses-spreadsheet-c...

Please note, some of our older tutorials have suffered from the migration to the new version of AccountingWEB; pictures have been lost, the layout has been scrambled, and links won't work in some cases. If you bump into any of these problems, please accept our apologies and email edtor[AT]accountingweb.co.uk with the URL of the offending page.

Plans are in hand for some refurbishment work, but as often happens this is taking us longer than expected to complete.

Thanks (0)
avatar
By cjsanghavi
21st Nov 2016 13:26
Thanks (0)
Replying to cjsanghavi:
Simon Hurst
By Simon Hurst
21st Nov 2016 17:51

Making money from strange vocalisations? Sounds ideal.

Thanks (0)
Share this content