Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

Learn to work with the new features of Excel 2010.

Course Outline

Learn to work with the new features of Excel 2010.

Course Description
In Excel 2010, the familiar toolbars and menus used in earlier versions of Excel have been replaced by the Ribbon. Once you've grown accustomed to this new way to access Excel commands, you'll want to know about Excel 2010's other new features as well.

Attend this course if you want to:

  • Understand function improvements
  • Open workbooks created in earlier versions of Excel.
  • Convert workbooks between versions.
  • Work with the Ribbon.
  • Understand the File tab and Backstage view.
  • Use the Quick Access toolbar.
  • Zoom in and out on a worksheet.
  • Change the view.
  • Format cells using the Mini toolbar.
  • View calculations on selected cells in the status bar.
  • Customize the status bar to display the information you prefer.
  • Format using styles.
  • Use Paste live preview and paste options.
  • Group related rows of data into a table.
  • Format a table.
  • Use formulas in tables.
  • Convert a table back to a regular range of cells.
  • Use the new Page Layout view.
  • Use data bars, color scales, and icon sets to help visualize your data values.
  • Highlight cells in a range based on a rule.
  • Sort data in a worksheet.
  • Use sparklines.
  • Insert charts from the Ribbon.
  • Use slicers.
  • Understand new file formats for Excel.

Prerequisites & Certificates

Familiar with previous versions of Excel (specifically Excel 97, 2000, 2002, or 2003). Familiar with the new Office 2010 interface (helpful, though not essential) (Suggested course: Office 2010 New Features)

Certificates offered

Certificate of Completion

Cancellation Policy
If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews
Elert & Associates Technology Training
[ View Provider's Profile ]

I did the online course and found it awesome! The instructor was very knowledgeable and extremely helpful I finished the course feeling I got my money's worth and then some. Thank you Survey is stupid as it does not take into consideration I was an online course - has mandatory fields not applicable to me.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1016 times.