In-House Microsoft Office 2010 Training

Many businesses are finding that they are upgrading their Office suite to 2010 either due to a decision by the ITdepartment or by a need to buy new hardware and therefore corresponding new software. The immediate reaction of new users to Office 2010 is one of horror and ‘where has that button gone?’ Users then tend to use those bits of Office that they used to use without exploring any of the new features or finding easier ways of doing things.

We can simply show staff what has changed in 2010 or can use 2010 as a starting point for Office training.  Suggestions of the content of each level for each application are given below.  The exact content and length of each course will be developed based on our discussion.

All our Microsoft Office courses will be designed around the results of the initial application exercises and can be delivered at Beginner, Intermediate or Advanced level depending on the needs of your business and your staff. Examples of what the courses might include are given below.

Microsoft Word 2010

Beginner

• Understand the ribbon interface
• Text formatting (size, font style, colour, bold, underline and italic)
• Paragraph formatting (bullets, numbering, line spacing, borders, shading)
• Page layout (orientation, margins, page breaks, page numbering)
• Tables (insert, delete rows and columns, adjust column width)
• Copy / paste

Intermediate:

• Use Templates, Themes / Styles
• Tables /  Forms / Columns,
• Mail Merge
• Page Layout (Header / Footer, Section breaks)
• Smart Art
• Building Blocks
• Picture formatting

Advanced

• Create Templates, Themes / Styles
• Hyperlinks / link information between documents
• Protection / Version control . Track changes / Compare and merge
• Tables of content / Indexes / Bookmarks / Bibliography

Microsoft Excel 2010

Beginner

• Understand the ribbon interface
• Enter numbers and text into spreadsheet
• Format cells
• Insert / delete rows and columns,
• Simple formulae
• Common functions
• Create graphs.

Intermediate

• Absolute and relative cell references
• Format charts and graphs
• Conditional formatting
• Analyse spreadsheets using tables / graphs and charts / filters
• Use mathematical, statistical, financial, conditional, logical functions
• Smart Art

Advanced

• Protect cells, sheets, workbooks
• Data validation and Lookup functions
• What-if scenarios / Goal seek / Sparklines
• Pivot tables and charts and Slicers
• Merge multiple copies of workbook.

Microsoft PowerPoint 2010

Beginner

• Understand the ribbon interface
• Slide layout and slide design, use existing templates, themes
• Format slides (bullets, numbering, line spacing, alignment, colour, fonts, size, background),
• Handouts and  speaker notes

Intermediate

• Include clipart and images/ Format pictures
• Include and format video / Understand video and audio formats
• Custom slide layouts / master slides
• Tables and Graphs
• Animations
• Slide transition

Advanced

• Create themes / slide design
• Animation sequences
• Action buttons
• Interactive elements

Microsoft Outlook 2010

• Understand the ribbon interface
• Email – folders, rules, filters, templates, quick steps, conversation view
• Social Connector
• Calendar,
• Tasks to keep your ‘to do’ list ,
• Contacts, create and maintain, organise using lists and categories.

Business Contact Manager 2010

• Understand the ribbon interface
• Contact Management
• Sales
• Marketing
• Project management

Interested?

Contact us to discuss your specific requirements.