Microsoft Excel 2007 Introduction
Presented by Team TC
 |
£49 + VAT |
Contents
Getting Started
What can Excel do?
Using the Excel Ribbon
Using the Office button
Using the Quick Access toolbar
Creating a new workbook
Moving around workbooks and worksheets
Excel file formats
Entering and Editing Data
Editing cells and entering text
AutoComplete, AutoFill and custom lists
Entering and formatting numbers
Entering and formatting dates
Entering formulas with the AutoSum tool
Undo and Redo
Cut, Copy and Paste
Drag and Drop
Excel Formulas
Formula basics
Adding formulas to an invoice
Operator precedence
Relative and absolute references
Using named ranges
Calculating markup
Entering formulas with the AutoSum tool
Formatting Cells
Style, font and size
Text and cell colours
Text alignment and text wrap
Merge and Center
Using the Format Painter
Excel Functions
Sum function
Average
Count Numbers
Max and Min
If statements
Concatenation
Editing Cells, Columns and Rows
The active cell
Setting column widths and row heights
Using Autofit
Inserting and deleting rows and columns
Inserting and deleting cells
Setting default widths and heights
Freezing rows and columns
Editing Worksheets
Dividing a worksheet into panes
Zooming in and out
Inserting and deleting sheets
Renaming sheets
Setting the tab colour
Reordering sheets
Moving sheets between workbooks
Page Setup and Printing
Anatomy of an Excel chart
Creating a chart
Manipulating charts
Creating a column chart
Creating a line chart
Creating a pie chart
Creating a bar chart
Printing charts