Whether you are new to Microsoft Excel, need to brush up your skills, or just want to see what's new in the 2003 edition, this tutorial is for you. In this course, you will learn to: build and navigate spreadsheets, work with formulas, format cells and contents, apply styles and templates, set up pages for printing, organize workbooks, and more. Microsoft Excel's most critical features are taught in a simulated environment and reinforced through performance-based practices and testing. Enhance your performance on the job, in the classroom, or at home by brushing up on your Microsoft Excel 2003 fundamental skills. This course has received Microsoft Office Specialist certification. Use the Fundamentals, Intermediate, and Advanced courses to prepare for the Excel Specialist and Excel Expert exams.

This course will enable you to organize, manage, format, and customize data in a worksheet. In this course, you will learn to organize and manage data in a worksheet using ranges, filters, automated tools, and functions. You will also learn to audit and review data. In addition, you will learn to format worksheet components and customize Excel workbooks.

In this course, you will learn to import and export data, structure workbooks using XML, and protect workbooks, worksheets, and cells. You will also learn to apply data validation criteria, conditional formatting, and custom number formats to cells. You will learn to use the Lookup, Reference, and Database functions, the research tool, advanced filters, and macros. You will also learn to create PivotTables and PivotChart reports, share and merge workbooks, manage formulas and scenarios, and modify Excel default settings.

Excel is a powerful software application that can be used to organize and present your data in a clear, concise manner. In this course, you will learn how to perform basic data analysis, use formulas and functions, and modify worksheets. Finally, we'll cover different options for printing your data, and learn how to post Excel documents on the web.

In this course, you'll learn techniques for increasing your proficiency in using Excel for more complicated operations. You'll learn to add and select a named range, name a single cell, use column and row labels, insert a row, use a named range in a formula, delete a named range, revise a formula, and list named ranges in a workbook. This course will introduce you to templates, teach you how to manage workbooks and folders, plus review workspaces, customize toolbars and menus, and format dates. You will also work with data and lists.

Increase your skills for working with functions and formulas, record and edit macros, assign macros to toolbar buttons and worksheet objects. You will also create charts and graphics.