MS Excel

 

 

Course Description

Microsoft Excel

 

 

Whether you've used MS Excel before and just want to learn more about Excel 2003 or are completely new to the program, this course is designed to teach you the features of MS Excel 2003 to have you using it like a pro.  

It's a fact that a lot of people just like you shy away from learning MS Excel because it seems so complicated. Those who do eventually use it only know certain aspects of the program and are not aware of all it can do. But there's good news for you! MS Excel 2003 is even easier to use that past versions with more toolbars and commands to simplify even the hardest of tasks. 

This course is designed to walk you through MS Excel 2003, showing you how to use this popular spreadsheet program to do anything from making a list to calculating complex equations in a simple and easy-to-understand manner. We promise you that even if you've never used a spreadsheet program before, you'll come away with this course with advanced knowledge and comprehension of MS Excel 2003.

 

 

Lesson 1: Introduction to MS Excel 2003

This lesson teaches how to open an excel sheet and introduces the advantages of excel 2003. It explains fields present in title bar and standard tool bar.

Lesson 2: Worksheets and Workbooks

Lesson 2: This lesson educates us on how to create and add workbooks and worksheets. It explains the ways to create, add, delete, hide, and unhide workbooks and worksheets.

Lesson 3: Entering Information into MS Excel 2003

Lesson 3: In this lesson, you will learn to enter data into the worksheet. It shows how to insert, delete, copy, and paste rows and columns. It also provides tips to use splitting and freezing panes.

Lesson 4: Formatting a Worksheet

Lesson 4: This lesson explains the features of formatting the toolbar. It details how one can change the color, size, and the font of the cell. It educates about the significance of auto formatting and the ways to apply that in the excel sheet.

Lesson 5: Adding Elements to a Workbook

Lesson 5: This lesson teaches how to insert images, auto shapes, and other graphic designs from scanner or camera to the worksheet. It provides useful tips to use these applications with examples.

Lesson 6: Charts and Diagrams

Lesson 6: This lesson describes the usage of charts and diagrams in excel sheet. It provides the methods to insert the normal charts and organizational charts with useful tips.

Lesson 7: Formulas and Calculations

Lesson 7: This lesson introduces one of the most useful features of excel sheet: formulae and calculations to minimize our work. It explains the useful methods to define formulae and calculations in excel sheet.

Lesson 8: Managing Data

Lesson 8: This lesson helps us to create worksheet with data form, another important feature of Excel, so that we can create customized error alert and warning alerts. This lesson also describes the formula auditing tool bar.

Lesson 9: Lists

Lesson 9: This lesson educates us about the special features of list command, such as auto filter, toggle, and sorting. It teaches how to create and use list command in Excel sheets.