Duration
3 days
Target Group
The Microsoft Excel 2007 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
Module 1: What’s New in Excel 2007
- Becoming Familiar with the New User Interface
- Managing Larger Data Collections
- Using the New Microsoft Office File Format
- Formatting Cells and Worksheets
- Managing Data Tables More Effectively
- Creating Formulas More Easily by Using Formula AutoComplete
- Summarizing Data Using New Functions
- Creating Powerful Conditional Formats
- Creating More Attractive Charts
- Controlling Printouts More Carefully
Module 2: Setting Up a Workbook
- Creating Workbooks
- Modifying Workbooks
- Modifying Worksheets
- Customizing the Excel 2007 Program Window
Module 3: Working with Data and Data Tables
- Entering and Revising Data
- Moving Data within a Workbook
- Finding and Replacing Data
- Correcting and Expanding Upon Worksheet Data
- Defining a Table
Module 4: Performing Calculations on Data
- Naming Groups of Data
- Creating Formulas to Calculate Values
- Summarizing Data That Meets Specific Conditions
- Finding and Correcting Errors in Calculations
Module 5: Changing Document Appearance
- Formatting Cells
- Defining Styles
- Applying Workbook Themes and Table Styles
- Making Numbers Easier to Read
- Changing the Appearance of Data Based on Its Value
- Adding Images to a Document
Module 6: Focusing on Specific Data Using Filters
- Limiting Data That Appears on Your Screen
- Manipulating List Data
- Defining Valid Sets of Values for Ranges of Cells
Module 7: Reordering and Summarizing Data
- Sorting Data Lists
- Organizing Data into Levels
- Looking Up Information in a Data List
Module 8: Combining Data from Multiple Sources
- Using Data Lists as Templates for Other Lists
- Linking to Data in Other Worksheets and Workbooks
- Consolidating Multiple Sets of Data into a Single Workbook
- Grouping Multiple Sets of Data
Module 9: Analyzing Alternative Data Sets
- Defining and Editing Alternative Data Sets
- Defining Multiple Alternative Data Sets
- Varying Your Data to Get a Desired Result Using Goal Seek
- Finding Optimal Solutions with Solver
- Analyzing Data with Descriptive Statistics
Module 10: Creating Dynamic Lists with PivotTables
- Analyzing Data Dynamically with PivotTables
- Filtering, Showing and Hiding PivotTable Data
- Editing PivotTables
- Formatting PivotTables
- Creating PivotTables from External Data
Module 11: Creating Charts and Graphics
- Creating Charts
- Customizing the Appearance of Charts
- Finding Trends in Your Data
- Creating Dynamic Charts Using PivotCharts
- Creating Diagrams by Using SmartArt
Module 12: Printing
- Adding Headers and Footers to Printed Pages
- Preparing Worksheets for Printing
- Printing Data Lists
- Printing Parts of Data Lists
- Printing Charts
Module 13: Automating Repetitive Tasks with Macros
- Introducing Macros
- Creating and Modifying Macros
- Running Macros When a Button Is Clicked
- Running Macros When a Workbook Is Opened
Module 14: Working with Other Microsoft Office System Programs
- Including Microsoft Office System Documents in Excel 2007 Worksheets
- Storing Excel 2007 Documents as Parts of
- Other Microsoft Office System Documents
- Creating Hyperlinks
- Pasting Charts into Other Documents
Module 15: Collaborating with Colleagues
- Sharing Data Lists
- Managing Comments
- Tracking and Managing Colleagues’ Changes
- Protecting Workbooks and Worksheets
- Authenticating Workbooks
- Saving Workbooks for the Web
Programme scope, delivery arrangements and suitability are confirmed during enquiry.