Microsoft Office Excel Basic to Advanced Training

By: BE Logistics Training  13-Mar-2012
Keywords: Training, Computer Training, Computer Education

EXCEL Basics

 

This one day course introduces the student to the basic aspects of correctly creating and using spreadsheets and charts through the use of Microsoft EXCEL – 2007.

 

Areas covered during the course include:

  • * Selecting and preparing resources
  • * Creating simple spreadsheets

    * Formatting

    * Using software functions

  • * Formulae

* Producing simple charts

  • * Identify chart types
  • * Data range
  • * Modifying chart type and layout
  • * Finalising spreadsheets

    * Previewing

    * Adjustments

    * Printing

  • * Saving

 

The student will gain the knowledge in formatting of workplace documents and the purpose and range of use of spreadsheet functions.

 

 

EXCEL Advanced

This one day course introduces the student to the advanced aspects of using Microsoft EXCEL – 2007 to complete business tasks to produce complex documents.

 

Areas covered during the course include:

  • * Preparing to develop spreadsheet
  • * Development of a linked spreadsheet solution

    * Functions

  • * Formulae

* Automation and standardising spreadsheet operations

  • * Macro
  • * Templates
  • * Using spreadsheets

    * Import and Export data

    * Previewing

    * Printing

  • * Storing

* Representing numerical data in graphic form

* Graphs

 

The student will gain knowledge in the advanced functions of EXCEL and the impact of formatting and design and presentation and readability of data.

 

For more information visit our website.

Keywords: Assessment, Computer Education, Computer Training, Excel 2007 Training, Excel 2010 Training, Excel Training, Microsoft Excel Advanced, Microsoft Excel Basic, Microsoft Excel Course, Microsoft Excel Training, Training,

Other products and services from BE Logistics Training

12-Mar-2012

Microsoft Office Word Basic to Advanced Training

WORD Basics   This one day course introduces the student to the basic aspects of designing and developing predominately


12-Mar-2012

Dangerous Goods Driver Licensing (bulk) Course

Accredited Course – The Transport of Dangerous Goods by Road (30744QLD) The Transport of Dangerous Goods by Road (30744QLD)


12-Mar-2012

Fatigue Management Training

A number of social and environmental trends have emerged in recent years which continue to impact on the industry. These


12-Mar-2012

Load Restraint Familiarisation Training

This course is designed to provide the student with the skills and knowledge required to Load and Unload Goods/Cargo


12-Mar-2012

Dangerous Goods Familiarisation Training

This course is designed to provide the student with the skills and knowledge required to prepare and transport Dangerous Goods