|
Provided by: Pitman Training Centre London Excel 2007 Part 1Excel |
 |
This course is aimed at everyone who needs to achieve a high intermediate standard in Excel 2007.
It's particularly helpful for people with limited experience of Excel, those who are self-taught and those who are coming to Office 2007 from the 2000 or 2003 versions.
This is a self-paced programme. You can start at any time and study at hours to suit you under the supervision of our friendly, experienced on-site trainers.
We're open from 09: 00-20: 00 Monday to Thursday, from 09: 00-16: 30 on Fridays and from 10: 00-16: 00 on Saturdays.
It's particularly helpful for people with limited experience of Excel, those who are self-taught and those who are coming to Office 2007 from the 2000 or 2003 versions.
This is a self-paced programme. You can start at any time and study at hours to suit you under the supervision of our friendly, experienced on-site trainers.
We're open from 09: 00-20: 00 Monday to Thursday, from 09: 00-16: 30 on Fridays and from 10: 00-16: 00 on Saturdays.
Related Software Programs or Products: Excel 2007
Related Awards, Degrees or Certifications: Pitman Training Certificate.
Related Jobs or Careers: bookkeeping, secretarial, administration, financial, office work
|
|
||||||||
Training
Provided by Pitman Training Centre London
- K asked: How much does this cost?
- A asked: I want to down load MS- Office basic Lessons. May I get? please
Excel 2007 Part 1
Using Excel 2007, you'll enjoy the following lessons:
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.
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.
About The Training Provider: Pitman Training Centre London
Pitman Training Centre London - We are Pitman Training London (High Holborn and Notting Hill), silver award winners of the "Best Learning Centre" category in the National IT Training Awards. We're also a Microsoft IT Academy We provide executive pa courses, legal secretarial courses, medical secretary training, secretarial skills, touch typing, shorthand, bookkeeping and Sage courses, payroll training, courses in Word,...
