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

Description: Learn Microsoft EXCEL FOR LAWYERS 2013 2010 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: 2013 & 2010 Course Length: 12 Hours Video Lessons: 235 Instruction Manuals: 1 (PDF) Product Type: DVD-ROM, Download & Online AccessLearn Microsoft Excel 2013 and 2010 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 235 video lessons with over 12 hours of introductory through advanced instruction for versions 2013-2007. 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 Templates 1. Chapter Overview 2. Using the Law Firm Financial Analysis Worksheet 3. Using the Law Firm Project Tracker 4. Using the Law Firm Project Plan Legal Business Functions 1. The Pv Function 2. The Fv Function 3. The IRR and XIRR Functions Simple IOLTA Management 1. 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 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 ShortcutsFile 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 FormatsData 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 AutoFillCreating 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 OnlyCopying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo ButtonColumns & 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 RowsFormatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another AreaWorksheet 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 WorksheetsSetting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. The Page Setup Dialog BoxPrinting Spreadsheets 1. Previewing and Printing Worksheets- 2013:2010 2. Using Print Preview- 2007 Only 3. Printing Worksheets- 2007 OnlyHelping Yourself 1. Using Excel HelpCreating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range ReferencesNamed 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 RangesConditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell StylesPaste Special 1. Using Paste Special 2. Pasting Linked FormulasSharing Workbooks 1. Sharing Workbooks 2. Highlighting Changes 3. Reviewing Changes 4. Using Comments 5. Compare and Merge WorkbooksAuditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell ValidationOutlining Worksheets 1. Using Outlines 2. Applying and Removing OutlinesConsolidating Worksheets 1. Consolidating DataTables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and FieldsSorting Data 1. Sorting Data 2. Custom Sort OrdersFiltering 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 FunctionsUsing What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal SeekTable-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR FunctionsSparklines 1. Inserting and Deleting Sparklines 2. Modifying SparklinesCreating 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 ChartsCreating Charts in Excel 2010 & 2007 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Moving and Resizing Charts 4. Changing the Chart Type 5. Changing the Date Range 6. Switching Column and Row Data 7. Choosing a Chart Layout 8. Choosing a Chart Style 9. Printing Charts 10. Deleting ChartsFormatting Charts in Excel 2013 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axes 4. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting Gridlines 10. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Trendlines 13. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Naming Charts 16. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart TemplatesFormatting Charts in Excel 2010 & 2007 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Changing Chart Labels 4. Changing Axes Display 5. Changing the Chart Background 6. Applying Chart Analysis Lines 7. Naming Charts 8. Applying Shape Styles to Chart Elements 9. Applying WordArt Styles to Chart Elements 10. Saving Custom Chart TemplatesData 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 ModelPivotTables 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 HeadersPivotTables 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 DataPowerPivot 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 PivotChartsPower 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 ChartSlicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying TimelinesSecurity Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files- 2013 5. Password Protecting Excel Files- 2010:2007Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. 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-08-28T06:40:28.000Z

Shipping Cost: 0 USD