Send to a Colleague Print Bookmark

Microsoft Excel 2007 Level 1

With Excel 2007 you can use spreadsheets for common tasks such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. Powerful calculation and visualisation tools make analysing data simple.

Quick Facts

 

$385 incl GST

Duration: 1 Days

Class Size: 10

Level: Beginner

Times: 9.00am - 5.00pm approx

 
 

About the Course

During this 1 day course, instructors will use practical exercises and real-life scenarios to take participants through the basics of Microsoft Excel 2007. Learn to navigate around Excel 2007, create workbooks and worksheets, use formulas, functions and ranges and apply formatting to enhance the presentation of your work.

Who should do this course?

This is an introductory course designed for people who need to know how to use Microsoft Excel 2007. Upon completion of the course, participants should be able to produce reports, budgets, lists and perform other similar tasks.

Prerequisites

No prior knowledge of Microsoft Excel is required, however it would be beneficial to have a general understanding of personal computers and the Windows operating system.

Course Units

Unit 1: Getting To Know Excel
- Starting Excel
- The Excel Screen
- Using The Ribbon
- Using The KeyTip Badges
- Minimising The Ribbon
- Using Shortcut Menus
- Launching Dialog Boxes
- Customising The Quick Access Toolbar
- The Office Button
- Using The Office Button
- The Status Bar
- Customising The Staus Bar
- Exiting Safely From Excel
Unit 2: Creating A New Workbook
- Understanding Workbooks
- Using The Blank Workbook Template
- Typing Text Into A Worksheet
- The Save As Dialog Box
- Saving A New Workbook
- Typing Numbers Into A Worksheet
- Typing Simple Formulas In A Worksheet
- Easy Formulas
- Typing Dates In A Worksheet
- Easy Formatting
- Checking Spelling In A Worksheet
- Making And Saving Changes
- Printing A Worksheet
- Safely Closing A Worksheet
Unit 3: Working With Workbooks
- Opening An Existing Workbook
- Moving About A Worksheet
- Moving About A Workbook
- Going To A Specific Location
- The Open Dialog Box
Unit 4: Editing In A Workbook
- Understanding Data Editing
- Overwriting Cells Contents
- Editing Longer Cell Entries
- Editing Formulas
- Editing Functions
- Clearing A Cell
- Deleting A Worksheet
- Undoing And Redoing Operations
Unit 5: Formulas And Functions
- Understanding Formulas
- Creating Formulas That Add
- Creating Formulas That Subtract
- Formulas That Multiply And Divide
- Understanding Functions
- Using The SUM Function To Add
- Summing Non-Contiguous Ranges
- Calculating An Average
- Finding A Maximum Value
- Finding A Minimum Value
- More complex Formulas
- What If Formulas
Unit 6: Selecting Ranges
- Understanding Ranges
- Selecting Ranges
- Selecting Non-Contiguous Ranges
- Using Special Selection Techniques
- Selecting Larger Ranges
- Selecting Rows
- Selecting Columns
- Viewing Range Calculations
- Creating An Input Range
Unit 7: Copying Excel Data
- Understanding Copying In Excel
- Using Fill For Quick Copying
- Copying From One Cell To Another
- Copying From One Cell To A Range
- Copying From One Range To Another
- Copying Relative Formulas
- Copying To A Non-Contiguous Range
- Copying To Another Worksheet
- Copying To Another Workbook
Unit 8: Moving Data
- Understanding Moving In Excel
- Moving Cells And Ranges
- Moving Data To Other Worksheets
- Moving Data To Other Workbooks
Unit 9: Font Formatting
- Understanding Font Formatting
- Working With Live Preview
- Changing Fonts
- Changing Font Size
- Growing And Shrinking Fonts
- Making Cells Bold
- Italicising Text
- Underling Text
- Changing Font Colours
- Changing Background Colours
- Using The Format Painter
- Applying Strikethrough
- Subscripting Text
- Superscripting Text
Unit 10: Applying Borders
- Applying A Border To A Cell
- Applying A Border To A Range
- Applying A Bottom Border
- Applying Top And Bottom Borders
- Removing Borders
- The More Borders Option
- Using The More Borders Option
Unit 11: Cell Alignment
- Understanding Cell Alignment
- Aligning Right
- Aligning To The Centre
- Aligning Left
- Aligning Top
- Aligning Bottom
- Aligning To The Middle
- Rotating Text
- Indenting Cells
- Wrapping And Merging Text
- Merging And Centring
- Merging Cells
- Unmerging Cells
Unit 12: Row And Column Formatting
- Approximating Column Widths
- Setting Precise Column Widths
- Setting The Default Column Width
- Approximating Row Height
- Setting Precise Row Height
- Hiding Rows And Columns
- Unhiding Rows And Columns
Unit 13: Number Formatting
- Understanding Number Formatting
- Applying General Formatting
- Formatting As Currency
- Formatting Percentages
- Formatting As Fractions
- Formatting As Dates
- Using The Thousands Separator
- Increasing And Decreasing Decimals
Unit 14: Number Formatting Techniques
- Using Alternate Currencies
- Formatting Dates
- Formatting Time
- Creating Custom Formats
Unit 15: Page Setup
- Using Built In Margins
- Setting Custom Margins
- Changing Margins By Dragging
- Centring On A Page
- Changing Orientation
- Specifying The Paper Size
- Setting The Print Area
- Clearing The Print Area
- Inserting Page Breaks
- Using Page Break Preview
- Removing Page Breaks
- Setting A Background
- Clearing The Background
- Setting Rows As Repeating Print Titles
- Clearing Print Titles
- Printing Gridlines
- Printing Headlines
- Scaling To A Percentage
- Fit To A Specific Number Of Pages
- Strategies For Printing Larger Worksheets
Unit 16: Printing
- Understanding Printing
- Previewing Before You Print
- Performing A Quick Print
- Selecting A Printer
- Printing A Range
- Printing An Entire Workbook
- Specifying The NUmber Of Copies
- The Print Dialog Box

Upcoming Courses

Sydney

Level 11, 32 Walker Street
North Sydney
View map

Date:
06 Feb 12
13 Feb 12
20 Feb 12
29 Feb 12
13 Mar 12
26 Mar 12
10 Apr 12
23 Apr 12
09 May 12
21 May 12
04 Jun 12
20 Jun 12

Melbourne

Level 12, 379 Collins Street
Melbourne
View map

Date:
13 Feb 12
22 Feb 12
28 Feb 12
05 Mar 12
14 Mar 12
20 Mar 12
02 Apr 12
17 Apr 12
02 May 12
14 May 12
28 May 12
13 Jun 12
25 Jun 12

Brisbane

C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map

Date:
15 Feb 12
05 Mar 12
26 Mar 12
16 Apr 12
09 May 12
29 May 12
20 Jun 12

Canberra

C/O Atlas Business Services, 21 Barry Drive
Turner
View map

Date:
20 Feb 12
27 Mar 12
01 May 12
04 Jun 12

Adelaide

C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map

Date:
27 Mar 12
15 May 12

Perth

C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map

Date:
21 Feb 12
28 Mar 12
23 Apr 12
23 May 12
18 Jun 12
 

$385 incl GST

Duration: 1 Days

Class Size: 10

Level: Beginner

Times: 9.00am - 5.00pm approx

 
Man and woman sitting at a computer SEEK logo