To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.
In Microsoft Office Excel: Introduction, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.
Prerequisites: Before starting this course, students are recommended to take the following or possess equivalent knowledge: Microsoft Office Excel: Introduction.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
Course Content
Lesson 1: Calculating Data with Advanced Formulas
Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
Topic 4A: Create a PivotTable Report
Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates
Course Description
Your training in and use of Microsoft® Office Excel® has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Excel. You have used Microsoft® Office Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
· increase productivity and improve efficiency by streamlining your workflow.
· collaborate with others using workbooks.
· audit worksheets.
· analyze data.
· work with multiple workbooks.
· import and export data.
· use Excel with the web.
· structure workbooks with XML.
Course Content
Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Topic 2H: Restrict Document Access
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Troubleshoot Errors in Formulas
Topic 3D: Troubleshoot Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Create a Data List Outline
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Word Table
Topic 6C: Import a Delimited Text File
Lesson 7: Using Excel with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query
Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Topic 8C: Manage XML Workbooks
Appendix A: Microsoft Office Specialist Program