Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


Microsoft Excel 2007 Training Course, Learn Step by Step, Level 2

6 sessions available starting from $450.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

Course Code: 50124
Course Duration: 1 days

This one-day instructor-led course provides students with experience at creating more elaborate worksheets and workbooks in Microsoft Office Excel 2007 to display data in more effective ways.

Skills Gained

After completing this course, students will be able to:

• Summarise data that meets specific conditions
• Find and correct errors in calculations
• Change the appearance of data based on its value
• Customise the appearance of charts
• Find trends in your data
• Print charts
• Add images to worksheets
• Create diagrams by using SmartArt
• Define valid sets of values for ranges of cells
• Limit data that appears on your screen
• Manipulate list data
• Sort data lists
• Organise data into levels
• Look up information in...

see more

Course Code: 50124
Course Duration: 1 days

This one-day instructor-led course provides students with experience at creating more elaborate worksheets and workbooks in Microsoft Office Excel 2007 to display data in more effective ways.

Skills Gained

After completing this course, students will be able to:

• Summarise data that meets specific conditions
• Find and correct errors in calculations
• Change the appearance of data based on its value
• Customise the appearance of charts
• Find trends in your data
• Print charts
• Add images to worksheets
• Create diagrams by using SmartArt
• Define valid sets of values for ranges of cells
• Limit data that appears on your screen
• Manipulate list data
• Sort data lists
• Organise data into levels
• Look up information in a data list
• Use data lists as templates for other lists
• Print data lists
• Print parts of data lists
• Link to data in other worksheets and workbooks
• Consolidate multiple sets of data into a single workbook
• Group multiple sets of data

Course Modules

Module 1: More Calculations and Formatting
This module explains how to create conditional formulas, identify and correct formula errors, and conditionally modify the appearance of data.

Lessons
• Summarising Data That Meets Specific Conditions
• Finding and Correcting Errors in Calculations
• Changing the Appearance of Data Based on Its Value

Lab : More Calculations and Formatting
• Create a conditional formula, and find the average and sum of worksheet values.
• Use auditing capabilities to identify and correct errors.
• Create conditional formats to change the appearance of data.

After completing this module, students will be able to:
• Create conditional formulas.
• Track down calculation errors.
• Use conditional formatting.

Module 2: More Charts and Graphics
This module explains how to tailor a chart to best show your data and how to print them. The module also explains how to add visual objects such as images and diagrams.

Lessons
• Customising the Appearance of Charts
• Finding Trends in Your Data
• Printing Charts
• Adding Images to Worksheets
• Creating Diagrams by Using SmartArt

Lab : More Charts and Graphics
• Customise a chart, and save it as a chart template.
• Add a trendline.
• Print a chart.
• Insert and modify an image, and then set the image as a repeating background.
• Create and modify an organization chart.

After completing this module, students will be able to:
• Modify the layout and style of a chart.
• Use a trendline to discover data trends.
• Print charts separately from their worksheets.
• Add visual objects such as images.
• Use SmartArt Graphics to create diagrams.

Module 3: Data Lists
This module explains how to limit the data that can be entered in a worksheet, how to filter data, and how to manipulate and sort data lists.

Lessons
• Defining Valid Sets of Values for Ranges of Cells
• Limiting Data That Appears on Your Screen
• Manipulating List Data
• Sorting Data Lists

Lab : Data Lists
• Create a data validation rule, and then test it.
• Filter a data list with AutoFilter items and a custom filter.
• Select random rows, create a SUBTOTAL formula, and find unique values.
• Sort a data list in various ways.

After completing this module, students will be able to:
• Validate data entered into worksheets.
• Use filters to display specific data.
• Extract specific information from a data list.
• Sort data in different ways.

Module 4: More Data Lists
This module explains how to organize data to show the information you want, look up information in data lists and use data lists as templates, and how to print all or part of a data list.

Lessons
• Organising Data into Levels
• Looking Up Information in a Data List
• Using Data Lists as Templates for Other Lists
• Printing Data Lists
• Printing Parts of Data Lists

Lab : More Data Lists
• Add subtotals, and then work with the resulting outline.
• Create a VLOOKUP function to return a value for a specified record.
• Create a workbook from a template, save workbook and worksheet templates, and insert a worksheet based on a template.
• Print nonadjacent worksheets, without errors.
• Specify custom print settings.

After completing this module, students will be able to:
• Create an outline to display different groups of data.
• Use VLOOKUP functions to look up values.
• Create templates for workbooks and worksheets.
• Print specific data and specify how information should be printed.

Module 5: Data from Multiple Sources
This module explains how to link data in other worksheets and workbooks, and how to consolidate and group multiple sets of data.

Lessons
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data

Lab : Data from Multiple Sources
• Create a link, and break and re-create the link.
• Total ranges from two workbooks.
• Save a workspace, and then open it.

After completing this module, students will be able to:
• Create, break, and re-create links to workbooks and worksheets
• Summarise data from different locations in one worksheet
• Save multiple workbooks as a workspace

Who Should Attend

This course is intended for information workers who want to learn intermediate-level Excel 2007 skills.

Prerequisites

Before attending this course, students must have:

• Basic computer knowledge
• Basic file-management skills
• Basic knowledge of the Excel interface and workbook creation

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $450.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Visual Studio 2008 ADO.NET 3.5
Visual Studio 2008 ADO.NET 3.5
6 sessions available starting from $1,660.00
Java 2.0 Programming Course
Java 2.0 Programming Course
6 sessions available starting from $1,800.00
Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010
Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010
6 sessions available starting from $2,475.00

see all listings »


Found In