The Best Step By Step Microsoft Excel XP Training CD Course!
Price: $99.00
Microsoft Excel XP Training is intended for individuals seeking the fundamental and advanced skills of Microsoft Excel XP. This series will also prepare individuals who are seeking to become a Microsoft Excel Proficient Specialist and Microsoft Excel Expert Specialist.
Learn To
- Excel Basics
- Entering and Correcting Data
- Using Formulas
- Navigation and Movement Techniques
- Working with Ranges
- Working with Functions
- Editing Cell Contents
- Inserting Rows and Ranges
- Moving and Copying Data
- Absolute References
- Using the Find and Replace Diaglog Box Using Comments
- Filtering a List
- Conditional Formatting
- Custom Number Formats
- Creating and Using Styles
- Adjusting Your Cell Alignment
- Importing Data
- Consolidating Data
- Creating Scenarios
- Using the NOW and PMT Functions
- Creating and Modifying Chart Sheets and Types
- Working with Built-in and Custom Toolbars
- Using Templates
- Using Names
- Using SUMIF, IF, and VLookup Functions
- Using Auditing Features
- Summarizing Data
- Creating Pivot Tables
- Modifying Pivot Tables
- Working with Workbooks
- Linking Cells in Different Workbooks
- Sharing and Merging Workbooks
- Using Hyperlinks and Sending Workbooks
- Protecting Workbooks