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 Course | Level 1

6 sessions available starting from $385.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

Course Code: DT011
Course Duration: 1 days

This one-day instructor-led course will provide a thorough understanding of introductory and intermediate concepts and skills that will enable the participant to effectively use Microsoft Excel 2007 through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.

Skills Gained

Upon successful completion of this course, students will be able to:

• Create basic worksheets
• Perform calculations
• Modify a worksheet
• Format a worksheet
• Print workbook contents
• Manage large workbooks

Course Modules

Starting Excel
• The Excel Screen
• The Ribbon
• The Microsoft Office Button

Moving around a Sheet
• Displaying other Areas
• Mouse Movements
• Viewing...

see more

Course Code: DT011
Course Duration: 1 days

This one-day instructor-led course will provide a thorough understanding of introductory and intermediate concepts and skills that will enable the participant to effectively use Microsoft Excel 2007 through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.

Skills Gained

Upon successful completion of this course, students will be able to:

• Create basic worksheets
• Perform calculations
• Modify a worksheet
• Format a worksheet
• Print workbook contents
• Manage large workbooks

Course Modules

Starting Excel
• The Excel Screen
• The Ribbon
• The Microsoft Office Button

Moving around a Sheet
• Displaying other Areas
• Mouse Movements
• Viewing other Sheets
• Selecting Cells

Inserting Text and Numbers
• Typing the Text
• Adjusting Column Widths
• Typing Numbers

Saving a Workbook
• The My Places Bar
• The My Places Bar
• File Properties

Alignment & Indenting
• Indenting
• Centre Aligning
• Merge and Centre

Calculations
• BEDMAS Rule
• AutoSum
• Filling the Formula
• Basic Formulas
• AutoCalculate
• Cell Editing

Multiple Worksheets
• Copying Sheet Contents
• Data Entry Ranges
• Calculating across Worksheets
• Copying Formulas

Functions
• Function Syntax
• The AVERAGE Function
• The MAX Function
• The MIN Function

Working with Worksheets
• Renaming Sheets
• Inserting a Sheet
• Deleting Sheets

Formatting
• Fonts and Fonts Sizes
• Number Formatting
• Formatting a Group of Sheets
• Borders
• The Format Painter
• Cell Shading
• Font Colour
• Inserting Images

Proofing
• Checking Spelling
• AutoCorrect
• Find & Replace
• Comments

Sorting Charts
• Column Chart
• Pie Chart

Print Preview
• Page Break Preview
• Adjusting the Page Breaks
• Previewing the Workbook
• Zoom
• Margins and Column Widths
• Column Widths in Print Preview

Page Setup
• Orientation
• Scaling
• Margin Settings
• Headers and Footers
• Built-In Headers and Footers
• Custom Headers and Footers
• Sheet Options
• Print Areas

Who Should Attend

This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Prerequisites

Microsoft Excel 2007 Level 1 assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.

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: $385.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: $385.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: $385.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: $385.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: $385.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: $385.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

Implementing Microsoft Office SharePoint Server 2007 Training Course
Implementing Microsoft Office SharePoint Server 2007 Training Course
1 session available for $2,040.00
Windows 7 Training for Developers
Windows 7 Training for Developers
5 sessions available starting from $2,720.00
SharePoint 2007 Training Course | Search Customisation
SharePoint 2007 Training Course | Search Customisation
2 sessions available starting from $1,360.00

see all listings »


Found In