Mastering Excel Made Easy DVD-ROM CPE EditionProduct Name: Mastering Excel Made Easy CPE EditionManufacturer: TeachUcomp, Inc.Versions Covered:2013, 2010 & 2007Course Length:10 HoursVideo Lessons:222Instruction Manuals: 3 (PDF)Includes:Practice Exam with feedback, Final Exam Submission, Certificate of CompletionLearn 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.This CPE package includes everything you need. You will receive all the video lessons, printable instruction manuals, a practice exam with answers and evaluative feedback to help you learn, your final exam submission and certificate of completion.Getting Acquainted with Excel1. About Excel2. The Excel Environment- 20133. The Excel Environment- 20104. The Excel Environment- 20075. The Title Bar6. The Ribbon7. The "File" Tab and Backstage View8. The Microsoft Office Button- 2007 Only9. Scroll Bars10. The Quick Access Toolbar11. Touch Mode12. The Formula Bar13. The Workbook Window14. The Status Bar15. The Workbook View Buttons16. The Zoom Slider17. The Mini Toolbar18. Keyboard ShortcutsFile Management 1. Creating New Workbooks- 20132. Creating New Workbooks- 20103. Creating New Workbooks- 20074. Saving Workbooks- 20135. Saving Workbooks- 20106. Saving Workbooks- 20077. Closing Workbooks- 20138. Closing Workbooks- 2010 and 20079. Opening Workbooks- 201310. Opening Workbooks- 201011. Opening Workbooks- 200712. Recovering Unsaved Workbooks13. Using the "Window" Command Group14. Switching to Full Screen View15. Working With Excel File FormatsData Entry1. Selecting Cells2. Entering Text into Cells3. Entering Numbers into Cells4. AutoComplete5. Pick from Drop-Down List6. Flash Fill- 2013 Only7. Selecting Ranges8. Ranged Data Entry9. Using AutoFillCreating Formulas1. Ranged Formula Syntax2. Simple Formula Syntax3. Writing Formulas4. Using AutoSum5. Inserting Functions6. Editing a Range7. Formula AutoCorrect8. AutoCalculate9. Function Compatibility- 2013 OnlyCopying & Pasting Formulas1. Relative References and Absolute References2. Cutting, Copying, and Pasting Data3. AutoFilling Cells4. The Undo Button5. The Redo ButtonColumns & Rows1. Selecting Columns & Rows2. Adjusting Column Width and Row Height3. Hiding and Unhiding Columns and Rows4. Inserting and Deleting Columns and RowsFormatting Worksheets1. Formatting Cells2. The Format Cells Dialog Box3. Clearing All Formatting from Cells4. Copying All Formatting from Cells to Another AreaWorksheet Tools1. Inserting and Deleting Worksheets2. Selecting Multiple Worksheets3. Navigating Worksheets- 2013 Only4. Navigating Worksheets- 2010:20075. Renaming Worksheets6. Coloring Worksheet Tabs7. Copying or Moving WorksheetsSetting Worksheet Layout1. Using Page Break Preview2. Using the Page Layout View3. The Page Setup Dialog BoxPrinting Spreadsheets1. Previewing and Printing Worksheets- 2013:20102. Using Print Preview- 2007 Only3. Printing Worksheets- 2007 OnlyHelping Yourself1. Using Excel HelpCreating 3D Formulas1. Creating 3D Formulas2. 3D Formula Syntax3. Creating 3D Range ReferencesNamed Ranges1. Naming Ranges2. Creating Names from Headings3. Moving to a Named Range4. Using Named Ranges in Formulas5. Naming 3D Ranges6. Managing Named RangesConditional Formatting and Cell Styles1. Conditional Formatting2. Finding Cells with Conditional Formatting3. Clearing Conditional Formatting4. Using Table and Cell StylesPaste Special1. Using Paste Special2. Pasting Linked FormulasSharing Workbooks1. Sharing Workbooks2. Highlighting Changes3. Reviewing Changes4. Using Comments5. Compare and Merge WorkbooksAuditing Worksheets1. Auditing Worksheets2. Tracing Precedent and Dependent Cells3. Tracing Errors4. Error Checking5. Using the Watch Window6. Cell ValidationOutlining Worksheets1. Using Outlines2. Applying and Removing OutlinesConsolidating Worksheets1. Consolidating DataTables1. Creating a Table2. Adding an Editing Records3. Inserting Records and Fields4. Deleting Records and FieldsSorting Data1. Sorting Data2. Custom Sort OrdersFiltering Data1. Using AutoFilters2. Using the Top 10 AutoFilter3. Using a Custom AutoFilter4. Creating Advanced Filters5. Applying Multiple Criteria6. Using Complex Criteria7. Copying Filter Results to a New Location8. Using Database FunctionsUsing What-If Analysis1. Using Data Tables2. Using Scenario Manager3. Using Goal SeekTable-Related Functions1. The Hlookup and Vlookup Functions2. Using the IF, AND, and OR FunctionsSparklines1. Inserting and Deleting Sparklines2. Modifying SparklinesCreating Charts In Excel 20131. Creating Charts2. Selecting Charts and Chart Elements3. Adding Chart Elements4. Moving and Resizing Charts5. Changing the Chart Type6. Changing the Data Range7. Switching Column and Row Data8. Choosing a Chart Layout9. Choosing a Chart Style10. Changing Color Schemes11. Printing Charts12. Deleting ChartsData Models1. Creating a Data Model from External Relational Data2. Creating a Data Model from Excel Tables3. Relating Tables in a Data Model4. Managing a Data ModelPivotTables and PivotCharts- 20131. Creating Recommended PivotTables2. Manually Creating a PivotTable3. Creating a PivotChart4. Manipulating a PivotTable or PivotChart5. Changing Calculated Value Fields6. Formatting PivotTables7. Formatting PivotCharts8. Setting PivotTable Options9. Sorting and Filtering Using Field HeadersPivotTables and PivotCharts- 2010:20071. Creating PivotTables and PivotCharts2. Manipulating a PivotTable3. Changing Calculated Value Fields4. Applying PivotTable Styles5. Creating a PivotChart6. Setting PivotTable Options7. Sorting and Filtering PivotTable DataPowerPivot1. Starting PowerPivot2. Managing the Data Model3. Calculated Columns and Fields4. Creating KPIs5. Creating and Managing Perspectives6. PowerPivot PivotTables and PivotChartsPower View1. Starting Power View2. Adding Report Visualizations3. Changing the Layout of Report Visualizations4. Using Undo and Redo in Power View5. Formatting the Power View Sheet6. Creating Multiples in a ChartSlicers and Timelines1. Inserting and Deleting Slicers2. Modifying Slicers3. Inserting and Deleting Timelines4. Modifying TimelinesSecurity Features1. Unlocking Cells2. Worksheet Protection3. Workbook Protection4. Password Protecting Excel Files- 20135. Password Protecting Excel Files- 2010:2007Making Macros1. Recording Macros2. Running and Deleting Recorded Macros3. The Personal Macro Workbook1 GHz Intel Pentium Processor or equivalentWindows 8, 7, Vista, XP, Mac OS X 10.1 or later1 GB RAM256 color SVGA capable of 1024x768 resolutionSpeakers or headphonesDVD-ROM DriveWhich 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 or provide your personal data to any other entity unless required by law.I have more questions. How can I contact you?Please use the eCRATER message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day. We're always happy to answer questions. We want to make your buying experience as pleasurable as possible.©TeachUcomp, Inc. All Rights Reserved.inkfrog terapeaki000000
