Microsoft Excel 2007 Level 2
Regular Excel 2007 users can take their spreadsheet skills to the next level with advanced techniques including multiple workbooks, lookup functions, fill techniques and more.
Quick Facts
Duration: 1 Days
Class Size: 10
Level: Intermediate
Times: 9.00am - 5.00pm approx
Other Microsoft Excel 2007 Courses:
About the Course
During this 1 day course, instructors show participants how to work more effectively with Excel 2007 workbooks and worksheets. Students will undertake hands-on exercises in advanced formatting, absolute referencing, Lookup functions and using complex sorting and filtering features to manage and analyse data.
Who should do this course?
This course is intended for current Microsoft Excel 2007 users who wish to extend their knowledge and skills beyond building simple workbooks. Upon completion of the course, students should be able to use advanced techniques to manage manipulate and analyse complex data.
Prerequisites
Participants should have already completed the Excel 2007 Level 1 course or have equivalent skills.
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: Formula Referencing
- - Absolute Versus Relative Referencing
- - Relative Formulas
- - Problems With Relative Formulas
- - Creating Absolute References
- - Creating Mixed References
|
- Unit 3: Labels
- - Understanding Labels And Names
- - Creating Names Using Text Labels
- - Using Names In New Formulas
- - Applying Names To Existing Formulas
- - Creating Names Using The Names Box
- - Using Names To Select Ranges
- - Pasting Names Into Formulas
- - Creating Names For Constants
- - Creating Names From A Selection
- - Scoping Names To The Worksheet
- - Using The Name Manager
- - Documenting Range Names
|
- 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: 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 6: 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 7: 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 8: 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 9: Sorting Data
- - Performing An Alphabetical Sort
- - Sorting On More Than One Column
- - Sorting By Rows
- - Sorting Numbered Lists
|
- Unit 10: Filtering Data
- - Applying And Using A Filter
- - Clearing A Filter
- - Creating Compound Filters
- - Multiple Value Filters
- - Creating Custom Filters
- - Using Wildcards
|
- Unit 11: 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 12: 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
|
- Unit 13: Chart Text Formatting
- - Using Font Formatting And Alignment
- - Using WordArt Styles
- - Changing Text Fill
- - Changing Text Outline
- - Changing Text Effects
|
- Unit 14: Chart Object Formatting
- - Understanding Chart Object Formatting
- - Selecting Chart Elements
- - Using Shape Styles To Format Objects
- - Changing Column Colour
- - Changing Pie Slice Colour
- - Changing Bar Colours
- - Changing Chart Line Colours
- - Using Shape Effects
- - Filling The Chart Area And The Plot Area
- - Filling The Background
- - The Format Dialog Box
- - Using The Format Dialog Box
- - Using Themes
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 14 Feb 12
- 21 Feb 12
- 01 Mar 12
- 14 Mar 12
- 27 Mar 12
- 11 Apr 12
- 24 Apr 12
- 10 May 12
- 22 May 12
- 05 Jun 12
- 21 Jun 12
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 09 Feb 12
- 14 Feb 12
- 23 Feb 12
- 29 Feb 12
- 06 Mar 12
- 15 Mar 12
- 21 Mar 12
- 03 Apr 12
- 18 Apr 12
- 03 May 12
- 15 May 12
- 29 May 12
- 14 Jun 12
- 26 Jun 12
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map
|
- Date:
- 16 Feb 12
- 06 Mar 12
- 27 Mar 12
- 17 Apr 12
- 10 May 12
- 30 May 12
- 21 Jun 12
|
|
Canberra
C/O Atlas Business Services, 21 Barry Drive
Turner
View map
|
- Date:
- 21 Feb 12
- 28 Mar 12
- 02 May 12
- 05 Jun 12
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
- Date:
- 04 Apr 12
- 23 May 12
- 31 May 12
|
|
Perth
C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map
|
- Date:
- 22 Feb 12
- 29 Mar 12
- 24 Apr 12
- 24 May 12
- 19 Jun 12
|
Duration: 1 Days
Class Size: 10
Level: Intermediate
Times: 9.00am - 5.00pm approx