Microsoft Excel 2007 Level 2
Who should do this course?
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel 2007 Level 1 course or have equivalent skills.
About the course:
This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data.
Learning outcomes:
Upon successful completion of this course, students will be able to:
- use the fill operations available to fill a data series
- move the contents of cells and ranges within and between workbooks
- use a range of formula techniques
- use a range of logical functions
- apply a range of number formatting techniques to data
- apply conditional formatting to ranges in a worksheet
- apply borders to cells and ranges
- work with various elements of a worksheet
- use a range of techniques to work with worksheets
- use a range of find and replace techniques
- apply a variety of page setup techniques
- sort data in a list in a worksheet
- filter data in a table
- use a range of techniques to enhance charts
- apply formatting techniques to text on charts
Quick Facts
| Level: |
Intermediate |
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_L2.pdf |
| |
|
|
|
|
| * Conditions apply. |
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 23-23 Mar 10
- 23-23 Mar 10
- 08-08 Apr 10
- 20-20 Apr 10
- 04-04 May 10
- 18-18 May 10
- 03-03 Jun 10
- 16-16 Jun 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 18-18 Mar 10
- 18-18 Mar 10
- 18-18 Mar 10
- 07-07 Apr 10
- 22-22 Apr 10
- 04-04 May 10
- 20-20 May 10
- 01-01 Jun 10
- 16-16 Jun 10
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen St
Brisbane
View map
|
- Date:
- 18-18 Mar 10
- 30-30 Mar 10
- 15-15 Apr 10
- 28-28 Apr 10
- 13-13 May 10
- 25-25 May 10
- 10-10 Jun 10
- 22-22 Jun 10
|
|
Canberra
C/- Training Choice, Level 12, 15 London Circuit
Canberra
View map
|
- Date:
- 29-29 Apr 10
|
|
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: Filling Data
- - Filling a Series
- - Filling a Growth Series
- - Filling a Series Backwards
- - Filling Using Options
- - Creating a Custom Fill List
- - Modifying a Custom Fill List
- - Deleting a Custom Fill List
|
- Unit 2: Moving Data
- - Understanding Moving in Excel
- - Moving Cells And Ranges
- - Moving Data to Other Worksheets
- - Moving Data to Other Workbooks
|
- Unit 3: Formula Techniques
- - Scoping a Formula
- - Developing a Nested Function
- - Creating Nested Functions
- - Editing Nested Functions
- - Copying Nested Functions
- - Using Concatenation
- - Switching to Manual Recalculation
- - Forcing a Recalculation
- - Pasting values From Formulas
- - Pasting Formulas As Pictures
|
- Unit 4: Logical Functions
- - Using IF to Display Text
- - Using IF to Calculate Values
- - Nesting IF Functions
- - Using IFERROR
- - Using TRUE and FALSE
- - Using AND
- - Using OR
- - Using NOT
|
- Unit 5: Number Formatting Techniques
- - Using Alternate Currencies
- - Formatting Dates
- - Formatting Time
- - Creating Custom Formats
|
- Unit 6: Conditional Formatting
- - Formatting Cells Containing Values
- - Clearing Conditional Formatting
- - More Cell Formatting Options
- - Top Ten Items
- - More Top And Bottom Formatting Options
- - Working with Data Bars
- - Working with Colour Scales
- - Working with Icon Sets
|
- Unit 7: 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 8: Working with a Worksheet
- - Changing Worksheet Views
- - Worksheet Zooming
- - Viewing the Formula Bar
- - Viewing the Gridlines
- - Viewing the Ruler
- - Inserting Cells
- - Deleting Cells
- - Inserting Columns
- - Inserting Rows
- - Deleting Rows And Columns
- - Switching Between Worksheets
|
- Unit 9: Worksheet Techniques
- - Inserting And Deleting Worksheets
- - Copying a Worksheet
- - Renaming a Worksheet
- - Moving a Worksheet
- - Hiding a Worksheet
- - Unhiding a Worksheet
- - Copying a Worksheet to Another Workbook
- - Moving a Worksheet to Another Workbook
- - Changing Worksheet Tab Colours
- - Grouping Worksheets
- - Hiding Rows And Columns
- - Unhiding Rows And Columns
- - Freezing Rows And Columns
- - Splitting Windows
|
- Unit 10: Finding And Replacing
- - Finding Text
- - Finding Cell References in Formulas
- - Replacing Values
- - Using Replace to Change Formulas
- - Replacing Within a Range
- - Finding Formats
- - Finding Constants Using Go to Special
- - Finding Formulas Using Go to Special
- - Finding the Current Region
- - Finding the Last Cell
|
- Unit 11: 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 12: Sorting Data
- - Performing an Alphabetical Sort
- - Sorting on More Than One Column
- - Sorting By Rows
- - Sorting Numbered Lists
|
- Unit 13: Filtering Data
- - Applying And Using a Filter
- - Clearing a Filter
- - Creating Compound Filters
- - Multiple Value Filters
- - Creating Custom Filters
- - Using Wildcards
|
- Unit 14: Charting Techniques
- - Adding a Chart Title
- - Adding Axes Titles
- - Positioning the Legend
- - Showing Data Labels
- - Showing a Data Table
- - Modifying the Axes
- - Showing Gridlines
- - Formatting the Plot Area
- - Showing the Plot Area
- - Adding a Trendline
- - Adding Error Bars
- - Adding a Text Box to a Chart
- - Drawing Shapes in a Chart
|
- Unit 15: Chart Text Formatting
- - Using Font Formatting And Alignment
- - Using WordArt Styles
- - Changing Text Fill
- - Changing Text Outline
- - Changing Text Effects
|