Objective:
Participants will learn more advanced feature of Ms Excel 2007. Participants must know basis function of Ms Excel 2007 before joining this course.
Course Outline
- Creating and Using Functions
- Round a Number
- Create a Conditional Formula
- Calculate a Conditional Sum
- Look Up Information
- Perform Time Calculations
- Perform Date Calculations
- Organizing Worksheet Data
- Filter Duplicate Records
- Perform Simple Sorts and Filters
- Perform Complex Sorts
- Sort by Cell Color, Font Color, or Icon
- Perform Complex Filters
- Subtotal Sorted Data
- Count Filtered Rocrds
- Define Data as a Table
- Modify a Table Style
- Working with Pivot Tables
- Creating a Pivot Table
- Updating Pivot Table
- Modify Pivot Table
- Formatting Pivot Table
- Creating A Pivot Chart
- Sharing Your Workbook with Others
- Adding Data Validation to a Worksheet
- Create Drop Down List
- Working with Comments
- Track Changes
- Protect Your Worksheet
- Locking and Unlocking Worksheet Cells
- Adding Security Encryption to a Workbook
- Adding Password Protection to a Workbook
- Automating With Macros
- Introducing Macros
- Set Macro Security Options
- Record a Macro
- Run a Macro
- Saving a Workbook with Macros
- Opening a Worbook with Macros
- Assigning a Macro into Quick Access Toolbar
- Delete a Macro
- Useful Data Analysis Tools and Techniques
- Optimize a Result with Goal Seek
- Solve a Formula with a Data Table
- Consolidate Data
- Conditionally Format Your Worksheet
|