Microsoft Excel 2002/2003 Level 1

Topics included in this 1 day course are : getting started, spreadsheet basics, file management, working with formulas, formulating your spreadsheet, printing your spreadsheet and more.

Course Outline

Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.

Objectives

• Navigate worksheets, document windows, and the application window
• Manage and manipulate Excel files
• Edit data
• Work with ranges
• Create simple formulas
• Use built-in Excel functions
• Cut, copy, and paste data
• Format column width, row height, fonts, styles, borders and shading, data type & alignment
• Print worksheets

Outline
    * Section 1 - Getting Started
          o Loading Excel 2002
          o Exiting Excel 2002
          o Understanding Application and Document Windows
          o The Standard Toolbar
          o The Formatting Toolbar
          o Manipulating Application and Document Windows
          o Minimizing and Maximising Windows
          o Moving and Sizing Windows
          o Switching Between Application and Document Windows
          o Accessing the Menu Using the Keyboard
    * Section 2 - Spreadsheet Basics
          o Understanding Spreadsheets
          o Moving Around The Worksheet
          o Freezing panes
          o Entering Data into The Spreadsheet
          o Editing Text In Cells
          o Selecting a Range of Cells
          o Clearing Cells
    * Section 3 - File Management
          o Managing Your Files
          o Creating a New Document
          o Saving Documents
          o Opening Documents
          o Closing Document Windows
          o Arranging Document Subwindows
          o Deleting Files
    * Section 4 - Working With Formulas
          o Understanding Formulas
          o Practising your Skills
          o Entering Simple Formulas
          o Using Functions - The Sum Function
          o Using Functions - The Paste Function Button
          o Using The Fill Utility
          o Practising Your Skills
    * Section 5 - Formulating Your Spreadsheet
          o Introduction to Formatting
          o Text and Number Alignment
          o Formatting Dates and Numbers
          o Changing Row Height and Column Width
          o Formatting Fonts
          o Applying Borders and Shading
          o Inserting Rows and Columns
          o Using Cut, Copy, and Paste
    * Section 6 - Printing Your Spreadsheet
          o Understanding Page Setup, Print Preview And Printing
          o Using Page Setup
          o Setting the Page Setup Options
          o Using Print Preview
          o Printing the Spreadsheet

Additional Details

Pre-Requisites

A thorough understanding of the Windows operating environment Strong mouse and keyboard ability

Certificates offered

Certificate of completion

Cancellation Policy

Should you postpone or cancel your course you must give 5 business days notice.

Map & Reviews

On Track Computer Training
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Great instructor - made it so much easier to get through a whole day staring at a computer!

Reviewed by Laurenne S. 2012

   

There wasnt enough taught in the course. I didnt find it went into enough detail and the handout is terribly written. The instructor was okay but he focused too much on how "Not to do something" then how to just do it correctly, on certain course material which confused people. I think less breaks, more days added so we can learn more about what MS project has to offer.

Reviewed by Emma S. 2012

   

One of the best training that I have ever emcountered.

Reviewed by Cenk O. 2011

   

The course was great and helped me learn a lot of skills using Excel for work. The instructor was really nice and knowledgable. Although my only complaint and concern is that the course was really rushed and i feel like some people wouldnt be able to keep up with the training.

Reviewed by Amanda C. 2011

   

I'd like to see a course at this level that is more in depth. More practice excercises, over a longer period of time. I was pleased the instructor made himself available to students even after the course was complete (gave us his email if we had any follow up questions).

Reviewed by Charity . 2011

   

Alan has a done an exceptional job. He is very knowledgeable and goes out of his way to explain everything in details. He is very patient and answers all my questions. He is an awesome teacher!

Reviewed by Peter C. 2011

   

I did note body odour of presenter was strong. Only critisism I have. Everything else was excellent.

Reviewed by Richard V. 2011

   

Alan was an excellent instructor!

Reviewed by Jami S. 2011

   

Excellent Excel 2 course, Alan is a very good instructor. I would take additional courses.

Reviewed by Rosmary C. 2011

   

I wondered why Access 2003 instead of 2010. I should have checked that before I took it. Anyway the course was great and I learned a lot and the Instructor was so nice and kind, I enjoyed his class.

Reviewed by Alma L. 2011

   

Haven't really looked over the course book much as I made lots of notes. Only comment re: technlogy was I had no internet connection which was a bit of a hassle during the lunch break as I wanted to check my email and my company website and had to use another desk.

Reviewed by Sheree G. 2011