Microsoft Excel 2007 Training Materials
Foundation Level Training Courseware Resources
A FIRST LOOK AT EXCEL
- 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
EXCEL 2007 HELP
- Getting help
- Searching for Help
- The Help ‘Table of Contents’
- Printing a Help topic
- Alt key help
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
EXCEL 2007 – MANIPULATING ROWS AND COLUMNS
- 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
EXCEL 2007 – COPYING, MOVING AND DELETING
- 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
EXCEL 2007 – MANIPULATING 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 colour
- Formatting the font colour
EXCEL 2007 – ALIGNMENT FORMATTING
- Aligning contents in a cell range
- Centring a title over a cell range
- Cell orientation
- Text wrapping
- Format painter
EXCEL 2007 – NUMBER FORMATTING
- Number formatting
- Decimal point display
- Comma formatting
- Currency symbol
- Date styles
- Percentages
EXCEL 2007 – FREEZING ROW AND COLUMN TITLES
- 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
EXCEL 2007 – USING CHARTS
- 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 colour
- Changing a column, bar, line or pie slice colours
- 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
- Minimising the Ribbon
- AutoCorrect options
EXCEL 2007 – WORKSHEET SETUP
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and Footers
- Header and footer fields
- Scaling your worksheet to fit a page(s)
EXCEL 2007 – PREPARING TO PRINT A 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