Microsoft Excel 2007 Level 1
Who should do this course?
This course is primarily designed for people who need to know how to use Microsoft Excel. It is ideal for people who need to produce reports, budgets, lists and the like.
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.
About the course:
The skills and knowledge are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists.
Learning outcomes:
Upon successful completion of this course, participants will be able to:
- work within the basic Excel environment
- create a new workbook
- open and navigate within workbooks and worksheets
- make changes to data in a workbook
- understand, create and work with formulas and functions used to perform calculations
- understand and use formula cell referencing to create more complex formulas
- understand and work with ranges in a worksheet
- copy and paste data in Excel
- use font formatting techniques to greatly enhance the look of a worksheet
- align the contents of cells in a number of ways
- format rows and columns in a worksheet
- understand and use the number formatting features in Excel
- print your workbook data
- create effective charts in Microsoft Excel
Quick Facts
| Level: |
Beginner |
Price: |
$385.00 incl GST |
You will receive: |
| Duration: |
1 Days |
Discounts*: |
2 Students - 10% |
- Certificate of completion |
| Size: |
10 |
|
3 Students - 15% |
- Training Manual |
| Times: |
9.00am - 5.00pm approx |
|
4 Students - 20% |
- 12 months FREE email support* |
| Pre-requisites: |
Refer to course description |
Bonus: |
2 FREE |
- FREE class re-sit (if necessary)* |
| |
|
|
Movie Tickets |
Course Brochure: |
| |
|
|
|
Excel_2007_L1.pdf |
| |
|
|
|
|
| * Conditions apply. |
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 10-10 Mar 10
- 10-10 Mar 10
- 22-22 Mar 10
- 22-22 Mar 10
- 07-07 Apr 10
- 19-19 Apr 10
- 03-03 May 10
- 17-17 May 10
- 02-02 Jun 10
- 15-15 Jun 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 17-17 Mar 10
- 17-17 Mar 10
- 06-06 Apr 10
- 21-21 Apr 10
- 03-03 May 10
- 19-19 May 10
- 31-31 May 10
- 15-15 Jun 10
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen St
Brisbane
View map
|
- Date:
- 17-17 Mar 10
- 29-29 Mar 10
- 14-14 Apr 10
- 27-27 Apr 10
- 12-12 May 10
- 24-24 May 10
- 09-09 Jun 10
- 21-21 Jun 10
|
|
Canberra
C/- Training Choice, Level 12, 15 London Circuit
Canberra
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
For more information on dates or locations, please call
1300 888 724 or
enquire online.
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: Formula Referencing
- - Absolute Versus Relative Referencing
- - Relative Formulas
- - Problems with Relative Formulas
- - Creating Absolute References
- - Creating Mixed References
|
- Unit 7: 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 8: 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 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: 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 11: 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 12: 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 13: 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
|
- Unit 14: Creating Charts
- - Understanding the Charting Process
- - Choosing the Chart Type
- - Creating a New Chart
- - Working with an Embedded Chart
- - Resizing a Chart
- - Dragging a Chart
- - Printing an Embedded Chart
- - Creating a Chart Sheet
- - Changing the Chart Type
- - Changing the Chart Layout
- - Changing the Chart Style
- - Printing a Chart Sheet
- - Embedding a Chart into a Worksheet
- - Deleting a Chart
|