Search all of Office.com
 
Support / Excel / Excel 2010 Help and How-to
 
 

Videos

Video: Insert sparklines to show data trends

Video Watch this video to learn about sparklines – tiny charts in worksheet cells – and how to create and customize them.

Video: Fix broken formulas

Video Learn how to fix broken formulas and how to avoid common errors when you build them.

Video: Save a workbook to a SharePoint site

Video Watch this video to learn how to save a workbook to a SharePoint Services library.

Video: Publish a workbook to a SharePoint site

Video Learn how to publish a workbook to a document library on a SharePoint server and view its content in the browser.

Video: Getting Started with Excel 2010

Video In this video, get a quick intro to slicers, sparklines, and other great new features in Excel 2010.

Video: Create a workbook

Video This video shows you how to quickly create a new, blank workbook. Create a workbook Click the File tab. Click New . Under Available Templates , click Blank...

Video: Enter a simple formula

Video Learn how to enter simple formulas to add and subtract numbers.

Video: Count cells in Excel

Video Watch this video to learn how to count cells in a range or table. You can use different variations of count functions to count cells that meet a condition...

Video: Use the Text to Columns Wizard

Video Use the Convert Text to Columns Wizard to separate simple cell content, such as first names and last names, into different columns.

Video: Filter data by using an AutoFilter

Video Use the AutoFilter to filter a range of data in Excel 2007 and Excel 2010 and learn how to remove filters.

Video: Use functions in formulas

Video Learn how to harness the power of Excel by using worksheet functions in your formulas.

Video: Sort data

Video Learn how to sort data in a worksheet.

Video: Add and subtract numbers

Video Learn how to do simple addition and subtraction in an Excel worksheet.

Video: Apply data validation

Video You can use data validation to help control the type of data or the values that users enter into a cell. Watch this short video to see how easy it is to...

Video: Move and copy a formula

Video Moving and copying a formula in Excel is simple. Watch this short video to learn how.

Video: Use the Show Values As feature in a PivotTable report

Video This video shows how to effectively use the Show Values As feature and choose from preset calculation options in Excel 2010.

Video: Find and fix accessibility issues in a workbook

Video In this video, learn how to use the Accessibility Checker in Microsoft Excel 2010, which lets you find and fix issues tha t can make it difficult for people...

Video: Backstage view in Excel 2010

Video Take a quick tour of the Backstage view in Microsoft Excel 2010, where you can open, save, print, and otherwise manage your files.  Note     This video...

Video: Use Named Sets in an OLAP PivotTable report

Video Video: Watch this video to see how you can quickly apply a specific field selection in a PivotTable report by saving it as a named set.

Video: Apply conditional formatting

Video Learn how to apply conditional formatting to cells to make values and trends in your worksheet stand out.

Video: Get even more out of conditional formatting

Video See examples of more advanced uses of conditional formatting, including using formulas, in Excel 2010.

Video: Share a workbook in the cloud

Video Watch this video to find how you can share a workbook with anyone, anywhere by using Excel 2010, Windows Live SkyDrive (the “cloud”), and Excel Web App...

Video: Format numbers in a worksheet

Video You can apply different number formats to display numbers as percentages, dates, currency, and so on. Watch this short video to learn how to format numbers...

Video: Create an Excel table

Video Watch this video to learn how to quickly convert a range of data into an Excel table.

Video: Changes made to functions

Video Watch this video to see what’s new and improved in the functions area.