Pitman Training London:
As the oldest-established office skills training organisation in the UK, Pitman Training in London's Notting Hill and High Holborn offers a wide-range of courses leading to nationally recognised qualifications.
Email: Contact us below ( or request a callback ).
Excel Course For Beginners And Intermediates
Our Excel Proficient course is perfect for people who are either new to spreadsheets or those who have been using them for some time but need more confidence and knowledge to help them work more efficiently. After all, most people know how to use less than 10% of Excel's functionality and those with more knowledge are very attractive to employers.
Our step-by-step course is deliver
ed as a self-paced programme so you can learn at your own pace at times to suit you at Pitman Training London in Notting Hill or High Holborn. The average student takes approximately 20 hours to complete the course which includes seven fascinating lessons.
And once you've passed your final exam, you'll have a sought-after Pitman Training certificate and a Microsoft Training Academy certificate to prove your worth! That means you can qualify for internationally recognised Microsoft certificates as well as Pitman Training qualifications.
What Is Covered:
The course spans 7 vital lessons which cover the following:
Lesson 1: Creating a spreadsheet, entering text and numbers, navigating a spreadsheet, saving, naming and closing a spreadsheet, opening an existing spreadsheet, editing cell contents.
Lesson 2: Formatting, selecting cells and ranges, text alignment, merging and centring, printing, inserting and deleting rows, simple formulas, moving and copying cells, AutoFill, editing formulas.
Lesson 3: Using AutoComplete, freezing and unfreezing panes, text orientation, page break preview, changing page orientation, adjusting margins and scaling, centring horizontally and vertically, displaying gridlines, inserting headers and footers, printing selected data, naming a worksheet, deleting a worksheet.
Lesson 4: Using AutoCalculate, applying absolute cell references, cell formatting, using more complex formulas, applying borders, using styles.
Lesson 5: inserting a new worksheet, naming a worksheet, grouping and ungrouping worksheets, applying wrap text formatting, indenting text, creating linked formulas, printing row and column headings, centring text horizontally and vertically.
Lesson 6: Using the SUM and COUNT functions, Using the formula palette to enter formulas for AVERAGE, MAX and MIN, sorting columns, using the Now, Date, IF, PMT and FV functions.
Lesson 7: Using the Chart Wizard, formatting and editing charts, saving selected data and a workbook as a web page, inserting and using a hyperlink, sending a workbook via email, deleting an object, using find and replace.