MS Excel 2010 Upgrade Course Information
Duration: 1/2 Day Price: $320
Software and Version | Course Length | May 2022 | June 2022 | July 2022 | August 2022 | September 2022 | October 2022 | November 2022 |
---|---|---|---|---|---|---|---|---|
Excel 2010 | 1/2 Day Course | 2 May – AM session | 1 June – AM session | 15 July – AM session | 2 August – AM session | 23 September – AM session | 17 October – AM session | 3 November – AM session |
Course Booking
Target Audience & Purpose
Excel Upgrade to 2010 Training is for people who have been using Intermediate to advanced Excel features in previous versions and wish to learn the new features of Microsoft Excel 2010.
Objectives
By the end of the course participants should be able to:
- Use new File Features
- Use new Help Features
- Use new Conditional Formatting features
- Use new Pivot Table features
- Use new Table features
- Use new Formula features in Excel
- Use the new Sort and Filter features
- Use the new Graphics features
- Use the new File Format features
Course Inclusions
- Comprehensive learning materials incl. exercise files
- Post course telephone support
- ‘Certificate of Attendance’
on completion of course - Morning & afternoon tea
Course Prerequisites
- Participants should already:
- Have existing Intermediate/Advanced skills in Excel 2003 or 2007
MS Excel 2010 Course Content
Using Excel 2010 Interface
Using the Interface
Using the Backstage View
Use the Quick Access Toolbar
Customise the Quick Access Toolbar
Use the Mini Toolbar
Use Ribbons and Tabs
Use Dialog Box Launchers
Use Contextual tabs
Use Live Preview
Exploring New Excel Features
Hiding the Ribbon Tab
Using KeyTips
Inserting a New Worksheet
Freezing the Panes
Exploring Excel Options
Customizing the Status Bar
Using Page Layout View
Using the Zoom Slider
Using Sparklines
Insert Sparklines in a Worksheet
Customize Sparklines
Delete Sparklines
Using New Conditional Formatting Features
Using Highlight Cell Rules
Using Manage Rules
Using Clear Rules
Using Data Bars
Using New PivotTable Features
Creating a PivotTable Report
Adding PivotTable Report Fields
Using Expand and Collapse Buttons
Add Slicers
Using New Table Features
Creating a Table
Removing Duplicates from a Table
Using New Formula Features
Using Formula AutoComplete
Using New Sort and Filtering Features
Sorting Records by Multiple Fields
Filtering Data to find Above Average
Using New Graphic Features
Using New Chart Features
Using SmartArt
Using New File Format Features
Using the Document Inspector
Marking a Workbook as Final
Saving to a PDF Format
Working with the Compatibility Checker
Converting a File to Excel 2010 Format
Saving in a Binary Format
Forrest Training
Roving one-on-one trainer
Microsoft Office Courses
- Windows 10 Training
- Computer Fundamentals Course
- Microsoft Access Training
- Microsoft Excel Training
- Microsoft Office Training Schedule
- Microsoft Office Upgrade Training
- Microsoft OneNote Training
- Microsoft Outlook Training
- Microsoft PowerPoint Training
- Microsoft Project Training
- Microsoft Publisher Training
- Microsoft Visio Training
- Microsoft Word Training
Microsoft Training & Certification
Desktop – Non Microsoft Courses
Professional Development Courses
- Business Etiquette Training
- Change Management Training
- Creative Problem Solving Training
- Customer Service Training
- Effective Business Writing Training
- Effective Communication Skills Training
- Leadership and Influence Training
- Management Fundamentals Training
- Negotiation Skills Training
- Presentation Skills Training – Presenting with Confidence
- Project Management Training
- Time Management Training