About This Training Course

Note that this Excel Essentials Version 2007/2010 Training Course is well suited to users who would like to improve or sharpen their exisiting basic or intermediate skills in microsoft excel. If you would like to fully get your head around the standard and intermediate options in microsoft excel, this Excel Essentials Version 2007/2010 Training Courseis for you. Much emphasis is also placed on the quickest and easiest ways to accomplish activities in microsoft excel.

Session 1: Worksheet and Workbook Basics
1.1 The Excel Layout
• Default Excel toolbars
1.2 Cells and Data
1.3 Worksheet Layouts

• Selecting Cells, Rows, Columns and Ranges
• Deleting Cell Contents
• Deleting a cell or a range of cells
• Inserting and Deleting Rows and Columns
• Cut, Copy and Paste

1.4 Entering and Editing Cell Data
• Editing Cell Data
• Entering Formulas
• Creating Totals Formulas

1.5 Checking Spelling in a Worksheet
1.6 Using Find and Replace
• Finding and Replacing Text
• Finding and Replacing Formatting

1.7 Filtering lists
• AutoFilter
• Custom Filters

Session 2: Managing Workbooks
2.1 File Management within Dialog Boxes
• Creating a New Folder
• Opening a Workbook as Read Only or as a Copy
• Deleting, Moving and Copying Workbooks

2.2 Creating a Workbook from a Template
2.3 Modifying Toolbars
2.4 Saving Workbooks using Different Names & Formats
• Saving Workbooks with Different Filenames
• Saving a Workbooks/sheets in previous Excel formats
• Saving a Workbook in a Non-Excel File Format

Session 3: Formatting and Printing Worksheets
3.1 Formatting Worksheets (Row, Cell & Column formats)
• Number Formats

3.2 Formatting Text
• Aligning Text
• Rotating, Merging, Shrinking to Fit and Text Wrapping
• Applying Borders and Colour

3.3 Adjusting Worksheet Layouts

• Adjusting Column Width and Row Heights

3.4 Applying AutoFormats and Styles
• AutoFormats
• Styles

3.5 Previewing, Printing and Altering Page Setups

• Setting Page Options
• Setting Margins in the Page Setup Dialog Box
• Setting Headers and Footers
• Changing Sheet Settings

3.6 Setting Print Options
• Using Page Break Preview
• Inserting Manual Page Breaks
• Change the Print Settings

Session 4: Enhancing & Revising Workbooks
4.1 Modifying Workbooks
• Inserting Worksheets
• Deleting Worksheets
• Modifying Worksheet Names
• Moving and Copying Worksheets

4.2 Creating Complex Formulas
• Using 3D References
• Creating and Revising Formulas

4.3 Constructing Formulas using Functions
• Using Statistical Functions
• Using Date and Time Functions
• Using Financial Functions
• Using Logical Functions

Session 5: Charts and Graphics
5.1 Charts
• Pie Charts
• Moving, Sizing and Printing Chart Objects
• Printing Charts as Objects or Worksheets
• Creating Series Charts
• Modifying Charts
• Editing and Formatting Charts
• Resizing and Deleting Objects in a Chart
• Formatting the Chart with the Chart Toolbar

5.2 Working with Graphics
• Inserting and Positioning Pictures

Session 6: Work group Collaboration
6.1 Web Publishing in Excel
• Creating Hyperlinks
• Inserting a Hyperlink

6.2 Using Comments
• View and Edit Comments

Prerequisites

What is assumed of the students?
- Students have basic keyboard skills.
- Students have basic mouse skills.
- Students have a basic knowledge of Windows.

Other Information

If you need more information contact Startnextweek.com.au on 1300 728 102