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.

Excel Essentials

16 sessions available starting from $255.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

What is assumed of the Students

• Students have fundamental keyboard skills.
• Students have fundamental mouse skills.
• Students have a fundamental knowledge of Windows.

Who Should Attend?
Users who want to improve or sharpen their exisiting basic or intermediate skills in Excel. Much emphasis is also placed on the quickest and easiest ways to accomplish activities in Excel.

Please note that this course is not intended for brand new users to a computer. Attendees should already have fundamental keyboard and mouse skills.

Part One: Worksheet and Workbook Basics

• The Excel Layout
• Cells & Data
• Highlight, Insert & Delete cells, rows, columns
• Cut, copy & paste
• Entering & Editing Cell Data
• Using the Autofiller
• Creating Date and Number patterns
• Create custom...

see more

What is assumed of the Students

• Students have fundamental keyboard skills.
• Students have fundamental mouse skills.
• Students have a fundamental knowledge of Windows.

Who Should Attend?
Users who want to improve or sharpen their exisiting basic or intermediate skills in Excel. Much emphasis is also placed on the quickest and easiest ways to accomplish activities in Excel.

Please note that this course is not intended for brand new users to a computer. Attendees should already have fundamental keyboard and mouse skills.

Part One: Worksheet and Workbook Basics

• The Excel Layout
• Cells & Data
• Highlight, Insert & Delete cells, rows, columns
• Cut, copy & paste
• Entering & Editing Cell Data
• Using the Autofiller
• Creating Date and Number patterns
• Create custom fill patterns
• Entering and modifying formulas
• SUM / AVERAGE / MAX / MIN / COUNT / COUNTA functions
• Percentage formulae
• Absolute and Relative References
• Checking Spelling
• Using Find & Replace
• Filtering lists
• Modifying Toolbars (Excel 2003)
• Modifying the Quick Access Toolbar (Excel 2007)

Part Two: Formatting and Printing

• Formatting Worksheets (Row, Cell & Column formats)
• Number formats
• Aligning, Rotating, Merging, Indents, Text Wrapping
• Applying borders & colours
• Adjusting column width & row heights
• Applying AutoFormats & Styles
• Previewing, Printing & Altering Page Setups
• Setting page options
• Setting margins in the page setup dialog box
• Setting headers & footers
• Changing sheet settings
• Page Break Preview
• Inserting and removing page breaks
• Changing print settings

Part Three: Enhance and Revise Workbooks

• Modifying Workbooks
• Inserting and Deleting worksheets
• Modifying worksheet names
• Moving & copying worksheets
• More Complex Formulas
• Linking Worksheets and Workbooks
• Using 3D Reference functions (for Summary Sheets)
• Using the IF function

Part Four: Charts and Graphics

• Pie / Column / Bar / Line charts
• Scaling & printing chart objects
• Modifying charts
• Editing & formatting charts
• Working with Graphics

Part Five: Collaboration

• Web Publishing in Excel
• Creating and Editing hyperlinks
• Using Comment

see less

Choose from 16 available sessions:

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions

When

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

Where

  • 19/1904 Beach Rd
    Perth, WA 6090

Price: $255.00

Type

  • Class / Group Sessions



My Other Listings

Excel Expert
Excel Expert
6 sessions available starting from $255.00
Excel Formula Workshop
Excel Formula Workshop
3 sessions available starting from $255.00
Publisher Essentials
Publisher Essentials
2 sessions available starting from $255.00

see all listings »


Found In