Description
Duration: 1 day
Microsoft Office Excel 2010 contains powerful tools to help you analyze, manage, and share critical business data. You can also work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create Pivot Tables and Pivot Charts, incorporate multiple data sources, and import/export data.
This one-day course prepares you for Exam 77-882
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/25/2023 | 12/25/2023 | ||||
| 1/15/2024 | 1/15/2024 | ||||
| 2/5/2024 | 2/5/2024 | ||||
| 2/26/2024 | 2/26/2024 | ||||
| 3/18/2024 | 3/18/2024 | ||||
| 4/8/2024 | 4/8/2024 | ||||
| 4/29/2024 | 4/29/2024 | ||||
| 5/20/2024 | 5/20/2024 | ||||
| 6/10/2024 | 6/10/2024 | ||||
| 7/1/2024 | 7/1/2024 | ||||
| 7/22/2024 | 7/22/2024 | ||||
| 8/12/2024 | 8/12/2024 | ||||
| 9/2/2024 | 9/2/2024 | ||||
| 9/23/2024 | 9/23/2024 | ||||
| 10/14/2024 | 10/14/2024 | ||||
| 11/4/2024 | 11/4/2024 | ||||
| 11/25/2024 | 11/25/2024 | ||||
| 12/16/2024 | 12/16/2024 | ||||
| 1/6/2025 | 1/6/2025 |
Curriculum
Lesson 1: Getting Started with Excel
Identify the Elements of the Excel Interface
Navigate and Select Cells in Worksheets
Customize the Excel Interface
Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas
Lesson 3: Modifying an Excel Worksheet
Edit Worksheet Data
Find and Replace Data
Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
Apply Font Properties
Add Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles
Lesson 5: Managing an Excel Workbook
Manage Worksheets
View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
Define the Page Layout
Print a Workbook
Lesson 7: Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
Lesson 8: Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data
Lesson 9: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts
Lesson 11: Inserting Graphics Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Lesson 12: Customizing and Enhancing the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
Lesson 13: Streamlining Workflow
Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 14: Collaborating with Other Users
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
Lesson 15: Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 16: Analyzing Data
Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPack
Lesson 17: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Lesson 18: Importing and Exporting Data
Export Excel Data
Import a Delimited Text File
Lesson 19: Integrating Excel Data with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Lesson 20: Structuring Workbooks with XML
Develop XML Maps
Import and Export XML Data
