Support

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

Word Essentials
Word Essentials
6 sessions available starting from $255.00
Word Expert
Word Expert
2 sessions available starting from $255.00
Project Essentials
Project Essentials
1 session available for $480.00

see all listings »


Found In