INDIVIDUALLY GIFTED, COLLECTIVELY BRILLIANT ®

Print E-mail

Microsoft Office Training

The Mango Bites Microsoft Office Training Series has been developed to help businesses and teams improve productivity when working in Microsoft Office applications.

The program is broken into short training courses across Microsoft Office applications Word, Excel, PowerPoint, Outlook, Access, Publisher as well as Microsoft Office 2007 upgrade and can be fully customised for your specific business requirements.

How you benefit

  • Customised Microsoft Office training courses; learn exactly what you need with minimum time out of the workplace
  • Improve efficient working practices in Microsoft Office suite
  • Reduce workplace stress and frustration
  • Increase staff motivation and performance
  • Maximise return on your training investment

Our place or yours?

Training courses can be run at the Perth-based Priority Learning Centre in Applecross, or your workplace, where we can use your computers or bring training laptops with us.

Contact us to organise your customised training today. We can provide training for small groups (minimum of 6 people per session) or company-wide software upgrades. We also offer Training Needs Analysis to help better understand the requirements of your team and business divisions.

Explore opportunities for customised training programs that combine bundled Mango Bites from Microsoft Word, Excel, PowerPoint, Outlook and Access.

The Mango Bites Microsoft Excel Series has been developed as part of our People-2-Technology training and development solutions to provide extended skills and knowledge in using Microsoft Excel. It is ideal for people who work in a business environment where there is a requirement for calculations, data analysis, budgeting, creating charts and producing reports in spreadsheets.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title. 

       

Formulas and Functions

 2hrs

This intensive training program is designed to show users how they can benefit from using formulas and functions in Excel. The skills and knowledge covered are sufficient for real-world applications such as budgeting, analysing sales, profit and loss statements, payroll statements and anything that requires in-depth calculations. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).

COURSE OUTLINES
  1. Understanding Formulas
  2. Using Arithmetic Operators (Addition, Subtraction, Multiplication and Division)
  3. What are Relative and Absolute References
  4. How to use Relative and Absolute References
  5. Formula Error Checking
  6. Understanding Functions
  7. Using Statistical Functions
    • SUM
    • AVERAGE
    • MAX
    • MIN
  8. Summing up non-contiguous ranges
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Build Formulas
  • Use Relative cell referencing
  • Use Absolute cell referencing
  • Understand the basics of Functions
  • Create Functions
  • Use the Insert Function feature
  • Work with Statistical Functions
  

Charting

 2hrs

This intensive training program is designed to show users how they can benefit from creating and formatting charts in Excel. The skills and knowledge covered are sufficient for real-world applications such as budgeting, analysing sales, profit and loss statements, payroll statements and presenting the data in an easy to use and understand chart >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).

COURSE OUTLINES
  1. The Charting process
  2. Choosing the Chart type
  3. Embedding a Chart
  4. Resizing and moving a Chart
  5. Printing a Chart
  6. Creating a Chart sheet
  7. Changing the Chart Type
  8. Changing the Chart Layout
  9. Changing the Chart Style
  10. Formatting the different Chart elements (e.g., axis, plot area, data series, etc)
  11. Printing a Chart sheet
  12. Embedding a Chart into a worksheet
  13. Deleting a Chart
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create a chart
  • Move a chart between chart sheet and worksheet
  • Format the chart
  • Create different types of charts
  • Add and delete Chart elements
  

Lists and Tables  

 2hrs

This intensive training program is designed to show users how they can benefit from storing database information in Tables or lists.  Users will learn how to summarise data efficiently and quickly.  Useful for anyone who works with large amounts of data. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).
Basic formatting of  the worksheet(s).

COURSE OUTLINES
  1. What is an Excel Table
  2. Creating a Table
  3. Formatting a Table
  4. Using Table features
  5. Using Formulas/Functions in Tables
  6. Sorting in Tables
  7. Subtotalling in Tables
  8. Filtering in Tables
LEARNING OUTCOMES

At the completion of this workshop participants will be familiar with:
  • Convert an Excel database to a Table and back to a range
  • Benefit from the useful features available in tables
  • Filter and sort information in a table
  • Subtotal information in a table using SUM, AVERAGE, MAX and MIN
  

PivotTables

 2hrs

This intensive training program is designed to show users how they can benefit from using Pivot Tables to summarise large amounts of data stored in an Excel database or list. Pivot Tables allow users to compare and/or summarise information in an understandable format, and allow users to spot trends or differences. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).
Basic formatting of  the worksheet(s).

COURSE OUTLINES
  1. Understanding PivotTables
  2. Creating a PivotTable
  3. Dropping Fields Into A PivotTable
  4. Filtering A PivotTable
  5. Switching PivotTable Labels
  6. Formatting A PivotTable
  7. Using Compound Fields
  8. Counting In A PivotTable
  9. Formatting PivotTable Values
  10. Working With PivotTable Totals
  11. Finding The Percentages
  12. Grouping In PivotTables
  13. Creating Calculated Fields
  14. Providing Custom Names
  15. Creating Calculated Items
  16. PivotTable Options
  17. Sorting In A PivotTable
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create and format a PivotTable
  • Add information to the row, column and/or Page Report fields
  • Summarise the data using Sum, Average, Count, and using percentages
  • Create a list of the source data used in the calculations
  • Create calculations based on the PivotTable results
  • Group results together for analysis
  

Basics of Macros

 2hrs

This intensive training program is designed to show users how they can benefit from creating and utilising Macros in Excel.  The user will obtain skills in streamlining their Excel operation by creating quick and easy shortcuts for every day  tasks. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).
Basic formatting of  the worksheet(s).

COURSE OUTLINES
  1. What is a Macro?
  2. Setting Macro Security and saving a document as Macro Enabled
  3. Recording A Simple Macro
  4. Running A Recorded Macro
  5. Relative Cell References
  6. Running A Macro With Relative References
  7. Viewing A Macro
  8. Editing A Macro
  9. Assigning A Macro To The Toolbar
  10. Assigning A Macro to a keyboard shortcut
  11. Assigning A Macro to a button on a worksheet
  12. Deleting A Macro
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Understand what a Macro is and what it can be used for
  • Record and save a Macro
  • Run a Macro
  • Edit a Macro
  • Delete a Macro
  • Assign a macro to a toolbar button, keyboard or menu item
  • Assign a macro to a button on the worksheet
  

Data Linking and Data Consolidation

 2hrs

This intensive training program is designed to show users how they can link data in Excel. Instruction in linking between worksheets, workbooks and other Microsoft Applications (e.g., Word, Powerpoint). We will also investigate how data can be consolidated from a number of workbooks to a target workbook. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).
Basic formatting of  the worksheet(s).

COURSE OUTLINES
  1. What is Data Linking?
  2.  Linking Data Between Worksheets
  3. Linking Data Between Workbooks
  4. Linking Data between Applications
  5. Updating Links Between Workbooks
  6. What is Data Consolidation?
  7. Consolidating With Identical Layouts
  8. Creating An Outlined Consolidation
  9. Consolidating With Different Layouts
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Build a linking formula
  • Understand how linking formulas work
  • View, change and update linking formulas
  • Understand the principles of Data Consolidation
  • Consolidate data from a number of workbooks
  

Advanced Functions

 2hrs

This intensive training program is designed to show users how to use some of the most popular advanced Functions provided by Microsoft. The skills and knowledge covered are sufficient for real-world applications that require math, text or logical calculations to find out information about the worksheet data. >>>>

PREREQUISITES

Create a new workbook. Open and close the workbook. Enter data into cells. Navigate through the worksheet(s).
Basic formatting of  the worksheet(s).

COURSE OUTLINES
  1. Using Logical Functions
    • Understanding the IF Function
    • Using the IF Function
    • Using TRUE and FALSE
    • Using AND, OR and NOT with IF
    • Using IFERROR
  2. Lookup Functions
    • Understanding Data Lookup Functions
    • Using CHOOSE
    • Using VLOOKUP
    • Using VLOOKUP For Exact Matches
    • Using HLOOKUP
    • Using INDEX
    • Using MATCH
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Use the IF Function to solve a problem
  • Nest the IF function with other functions (e.g., AND, OR and NOT)
  • Use the VLOOKUP function to look up information from reference tables
  

Microsoft Excel 2007 upgrade – What's New?

 2hrs

This intensive training program is designed to show users the new features of Excel, and where to find the regular features of Excel. >>>>

PREREQUISITES

Open and close files. Enter data into cells. Basic formatting.

COURSE OUTLINES
  1. The Office 2007 user Interface
  2. Recent Document Pushpin
  3. The Ribbon
  4. Contextual Tabs
  5. New File Types
  6. New Worksheet size
  7. Compatibility with previous versions
  8. Page Layout view
  9. Charting – Design, Layout and Format
  10. Conditional Formatting
  11. The Name Manager
  12. Excel Tables – New options
  13. New PivotTable features
  14. Excel Options
LEARNING OUTCOMES

At the completion of this workshop participants will be familiar with:
  • The new Excel 2007 interface
  • New Excel 2007 file types
  • Compatibility issues
  • The new Page Layout View
  • Charting Fundamentals
  • Using the new features of Conditional Formatting
  • Using named ranges and the Name Manager
  • New PivotTable Features
  • New Excel 2007 Options
  

Excel Foundations

 1day

This 1-day training program is primarily designed for people who need to know how to use Microsoft Excel. The skills and knowledge covered are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs, and managing small lists. >>>>

PREREQUISITES

This workshop assumes no prior knowledge of Microsoft Excel or creating electronic worksheets and workbooks.

COURSE OUTLINES
  1. Getting To Know Excel
  2. Creating A New Workbook
  3. Working With Workbooks
  4. Editing In A Workbook
  5. Formulas And Functions
  6. Formula Referencing
  7. Selecting Ranges
  8. Copying Excel Data
  9. Font Formatting
  10. Cell Alignment
  11. Row And Column Formatting
  12. Number Formatting
  13. Printing
  14. Creating Charts
LEARNING OUTCOMES

At the completion of Foundations Microsoft Excel workshop participants will be able to:
  • Work within the basic Excel environment
  • Create a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data in a workbook
  • Understand, create and work with formulas and functions used to perform calculations
  • Understand and use formula cell referencing to create more complex formulas
  • Understand and work with ranges in a worksheet
  • Copy and paste data in Excel
  • Use font formatting techniques to greatly enhance the look of a worksheet
  • Format rows and columns in a worksheet
  • Understand and use the number formatting features in Excel
  • Print your workbook data
  • Create effective charts in Microsoft Excel

Excel Intermediate

 1day

This 1-day training program extends the learner's basic knowledge of Excel. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks. This course is designed for existing users who would like to learn more of the techniques associated with Excel. >>>> 

PREREQUISITES

This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, enter simple formulas, and print and chart data.

COURSE OUTLINES
  1. Filling Data
  2. Moving Data
  3. Formula Techniques
  4. Logical Functions
  5. Number Formatting Techniques
  6. Conditional Formatting
  7. Applying Borders
  8. Working With A Worksheet
  9. Worksheet Techniques
  10. Splitting Windows
  11. Page Setup
  12. Sorting Data
  13. Filtering Data
  14. Charting Techniques
  15. Chart Text Formatting
LEARNING OUTCOMES

At the completion of Intermediate Microsoft Exccl workshop participants will be able to:
  • Use the fill operations available to fill a data series
  • Move the contents of cells and ranges within and between workbooks
  • Use a range of formula techniques
  • Use a range of logical functions
  • Apply a range of number formatting techniques to data
  • Apply conditional formatting to ranges in a worksheet
  • Apply borders to cells and ranges
  • Work with various elements of a worksheet
  • Use a range of techniques to work with worksheets
  • Use a range of find and replace techniques
  • Apply a variety of page setup techniques
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Use a range of techniques to enhance charts
  • Apply formatting techniques to text on charts

Excel Advanced

 1day

This 1-day training program covers aspects of workbook automation and productivity features. It includes areas such as workbook and worksheet consolidation and linking, data analysis tools, and automating workbook operations using macros. This course is designed for users who are already familiar with Excel and who are now now ready to explore more advanced analysis and automation tools. >>>> 

PREREQUISITES

This workshop assumes a good general understanding of Microsoft Excel and experience in the construction and modification of workbooks. The learner should be able to copy within Excel, create charts, and create basic formulas.

COURSE OUTLINES
  1. Lookup Functions
  2. Setting Excel Options
  3. Chart Object Formatting
  4. Labels And Names
  5. Protecting Data
  6. Summarising And Subtotalling
  7. Data Linking
  8. Data Consolidation
  9. Pivot Tables
  10. Pivot Charts
  11. Goal Seeking
  12. Grouping And Outlining
  13. Solver
  14. Recorded Macros
  15. Recorder Workshop
LEARNING OUTCOMES

At the completion of Advanced Microsoft Excel workshop participants will be able to:
  • Use a range of lookup and reference functions
  • Modify Excel options
  • Create and use labels and names in a workbook
  • Protect data in worksheets and workbooks
  • Summarise data using subtotals and relative range naming
  • Use data linking to create more efficient workbooks
  • Use the Data Consolidation feature to combine data from several workbooks into one
  • Construct and operate Pivot Tables using some of the more advanced techniques
  • Use goal seeking to determine the values required to reach a desired result
  • Group cells and use outlines to manipulate the worksheet
  • Use Solver to solve more complex and intricate problems
  • Use the macro recorder to create a variety of macros

The Mango Bites Microsoft Word Series has been developed as part of our People-2-Technology training and development solutions to provide businesses and teams with extended skills and knowledge in using Microsoft Word. It is ideal for people who work in a business environment where there is a requirement to produce professional looking reports and business documents.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Creating Word Tables

 2 hrs

This intensive training program was designed to show users how to benefit from creating tables to display structured information in a word document. Word tables have many uses and simplify what can be complex requirements. >>>> 

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. Creating a Table
  2. Adding Data to a Table
  3. Navigating and Selecting in a Table
  4. Inserting and deleting Columns and Rows
  5. Changing Column Widths and Row Heights
  6. Using Autofit on Columns
  7. Formatting a Table
    • Table Styles
    • Borders
    • Shading
  8. Drawing a Table
  9. Creating a Table from Text
  10. Changing Cell Alignments
  11. Creating Formulas in Tables
  12. Updating Formulas in Tables
  13. Sorting Table Data
  14. Merging and Splitting Table Cells
  15. Viewing Table Gridlines
  16. Changing Table Properties
  17. Changing Table Alignment
  18. Changing Text Direction
  19. Repeating Header Rows
  20. Converting a Table to Text
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create a Table
  • Draw a Table
  • Create a Table from Text
  • Format a table using Styles, Borders and Shading
  • Alter the Column and Rows
  • Alter the Table Properties
  • Use the Table Alignment Tools
  • Use Formulas to perform simple calculations
  • Repeat Header rows in large tables
 

Word Forms

 2 hrs

This intensive training program designed to show users how they can create automated forms using different fields, for streamlining use by multiple Word users. >>>>

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. What are Forms?
  2. Creating A Structure For The Form
  3. Understanding Content Controls
  4. Displaying The Developer Tab
  5. Adding Text Controls
  6. Setting Content Control Properties
  7. Using The Date Picker Control
  8. Adding Numeric Controls
  9. Adding Formulas
  10. Adding A Combo Box
  11. Adding A Drop-Down List
  12. Protecting And Saving The Form
  13. Using An Electronic Form
  14. Editing The Form
  15. Deleting A Content Control
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Understand Forms and their many uses
  • Create a Form
  • Create and use form controls:
    • Text
    • Date Picker
    • Combo Box
    • Drop Down List
  • Protect and Save the Form
  • Set up the Form for use by multiple users
  

Graphics

 2 hrs

This intensive training program was designed to show users how to benefit benefit from using some of the advanced graphic options available in Word 2007. Users will learn how to manipulate graphics and shapes, and use graphic tools to create impressive eye-catching visuals. >>>>

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. Using Pictures
    • Inserting a Picture
    • Selecting a Picture
    • Resizing and Moving a Picture
    • Applying Picture Styles
    • Applying Picture Fills, Outlines and Effects
  2. Using Shapes
    • Inserting Shapes
    • Selecting Shapes
    • Resizing and Moving Shapes
    • Applying Shapes Styles
    • Applying Shape Fills, Outlines and Effects
  3. WordArt
    • Creating and Editing WordArt
    • Resizing and Moving WordArt
    • Applying WordArt Styles
    • Applying WordArt Fills, Outlines and Effects
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create effective documents using graphics for interesting effects
  • Use Shapes and WordArt in a document to add interest and impress readers
  

Using Mail Merge

 2 hrs

This intensive training program is designed to show users how they can create how to use mail merge to create mass mail outs and mailing labels/envelopes using databases from a variety of sources – Word, Excel, Access or Outlook. >>>>

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. Understanding Formulas
  2. Understanding Mail Merging
  3. Selecting the Main document
  4. Selecting a Recipient List
  5. Writing the Details
  6. Previewing the Letters
  7. Completing the Merge
  8. Running An Existing Merge
  9. Selecting Specific Recipients
  10. Filtering Recipients For Merging
  11. Sorting Recipients For Merging
  12. Merging From Another Source
  13. Setting An IF Rule
  14. Setting a Prompt when completing the Merge
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create a mail merge main document
  • Select a number of different recipients list for the mail merge
  • Preview the mail merge, then complete the mail merge
  • Filter the recipient list based on certain criteria
  • Sort the recipient list based on certain criteria
  • Use the IF rule to ask a question of mail merge
  • Use a prompt for specific information to be used in the mail merge
 

Creating Long Documents

 2 hrs

This intensive training program is designed to show users how they can use some specific tools designed for long documents. These tools can streamline the creation of long documents and alleviate errors in the completed document. >>>>

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. Using Styles
    • Applying Styles
    • Using In-built Styles
    • Creating Styles
    • Updating Styles
  2. Using Sections
    • Understanding Sections
    • Using Next Page, Continuous, Even and Odd Page Breaks
  3. Headers and Footers
    • Creating and editing Headers and Footers
    • Using Different Headers and Footers in different sections
  4. Tables of Contents
    • Creating and editing a Table of Contents
    • Updating a Table of Contents
    • Formatting a Table of Contents
  5. Indexing
    • Marking Index Entries
    • Creating and Editing an Index
  6. Bookmarking, Footnotes and Endnotes
    • Creating and using Bookmarks and Cross-referencing
    • Creating Footnotes and/or Endnotes
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create a Long document
  • Use the Streamlining tools available to
    • Format the document
    • Create Sections and Section Headers and Footers
    • Generate an automatic Table of Contents and Index
    • Use Bookmarks, Endnotes and Footnotes effectively
 

Templates and Macros

 2 hrs

This intensive training program was designed to show users how to benefit from creating and utilising Templates and Macros together in Word. The user will obtain skills in streamlining their Word operation by creating quick and easy shortcuts for every day tasks. >>>>

PREREQUISITES

Create a new document, and use basic formatting techniques. Save, open and close the document.

COURSE OUTLINES
  1. Understanding Formulas
  2. Templates
    • What is a Template?
    • Creating a Template from Scratch
    • Modifying a Template
  3. Macros
    • What is a Macro?
    • Setting Macro Security
    • Saving A Document As Macro Enabled
    • Recording A Simple Macro
    • Running A Macro
    • Assigning A Macro To The Toolbar
    • Editing A Macro
    • Deleting A Macro
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Understand what Templates and Macros are and what they can be used for
  • Create and modify a Template
  • Record and save a Macro
  • Run a Macro
  • Edit a Macro
  • Delete a Macro
  • Assign a macro to a toolbar button or keyboard
 

Upgrade To Word 2007 – What's New?

 2 hrs

This intensive training program is designed to show users the new features of Word 2007, and where to find the regular features of Word. >>>>

PREREQUISITES

As this is an upgrade course it is assumed that the learner has some familiarity with one or more previous versions of Microsoft Office.

COURSE OUTLINES
  1. The Office 2007 user Interface
  2. Recent Document Pushpin
  3. The Ribbon
  4. Contextual Tabs
  5. New File Types
  6. The Quick Styles Gallery
  7. Changing Style Sets
  8. Creating and Modifying Themes
  9. Colour Themes
  10. Adding Cover Pages
  11. Page Colour and Borders
  12. Watermarks
  13. Building Blocks and Quick Parts
  14. Tables in Word
  15. Page Setup
  16. SmartArt
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • The new Word 2007 interface
  • New Word 2007 file types
  • Using Styles and the Style Gallery
  • Using Themes
  • Adding and editing Cover pages
  • Changing Page colour and Page Borders
  • Adding Page Watermarks
  • How to use Building Blocks and Quick Parts
  • How to create a Table and use Table Styles
  • How to use Page Setup
  • How to use SmartArt effectively
 

Word Foundations

 1day

This 1-day training program focuses on basic document production using Microsoft Word 2007 and is designed to give the learner a sound understanding of how documents are created, formatted, and printed. It is ideal for people who work in a business environment where there is a requirement to produce simple reports and business documents. >>>>

PREREQUISITES

This workshop assumes no prior knowledge of Microsoft Word.

COURSE OUTLINES
  1. Getting to Know Word
  2. Creating a New Document
  3. Working With A Document
  4. Working With Text
  5. Cutting and Copying
  6. Font Formatting
  7. Paragraph Formatting
  8. Page Layout
  9. Tables
  10. Printing
  11. Getting Help
LEARNING OUTCOMES

At the completion of Foundations Microsoft Word workshop participants will be able to:
  • Start and work with Microsoft Word 2007, its screens, menus, and dialog boxes
  • Create a new document from scratch
  • Work with existing documents
  • Work with text, including performing search and replace operations
  • Cut and copy text around a document
  • Format both text and paragraphs to produce appealing documents
  • Work with page layout and design features
  • Create and work with tables
  • Print documents
  • Access additional help and information as required

Word Intermediate

 1day

This 1-day training program extends the learner's basic skills and knowledge of Microsoft Word 2007 and helps them create more intricate and varied documents. Existing skills and knowledge are enhanced by covering more advanced aspects of key topics such as formatting, tables, and lists, and new features such as merging, envelopes, sections, clip art and graphics are introduced. It is ideal for people who work in a business environment where there is a requirement to produce more intricate documents. >>>>

PREREQUISITES

This training course assumes an understanding of Microsoft Word requisite with the skills and knowledge covered in the Foundations workshop. It is assumed that the learner will know how to create and save a document, do simple formatting, and print the document.

COURSE OUTLINES
  1. Setting Word Options
  2. Multiple Documents
  3. Formatting Techniques
  4. Tabs
  5. Lists
  6. Table Features
  7. Working With Building Blocks
  8. Styles
  9. Templates
  10. Sections
  11. Headers and Footers
  12. Mail Merging
  13. Pictures
  14. Shapes
  15. WordArt
LEARNING OUTCOMES

At the completion of Intermediate Microsoft Word workshop participants will be able to:
  • Set Word options to more easily access files and information
  • Work with multiple, concurrent documents
  • Further enhance documents and text using advanced formatting features
  • Use tabs, and work with bulleted and numbered lists
  • Create enhanced tables
  • Use timesaving features such as Building Blocks, styles and templates
  • Partition longer documents into sections
  • Create headers and footers in documents
  • Create letters, envelopes and labels
  • Perform mail merges
  • Incorporate pictures, drawings and WordArt into documents

Word Advanced

 1day

This 1-day training program is designed to provide the learner with advanced skills and knowledge in using Microsoft Word 2007. This workshop focuses on producing longer documents and includes key aspects such as creating a table of contents, indexing, creating cover pages, document automation through the use of fields, forms, and macros, and also deals with document change tracking and protection. >>>>

PREREQUISITES

This workshop assumes an understanding of Microsoft Word requisite with the skills and knowledge covered in the Foundations and Intermediate workshops.

COURSE OUTLINES
  1. Page Techniques
  2. Saving To PDF
  3. Merging Techniques
  4. SmartArt
  5. Building Blocks
  6. Bookmarks
  7. Table Of Contents
  8. Indexing
  9. Fields
  10. Interactive Fields
  11. Master Documents
  12. Tracking Changes
  13. Protecting Documents
  14. Electronic Forms
  15. Macros
  16. Inserting From Other Sources
LEARNING OUTCOMES

At the completion of Advanced Microsoft Word workshop participants will be able to:
  • Use bookmarks to mark and locate text
  • Create tables of content and indexes
  • Create longer, more structured documents using Master Documents and various page techniques
  • Insert data into documents from other sources
  • Automate documents using fields and macros
  • Create smarter merge operations
  • Create complex drawings using SmartArt
  • Collaborate with colleagues and track changes made to documents
  • Protect documents from unauthorized changes
  • Create electronic forms

The Mango Bites Microsoft Access Series has been developed as a part of out People-2-Technology training and development solutions to provide businesses and teams with extended skills and knowledge in using Microsoft Access. It is ideal for people who work in a business environment where there is a requirement to create effective databases and to manipulate data to provide viable information.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Access Foundations

 1day

This training program is designed for people who need to know how to create effective databases and to manipulate data to provide viable information. The skills and knowledge acquired in Microsoft Access Foundations are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. >>>>

PREREQUISITES

This workshop assumes no prior knowledge of Microsoft Access.

COURSE OUTLINES
  1. Access Orientation
  2. Designing A Lookup Database
  3. Creating A Lookup Database
  4. Modifying Table Structures
  5. Adding Records To A Table
  6. Adding Transactional Records
  7. Working With Records
  8. Sorting And Filtering
  9. Creating Queries
  10. Creating And Using Reports
  11. Creating And Using Forms
LEARNING OUTCOMES

At the completion of Foundations Microsoft Access workshop participants will be able to:
  • Understand how Access is used and how to navigate around it
  • Design a database with lookup tables
  • Create a database structure using Access
  • Modify the structure of an existing table
  • Add records to a new table
  • Add transactional records to a lookup database
  • Work with the records in a database table
  • Sort and filter records in a table
  • Create simple and effective queries
  • Create meaningful reports from tables
  • Create and use a variety of forms
  

Access Intermediate

 1day

The aim of this training course is to build on the introductory skills of Microsoft Access Foundations. The participants learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and are introduced to some basic automation techniques involving macros. >>>>

PREREQUISITES

This course assumes an understanding of Microsoft Access requisite with the skills and knowledge covered in the Foundations workshop. It is assumed that the learner can create databases comprising of tables, simple queries, forms and reports.

COURSE OUTLINES
  1. Data Validation
  2. Formatting Tables
  3. Querying Techniques
  4. Parameter Queries
  5. Calculations In Queries
  6. Creating And Using Macros
  7. Macro Techniques
  8. Macros On Forms
LEARNING OUTCOMES

At the completion of Intermediate Microsoft Access workshop participants will be able to:
  • Use various data validation features in Access to protect data
  • Format the data in a table
  • Perform more advanced queries using a variety of querying techniques
  • Create and use parameter queries
  • Create calculated queries
  • Create and use macros in Access
  • Work with a number of macro techniques
  • Create macros on forms
  

Access Advanced

 1day

This training program is designed for people who need to know how to automate operations in Microsoft Access. The skills and knowledge acquired in Microsoft Access Advanced are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access. >>>>

PREREQUISITES

This workshop assumes an understanding of Microsoft Access requisite with the skills and knowledge covered in the Foundations and Intermediate workshops.

COURSE OUTLINES
  1. Relational Database Design
  2. Creating A Relational Database
  3. Setting Table Relationships
  4. Multi-Table Queries
  5. Aggregation Queries
  6. Action Queries
  7. Macro Techniques
  8. An Introduction To VBA
LEARNING OUTCOMES

At the completion of Advanced Microsoft Access workshop participants will be able to:
  • Design a relational database project
  • Create a relational database file with multiple tables
  • Set table relationships and join tables together
  • Create queries based on one or more tables
  • Create and work with aggregation queries
  • Create and use a series of action queries
  • Work with a number of macro techniques
  • Create some simple programming code using VBA
  

The Mango Bites Microsoft Outlook Series has been developed as part of our People-2-Technology solutions to provide businesses and teams with extended skills and knowledge in using Microsoft Outlook. It is ideal for people who work in a business environment where there is a requirement to effectively manage electronic communication, schedule appointments, and keep track of contacts.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Outlook Mail

 2 hrs

This intensive training program designed to show users how to how to use Outlook Mail as an effective tool and be more productive. >>>>

PREREQUISITES

Create and send email.

COURSE OUTLINES
  1. Working With Attachments
  2. Flagging Messages
  3. Junk Email
  4. Organising Messages
  5. Archiving Messages
  6. Searching for Messages
  7. Email Techniques
    • Effective Email Management
    • Recalling A Sent Message
    • Message Formats
    • Saving A Message Draft
    • Sending A Voting Message
    • Responding To A Voting Message
    • Tracking Voting Responses
    • Configuring Send And Receive
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Understand and use the effective tools provided by Outlook to:
    • Work with Email Attachments
    • Flag Messages
    • Add Message to Junk Email
    • Organise Messages
    • Archive Messages
    • Search for Messages
    • Use specific email techniques
 

Outlook Calendar

 2 hrs

This intensive training program designed to show users how to utilise the powerful tools provided by Outlook Calendar to organise day to day appointments and tasks and use time management tools to increase productivity. >>>>

PREREQUISITES

Open and Close Outlook

COURSE OUTLINES
  1. Working With The Calendar
    • Changing Calendar Components
    • Navigating Within A Calendar
    • Changing The Current View
    • Creating A Second Time Zone
    • Creating A New Calendar
    • Deleting A Calendar
    • Working With Multiple Calendars
  2. Appointments And Events
    • Scheduling and Rescheduling Meetings
    • Creating and changing Recurring Appointments
    • Printing Your Calendar
    • Scheduling Free And Busy Times
    • Categorising Activities
  3. Scheduling Meetings
    • Responding To Meeting Requests
    • Tracking Meeting Responses
    • Adding Or Removing Attendees
    • Preventing Responses
    • Cancelling A Meeting
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Understand and use the effective tools provided by Outlook to:
    • Schedule Appointments
    • Schedule Meetings and Events
    • Respond to Meetings and Events
    • Track Meetings and Events
    • Print the Calendar
    • Categorise Appointments, Meetings and Evens
  

Upgrade To Outlook 2007 – What's New?

 1 hr

This intensive training program designed to show users the new features of Outlook, and where to find the regular features of Outlook. >>>>

PREREQUISITES

As this is an upgrade course it is assumed that the learner has some familiarity with one or more previous versions of Microsoft Outlook.

COURSE OUTLINES
  1. The Office 2007 user Interface
    • The Outlook 2007 Screen
    • The Navigation Pane
    • The To-Do Bar
    • Using Instant Search
    • Recent Searches and Searching the Desktop
  2. Working with Mail
    • Previewing Attachments
    • Colour Categories
    • Flagging Messages
    • Managing Follow-Ups in the To-Do Bar
    • Setting a Follow-Up Flag for Recipients
  3. Working with the Calendar
    • Calendar Views
    • Task Integration on the Calendar
    • Creating a Calendar Snapshot
    • Working with Multiple Calendars
    • Scheduling Meetings
  4. Working with Contacts
LEARNING OUTCOMES

At the completion of this workshop participants will be familiar with:
  • The new Outlook interface
  • Working with Email
  • Working with the Calendar
  • Working with Contacts
  

Outlook Essentials

 1day

Microsoft Outlook Essentials is designed for users who are keen to know how to use this application to send and retrieve email, schedule appointments and events, and add contact information. The skills and knowledge acquired in this training course are sufficient to be able to manage your e-mail, calendar and contacts with confidence. >>>>

PREREQUISITES

This workshop assumes no prior knowledge of Microsoft Outlook.

COURSE OUTLINES
  1. Email Concepts
  2. Outlook Basics
  3. Sending Email
  4. Receiving Email
  5. Working With Attachments
  6. Flagging Messages
  7. Junk Email
  8. Working With The Calendar
  9. Contacts
  10. Tasks
LEARNING OUTCOMES

At the completion of Essentials Microsoft Outlook workshop participants will be able to:
  • Gain an overview of the benefits of email
  • Start Outlook 2007 and navigate around the various features
  • Create and send email messages
  • Receive emails in your Inbox
  • Competently work with file and item attachments within email messages
  • Work with message flags and reminders
  • Work effectively with junk email
  • Work with the Calendar feature in Outlook
  • Create and work with contacts
  • Create and work with tasks

Advanced Outlook

 1day

The skills and knowledge acquired in this training program will enable participants to use some of the more advanced features of Microsoft Outlook to manage and organise e-mail, restrict junk email, schedule meetings with colleagues, manage contact information, and create task requests for others to perform. >>>> 

PREREQUISITES

This course assumes an understanding of Microsoft Outlook requisite with the skills and knowledge covered in the Starting With Outlook workshop. It is assumed that the learner will know how to create and send a letter, create Calendar appointments and tasks.

COURSE OUTLINES
  1. Editing Messages
  2. Organising Messages
  3. Searching
  4. Working With Views
  5. Colour Categories
  6. Working With Rules
  7. Email Techniques
  8. Appointments And Events
  9. Scheduling Meetings
  10. Managing Contacts
  11. Task Requests
LEARNING OUTCOMES

At the completion of Advanced Microsoft Outlook workshop participants will be able to:
  • Effectively edit email messages
  • Organise and work with mail folders
  • Use the search facilities to locate email messages
  • Work with message views
  • Create and use rules to manage your email messages
  • Format email messages and use special features to control how emails work
  • Schedule appointments and events in your calendar
  • Schedule meetings using Microsoft Outlook
  • Monitor and manage your contacts within Outlook
  • Delegate effectively, create and work with task requests

The Mango Bites Microsoft Power Point Series has been developed as part of our People-2-Technology training and development solutions to provide businesses and teams with extended skills and knowledge in using Microsoft Power Point. It is ideal for people who work in a business environment where there is a requirement to build and enhance powerful, real-world presentations for sales, training and more. p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Slide Masters And Templates

 2 hrs

This intensive training program is designed to show users how to benefit from creating slide masters and templates to create streamlined, effective presentations. Slide masters and templates ensure the look and feel of the presentation is consistent and professional. >>>>

PREREQUISITES

Create a new presentation, and use basic formatting techniques. Save, open and close the presentation.

COURSE OUTLINES
  1. Slide Masters
    • What are Slide Masters?
    • Creating and Modifying Slide Masters
    • Viewing The Slide Master
    • Modifying The Master Font
    • Modifying The Bullet Colour
    • Changing The Bullet Shape
    • Adding An Image
    • Adding Slide Numbers
  2. Templates
    • What are Templates?
    • Creating A Blank Presentation
    • Applying A Theme
    • Creating A New Layout
    • Customising A Layout
    • Adding Content
    • Creating A Template
    • Using A Custom Template
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Use Slide Masters and Templates to create an effective, professional presentation for use as a standard for all new presentations
  

Using Presentation Tools

 2 hrs

This intensive training program designed to show users how to utilise the powerful tools provided by Powerpoint to present amazing, professional and interesting presentations. >>>>

PREREQUISITES

Create a new presentation, and use basic formatting techniques. Save, open and close the presentation.

COURSE OUTLINES
  1. Slide Show Tools
    • Keyboard Shortcuts For Navigating Slide Shows
    • Presenting A Slide Show
  2. About Hyperlinks
    • Creating An Internal Hyperlink
    • Creating A Hyperlink To Another Presentation
    • Creating A Hyperlink To Another Application
  3. About Movies And Sounds
    • Inserting A Movie Clip
    • Inserting A Sound Clip
  4. Action Buttons
    • Creating Action Buttons
  5. Self-Running Presentations
    • Applying Timings For A Kiosk
    • Using Rehearsed Timings
    • Setting Up The Show For A Kiosk
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Use Tools provided to navigate, annotate and present professional and communicative presentations
  

Graphics

 2 hrs

This intensive training program designed to show users how to use some of the advanced graphic options available in Powerpoint 2007. Users will learn how to manipulate graphics and shapes, and use graphic tools to create impressive eye-catching visuals. >>>>

PREREQUISITES

Create a new presentation, and use basic formatting techniques. Save, open and close the presentation.

COURSE OUTLINES
  1. Understanding Formulas Using ClipArt
    • Inserting and Resizing Clip Art
    • Modifying Clip Art
    • Modifying Elements Of Clip Art
    • Applying Effects To Clip Art
    • Rotating Clip Art
    • Inserting Clips From The
    • Organiser
  2. Using Shapes
    • Drawing Shapes
    • Working With Shapes
    • Arranging Shapes
    • Adding Connectors To Shapes
    • Adding Text To Shapes
    • Grouping Shapes
    • Formatting Shapes
    • Layering Shapes
    • Using SmartArt
    • Adding A SmartArt Graphic
    • Formatting A SmartArt Graphic
    • Adding and Deleting SmartArt Shapes
    • Changing The Layout
    • Changing Colours
    • Changing SmartArt Styles
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • Create effective presentations using graphics for interesting effects
  • Use Shapes and SmartArt in a document to add interesting and dramatic presentations
 

Upgrade To PowerPoint 2007 – What's New?

 1 hr

This intensive training program designed to show users the new features of Powerpoint, and where to find the regular features of Powerpoint. >>>>

PREREQUISITES

As this is an upgrade course it is assumed that the learner has some familiarity with one or more previous versions of Microsoft Office.

COURSE OUTLINES
  1. The Office 2007 user Interface
  2. Recent Document Pushpin
  3. The Ribbon
  4. Contextual Tabs
  5. Powerpoint Views
  6. Powerpoint Themes
  7. Slide Masters
  8. SmartArt
  9. Tables
  10. Charts
  11. Photo Albums
LEARNING OUTCOMES

At the completion of this workshop participants will be able to:
  • The new Powerpoint2007 interface
  • The New Powerpoint Themes
  • Using the Slide Master
  • Using the new features of SmartArt, Tables, Charts and generating Photo Albums
 

PowerPoint Essentials

 1day

The skills and knowledge acquired in this training program are sufficient to be able to create real-world presentations. You will also learn how to add themes, run a slide show, print, publish presentations. Starting with Microsoft PowerPoint 2007 is designed for users who wish to use this application to present information. >>>>

PREREQUISITES

This workshop assumes no prior knowledge of Microsoft PowerPoint.

COURSE OUTLINES
  1. Getting To Know PowerPoint
  2. Working With Presentations
  3. Creating A Presentation
  4. Slide Layouts
  5. Clip Art
  6. Shapes
  7. SmartArt
  8. Slide Show Navigation
  9. Printing
  10. Getting Help
LEARNING OUTCOMES

At the completion of Essentials Microsoft PowerPoint workshop participants will be able to:
  • Start and work with Microsoft Word 2007, its screens, menus, and dialog boxes
  • Work with the basic features of PowerPoint
  • Work with presentations
  • Create a new presentation
  • Learn how to add slides with different layouts
  • Insert and modify clip art in the presentation
  • Draw and work with shapes
  • Create and work with SmartArt
  • Navigate a slide show in PowerPoint
  • Use a range of printing techniques
  • Find the information in Help

Advanced PowerPoint

 1day

The skills and knowledge acquired in this training course are sufficient to be able to build and enhance powerful, real-world business presentations. Mastering Microsoft PowerPoint is designed for users who are keen to broaden their understanding and knowledge of the software. It is ideal for people who work in areas where effective presenting of information is important. >>>>

PREREQUISITES

This course assumes an understanding of Microsoft PowerPoint requisite with the skills and knowledge covered in the Starting With PowerPoint workshop. It is assumed that the learner will know how to create and save a presentation, insert content, and print the document.

COURSE OUTLINES
  1. Text Techniques
  2. Tables And Charts
  3. Modifying Charts
  4. Modifying Tables
  5. Slide Masters
  6. Templates
  7. Importing Into PowerPoint
  8. Media And Action Buttons
  9. Setting Up Shows
LEARNING OUTCOMES

At the completion of Advanced Microsoft PowerPoint workshop participants will be able to:
  • Insert text into a slide and modify it
  • Create and work with tables and charts
  • Modify charts in a presentation
  • Modify and work effectively with tables
  • View and modify slide masters
  • Create and use custom templates
  • Import data into PowerPoint from a number of different applications
  • Insert movie and sound clips and work with action buttons
  • Set up a presentation based on how it is to be delivered
  • Find the information you need in Help
The Mango Bites Microsoft Publisher Series has been developed to provide businesses and teams with advanced skills and knowledge in using Microsoft Publisher.  It is ideal for people who work in a business environment where there is a requirement to create a range of business-based documents including brochures, fliers, newsletters, labels, and the like.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Publisher Essentials

 1day

This training course is primarily designed for people who need to know how to use the Microsoft Publisher o create a range of business-based documents including brochures, fliers, newsletters, labels, and the like. >>>>

PREREQUISITES

Microsoft Publisher assumes little or no knowledge of the software.

COURSE OUTLINES
  1. Publisher Orientation
  2. Publisher Essentials
  3. Objects And Frames
  4. Text
  5. Text Techniques
  6. Text Styles
  7. Tabs And Lists
  8. Tables
  9. Mail Merge
  10. Drawing
  11. WordArt
  12. Stationery And Page Orientation
  13. Layout And Page Techniques
LEARNING OUTCOMES

At the completion of Microsoft Publisher workshop participants will be able to:
  • Start, navigate and generally work with Microsoft Publisher
  • Understand concepts essential to the use of Publisher
  • Work with objects and frames in a publication
  • Work with text in a publication
  • Enhance the text in a publication
  • Perform a mail merge in Microsoft Publisher
  • Create drawings
  • Create WordArt objects
  • Create stationery using Microsoft Publisher
  • Use layout and page techniques to enhance publications

The Mango Bites Upgrade to Microsoft Office 2007 Series has been developed as part of out People-2-Technology training and development solutions to help businesses and teams become quickly proficient in the changes and new features introduced in Microsoft Office Word, Excel and PowerPoint 2007 such as the ribbon interface. As this is an upgrade course it is assumed that the learner has some familiarity with one or more previous versions of Microsoft Office.p2t-button-DownloadCourseOutlines

To view course outlines please click on the program title.

       

Upgrade to Microsoft Office 2007

 1day

Upgrade to Microsoft Office 2007 is designed for people who are upgrading to Microsoft Office 2007 and need to understand the changes and new features in Word, Excel and PowerPoint . This program can be delivered as one full day or two 1/2 days customised workshops. >>>>

PREREQUISITES

As this is an Microsoft upgrade course it is assumed that the learner has some familiarity with one or more previous versions of Microsoft Office.

COURSE OUTLINES

Getting to Know Microsoft Office 2007
  1. UPGRADE TO MICROSOFT WORD 2007
    • Getting to Know Microsoft Word 2007
    • Using Tables in Word 2007
    • Proofing And Printing
    • Working With Illustrations
  2. UPGRADE TO MICROSOFT EXCEL 2007
    • Getting to Know Microsoft Excel 2007
    • Formatting In Excel 2007
    • Working With Formulas
    • Working With Tables
    • Creating Charts In Excel 2007
  3. UPGRADE TO MICROSOFT POWERPOINT 2007
    • Getting to Know Microsoft PowerPoint 2007
    • Working With PowerPoint 2007
    • Illustrations And Tables
    • Animation And Slide Shows
LEARNING OUTCOMES

At the completion of Microsoft Office 2007 upgrade workshop participants will be able to:
  • Work within the new Office 2007 user interface
  • Use the new features in Word 2007
  • Create tables using the new features in Word 2007
  • Use the new methods for proofing and printing documents
  • Insert and work with illustrations
  • Identify and work with the new features available in Microsoft Excel 2007
  • Use new formatting features in Excel 2007
  • Use the Formulas tab to create and manage formulas and functions
  • Create, format, sort and filter tables in a workbook
  • Create and manage charts in Excel 2007
  • Work with the new features available in Microsoft PowerPoint 2007
  • Work with the new design features available in Microsoft PowerPoint 2007
  • Use the new illustration and table features within PowerPoint 2007
  • Animate and run a slide show

To discuss your specific needs or to book a course, call our office on 9200 6000 or click here to email us.
 

What's included?

• Interactive training courses

• Customised training workbooks

• Online supportmango-banner



Call 9200 6000 or email us to organise your training sessions

Here is what our clients clients say about us:

"A very 'eye opening' experience"

"Dealing with Mango has been a very 'eye opening' experience. Being involved in open discussions with Mango staff has been great. Their ability to listen and get involved in our experiences and points of view is very appreciated rather than a typical approach of teach and tell.

Mango has helped me to gain a plethora of knowledge and confidence that will undoubtedly assist me throughout me career development, as I move forward becoming not only a better manager, but a better person... in business... and in LIFE."

Jeremy Cripps, Drafting Manager
E-Tec Consultants

"One of the most impressive aspects of Mango has been their personal approach and their flexibility"

 "We identified a need for training due to a change in e-mail platform for our users from Microsoft Outlook to Lotus Notes.  Mango worked with us to develop a tailor-made training presentation for our user base, incorporating company and business process specific information. 

Our transition is an ongoing process and Mango have been delivering this course to users as they are transitioned to the new software over the last few months with great effect.  This user transition has been a challenging time for all involved, but one of the most impressive aspects of Mango has been their personal approach and their flexibility in incorporating our ever changing business needs."

Kevin D Chapman, Project Information Manager
FAST - Fluor SKM Iron Ore Joint Venture

"A very powerful set of tools in managing personal life and work life" 

"I have found that Karen & Natalie have been very helpful in bringing the best out of all the team members, have a great sense of the individuals involved specific methods of learning styles.

The High Performance Leadership Program has given me a very powerful set of tools both in managing my personal life and my work life. The course has a structure that has pushed me where I have needed it and pulled me where I had to grow"

Cris Flynn, Drafting Manager
E-Tec Consultants

"You have been an absolute joy to work with"

"Karen, thank you for everything. You and your team have been an absolute joy to work with, nothing was ever too much trouble. We will of course keep you in mind for any future training requirements."

Eleanor Dix, Project Automation Specialist
FAST - Fluor SKM Iron Ore Joint Venture

"It was fantastic to see the growth of the individuals in our team"

"I learned invaluable skills both personally and professionally. It was fantastic to see the growth of the individuals in our team. Mango's facilitation was excellent and professional, while being fun, all the times."

John Velios, Director
E-Tec consultants

"The best and the most effective program" 

"I've done many sales skills workshops by different companies and I can confess that Brian Tracy International is really the best and the most effective program!" 

Aleksander Moreno, Technical Sales Manager
Lefroy Valley

"Do yourself and your team a favour, work with Mango – it will enrich you personally and professionally."

"I highly recommend working with Mango team. The high calibre of the 'Mango People' ensures the highest levels of professionalism and enthusiasm are used to facilitate their top quality programs. Their exciting delivery methodology resulted in our team being fully engaged and comfortable in contributing to the knowledge sharing experience. 

On personal note, I have found that my involvement with the Mango Team has been a very positive influence in both my professional and personal life. Being provided with various tools to more effectively managew my work and home life has been an extremely rewarding experience.

Do yourself and your team a favour, work with Mango – it will enrich you personally and professionally."

Ian McCormick, Senior Civil Engineer
E-Tec Consultants

"An opportunity to gain the right tools to become a high performer" 

"This was a really refreshing approach to getting yourself in to action. One of the key indicators to any sort of training is that at the end of it, the solutions seem so simple, yet we needed this group training to put it all together. Thank you for an opportunity to gain the right tools to become a high performer."

Rodney Kalem, HR Manager
Rapallo

"Achieved clarity around what is important"

"Thanks for the course Karen and Mark. The course help me achieve clarity around what is important in my life and the need to eliminate the distractions."

Tony Monisse, Director
Brentnalls WA

"Clients now want to work with all of our staff rather than just 'the boss'"

 "It really is difficult to write a testimonial that doesn't sound like a sales pitch... How do I truly express how beneficial it has been to have Karen and the Mango Leadership team working with E-Tec??

Prior to the High Performance Program, E-Tec leaders were operating in a silo mentality which led to confused and demotivated staff.  It has always been a fun place to work, but eventually individuals want to progress and develop.  Mango Leadership has been an integral part of assisting E-Tec Consultants to realise the need to provide a culture that encourages growth, development and success. E-Tec had to improve its responsibility, and Mango taught us how. 

Karen and Nat gave us the tools and confidence to coach, mentor, performance manage, motivate and reward our team whilst working in alignment with each other. As a direct result of our various programs, conversations, emails, phone calls and chats over coffee, the team at E-Tec have increased business competency, leadership and communication skills.

In addition to this individual and personal development, we achieved the following:  

• Created and maintained a Personal Development System which focuses equally on KPI's and Professional Behaviours.
• Become masters of change and now quickly and appropriately respond to External/Economic Pressures.
•  Increased clarity when communicating across the Company to Clients.
• 25% increase in the efficiency of meetings - internal and external.
• Clients now want to work with all of our staff rather than just "the boss".
• Improved systems and procedures have increased the productivity of individuals."

Bek Polak, Executive HR Assistant
E-Tec Consultants

"I don't think we could have achieved such a fantastic result without Mango Leadership"

"We engaged Mango Leadership to help us develop a Document Management Plan. The Mango team invested the time to understand our business and created a new process for handling documents that worked for everyone. This helped both staff and management to understand the problem, and see the benefits of an implemented Document Management Plan.

With the plan agreed we continued to work with the Mango team through the implementation process and were impressed with their ability to provide workable solutions to any issues we came across, provide tailored training to groups and individuals and to adapt to the situation to address the specific "hurdles" while maintaining the focus on the overall outcome.

The result has been a reduction of over 75% of the number of electronic files stored, an increased efficiency in storing and retrieving information and less staff frustration.

I don't think we could have achieved such a fantastic result without Mango Leadership and I would (and have) recommend their services to others"

Sarah Maguire, Assistant to the General Manager,
AMC Management (WA) Pty Ltd

Microsoft Office public programs & one-on-one IT skills coaching:

“Nicely structured course. Filled in a lot of missing gaps of knowledge”

Omero Combi, Combined Painting Contractors

“Very enjoyable. Great presenter. Environment great for learning. Will recommend”

Andrea Granagan, Perth College of Beauty Therapy

“The course is well suited to those with a basic knowledge of the Microsoft Office suite who wish to improve their capabilities” 

Adrew McKenzie-Frasir, Peter Carnley Anglican Community School 

“Very informative. Great course” 

Vaughan Thomas, Crime and Corruption Commission

“I really enjoyed the "Upgrade to Microsoft Office 2007" course on Wednesday.  I found Helene to be professional, easy to understand, knowledgeable about her subject and very helpful.  The course has made it much easier to find my way around Microsoft 2007 and I hope I can remember all the things she had at her fingertips that made it so much easier to complete professional looking documents and reports.” 

Barbara Cotton, Glenrowan Consultants 

“I enjoyed the course very much. I will take away a lot of information” 

Sam Samarelli, AMC Management

“I enjoyed this course very much. The facilitator was knowledgeable and engaging. I think I may have learned something!! Highly recommended” 

Gaye Wade, Hardy Bowen

“Informative. Learnt a lot. Great presentation. Easy to understand”

Lee Casey, AMC Management

“Great to come away feeling empowered with knowledge you just can't wait to use” 

Gary Hall-Johnes, VDM Consulting

“The Excel course was excellent and Helene is an excellent educator who works through examples, answers all questions with authority and does not use the notes as rote learning. I would certainly recommend this course to other Excel users.” 

Antony James Truelove, Southern Cross Goldfields

"An excellent refresher course for anyone who is part of today's workforce or life in general"

Ravi Eyengar, Worley Parsons

"I found this to be an excellent 1/2 day course. Fun, educational and grounded in real-world activities and solutions. The presenter was friendly, approachable and I would recommend this course to anyone that would like to impove their excel skills"

Sarah Loader, Synergy Plus Operations