Learn Microsoft EXCEL 2016 DELUXE Training Tutorial Course Quick Reference Guide

Description: Learn Microsoft EXCEL 2016 DELUXE Training Tutorial Course Quick Reference Guide Mastering Excel Made Easy DELUXE Self-Study Training Course Product Details:Product Name: Mastering Excel Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2016 Course Length: 10 Hours Video Lessons: 199 Instruction Manuals: 1 (PDF) Practice Exam: Included FinalExam: Included Certificate of Completion: Included Quick Reference Guide: 4 Pages, Laminated, 59 Topics Product Type: DELUXELearn Excel 2016 with this Deluxe training package from TeachUcomp, Inc. Mastering Excel Made Easy Deluxe features 199 video lessons with over 10 hours of introductory through advanced instruction on both DVD-ROM to play on your PC or Mac and via online for one year (with enclosed Online Key Code) to view the course on your computer or mobile device. In addition, you’ll get our Excel Quick Reference Guide- a four-page printed, laminated guide with step-by-step instructions in the most critical functions. Pop in the DVD-ROM or launch the online version to 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 in PDF (Introductory, Intermediate, Advanced), additional images and practice exercises. This package also includes an optional practice exam with evaluative feedback, an optional final exam and a Certificate of Completion when you pass the final exam. Test your knowledge after completing the course and demonstrate your proficiency. 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. Note: A copy of the software is not included with this purchase. This is a tutorial only. Topics Covered:Getting Acquainted with Excel 1. About Excel2. The Excel Environment3. The Title Bar4. The Ribbon5. The "File" Tab and Backstage View6. Scroll Bars7. The Quick Access Toolbar8. Touch Mode9. The Formula Bar10. The Workbook Window11. The Status Bar12. The Workbook View Buttons13. The Zoom Slider14. The Mini Toolbar15. Keyboard ShortcutsFile Management 1. Creating New Workbooks2. Saving Workbooks3. Closing Workbooks4. Opening Workbooks5. Recovering Unsaved Workbooks6. Opening a Workbook in a New Window7. Arranging Open Workbook Windows8. Freeze Panes9. Split Panes10. Hiding and Unhiding Workbook Windows11.Comparing Open Workbooks12. Switching Open Workbooks13. Switching to Full Screen View14. Working With Excel File FormatsData Entry1. Selecting Cells2. Entering Text into Cells3. Entering Numbers into Cells4. AutoComplete5. Pick from Drop-Down List6. Flash Fill7. 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 CompatibilityCopying & 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 Worksheets4. Renaming Worksheets5. Coloring Worksheet Tabs6. Copying or Moving WorksheetsSetting Worksheet Layout1. Using Page Break Preview2. Using the Page Layout View3. Opening The Page Setup Dialog Box4. Page Settings5. Setting Margins6. Creating Headers and Footers7. Sheet SettingsPrinting Spreadsheets1. Previewing and Printing WorksheetsHelping Yourself1. Using Excel Help2. The Tell Me Bar- 2016 Only3. The Smart Lookup and Insights- 2016 OnlyCreating 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. Deleting 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. About Sharing Workbooks2. Simplified Workbook Sharing in Excel 20163. Traditional Workbook Sharing4. Highlighting Changes5. Reviewing Changes6. Using Comments7. 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 Worksheets 1. 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 Seek4. Forecast Sheets- 2016 OnlyTable-Related Functions1. The Hlookup and Vlookup Functions2. Using the IF, AND, and OR FunctionsSparklines1. Inserting and Deleting Sparklines2. Modifying SparklinesCreating Charts In Excel1. 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 ChartsFormatting Charts in Excel1. Formatting Chart Objects2. Inserting Objects into a Chart3. Formatting Axes4. Formatting Axis Titles5. Formatting a Chart Title6. Formatting Data Labels7. Formatting a Data Table8. Formatting Error Bars9. Formatting Gridlines10. Formatting a Legend11. Formatting Drop and High-Low Lines12. Formatting Trendlines13. Formatting Up/Down Bars14. Formatting the Chart and Plot Areas15. Naming Charts16. Applying Shape Styles17. Applying WordArt Styles18. Saving Custom Chart TemplatesData 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 PivotCharts1. 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 HeadersPowerPivot1. Starting PowerPivot2. Managing the Data Model3. Calculated Columns and Fields4. Measures5. Creating KPIs6. Creating and Managing Perspectives7. 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 Chart7. Filtering Power View Using the Filter Data8. Cross-Filtering VisualizationsSlicers and Timelines1. Inserting and Deleting Slicers2. Modifying Slicers3. Inserting and Deleting Timelines4. Modifying TimelinesSecurity Features1. Unlocking Cells2. Worksheet Protection3. Workbook Protection4. Password Protecting Excel FilesMaking Macros1. Recording Macros2. Running and Deleting Recorded Macros3. The Personal Macro WorkbookMinimum System Requirements:1 GHz Intel Pentium Processor or equivalentWindows or MAC1 GB RAM256 color SVGA capable of 1024x768 resolutionSpeakers or headphonesDVD-ROM Drive Payment Shipping Returns Contact We accept PayPal for all orders- the safest way to shop on eBay. Physical Products: We offer FREE shipping on all U.S. orders. Your order will be shipped within 1 business day of receiving payment (Monday-Friday). In the very unlikely event that your item is lost or damaged during shipment, please be sure to let us know. We will issue either a full refund or replacement. If you are not 100% satisfied with your purchase, you can return the product and get a full refund (minus any shipping costs) or exchange the product for another one. You can return a product for up to 30 days from the date you purchased it. Any physical product you return must be in the same condition you received it and in the original sealed packaging. Please use the eBay 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. Listing and template services provided by inkFrog

Price: 40 USD

Location: East Lansing, Michigan

End Time: 2024-08-11T22:36:31.000Z

Shipping Cost: 0 USD