About Our 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 delivered 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.
To enrol or find out more, call
020 7025
4700 for High Holborn
020 7792 5214 for Notting Hill
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.
What To Do Now.
To find out more or to make your booking, just call 020 7025 4700 for High Holborn or 020 7792 5214 for Notting Hill and speak to one of our course advisors. Or contact us by email.
