Back to homepage Contact us  
List of training courses View trainer's profile

Course Details

 
 
 
 
 
 
 
 
MICROSOFT® EXCEL BASICS
   
iNTRODUCTION :
 
 

Whatever organization you work in, be it a small company, government agency, a Fortune 500 corporation, or a non-profit organization, the chances are that you use Microsoft Excel (MS Excel) in your daily work. MS Excel is an application program for Microsoft Office which can be found in almost all computers today. After many revisions, MS Excel is now capable of solving many of the basic management science problems. Since it is readily available to most people, the use of spreadsheet (specifically MS Excel) has become an important tool for calculating, summarizing, reporting, analyzing and presenting data.

This 1-day intensive course provides the basic foundation to use many of the Microsoft Excel spreadsheet powerful functions and features. It will get you started and move on with speed to acquire those essential MS Excel skills. With this basic foundation in Excel, participants can then move on easily and speedily to acquire further skills such as Statistics, Statistical Quality Control, Problem Solving Skills involving QC Tools, Business Decisions Modelling, Financial Investments, and many more.

COURSE OBJECTIVES:

At the end of the course, participants will..

  • Understand the overall concept and workings of spreadsheet.
  • Understand and know how to use MS Excel software.
  • Learn how to create, edit, format, save and print multiple spreadsheet worksheets.
  • Learn all the basic MS Excel functions
  • Learn how apply MS Excel formulas
  • Learn how to construct graphs, charts and export it for reporting purposes
course contents:


Introduction:

  • Why learn MS Excel?
  • Getting started
  • Creating workbooks.
  • Modifying worksheets
  • Saving workbooks

Formatting Worksheets

  • Formating worksheets
  • Printing workbooks
  • Enhancing worksheets
  • Using multiple worksheets
  • Finding and replacing data
  • Importing and exporting data

Working With Formula

  • Entering a formula
  • Working with cell references.
  • Exploring MS Excel formulas

Charting

  • Using MS charting wizard
  • Constructing charts
  • Editing charts.
  • Using templates, styles and autoformats
  • Manipulating the screen display

Some Advanced Functions

  • Installing and enabling MS Excel Add-ins
  • Working with Advanced Functions
  • Formulas and Text
**SPECIAL NOTE ** :

1). This is an intensive hands-on course. Participants must have prior basic computer usage knowledge (i.e. using the mouse, typing, windows OS basic operations, etc) before attending this course.

2). Class setup must include making computers preloaded with MS Excel 2000 (and above) licensed software available for participants to work on.

 

who should attend:
  • ALL levels of employees
administrative details :
Duration : 1 day
Time : 9.00am - 5.00pm
Venue : In-house or public program
Language medium : English
 
 
Trainer :
Nelson Kok (please click here to see trainer's profile)
 
 
 
 
Back to Top
 
Home | Courses | Trainer Profile | Testimonials | Contact Us
Train for Personal Effectiveness and Organizational Growth
2014 MyTrainingProvider.com, All Rights Reserved.