Office 2010 – EXCEL

Who is the course for?

Learn how to take your skills to the next level with Office 2010 Microsoft Excel training.

What will I study?

The course will initially take you through the new visual layout of Office 2010 to include: Ribbon, Office button/File Tab (Backstage), Quick Access Toolbar, Tabs, Contextual Tabs, Groups, Dialog box Launchers, Commands, Keyboard Shortcuts, Mini Toolbar, Configurable Status Bar, Creating user defined ribbons, Live Preview, Screenshots, Printing to PDF/XPS.

The course will cover the following topics specific to Excel 2010 to update you as to the new features of this application:

• Row and column amounts
• Conditional formatting tools
• Themes and styles
• Function library
• Named ranges
• Olap functions
• Sorting and filtering
• Table enhancements (formatting)
• List enhancements
• PivotTables enhancements and functionality
• Page layout view
• Excel services to share work
• Sparklines
• Slicers
• PivotTable Improvements
• Improved Conditional Formatting
• PowerPivot Addin
• Improved Solver
• Improved accuracy in Statistical Functions
• Improved filters (Search)
• Improved Charting
• Improved equation builder
• Template access online

How will the course be delivered?

The course runs for 2 hours per week for 2 weeks.

Course Entry Requirements

No entry criteria, all welcome.

The college operates a no refunds policy as detailed below. Cancellations and transfer requests are subject to the following conditions:

• More than 4 weeks notice – no charge
• 4 weeks notice – 30% of the cost
• 2-3 weeks notice – 50% of the cost
• 1-2 weeks notice – 75% of the cost
• Less than 1 weeks notice – 100% of the cost

All cancellations must be made in writing and are subject to a £10 administration charge. The full fee’s policy is available on request.

What will I get at the end of the course?

Blackburn College Certificate of Attendance

What can I do next?

Office 2010: Publisher, Word, Excel, PowerPoint, Access: Click here for more information.

How much does it cost?

£99 per person
(prices are subject to change)