Excel Skills | Excel Tutorials | Excel 2010 Features

Our more than 340 Excel 2010 tutorials cover all the core functionality that is included in Microsoft Excel 2010. The tutorials can be viewed in a category or course based format and are suitable for novice and advanced users. We recommend that novice users start with the basic Excel course before progressing to the advanced Excel course and that advanced users also view the tutorials on basic Excel features because some of these tutorials contain guidance that can significantly increase your efficiency when working in Excel. This page provides information on the main Excel features that are covered in each tutorial category.

This category includes guidance on the new user interface that has been implemented in Office 2010. Our aim with the 13 tutorials that are included in this category is to help you to familiarize yourself with the Excel ribbon, File tab, Quick Access Toolbar and the 8 tabs that are included on the ribbon. We'll also show you how to access the online Help feature.

This category covers basic Excel features like opening and exiting the Excel application, opening a new or existing workbook and saving, copying and closing a workbook. It also includes a tutorial aimed at novice users on the Excel application environment and more advanced features like how to convert an Excel file to a PDF document and how to e-mail Excel files.

This category includes guidance on customizing the default Excel settings to your requirements. We'll show you how to add and remove features from the Quick Access Toolbar, how to add a custom tab on the Excel ribbon, how to customize the status bar and Windows taskbar for optimum efficiency and we also review the window view options.

This category covers some of the more basic Excel features like entering data and selecting cells, but you should note that the tutorials in this category may improve your productivity in Excel significantly. The actions of entering data and selecting cells are performed frequently. You could therefore save a lot of time by using the most efficient techniques when performing these actions.

This category covers basic Excel guidance on editing data, clearing cell values and/or formatting, moving cells and using the undo and redo features. You will also learn how to use the comprehensive find and replace features and we'll also show you how to move cells to another worksheet or another workbook.

In this category you will learn various techniques that can be used to insert cells, rows or columns. Then we'll also show you how to delete cells, rows or columns. We don't only cover a single technique that requires accessing the Excel ribbon; we'll show you how to use the shortcut menu and which cells to select before you access the appropriate features.

This category covers everything that you need to know about copying and pasting data. We'll show you the most efficient technique of copying data and then we'll also cover the numerous pasting options that are available. We'll illustrate how to copy data with the clipboard and we also provide detailed guidance on the Auto Fill feature.

This category includes comprehensive guidance on formatting cells in Excel. The tutorials include basic formatting features like text font, size, background colour & colour, alignment, number and date formats as well as more advanced features like wrapping text and merging cells. We'll also illustrate how to use a very efficient Excel 2010 feature that enables you to format data without using the Excel ribbon.

This category includes comprehensive guidance on two very useful Excel 2010 features - themes and cell styles. We'll start by providing you with background information on these features and then we'll show you how to create your own custom styles and themes. These features will save hours of your time because they enable you to apply advanced formatting styles quickly.

This category includes everything there is to know about adjusting the row heights and column widths of a worksheet. We go way beyond the standard features and we'll show you which cells to select in order to use these features efficiently. We'll also show you how to Autofit and hide or unhide rows or columns.

This category covers one of the most comprehensive features of Excel 2010. A lot of functionality has been included in the conditional formatting feature that will enable you to analyze data a lot more efficiently. We cover all aspects of these extremely useful features including how to apply data bars, colour scales and icon sets.

This category covers essential basic features like how to enter a formula and how to create a link. A comprehensive illustration of absolute and relative cell references is also included - it is an essential concept for all novice Excel users to understand. We'll also show you how to create, edit, update and break links between workbooks.

This category is dedicated to worksheets. You will learn how to insert, delete, copy, move & rename, hide or unhide worksheets. There are also tutorials on changing the tab colour of a worksheet and selecting multiple worksheets at the same time, which is quite useful when printing only selected worksheets.

This category includes guidance on sorting data based on single or multiple columns. We'll also highlight a few important points to take note of when sorting data. Then we cover the comprehensive data filtering features that are available in Excel 2010. We'll show you how to use the Auto Filter feature, create custom filters and how to use the advanced filter.

This category includes comprehensive guidance on the Excel tables feature (also referred to as Excel data tables). This feature is a significant improvement on the Lists feature that was included in Excel 2003 and makes it a lot easier to format and apply calculations to data ranges. We also cover the unique structured cell referencing system.

This category includes guidance on one of the most useful features in Excel. After studying this category, you will be able to create, format, refresh and edit pivot tables. Methods used for filtering data in a pivot table and drilling down to the source data of each entry group are also illustrated. In addition, we'll show you how to create a pivot chart and how to use this feature for analyzing data in a visual format.

This category includes comprehensive guidance on the new Excel 2010 pivot table slicers features. We'll show you how to insert a pivot table slicer, how to insert multiple slicers simultaneously, how to use slicers when filtering data, how to select multiple fields from the same slicer, how to share slicers between pivot tables, how to format slicers and how to disconnect or delete slicers.

This category includes comprehensive guidance on the Excel 2010 charts features. We cover the basics of chart features by showing you where to find the features that are available for each chart element and how to access the chart formatting features. We'll also show you how to create charts from multiple source data ranges and how to implement a secondary chart axis.

This category includes guidance on the new Excel 2010 sparklines features. Sparklines are small charts that can be inserted in the background of a cell. We'll show you how to insert a single sparkline, insert more than one sparkline simultaneously, format sparklines, group sparklines, change to row or column basis of sparklines, include hidden cells in sparklines, delete sparklines and how to change the default sparkline settings.

This category includes comprehensive guidance on customizing the page layout of a worksheet and printing data efficiently. We cover everything from print orientation, page margins, print areas, page headers & footers to repeating rows and columns on printed pages. We'll also show you how to insert & customize page breaks and how to print cell selections, multiple worksheets or an entire workbook.

This category includes guidance on how to import data from external data sources. This is probably the category which adds the most value in terms of productivity and efficiency. We start with some basic guidance on setting up a data connection to perform database queries on and then proceed to illustrate how to create, edit and refresh database queries and pivot table database queries.

This category includes guidance on how to convert text strings to multiple column data, remove duplicate records from a worksheet, apply data validation to a range of cells, create a drop-down list box in order to simplify the input of data and adding subtotals to a worksheet. All of these features are extremely useful data tools that every user should be familiar with.

This category covers a few useful Excel features that you may not be aware of. Included are data tables that enable you to analyze one or two input variables at a time, the goal seek feature which can be used instead of trial & error calculations and the comprehensive scenarios feature which enables users to save cell values into multiple scenarios that can be compared to one another.

This category includes basic guidance on features like spelling, research, thesaurus and translation. We'll also show you how to insert a comment into a cell, how to delete comments, show a comment or show all comments and how to hide comments.

This category includes guidance on protecting cells through worksheet protection and how to protect the structure of a workbook. We'll also show you how to restrict user access to a workbook by the addition of a password that is required to open the workbook. Then we'll also illustrate how to share a workbook with other users and track changes that are made to the shared workbook.

This category includes guidance on Excel window features. You will learn how to open the same workbook in two different windows, how to arrange open windows, split windows and use the freeze panes feature to adjust scrolling. These features are especially useful when linking or copying cells from different workbooks and will save you time when performing these tasks.

This category includes guidance on tracing cells that are included in formulas and tracing formulas that depend on the value in a particular cell. We'll also show you how to check formulas for errors and how to evaluate formulas. Then we provide guidance on calculation options and we'll show you how to add a watch window to your Excel window.

This category covers named ranges. If you have not used this Excel feature before, you will learn more about a feature that will save you a lot of time when entering formulas and creating complex Excel sheets. In this category of tutorials we show you how to create, edit, copy & paste, rename and apply named ranges in formulas.

This category includes important guidance on Excel functions like how to insert, enter, select or edit a function and how to obtain help on specific functions. We'll also show you how to use wildcard characters in function formulas and we cover some of the most common formula errors.


	Excel Features Our more than 340 Excel 2010 tutorials cover all the core functionality that is included in Microsoft Excel 2010. The tutorials can be viewed in a category or course based format and are suitable for novice and advanced users. We recommend that novice users start with the basic Excel course before progressing to the advanced Excel course and that advanced users also view the tutorials on basic Excel features because some of these tutorials contain guidance that can significantly increase your efficiency when working in Excel. This page provides information on the main Excel features that are covered in each tutorial category.		Links Return to the list of Excel tutorials Read more about our tutorials & templates View our training membership fees View the Excel 2010 file specifications (PDF) Read more about our Excel Function tutorials
	Get Familiar with Excel 2010 Learn how to: This category includes guidance on the new user interface that has been implemented in Office 2010. Our aim with the 13 tutorials that are included in this category is to help you to familiarize yourself with the Excel ribbon, File tab, Quick Access Toolbar and the 8 tabs that are included on the ribbon. We'll also show you how to access the online Help feature.	Using Excel 2010 Files Learn how to: This category covers basic Excel features like opening and exiting the Excel application, opening a new or existing workbook and saving, copying and closing a workbook. It also includes a tutorial aimed at novice users on the Excel application environment and more advanced features like how to convert an Excel file to a PDF document and how to e-mail Excel files.	Customize Excel 2010 Learn how to: This category includes guidance on customizing the default Excel settings to your requirements. We'll show you how to add and remove features from the Quick Access Toolbar, how to add a custom tab on the Excel ribbon, how to customize the status bar and Windows taskbar for optimum efficiency and we also review the window view options.
	Enter Data / Select Cells Learn how to: This category covers some of the more basic Excel features like entering data and selecting cells, but you should note that the tutorials in this category may improve your productivity in Excel significantly. The actions of entering data and selecting cells are performed frequently. You could therefore save a lot of time by using the most efficient techniques when performing these actions.	Edit Data Learn how to: This category covers basic Excel guidance on editing data, clearing cell values and/or formatting, moving cells and using the undo and redo features. You will also learn how to use the comprehensive find and replace features and we'll also show you how to move cells to another worksheet or another workbook.	Insert / Delete Data Learn how to: In this category you will learn various techniques that can be used to insert cells, rows or columns. Then we'll also show you how to delete cells, rows or columns. We don't only cover a single technique that requires accessing the Excel ribbon; we'll show you how to use the shortcut menu and which cells to select before you access the appropriate features.
	Copy & Paste Data Learn how to: This category covers everything that you need to know about copying and pasting data. We'll show you the most efficient technique of copying data and then we'll also cover the numerous pasting options that are available. We'll illustrate how to copy data with the clipboard and we also provide detailed guidance on the Auto Fill feature.	Format Cells Learn how to: This category includes comprehensive guidance on formatting cells in Excel. The tutorials include basic formatting features like text font, size, background colour & colour, alignment, number and date formats as well as more advanced features like wrapping text and merging cells. We'll also illustrate how to use a very efficient Excel 2010 feature that enables you to format data without using the Excel ribbon.	Themes, Styles & Pictures Learn how to: This category includes comprehensive guidance on two very useful Excel 2010 features - themes and cell styles. We'll start by providing you with background information on these features and then we'll show you how to create your own custom styles and themes. These features will save hours of your time because they enable you to apply advanced formatting styles quickly.
	Row / Column Formatting Learn how to: This category includes everything there is to know about adjusting the row heights and column widths of a worksheet. We go way beyond the standard features and we'll show you which cells to select in order to use these features efficiently. We'll also show you how to Autofit and hide or unhide rows or columns.	Conditional Formatting Learn how to: This category covers one of the most comprehensive features of Excel 2010. A lot of functionality has been included in the conditional formatting feature that will enable you to analyze data a lot more efficiently. We cover all aspects of these extremely useful features including how to apply data bars, colour scales and icon sets.	Formulas & Links Learn how to: This category covers essential basic features like how to enter a formula and how to create a link. A comprehensive illustration of absolute and relative cell references is also included - it is an essential concept for all novice Excel users to understand. We'll also show you how to create, edit, update and break links between workbooks.
	Worksheets Learn how to: This category is dedicated to worksheets. You will learn how to insert, delete, copy, move & rename, hide or unhide worksheets. There are also tutorials on changing the tab colour of a worksheet and selecting multiple worksheets at the same time, which is quite useful when printing only selected worksheets.	Sort & Filter Data Learn how to: This category includes guidance on sorting data based on single or multiple columns. We'll also highlight a few important points to take note of when sorting data. Then we cover the comprehensive data filtering features that are available in Excel 2010. We'll show you how to use the Auto Filter feature, create custom filters and how to use the advanced filter.	Excel Tables Learn how to: This category includes comprehensive guidance on the Excel tables feature (also referred to as Excel data tables). This feature is a significant improvement on the Lists feature that was included in Excel 2003 and makes it a lot easier to format and apply calculations to data ranges. We also cover the unique structured cell referencing system.
	Pivot Tables & Pivot Charts Learn how to: This category includes guidance on one of the most useful features in Excel. After studying this category, you will be able to create, format, refresh and edit pivot tables. Methods used for filtering data in a pivot table and drilling down to the source data of each entry group are also illustrated. In addition, we'll show you how to create a pivot chart and how to use this feature for analyzing data in a visual format.	Pivot Table Slicers Learn how to: This category includes comprehensive guidance on the new Excel 2010 pivot table slicers features. We'll show you how to insert a pivot table slicer, how to insert multiple slicers simultaneously, how to use slicers when filtering data, how to select multiple fields from the same slicer, how to share slicers between pivot tables, how to format slicers and how to disconnect or delete slicers.	Charts Learn how to: This category includes comprehensive guidance on the Excel 2010 charts features. We cover the basics of chart features by showing you where to find the features that are available for each chart element and how to access the chart formatting features. We'll also show you how to create charts from multiple source data ranges and how to implement a secondary chart axis.
	Sparklines Learn how to: This category includes guidance on the new Excel 2010 sparklines features. Sparklines are small charts that can be inserted in the background of a cell. We'll show you how to insert a single sparkline, insert more than one sparkline simultaneously, format sparklines, group sparklines, change to row or column basis of sparklines, include hidden cells in sparklines, delete sparklines and how to change the default sparkline settings.	Page Layout & Printing Learn how to: This category includes comprehensive guidance on customizing the page layout of a worksheet and printing data efficiently. We cover everything from print orientation, page margins, print areas, page headers & footers to repeating rows and columns on printed pages. We'll also show you how to insert & customize page breaks and how to print cell selections, multiple worksheets or an entire workbook.	Importing External Data Learn how to: This category includes guidance on how to import data from external data sources. This is probably the category which adds the most value in terms of productivity and efficiency. We start with some basic guidance on setting up a data connection to perform database queries on and then proceed to illustrate how to create, edit and refresh database queries and pivot table database queries.
	Data Tools Learn how to: This category includes guidance on how to convert text strings to multiple column data, remove duplicate records from a worksheet, apply data validation to a range of cells, create a drop-down list box in order to simplify the input of data and adding subtotals to a worksheet. All of these features are extremely useful data tools that every user should be familiar with.	What-if Tools Learn how to: This category covers a few useful Excel features that you may not be aware of. Included are data tables that enable you to analyze one or two input variables at a time, the goal seek feature which can be used instead of trial & error calculations and the comprehensive scenarios feature which enables users to save cell values into multiple scenarios that can be compared to one another.	Proofing & Comments Learn how to: This category includes basic guidance on features like spelling, research, thesaurus and translation. We'll also show you how to insert a comment into a cell, how to delete comments, show a comment or show all comments and how to hide comments.
	Protect / Share Workbooks Learn how to: This category includes guidance on protecting cells through worksheet protection and how to protect the structure of a workbook. We'll also show you how to restrict user access to a workbook by the addition of a password that is required to open the workbook. Then we'll also illustrate how to share a workbook with other users and track changes that are made to the shared workbook.	Window Options Learn how to: This category includes guidance on Excel window features. You will learn how to open the same workbook in two different windows, how to arrange open windows, split windows and use the freeze panes feature to adjust scrolling. These features are especially useful when linking or copying cells from different workbooks and will save you time when performing these tasks.	Formula Options Learn how to: This category includes guidance on tracing cells that are included in formulas and tracing formulas that depend on the value in a particular cell. We'll also show you how to check formulas for errors and how to evaluate formulas. Then we provide guidance on calculation options and we'll show you how to add a watch window to your Excel window.
	Using Named Ranges Learn how to: This category covers named ranges. If you have not used this Excel feature before, you will learn more about a feature that will save you a lot of time when entering formulas and creating complex Excel sheets. In this category of tutorials we show you how to create, edit, copy & paste, rename and apply named ranges in formulas.	Using Functions Learn how to: This category includes important guidance on Excel functions like how to insert, enter, select or edit a function and how to obtain help on specific functions. We'll also show you how to use wildcard characters in function formulas and we cover some of the most common formula errors.
	More about our Excel Function tutorials
2012 © Excel-Skills.com. All rights reserved. \| Privacy Policy \| Submit Feedback