Excel Proficient 2003
Course
Blended learning in Bromley, Chatham, Croydon and 4 other venues
Description
-
Type
Course
-
Methodology
Blended
-
Location
-
Class hours
24h
Suitable for: 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.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Reviews
Course programme
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. 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.
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.
Excel Proficient 2003