Microsoft Office Specialist

 

Microsoft Partner for Training


Microsoft IT Training Academy


 

enlarge funding finder web tool
Find out if you are eligible for FREE training

 

Excel 2003/2007

Microsoft Office Excel 2003/2007

Updated: July 9, 2007

Skill Sets

Exam Skill Standards

Creating Data and Content

Enter and edit cell content

Locate specific cell content

Locate, select, and insert supporting information

Insert, position, and size graphics

Analyzing Data

Filter lists using the AutoFilter feature

Sort lists

Insert and modify formulas

Use statistical, date and time, financial, and logical functions

Create, modify, and position diagrams and charts based on worksheet data

Formatting Data and Content

Apply and modify cell formats

Apply and modify cell styles

Modify row and column formats

Format worksheets

Collaborating

Insert, view, and edit comments

Managing Workbooks

Create new workbooks from templates

Insert, delete, and move cells

Create and modify hyperlinks

Organize worksheets

Preview data in other views

Customize window layout

Setup pages for printing

Print data

Organize workbooks using file folders

Save data in appropriate formats for different uses

 

Free Learndirect courses to improve Maths and English skills
Free Learndirect Courses in Business and Management
Microsoft Office Courses, web design, HTML, Photoshop, SAGE accounting software and many other IT training courses
Expert tuition in Photoshop CS3, Dreamweaver 8, Flash CS3 and CS4, HTML and other Web Design related training
ICB recognised bookkeeping and accounting training in double entry and SAGE book keeping
SAGE line 50 and SAGE payroll training courses
BEST IT, Microsoft office, word, excel, access, powerpoint, adobe photoshop, dreamweaver, flash, html Training course search
BEST training course booking online by card or invoice, you can also book by phone

 

Site Search


BEST Computer Training, (HO) Suite 1.01, 65 Whitechapel Road, London E1 1DU | 0207 247 2428 | 0207 377 1072