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
Course Objectives
This course is designed to give office workers a systematic understanding of a spreadsheet and its benefits. This program will equip participants with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment. Hand-on exercises will help to reinforce concepts and features covered.
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
:: Course EXC03SBS ::
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
:: Course EXC03SBS ::
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.