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
Duration: 1 Days
Class Size: 10
Level: Beginner
Times: 9.00am - 5.00pm approx
Other Microsoft Excel 2007 Courses:
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
|
Duration: 1 Days
Class Size: 10
Level: Beginner
Times: 9.00am - 5.00pm approx
