Excel Skills | Excel Tutorials | Excel 2007 Features

Our more than 320 Excel 2007 tutorials cover all the core functionality that is included in Microsoft Excel 2007. 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 was implemented in Office 2007. Our aim with the 13 tutorials that are included in this category is to help you to familiarize yourself with the Excel ribbon, Office Button, 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, illustrate the display options that are available for the Excel ribbon, show you 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, 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 addition to Excel 2007 that enables you to format data without using the Excel ribbon.

This category includes comprehensive guidance on two new features in Excel 2007 - workbook themes and cell styles. We'll start by providing you with some 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 row heights and column widths. 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 improved features of Excel 2007. A lot of functionality and flexibility has been added to the conditional formatting feature that will enable you to analyze data a lot more efficiently. We cover all aspects of this newly designed feature 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 and 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 about sorting data. Then we cover the comprehensive improvements to the data filtering features in Excel 2007. We'll show you how to use the Auto Filter feature, create your own custom filters and use the advanced filter.

This category includes comprehensive guidance on the new Excel tables feature (sometimes also referred to as 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 2007 charts feature. We cover the basics of the new chart feature by showing you where to find the features that are available for each chart element and how to access the new 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 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 and 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 data in multiple columns, removing duplicate records from a worksheet (new Excel 2007 feature), applying data validation to a range of cells, creating a drop-down list box to simplify user input 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 input variables, the goal seek feature that can be used instead of trial & error calculations and the comprehensive scenarios feature that enables you to save cell values into multiple scenarios that can then 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 workbooks. We'll also show you how to restrict access to a workbook by implementing 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 spreadsheets. 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 basic Excel guidance on 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 320 Excel 2007 tutorials cover all the core functionality that is included in Microsoft Excel 2007. 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 2007 file specifications (PDF) Read more about our Excel Function tutorials
	Get Familiar with Excel 2007 Learn how to: This category includes guidance on the new user interface that was implemented in Office 2007. Our aim with the 13 tutorials that are included in this category is to help you to familiarize yourself with the Excel ribbon, Office Button, 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 2007 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 2007 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, illustrate the display options that are available for the Excel ribbon, show you 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, 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 addition to Excel 2007 that enables you to format data without using the Excel ribbon.	Themes, Styles & Pictures Learn how to: This category includes comprehensive guidance on two new features in Excel 2007 - workbook themes and cell styles. We'll start by providing you with some 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 row heights and column widths. 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 improved features of Excel 2007. A lot of functionality and flexibility has been added to the conditional formatting feature that will enable you to analyze data a lot more efficiently. We cover all aspects of this newly designed feature 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 and 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 about sorting data. Then we cover the comprehensive improvements to the data filtering features in Excel 2007. We'll show you how to use the Auto Filter feature, create your own custom filters and use the advanced filter.	Excel Tables Learn how to: This category includes comprehensive guidance on the new Excel tables feature (sometimes also referred to as 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.	Charts Learn how to: This category includes comprehensive guidance on the new Excel 2007 charts feature. We cover the basics of the new chart feature by showing you where to find the features that are available for each chart element and how to access the new 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.	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 and 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 data in multiple columns, removing duplicate records from a worksheet (new Excel 2007 feature), applying data validation to a range of cells, creating a drop-down list box to simplify user input 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 input variables, the goal seek feature that can be used instead of trial & error calculations and the comprehensive scenarios feature that enables you to save cell values into multiple scenarios that can then 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 workbooks. We'll also show you how to restrict access to a workbook by implementing 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 spreadsheets. 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 basic Excel guidance on 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