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 3

3 sessions available starting from $800.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

Course Code: DT013
Course Duration: 2 days

This one-day instructor-led coursee will provide a thorough understanding of advanced 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:

• Increase productivity and improve efficiency by streamlining your workflow
• Collaborate with others using workbooks
• Audit worksheets
• Analyze data
• Work with multiple workbooks
• Import and export data
• Use Excel with the web
• Creating PivotCharts
• Create, edit and customise Macros

Course Modules

Security and Protection...

see more

Course Code: DT013
Course Duration: 2 days

This one-day instructor-led coursee will provide a thorough understanding of advanced 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:

• Increase productivity and improve efficiency by streamlining your workflow
• Collaborate with others using workbooks
• Audit worksheets
• Analyze data
• Work with multiple workbooks
• Import and export data
• Use Excel with the web
• Creating PivotCharts
• Create, edit and customise Macros

Course Modules

Security and Protection
• Password Protection
• Attaching a Password
• Modification Password

Saving with a Backup Cell Protection
• Protecting Cells

Circular References
• Circular Error Messages
• Error Checking

Functions
• Function Overview
• Functions Revision
• Math & Trig Functions
• The SUMPRODUCT Function
• Rounding Functions
• Financial Functions
• The PMT Function
• Logical Functions
• The IF Function
• Nested IF Functions
• The AND Function
• The OR Function
• More Functions
• Lookup Functions
• The VLOOKUP Function
• The HLOOKUP Function
• Concatenating Functions
• Index & Match Functions
• Naming Ranges
• The MATCH Function
• The INDEX Function
• Using the Function Library

Goal Seek
• Using Goal Seek

Solver
• Target Cell & Value
• Saving a Scenario
• Solver Reports

Scenarios
• Adding a Scenario
• Showing Scenarios

Linking
• Worksheet Linking
• Workbook Linking

Data Consolidation
• Using Statistical Functions

Importing Data
• Importing CSV Files
• Text Import Wizard

Exporting Data
• Choosing a Specific Format
• Exporting to Microsoft Word
• Pasting Data with a Link
• Copying a Graph as a Picture

PivotTable Reports
• Rearranging Data
• Filtering a Report
• Adding Fields
• Field Settings
• Refreshing Data
• Formatting a PivotTable
• Expanding and Collapsing Detail

PivotChart Reports
• Creating a PivotChart
• PivotChart Reports from scratch
• Adding Fields to a PivotChart

Macros
• Recording a Macro
• Editing a Macro
• Relative/Absolute Recording
• Stepping through a Macro

Macro Buttons
• Customising the Quick Access
• Toolbar
• Deleting Macros
• Macro Revision Exercise
• Macro Security Level

Who Should Attend

This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

Before attending this course it is recommended participants have completed the Excel 2007 Level 1 and Level 2 training or have the equivalent working experience.

see less

Choose from 3 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: $800.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: $800.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: $800.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

Advanced Foundations of Microsoft .NET 2.0 Development
Advanced Foundations of Microsoft .NET 2.0 Development
6 sessions available starting from $2,040.00
Microsoft BizTalk Server 2009 Training Course
Microsoft BizTalk Server 2009 Training Course
3 sessions available starting from $2,490.00
Creating Lasting Customer Experiences
Creating Lasting Customer Experiences
6 sessions available starting from $495.00

see all listings »


Found In