112 Osprey Drive

Welcome Bay

Tauranga

07 5443172

sue@computertraining.co.nz

chris@computertraining.co.nz

  • Facebook Social Icon

© 2023 by Ground Floor. Proudly created with Wix.com

Excel level 1

Covers the essentials of spreadsheeting . Creating a spreadsheet, simple formulas, changing and improving the way it looks, printing and saving it for future use.

Practical hands-on training in:

  • Definition, Concepts & Terms

  • Types of Entries

  • Formulas & Cell Formats

  • Copying, Moving & Deleting

  • Insert/Delete Columns/Rows

  • Change Column Width/Row Height

  • Planning & Layout

  • Formatting Data

  • Borders & Shading

  • Spell Check

  • Printing Issues

 

Duration: Full Day

Recommended Prerequisites:

Keyboard Skills and Computer Awareness

Excel Level 2

Covers extended use of MS Excel including charts. Includes the skills required to give a professional finish to your spreadsheet.

Practical hands-on training in:

  • Overview of the Basic Elements

  • Designing Worksheet Presentation

  • Sorting A Range of Cells

  • Split Windows, Freezing Panes

  • Naming Cells and Ranges

  • Toolbars

  • Advanced Formulas

  • Goal Seek

  • Inserting Graphics

  • Linking Spreadsheets

  • Creating, Editing & Formatting Charts

 

Duration: Full day

Recommended Prerequisites:

Understanding Excel (Level 1) or equivalent experience.

Excel Formulas Refresher

  • Formulas in Excel 2007/2010

  • Order of calculation of formulas - BODMAS

  • A quick overview of the basic elements

  • Relative vs. absolute references

  • Naming cells and ranges of cells

  • Advanced formulas

  • Insert function button

 

Duration: 1/2 day

Who should attend:

Excel users who are not confident with formulas.

Excel: Customising and Automating

Practical hands-on training in :

  • mouse and keyboard shortcuts

  • AutoCorrect

  • Custom lists

  • Find and Replace

  • Customising the Quick Access Toolbar and Ribbons

  • Templates

  • Workbook protection

  • Changing Options

  • Macros

 

Duration:    ½ day

Recommended Prerequisites:

Microsoft Excel experience at Level Two or equivalent.