Microsoft Excel

Excel is the world's most popular and in-demand spreadsheet software.

• 64% of excel jobs in Berkshire earn between £20,000 - £50,000 (July 2016, Hays)
• There are 990 excel jobs available in Berkshire (July 2016, reed) waiting for candidates with the right skills and qualifications

You can start when you like and our flexible learning system means you can fit your studying around your existing work and home commitments. There will also be a course advisor on hand to help, should you need additional support.

Testimonial: Dori, Excel 2013

"I 100% recommend Pitman’s. I haven’t done a course in ages and I am not the kind of person that enjoy studying but funnily enough when I was doing my course, I always looked forward to Thursdays as the course was so much fun. Even for someone that usually struggles or is not 100% confident in the subject, Pitman’s makes it so easy. Just try it … and you will have all the help that you need.”"

When considering training to further your career, it is important to be able to answer the following questions with a firm 'yes':

1. Is the training provider trustworthy and do they have a good track record?
2. Will the training actually give me the vocational skills that I require to advance my career?
3. Will potential employers/clients recognise the training and give me work as a result, so that I get a return on my investment?
4. Will I enjoy the training and see it through to the end?

Why Pitman Training?

• No one has helped more people gain valuable business skills than Pitman Training. That unbeatable experience is your guarantee of success.
• Our teaching methods are proven; our course materials are the best of their kind.
• There are no hidden costs. The Certificate package includes certification fees and all training.
• A Pitman Training Certificate is an industry standard; your passport to a better career.

Ten Core lessons

1) Introduction to the Excel program, worksheets, SUM, navigation and more.

2) Formats, mini-toolbar, cell ranges, number formats, Autofill and more.

3) Insertion and deletion, hiding/unhiding, alignment, colour, borders, undo/redo, copy and paste and more.

4) AutoComplete, orientation, freezing, page break preview, count function, templates and more.

5) Styles, themes, margins and scaling, gridlines, print area, COUNT, AVERAGE, MAX and MIN functions and more.

6) Headers and footers, grouping and formatting multiple worksheets, charts and more.

7) More complex formulas, percentages, absolute cell references, calculations in status bar, insert function, NOW, TODAY, IF functions, comments and more.

8) Hidden worksheets, PMT and FV functions, errors, IFERROR function, 3D formulas and more.

9) Layout options, sparklines, picture ‘corrections’, picture styles and effects, WordArt, SmartArt and more.

10) Lessons Ten: Spell check, filter, find and replace texts and formats, hyperlinks, conditional formatting, customising ribbon and more.

This course is aimed at anyone wanting to develop their skills in Excel. Amongst others, this course holds valuable skills for administrators, bookkeepers, small business owners, accountants, payroll and finance administrators, and many other office-based jobs.

Suitable for beginner to intermediate level learners.

No prerequisites

Excel is used in roles such as:

• Bookkeeper
• Accountant
• Data Analyst
• Finance Administrator
• Data Administrator
• Finance analyst
• Office Administrator
• Business Support Administrator
• Financial Accountant
• Management Accountant