Learn Microsoft EXCEL FOR LAWYERS 2016 2013 Training Tutorial DVD-ROM Course

Description: Learn Microsoft EXCEL FOR LAWYERS 2016 2013 Training Tutorial DVD-ROM Course Mastering Excel Made Easy for Lawyers Digital Self-Study Training Course Normal 0 false false false EN-US X-NONE X-NONE DVD-ROM and Digital Course. We grant you fast access while your DVD-ROM is shipped. Within one business day following purchase, you will receive a message from us through the eBay messaging system that contains your login credentials and instructions to download your course from our site. The course downloads to your PC or Mac and is yours to keep. You will also receive one year online access to the course that you can view from any computer or mobile device with an internet connection. We will then ship a hard copy of your DVD-ROM to your confirmed eBay shipping address. Product Details:Product Name: Mastering Excel for Lawyers Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2016 & 2013 Course Length: 12 Hours Video Lessons: 212 Instruction Manuals: 1 (PDF) Product Type: DVD-ROM, Download & Online AccessLearn Microsoft Excel 2016 and 2013 with this comprehensive course from TeachUcomp, Inc. This Excel training course includes a training module specific to the practice of law. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. In addition, you’ll receive our complete Excel curriculum. Mastering Excel Made Easy features 212 video lessons with over 12 hours of introductory through advanced instruction for versions 2016 and 2013. 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 printable classroom instruction manual (Introductory through Advanced), additional images and practice exercises. 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 launch the easy-to-use interface, click to start a video lesson or open the manual and you are on your way to mastering Excel. Topics Covered:LEGAL CURRICULUM:Legal Templates1. Chapter Overview 2. Using the Law Firm Financial Analysis Worksheet 3. Using the Law Firm Project Tracker4. Using the Law Firm Project Plan Legal Business Functions 1. The Pv Function2. The Fv Function3. The IRR and XIRR FunctionsSimple IOLTA Management1. IOLTA Basics 2. Using Excel for Simple IOLTA Management 3. Using the Simple IOLTA Template BONUS COMPLETE EXCEL CURRICULUM: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 Workbook Minimum System Requirements:1 GHz Intel Pentium Processor or equivalentWindows or MACDVD-ROM DriveHigh-Speed Internet Connection256 color SVGA capable of 1024x768 resolutionSpeakers or headphones 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: 25 USD

Location: East Lansing, Michigan

End Time: 2024-03-10T20:46:01.000Z

Shipping Cost: 0 USD