Free Online Interactive Courses and Skills Training for the Workplace

Share |

Proceed to Microsoft Office Excel 2003 Training >>>





	Microsoft Excel 2003 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets.


	Course information
	(Unavailable)
	Screenshots
	(Preview the course interface)
	Manage a group of learners
	(Create an ALISON Manager virtual classroom)
	Developer: Advance Learning


	Are you ready to start your course? Click the START button!

This course is free to access for individual study.

Microsoft Excel 2003

Documentation is also available for Excel 2007 Working with Excel * Getting Started with Excel * The Office 2003 Environment * Pointer Shapes * Worksheet Terms * Formatting Your Worksheets * Editing Cell Contents * Calculating with Functions * Working with Rows and Columns * Importing an External Data File Printing with Excel * Printing Basics * Using Printing Options * About the Page Setup Dialog Box ( bullet arrow Windows, bullet arrow Macintosh) * Customizing Page Layout * Modifying Header and Footer Information * Other Printing Options * Using Print Preview Special Features * Working with Comments * Using the Fill Command * Using the Paste Special Feature * Using the Find and Replace Features * Hiding Columns, Rows, and Cells * Splitting Cell Data Working with the Database Feature * Database Basics * Establishing Criteria * Filtering Your Database * Using the Sort Command * Analyzing Your Database with Functions * Working with Range Names * Calculating Subtotals in Databases Managing Your Excel Worksheet * Organizing Worksheets * Working with Groups of Worksheets * Working with Range Names * Navigating Through Your Large Workbook * Performing Calculations in Your Workbook * Correcting Circular References * Protecting Your Worksheet Charting with Excel * About Charting * Guidelines for Charting * Getting Ready to Chart * Creating a Basic Chart * Formatting Your Chart * Working with Chart Elements * Creating Exploding Pie Charts * Charting Extras Favorite Excel Functions * Rank * Countif and Sumif * Concatenate * Subtotal * Inserting Dates and Times Automating Excel with Macros Excel Gradebook * Phase 1: Capturing Student Names * Phase 2: Cleaning Up the Data for Use * Phase 3: Entering the Grades * Phase 4: Calculating Subtotals & Percentages * Phase 5: Assigning Grades * Phase 6: Submitting Electronic Grades * Transferring Data into Other Gradebook Software * Other Helpful Calculations * Creating a Weighted Gradebook * Printing Tips * Adding and Deleting Rows or Columns * Additional Tips Inserting Clip Art * Overview of Clip Art * Using Clip Art * Importing Clip Art from the Web * Importing Clip Art from the Office 2003 Server Using Microsoft Office Help

Proceed to Microsoft Office Excel 2003 Training >>>

	PUBLISHER: Advance Learning
More courses from this publisher

Advertising Policy

免费在线课程
Courses
Education
Online Schools
Computer Training
Pages and Resources
What are you looking for?
ALISON Online Store
Classes
Provide General Feedback
Feedback on Advertising