Duration
3 days
Target Group
The Microsoft Excel 2003 course is targeted at IT Manager, IT Executive, HR Officer, HR Manager, IT Consultant, IT Assistant, Secretary, Purchasing Executive, Purchasing Officer, Training Officer, Administrator, MIS Officer, MIS Manager, and Information Technologist.
Prerequisites
Basic knowledge of Windows is required with the follow pre-requisites:
- Able to maneuver with the mouse – Point, Click, Drag and Double Click.
- Able to configure the desktop
- Able to use the Control Panel
- Able to move and re-size Application Windows
- Able to switch between task applications
Chapter 1: Getting to Know Excel
- Introducing Excel
- Working with an Exiting Data List
- Zeroing In on Data in a List
- Creating a Workbook
- Checking and Correcting Data
Chapter 2: Setting Up a Workbook
- Making Workbooks Easier to Work With
- Making Data Easier to Read
- Adding a Graphic to a Document
Chapter 3: Performing Calculations on Data
- Naming Groups of Data
- Creating Formulas to Calculate Values
- Finding and Correcting Errors in Calculations
Chapter 4: Changing Document Appearance
- Changing the Appearance of Data
- Applying an Exiting Format to Data
- Making Numbers Easier to Read
- Changing Data’s Appearance Based on Its Value
- Making Printouts Easier to Follow
- Positioning Data on a Printout
Chapter 5: Focusing on Specific Data Using Filters
- Limiting the Data That Appears on the Screen
- Performing Calculations on Filtered Data
- Defining a Valid Set of Values for a Range of Cells
Chapter 6: Combining Data from Multiple Sources
- Using a Data List as a Template for Other Lists
- Working with More Than One Set of Data
- Linking to Data in Other Workbooks
- Summarizing Multiple Sets of Data
- Grouping Multiple Data Lists
Chapter 7: Reordering and Summarizing Data
- Sorting a Data List
- Organizing Data into Levels
Chapter 8: Analyzing Alternative Data Sets
- Defining and Editing Alternative Data Sets
- Defining Multiple Alternative Data Sets
- Varying Your Data to Get a Desired Result
- Finding Optimal Solutions with Solver
- Analyzing Data with Descriptive Statistics
Chapter 9: Creating Dynamic Lists with PivotTables
- Creating Dynamic Lists with PivotTables
- Editing PivotTables
- Creating PivotTables from External Data
Chapter 10: Creating Charts
- Creating a Chart
- Customizing Chart Labels and Numbers
- Finding Trends in Your Data
- Creating a Dynamic Chart Using PivotCharts
- Creating Diagrams
Chapter 11: Printing
- Printing Data Lists
- Printing Part of a Data List
- Printing a Chart
Chapter 12: Automating Repetitive Tasks with Macros
- Introducing Macros
- Creating and Modifying Macros
- Creating a Toolbar to Hold Macros
- Running a Macro When a Workbook Is Opened
Chapter 13: Working with Other Microsoft Office Programs
- Including an Office Document in an Excel Worksheet
- Sorting and Excel Document as Part of Another Office Document
- Creating a Hyperlink
- Pasting a Chart into Another Document
Chapter 14: Working with Database Data
- Looking Up Information in a Data List
- Retrieving Data from a Database
- Summarizing List Data
Chapter 15: Publishing Information on the Web
- Saving a Workbook for the Web
- Publishing Worksheets on the Web
- Publishing a PivotTable on the Web
- Retrieving Data from the Web
- Acquiring Web Data with Smart Tags
- Working with Structured Data
- Use Professional XML Data Capabilities
Chapter 16: Collaborating with Colleagues
- Sharing a Data List
- Managing Comments
- Tracking and Managing Colleagues’ Changes
- Identifying Which Revisions to Keep
- Protecting Workbooks and Worksheets
- Authenticate Workbooks
Programme scope, delivery arrangements and suitability are confirmed during enquiry.