More Customers and Case Studies

Customers Include: Microsoft Pepsi Verio GE Boeing Xerox EDS Chevron



At a Glance
  • Total Length 7 Hours
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds

Excel 2010 Training Highlights

  • Themes, SmartArt and Charts
  • PivotTables, PivotCharts and Slicers
  • AutoFill
  • Custom Number Formats
  • AutoFilter
  • Advanced Filter
  • Automatic Subtotals
  • Scenarios
  • Advanced functions like VLOOKUP, HLOOKUP, DSUM, Concatenate and Nested IF statements

Microsoft Excel 2010 Training: Course Description

Did you know that you can actually spend less trying finding features in Microsoft Excel 2010 and more time meeting and exceeding this year’s business goals? Then, use Excel to prove to your boss that you deserve a raise. And, we can help you. That’s why we created this Microsoft Office Excel 2010 training course.

This Microsoft Office Excel 2010 training course appeals to new and experienced Excel users. Really. That’s our goal, anyway. We don’t know how many brand new Excel users are left out there, but surely there’s a few. 

 
 

Of course, you can read the outline, but here’s what you’ll get…in a nutshell

If you’re an Excel newbie, you’ll simply start with Level 1 – right at the beginning. We’ll move you quickly from creating new workbooks through hiding worksheets and adding print titles – all in the first level.

Think you already know everything there is to know about Excel?

Kudos. But, what if there were a trick or two that you hadn’t seen, yet? Would learning that trick appeal to you? We hope so. You see, if you’ve already been around the block a time or two with Excel, we think you’ll love this course because it consists of short, succinct, standalone topics. This structure means you don’t have to wade through content that you already know. You can skip directly to the topics you want to learn about.

Excel 2010 Training Topics Include:

  • AutoFill and Function AutoComplete to help you quickly populate a worksheet
  • Function anatomy to create basic and advanced formulas of all types with three different types of cell references and named ranges
  • Customize your worksheet with headers, print titles, backgrounds and custom number formats
  • Create embedded charts, chart sheets and little charts within a cell with Sparklines
  • Advanced data management techniques for working with long lists like AutoFilter, Advanced Filter, and Automatic Subtotals
  • Perform hefty data analysis with Scenarios, PivotTables, PivotCharts and Slicers
  • Protect worksheets from common data entry errors with Data Validation and Conditional Formatting

 

 

 

 

 

 

Are you still reading? Good. Because, we have something important to talk about.

Our Microsoft Office Excel 2010 training course is best enhanced when viewed with our fresh learning platform that merges the best Learning Management Systems (LMS) and knowledgebase features into a slick enterprise-wide Software as a Service (SaaS) application. 

What Does That Mean For You?
 
  • Online, 24/7 access to full Microsoft Excel 2010 Training course content that is also available as searchable, bite-sized training articles and videos that can be quickly found when needed through a handy, quick search feature.  (Training you need, when you need it)
  • Customized Microsoft Excel 2010 Training for all levels of Office users that starts with topic introduction, continues through real-world exercises to practice what you learned and wraps up with a quiz to test your recall.  (Start where you want, practice what you see, prove your new skills)
  • With almost 200 topics to choose from and 7 hours of recorded Excel 2010 Training lessons, we're pretty confident that you'll learn something new, and if not, call us; we may have a teaching job for you.  (Every Microsoft Excel 2010 Training video has a matching article)
 

KeyStone OnDemand Interface

Excel 2010 Training at a Glance:

Total Length: 7 Hours

Level: Beginner to Advanced

You Need 24X7 Excel 2010 Training Support for Common Day-to-Day QuestionsConnecting the Pieces

  • An easy way to support Excel users
  • Proactively cut costs with reduced support
  • Easily customize training for local needs

You're in the Right Place

  • Find what you need instantly by keyword
  • Beginner to Advanced topics in Video & Text
  • Interactive training includes Excercises & Quizzes

And We Know Enterprise

Whether you are suppporting a local migration or managing a global roll out, KeyStone provides complete end-to-end support!

Business Features include:

  • Migration and Roll out support packages
  • Pre and Post Assessments
  • Robust Learning and Content Management
  • Built in Helpdesk Integration
  • 24x7 Access with no hidden costs
  • Unlimited Tier 1 support for licensed users
  • Globalization & awareness campaigns including Webinars, Posters, Quick Reference Cards
  • Customize and create your own content for rapid deployment

 



Includes Learning and Content Management, Certificates of Completion, and a Complete Library of Courses.

 


 

 

     

The Complete Microsoft Excel 2010 Training Solution (because you need a plan)

We think this Microsoft Excel 2010 Training course is great, and we believe you'll think so, too.  We could go on and on about the benefits of training and how it positively impacts user productivity ultimately resulting in a net gain of getting more done in a shorter amount of time. But, you already know all of that.

What You Don't Know is What Makes Us Different.

KeyStone Learning Systems offers comprehensive training solutions for enterprise clients. What does that mean? If you're a company looking for high quality Microsoft Excel 2010 end-user training you can track and assign with the ability to customize the off-the-shelf content, we can help.

The next you get a request for Excel 2010 training, you can open your web browser, assign a user to a course and they have access... immediately. Our system tracks your users, what courses they've taken and sends that usage data right back to you.
 

Did we mention there's no software to buy or install? The news just keeps getting better. Does your organization have Internet access? Silly question, we know. But, if you have that, you can have KeyStone OnDemand.

Basically, you License It and We Stream It.

That's 24/7 access for you and your company with no hidden IT, support or other technology costs that we all know tend to add up pretty quickly. We think it's revolutionary, but we wouldnít mind hearing your opinion.

Did we mention?

  • Our trainers are MCTs with a passion for training that you'll feel from the first video
  • We offer unlimited Tier 1 support via email for licensed users
  • We provide complete training, migration and roll out support packages including Quick Reference Cards, Webinars, Posters, Pre and Post Assessments, Custom Introduction Videos (from your Management team), Awareness Campaigns, and Helpdesk Support Features.
  • Your company could be up and running with our training within 2-4 business hours (there are some time zone requirements here, but you get the idea)
  • You can add your own training content to our existing, and fabulous, off-the-shelf training

Key Learning Objectives for Microsoft Excel 2010 Training Essentials: 

This is such a big course, even bigger when you get it with the rest of the Microsoft Office 2010 training course, we can't possibly list all of the learning objectives here. For that, check out the outline. But, here are some things that we think are pretty cool.
  • Make the transition from the old menu-based system to the new ribbon to reduce the decrease in productivity many experience when making this upgrade
  • Quickly populate a new workbook with classic tools like AutoFill, AutoComplete and copy and paste
  • Work with common Microsoft Office 2010 features like Themes, SmartArt, and Charts, all inside Microsoft Office Excel 2010
  • Create and edit Excel workbooks using templates and quick navigation techniques
  • Format text with key features like the Quick Format Mini Toolbar, Format Painter and custom number formats
  • Manage large sets of data using features like AutoFilter, Automatic Subtotals and Advanced Filters using multiple sets of criteria
  • Collaborate with team members through revisions, comments and workbook sharing and security
At a Glance
  • Total Length 7 Hours
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds

Microsoft Office Excel 2010 Training Outline

 

Microsoft Excel 2010 Training: Level 1

(Get Up and Running Quickly with Microsoft Excel 2010)
 
  • 1. The Excel 2010 Interface & File Types
  • 1.1. Experience the New Excel 2010 Interface
  • 1.2. Go Backstage via the File Tab
  • 1.3. Customize the Quick Access Toolbar
  • 1.4. Customize the Ribbon
  • 1.5. Excel File Types and What They Mean to You
  • 1.6. Need Help? It’s Local & Online
 
  • 2. Create a New Workbook
  • 2.1. Create a New Workbook Based on a Template
  • 2.2. Fill in  Your Spreadsheet
  • 2.3. Get Around in a Worksheet
  • 2.4. Use AutoFill to Quickly Add Standard Lists to Your Worksheet
  • 2.5. Take Advantage of AutoComplete when Working with Long Lists of Data
  • 2.6. Undo & Redo
  • 2.7. File Recovery Options
 
  • 3. Introduction to Formulas
  • 3.1. Anatomy of a Formula
  • 3.2. AutoSum
  • 3.3. Status Bar Calculations
  • 3.4. Copying Formulas
  • 3.5. Use Cell References in a Formula
 
  • 4. Formatting Your Spreadsheet
  • 4.1. Text Editing Techniques
  • 4.2. Use Format Painter to Copy Applied Formatting
  • 4.3. Apply Number Formats
  • 4.4. Create a Custom Number Format
  • 4.5. Merge & Split Cells
  • 4.6. Rotate Text in a Cell
  • 4.7. Wrap Text in a Cell
 
  • 5. Review Your Spreadsheet
  • 5.1. AutoCorrect
  • 5.2. Use Spell Check … Please
  • 5.3. Use the Research Pane
  • 5.4. Use Find & Replace
 
  • 6. Change a Worksheet’s Layout
  • 6.1. Insert & Delete Rows and Columns
  • 6.2. Insert & Delete Cells
  • 6.3. Adjust the Width of a Column
  • 6.4. Adjust the Height of a Row
  • 6.5. Move & Copy Text
  • 6.6. Hide Columns & Rows
 
  • 7. Manage & Edit Workbooks
  • 7.1. Rename Worksheet Tabs
  • 7.2. Add New Worksheets to a Workbook
  • 7.3. Remove Worksheets from a Workbook
  • 7.4. Move & Copy Worksheet Tabs
  • 7.5. Hide Worksheets
  • 7.6. Split Your Worksheet View
  • 7.7. Freeze Rows & Columns to Anchor Data on Your Screen
 
  • 8. Excel Print Options
  • 8.1. Change Worksheet Margins
  • 8.2. Change a Worksheet’s Page Orientation to Portrait or Landscape
  • 8.3. Add Print Titles to a Worksheet
  • 8.4. Set or Clear a Worksheet’s Print Area
  • 8.5. View and Set Page Breaks on a Worksheet
  • 8.6. Add a Worksheet Header or Footer
 
  • 9. Microsoft Excel 2010 Training: Level 1 Resources
  • 9.1. Excel 2010 Level 1 Exercises 
  • 9.2. Excel 2010 Level 1 Sample Files
  • 9.3. Excel 2010 Level 1 Knowledge Checks
  • 9.4. Excel 2010 Level 1 Training KeyNotes
 

Microsoft Excel 2010 Training: Level 2

(Working with Objects, Themes and a Team in Excel 2010)

 
  • 1. Work with ClipArt, Images, Shapes, Equations and Symbols
  • 1.1. Insert ClipArt & Pictures
  • 1.2. Insert a Screenshot
  • 1.3. Insert a WordArt Object
  • 1.4. Insert a Symbol
  • 1.5. Insert an Equation
  • 1.6. Remove an Image’s Background
  • 1.7. Apply a Picture Style
  • 1.8. Apply a Picture Border
  • 1.9. Apply Picture Effects
  • 1.10. Apply a Picture Layout
  • 1.11. Work with Image Corrections, Color and Artistic Effects
  • 1.12. Create AutoShapes
 
  • 2. Work with SmartArt
  • 2.1. About SmartArt
  • 2.2. Create a SmartArt Object
  • 2.3. Edit SmartArt Text
  • 2.4. Modify the SmartArt Layout
  • 2.5. Apply a SmartArt Style
  • 2.6. Change the Colors Applied to a SmartArt Graphic
  • 2.7. Convert a SmartArt Object to Text or Shapes
 
  • 3. Work with Charts in Excel
  • 3.1. Add an Embedded Chart to an Excel Spreadsheet
  • 3.2. Add a Chart Sheet to an Excel Workbook
  • 3.3. Add a Sparkline
  • 3.4. Change the Chart Type
  • 3.5. Edit, Add, and Remove Chart Data
  • 3.6. Change a Chart’s Data Range
  • 3.7. Apply a Chart Layout
  • 3.8. Apply a Chart Style
  • 3.9. Work with Chart Labels
  • 3.10. Adjust a Chart’s Axes & Gridlines
  • 3.11. Change a Chart’s Background
  • 3.12. Add Trendlines & Error Bars to a Chart
  • 3.13. Change the Size of a Chart
 
  • 4. Work with Objects on a Spreadsheet
  • 4.1. Use the Selection Pane to Work with Objects
  • 4.2. Move & Copy Text
  • 4.3. Resize an Object
  • 4.4. Layer Objects
  • 4.5. Group & Ungroup Objects
  • 4.6. Modify Object Styles
  • 4.7. Align Objects
 
  • 5. Apply and Customize Themes & Styles in Excel
  • 5.1. About Office 2010 Themes
  • 5.2. Change a Theme’s Color, Font & Effects
  • 5.3. Create & Save a Custom Theme
  • 5.4. Apply a Background
  • 5.5. Apply a Cell Style
  • 5.6. Create a Custom Cell Style
 
  • 6. Excel Team Collaboration Options
  • 6.1. Add Comments to a Worksheet
  • 6.2. Edit & Delete Comments
  • 6.3. Comment View & Print Options
  • 6.4. Set Password Protection on a Worksheet
  • 6.5. Set Password Protection on a Workbook
  • 6.6. Enable Workbook Security
 
  • 7. Sharing Excel Files
  • 7.1. Share Workbooks
  • 7.2. Save an Excel File to the Web
  • 7.3. Import Data to Excel from Access
  • 7.4. Import Data to Excel from a Text File
  • 7.5. Manage a Workbook’s Data Connections
 
  • 8. Microsoft Excel 2010 Training: Level 2 Resources
  • 8.1. Excel 2010 Level 2 Exercises 
  • 8.2. Excel 2010 Level 2 Sample Files
  • 8.3. Excel 2010 Level 2 Knowledge Checks
  • 7.4. Excel 2010 Level 2 Training KeyNotes
 

Microsoft Excel 2010 Training: Level 3

(Advanced Data Management in Excel 2010)

 
  • 1. Tables & Data Management
  • 1.1. Table Guidelines
  • 1.2. Sort Your Worksheet in Ascending or Descending Order
  • 1.3. Create a Custom Sort Based on Multiple Criteria
  • 1.4. Convert Your List to a Table
  • 1.5. Add a Total Row to a Table
  • 1.6. Remove Duplicates from a Table
  • 1.7. Convert a Table to a List
  • 1.8. Work with Automatic Subtotals
 
  • 2. Highlight Specific Subsets of Data in a Large Worksheet
  • 2.1. Apply Built-In Conditional Formatting to Cells
  • 2.2. Add Data Bars & Color Scales to a Range of Cells
  • 2.3. Convert Your Excel Data to Icon Sets
  • 2.4. Create a Custom Conditional Format
  • 2.5. Use Expressions in a Custom Conditional Format
  • 2.6. Work with AutoFilter
  • 2.7. Find a Unique Entry Using AutoFilter’s Search Feature
  • 2.8. Create an Advanced Filter Using Single Criteria
  • 2.9. Create an Advanced Filter Using Multiple Criteria
 
  • 3. A Few Advanced Features & Functions
  • 3.1. Reference Cells in Other Worksheets in a Formula
  • 3.2. Simplify Formulas with Names
  • 3.3. Work with Names in the Name Manager
  • 3.4. Create Basic IF Functions
  • 3.5. Create a Nested IF Function
  • 3.6. Fill in a Sheet using VLOOKUP & HLOOKUP
  • 3.7. General List Totals with DSUM
  • 3.8. Combine Strings with the Concatenate Function
 
  • 4. Consolidate Data & Find Errors
  • 4.1. About Data Consolidation
  • 4.2. Data Consolidation by Rows
  • 4.3. Data Consolidation by Category
  • 4.4. About Auditing
  • 4.5. Tracing Precedents
  • 4.6. Tracing Dependents
  • 4.7. Tracing Errors
 
  • 5. Create a Template for Future Worksheets
  • 5.1. About Data Validation
  • 5.2. Validate Data Based on a Range of Numbers
  • 5.3. Validate Data Based on a List
  • 5.4. Customize the Data Validation Input Message
  • 5.5. Customize the Data Validation Error Alert
  • 5.6. Create a New Template
  • 5.7. Edit an Existing Template
 
  • 6. Work with Scenarios & the Watch Window
  • 6.1. Create Scenarios to See the Effect of Different Cell Values
  • 6.2. Edit, Display & Remove Scenarios
  • 6.3. Create a Scenario Summary Report
  • 6.4. Use the Watch Window to Keep Track of Changing Data
 
  • 7. Create Robust Analysis with PivotTables & PivotCharts 
  • 7.1. About PivotTables & PivotCharts
  • 7.2. Create a PivotTable
  • 7.3. Edit a PivotTable’s Field Settings
  • 7.4. Redefine a PivotTable’s Data Source
  • 7.5. Control a PivotTable’s Data Calculations
  • 7.6. Format a PivotTable’s Results
  • 7.7. Understand PivotTable Layout & Format Options
  • 7.8. Use a PivotTable’s Totals & Filters Options
  • 7.9. Customize a PivotTable’s Display Options
  • 7.10. PivotTable Printing & Data Options
  • 7.11. Filter Data in a PivotTable with Slicers
  • 7.12. Create a PivotChart

 

 

  • 8. Microsoft Excel 2010 Training: Level 3 Resources
  • 8.1. Excel 2010 Level 3 Exercises 
  • 8.2. Excel 2010 Level 3 Sample Files
  • 8.3. Excel 2010 Level 3 Knowledge Checks
  • 8.4. Excel 2010 Level 3 Training KeyNotes

Microsoft Excel 2010 Training Course Instructor

Instructor Photo

Deanna Reynolds

MCTS, Technical Trainer, Published Author

Deanna is an author and technical instructor residing in Bellingham, Washington. For close to 20 years, Deanna has trained students in all arenas, specializing in delivering enterprise training. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.  These days, Deanna’s technical training has extended beyond the classroom to include more than 20 courses for KeyStone Learning Systems and three published books: Excel 2010: No Problem! (Wiley), Word 2007 Pocket Book (Prentice Hall), and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).

In the Microsoft Excel 2010 Training course, Deanna will guide users of all levels to better spreadsheet productivity through a complete understanding of Excel 2010. 

Some Quick Microsoft Excel 2010 Training Tips

Excel 2010 TRAINING TIP: Add the & to the Header or footer 

Since Excel 2010 header and footer commands use the ampersand for coding, when you try to type the & sign into the header or footer, it doesn’t appear when the file is printed. To get an ampersand to print, you have to type two of them. For instance, to print Reynolds & Reynolds, you need to add it to the Header or Footer section as Deanna && Deanna. (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

EXCEL 2010 TRAINING TIP: ADD a Calculated column 

Tables are fairly intuitive. This means that when you click inside a blank cell in the first column to the right of the table and type some text, a new field, or column, is automatically added to the table range. If you add a formula over in that first blank column, Excel 2010 will automatically populate the entire list with the same relative formula, quickly creating an entire column of calculations. (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

EXCEL 2010 TRAINING TIP: convert text to columns 

Though it’s not necessarily proper database design, the data you import often contains several pieces of information in one field, or cell. For instance, if you’re keeping track of client names, some databases list the first and last name in the same cell. This makes it extremely different to sort by the last name. But, you can fix this by using Excel’s Text to Column feature to take combined information in one cell and break it apart across multiple cells.

Using a wizard similar to what you see when you import a text file, you can define the character that separates each piece of data and break your text across columns. (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

EXCEL 2010 TRAINING TIP: sumifs, countifs, & averageifs 

In 2010, Excel has several new functions including SUMIFS, COUNTIFS and AVERAGEIFS. These functions work very similarly to their singular counterparts. However, they allow you to sum, count and average based on multiple logical tests. This makes them slightly more powerful and worth the look. (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

EXCEL 2010 TRAINING TIP: move a pivottable 

In the event that you’re less than thrilled with the placement of a PivotTable, before you create a new one; consider using the Move PivotTable option in the Actions group on the ribbon’s PivotTable Tools Options contextual tab. This option opens a dialog that allows you to move the existing PivotTable to a new worksheet or to a different location on an existing worksheet in the workbook.  (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

EXCEL 2010 TRAINING TIP: paste special to work with static data 

Since PivotTables are based on source data, it makes them slightly difficult to analyze separately. But, you can copy the data in a PivotTable and using the Paste Special option, paste the dataset as plain text on a different worksheet. This way, you still have the results of the PivotTable summary, but now you can work with it as though you have typed the values in yourself. 

 (Microsoft Excel 2010 Training Tips: © KeyStone Learning Systems)

 

 

 

Other Resouces on the Web

LinkedIn's Microsoft Learning Professionals Group
This is a group for Microsoft learning and training professionals, including desktop support managers, project managers, instructional designers, learning officers and classroom trainers.

 

 

 

 

 

 

 

 

Purchase

Single User

365 Day Single User Licenses

Multi-User

Excel 2010 Multi-user Bundle

User Licenses

At a Glance
  • Total Length 7 Hours
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds