Course Outline
Lesson 1: Introduction to Excel 2007
This lesson discusses the new Excel interface and explains how to work with workbooks, including how to create and modify them. It also explains how to customise the Excel program window to suit your needs.
- Becoming Familiar with the New User Interface
- Creating Workbooks
- Modifying Workbooks
- Customising the Excel 2007 Program Window
Lab : Introduction to Excel 2007
- Create and save a new workbook, save a workbook with a new name, and work with properties.
- Insert, rename, move, hide, copy, and delete sheets.
- Change zoom level, zoom in on a range, switch and cascade workbooks, and add a button to the Quick Access Toolbar.
Lesson 2: Data
This lesson explains how to enter and edit worksheet data, rearrange data, find and replace specific information, and use tools to check spelling, find synonyms, and translate words.
- Entering and Revising Data
- Modifying Worksheets
- Moving Data Within a Workbook
- Finding and Replacing Data
- Correcting and Expanding Upon Worksheet Data
Lab : Data
- Enter data in different ways, including filling a data series.
- Insert columns, rows, and cells; and delete and move cells and groups of cells.
- Copy column headers, move a column of data, and choose how data is pasted.
- Find a specific value, replace every occurrence, and find a cell with specific formatting.
- Check spelling, search for synonyms, and translate a word.
Lesson 3: Formatting
This lesson explains how to format data, cells, and cell ranges; create and apply styles such as table styles and themes; and make data easier to read.
- Formatting Cells
- Defining Styles
- Applying Workbook Themes and Table Styles
- Making Numbers Easier to Read
Lab : Formatting
- Change the formatting of data, and add a border and fill color to a cell range.
- Create a style, apply the new style, and use the Format Painter.
- Create a table style, and apply it to a table; and create and apply a theme.
- Assign date, phone number, and currency formats to cells.
For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.