Microsoft Excel 2007 Foundation Training Materials
Training Course Outline
A FIRST LOOK AT EXCEL 2007
- Starting the Excel program
- What is the Active Cell?
- The Excel cell referencing system
- Entering numbers and text
- Default text and number alignment
- Adding a column of numbers
- Worksheets and Workbooks
- Saving a workbook
- Closing a workbook
- Creating a new workbook
- Opening a workbook
- Switching between workbooks
- Saving a workbook using another name
- Saving a workbook using a different file type
HELP WITHIN EXCEL 2007
- Getting help
- Searching for Help
- The Help ‘Table of Contents’
- Printing a Help topic
- Alt key help
EXCEL 2007 SELECTION TECHNIQUES
- Why are selection techniques important?
- Selecting a cell
- Selecting a range of connecting cells
- Selecting a range of non-connecting cells
- Selecting the entire worksheet
- Selecting a row
- Selecting a range of connecting rows
- Selecting a range of non-connected rows
- Selecting a column
- Selecting a range of connecting columns
- Selecting a range of non-connecting columns
MANIPULATING ROWS AND COLUMNS IN EXCEL 2007
- Inserting rows into a worksheet
- Inserting columns into a worksheet
- Deleting rows within a worksheet
- Deleting columns within a worksheet
- Modifying column widths
- Modifying column widths using ‘drag and drop’
- Automatically resizing the column width to fit contents
- Modifying row heights
COPYING, MOVING AND DELETING IN EXCEL 2007
- Copying the cell or range contents Deleting cell contents
- Moving the contents of a cell or range
- Editing cell content
- Undo and Redo
- AutoFill
- Sorting a cell range
- Searching and replacing data
MANIPULATING EXCEL 2007 WORKSHEETS
- Switching between worksheets
- Renaming a worksheet
- Inserting a new worksheet
- Deleting a worksheet
- Copying a worksheet within a workbook
- Moving a worksheet within a workbook
- Copying or moving worksheets between workbooks
EXCEL 2007 FONT FORMATTING
- Font type
- Font size
- Bold, italic, underline formatting
- Cell border formatting
- Formatting the background color
- Formatting the font color
ALIGNMENT FORMATTING WITHIN EXCEL 2007
- Aligning contents in a cell range
- Centering a title over a cell range
- Cell orientation
- Text wrapping
- Format painter
NUMBER FORMATTING & EXCEL 2007
- Number formatting
- Decimal point display
- Comma formatting
- Currency symbol
- Date styles
- Percentages
FREEZING ROW AND COLUMN TITLES IN EXCEL 2007
- Freezing row and column titles
EXCEL 2007 FORMULAS
- Creating formulas
- Easy way to create formulas
- Copying formulas
- Operators
- Formula error messages
EXCEL 2007 CELL REFERENCING
- Relative cell referencing within in formulas
- Absolute cell referencing within formulas
EXCEL 2007 FUNCTIONS
- What is a function?
- Common functions
- Sum function
- Average function
- Max function
- Min function
- Count function
- What are ‘IF functions’?
- Using the IF function
USING CHARTS WITHIN EXCEL 2007
- Inserting a column chart
- Inserting a line chart
- Inserting a bar chart
- Inserting a pie chart
- Resizing a chart
- Deleting a chart
- Chart title or labels
- Chart background color
- Changing a column, bar, line or pie slice colors
- Changing the chart type
- Modifying Charts using the Layout tab
- Copying and moving charts within a worksheet
- Copying and moving charts between worksheets
- Copying and moving charts between workbooks
CUSTOMIZING EXCEL 2007
- Modifying basic options
- Minimizing the Ribbon
- AutoCorrect options
WORKSHEET SETUP IN EXCEL 2007
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and Footers
- Header and footer fields
- Scaling your worksheet to fit a page(s)
PREPARING TO PRINT AN EXCEL 2007 WORKSHEET
- Visually check your calculations
- Gridline display when printing
- Printing titles on every page when printing
- Printing the Excel row and column headings
- Spell checking
- Previewing a worksheet
- Comparing Workbooks side by side
- Zooming the view
- Printing options