Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 

Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!

PlanComparison

Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!

Microsoft Excel 2010 Training


Course Highlights

  • Quickly find old features within the results-oriented user interface and Ribbon.
  • Learn to write advanced formulas and use functions such as IF, HLOOKUP and DSUM.
  • Collaborate with team members using Excel’s comments, security and data validation options.
  • Save time with Excel’s table and list management features, including AutoFilter and Automatic Subtotals.
  • Create and use interactive PivotTables to summarize and retrieve sets of data on the fly.

About This Course

This Microsoft Office Excel 2010 Essentials Training Course contains three levels of instruction to walk you through performing many time-saving tasks in Excel, beginning with an introduction to the new results-oriented interface. The course topics appeal to all Excel users – beginner through advanced. You will learn everything from creating professional-looking charts to sharing data with enhanced security and managing your spreadsheets more effectively.

In this course, you’ll learn from a combination of quick tips and detailed instruction on using Excel for team collaboration and creating templates to work smarter, not harder. You will learn how to create professional-looking spreadsheets through modifying the worksheet layout and formatting.

And, of course, you will learn about harnessing the power of Excel formulas with an entire section devoted to the anatomy of formula. To really understand formulas, there are additional lessons on advanced functions (such as Nested IF Statements, HLOOKUP, VLOOKUP and DSUM) and data consolidation using three dimensional formulas, position and category.

There are over 100 lessons in this Excel course – all designed to increase your productivity.

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


 



Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
Visio
2003 / 2007
OneNote
2003 / 2007
Project
2003 | 2007
Sharepoint
3.0
Access
2010 | 2007
Excel
2010 | 2007
Outlook
2010 | 2007
PowerPoint
2010 | 2007
Word
2010 | 2007
Office for Mac
2008
Excel for Mac
2008
Entourage for Mac
2008
PowerPoint for Mac
2008
Word for Mac
2008

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003


Typing Speed Test
Test your typing speed with our certified typing speed test today.



  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2011 National Computer Science Academy, All Rights Reserved.