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!

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