Mastering Excel Made EasyMastering Excel Made Easy DVD-ROM Self-Study Training Course Product Name: Mastering Excel Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2013, 2010 & 2007 Course Length: 10 Hours Video Lessons: 222 Instruction Manuals: 3 (PDF) Learn Microsoft Excel 2013 and 2010 with this comprehensive course from TeachUcomp, Inc. Mastering Excel Made Easy features 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more. Whether you are completely new to Excel or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply insert the DVD-ROM into your computer to launch the easy-to-use interface, click to launch a video lesson or open one of the manuals and you’re on your way to mastering Excel. This course also includes lessons for versions prior to 2013, making an upgrade from earlier versions a breeze. Getting Acquainted with Excel 1. About Excel 2. The Excel Environment- 2013 3. The Excel Environment- 2010 4. The Excel Environment- 2007 5. The Title Bar 6. The Ribbon 7. The "File" Tab and Backstage View 8. The Microsoft Office Button- 2007 Only 9. Scroll Bars 10. The Quick Access Toolbar 11. Touch Mode 12. The Formula Bar 13. The Workbook Window 14. The Status Bar 15. The Workbook View Buttons 16. The Zoom Slider 17. The Mini Toolbar 18. Keyboard Shortcuts File Management 1. Creating New Workbooks- 2013 2. Creating New Workbooks- 2010 3. Creating New Workbooks- 2007 4. Saving Workbooks- 2013 5. Saving Workbooks- 2010 6. Saving Workbooks- 2007 7. Closing Workbooks- 2013 8. Closing Workbooks- 2010 and 2007 9. Opening Workbooks- 2013 10. Opening Workbooks- 2010 11. Opening Workbooks- 2007 12. Recovering Unsaved Workbooks 13. Using the "Window" Command Group 14. Switching to Full Screen View 15. Working With Excel File Formats Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill- 2013 Only 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility- 2013 Only Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets- 2013 Only 4. Navigating Worksheets- 2010:2007 5. Renaming Worksheets 6. Coloring Worksheet Tabs 7. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. The Page Setup Dialog Box Printing Spreadsheets 1. Previewing and Printing Worksheets- 2013:2010 2. Using Print Preview- 2007 Only 3. Printing Worksheets- 2007 Only Helping Yourself 1. Using Excel Help Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Managing Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Linked Formulas Sharing Workbooks 1. Sharing Workbooks 2. Highlighting Changes 3. Reviewing Changes 4. Using Comments 5. Compare and Merge Workbooks Auditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell Validation Outlining Worksheets 1. Using Outlines 2. Applying and Removing Outlines Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields Sorting Data 1. Sorting Data 2. Custom Sort Orders Filtering Data 1. Using AutoFilters 2. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 2013 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Printing Charts 12. Deleting Charts Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Relating Tables in a Data Model 4. Managing a Data Model PivotTables and PivotCharts- 2013 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Formatting PivotTables 7. Formatting PivotCharts 8. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PivotTables and PivotCharts- 2010:2007 1. Creating PivotTables and PivotCharts 2. Manipulating a PivotTable 3. Changing Calculated Value Fields 4. Applying PivotTable Styles 5. Creating a PivotChart 6. Setting PivotTable Options 7. Sorting and Filtering PivotTable Data PowerPivot 1. Starting PowerPivot 2. Managing the Data Model 3. Calculated Columns and Fields 4. Creating KPIs 5. Creating and Managing Perspectives 6. PowerPivot PivotTables and PivotCharts Power View 1. Starting Power View 2. Adding Report Visualizations 3. Changing the Layout of Report Visualizations 4. Using Undo and Redo in Power View 5. Formatting the Power View Sheet 6. Creating Multiples in a Chart Slicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files- 2013 5. Password Protecting Excel Files- 2010:2007 Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. The Personal Macro Workbook 1 GHz Intel Pentium Processor or equivalent Windows 8, 7, Vista, XP, Mac OS X 10.1 or later 1 GB RAM 256 color SVGA capable of 1024x768 resolution Speakers or headphones DVD-ROM Drive Which methods of payment do you accept? PayPal (preferred) or VISA/MC/AMEX/DISC. Payment is due within 3 days following the product (72 hours). After 4 days, we file an eCRATER non-paying buyder alert. Where do you ship? We ship all over the world. Please check the shipping options for each item for specifics. We ship Monday-Friday (except Holidays). Orders placed by 2 pm Eastern ship the same day. Where do you charge sales tax? Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax usyour tax exempt license at 517-333-2958. What is your Privacy Policy? We value your right to privacy. When you order products from TeachUcomp, Inc., your personal information is kept in strict confidence. We do not rent, sell