Course Objectives
You will use the features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel power user.
Prerequisites
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
- Windows XP Professional: Level 1
- Windows XP: Introduction
Target Student
This course is designed for students who desire to gain the necessary skills to perform basic through advanced functions using Microsoft Office Excel 2010.
Certification
This course is one of a series of courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.
Hardware Requirements
For this course, you will need one computer for each student and the instructor. Each computer should have the following minimum hardware configuration:
- A 1 GHz Pentium-class processor or faster.
- A minimum of 1 GB of RAM is recommended.
- 20 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for Office 2010 installation.
- A DVD-ROM drive.
- A keyboard and mouse or other pointing device.
- A 1024 x 768 resolution SVGA monitor is recommended.
- Network cards and cabling for local network access.
- Internet access (check with your local network administrator).
- A printer (optional) or an installed printer driver.
- A projection system to display the instructor’s computer screen.
Software Requirements
Each computer requires the following software:
- Microsoft® Office Professional Plus 2010 Edition
- Microsoft® Office Suite Service Pack 1
- Microsoft® Windows® XP Professional with Service Pack 2
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a basic worksheet by using Microsoft Excel 2010.
- perform calculations in an Excel worksheet.
- modify an Excel worksheet.
- modify the appearance of data within a worksheet.
- manage Excel workbooks.
- print the content of an Excel worksheet.
- use advanced formulas.
- organize worksheet and table data using various techniques.
- create and modify charts.
- analyze data using PivotTables, Slicers, and PivotCharts.
- insert and modify graphic objects in a worksheet.
- customize and enhance workbooks and the Microsoft Office Excel environment.
- enhance productivity and efficiency by streamlining the workflow.
- collaborate with other workbook users.
- audit worksheets.
- analyze data.
- work with multiple workbooks.
- import and export data.
- manipulate data using statistical and lookup functions.
- analyze data using the data analysis tools in Microsoft Excel 2010.
- make investment decisions using the financial functions in Excel 2010.
- examine data using math functions in Excel 2010
Course duration
3 Days
Course outline
Lesson 1: Getting Started with Excel
Topic1A: Identify the Elements of the Excel Interface
Topic1B: Navigate and Select Cells in Worksheets
Topic1C: Customize the Excel Interface
Topic1D: Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
Topic2A: Create Formulas in a Worksheet
Topic2B: Insert Functions in a Worksheet
Topic2C: Reuse Formulas
Lesson 3: Modifying an Excel Worksheet
Topic3A: Edit Worksheet Data
Topic3B: Find and Replace Data
Topic3C: Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
Topic4A: Apply Font Properties
Topic4B: Align Content in a Cell
Topic4C: Apply Number Formatting
Topic4D: Apply Cell Styles
Lesson 5: Managing an Excel Workbook
Topic5A: Manage Worksheets
Topic5B: View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
Topic6A: Define the Page Layout
Topic6B: Print a Workbook
Lesson 7: Calculating Data with Advanced Formulas
Topic7A: Apply Cell and Range Names
Topic7B: Analyze Data with Logical and Lookup Functions
Lesson 8: Organizing Worksheet and Table Data
Topic8A: Create and Modify Tables
Topic8B: Sort or Filter Data
Lesson 9: Presenting Data Using Charts
Topic9A: Create a Chart
Topic9B: Create Advanced Charts
Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Topic10A: Create a PivotTable Report
Topic10B: Filter Data Using Slicers
Topic10C: Analyze Data Using PivotCharts
Lesson 11: Inserting Graphic Objects
Topic11A: Insert and Modify Pictures and ClipArt
Topic11B: Draw and Modify Shapes
Topic11C: Illustrate Workflow Using SmartArt Graphics
Lesson 12: Customizing and Enhancing the Excel Environment
Topic12A: Customize the Excel Environment
Topic12B: Customize Workbooks
Topic12C: Create and Use Templates
Lesson 13: Streamlining Workflow
Topic13A: Update Workbook Properties
Topic13B: Create a Macro
Topic13C: Edit a Macro
Topic13D: Apply Conditional Formatting
Topic13E: Add Data Validation Criteria
Lesson 14: Collaborating with Other Users
Topic14A: Protect Files
Topic14B: Share a Workbook
Topic14C: Set Revision Tracking
Topic14D: Review Tracked Revisions
Topic14E: Merge Workbooks
Topic14F: Restrict Document Access
Lesson 15: Auditing Worksheets
Topic15A: Trace Cells
Topic15B: Troubleshoot Invalid Data and Formula Errors
Topic15C: Watch and Evaluate Formulas
Topic15D: Create a Data List Outline
Lesson 16: Analyzing Data
Topic16A: Create a Trendline
Topic16B: Create Sparklines
Topic16C: Create Scenarios
Topic16D: Perform a What-If Analysis
Topic16E: Perform a Statistical Analysis with the Analysis ToolPak
Lesson 17: Working with Multiple Workbooks
Topic17A: Create a Workspace
Topic17B: Consolidate Data
Lesson 18: Importing and Exporting Data
Topic18A: Export Excel Data
Topic18B: Import a Delimited Text File
Topic18C: Import and Export XML Data
Lesson 19: Manipulating Data Using Functions
Topic19A: Forecast GDP Using Statistical Functions
Topic19B: Manipulate Data Using Text Functions
Topic19C: Validate Data Using Information Functions
Lesson 20: Analyzing Data Using Data Analysis Tools
Topic20A: Analyze Sales Data Using Descriptive Statistics
Topic20B: Analyze Time Series Data Using Exponential Smoothing
Topic20C: Analyze Data Using Regression
Topic20D: Analyze Sector Data Using Correlation and Covariance Matrices
Topic20E: Optimize a Stock Portfolio Using Solver
Lesson 21: Working with Data Using Financial Functions
Topic21A: Develop an Investment Schedule Using Financial Functions
Topic21B: Make Investment Decisions Using Financial Functions
Lesson 22: Examining Data Using Math Functions
Topic22A: Analyze Sales Data Using Math Functions
Topic22B: Calculate Stock Returns Using Math Functions
Topic22C: Aggregate GDP Data Using Math Functions
Appendix A: Creating Excel Forms
Appendix B: Commonly Used Excel Functions
Appendix C: Microsoft Office Excel 2010
Appendix D: Microsoft Office Excel 2010
|
