A Complete Beginner’s Guide to Excel for Lawyers
Unlock the Power of Microsoft Excel for Lawyers with Our Comprehensive Tutorial!
What you’ll learn
- Create both basic and advanced spreadsheets.
- Create complex formulas.
- Chart and graph data.
- Create PivotTables and PivotCharts.
- Audit worksheets.
- Manage security features.
- Learn How to Use Legal Templates.
- Discover Legal Functions in Excel.
- Learn Simple IOLTA Management.
- Much more!.
Course Content
- Course Introduction –> 1 lecture • 1min.
- Getting Acquainted with Excel –> 15 lectures • 26min.
- File Management –> 15 lectures • 30min.
- Data Entry –> 9 lectures • 20min.
- Creating Formulas –> 9 lectures • 17min.
- Copying and Pasting Formulas –> 5 lectures • 9min.
- Columns and Rows –> 4 lectures • 11min.
- Formatting Worksheets –> 4 lectures • 10min.
- Worksheet Tools –> 6 lectures • 8min.
- Setting Worksheet Layout –> 7 lectures • 11min.
- Printing Worksheets –> 1 lecture • 4min.
- Helping Yourself –> 3 lectures • 7min.
- 3D Formulas –> 3 lectures • 3min.
- Named Ranges –> 6 lectures • 8min.
- Conditional Formatting and Cell Styles –> 4 lectures • 8min.
- Paste Special –> 2 lectures • 8min.
- Sharing Workbooks –> 8 lectures • 38min.
- Auditing Worksheets –> 6 lectures • 17min.
- Outlining Worksheets –> 3 lectures • 6min.
- Consolidating Worksheets –> 1 lecture • 6min.
- Tables –> 4 lectures • 8min.
- Sorting Data –> 2 lectures • 6min.
- Filtering Data –> 8 lectures • 20min.
- What-If Analysis and Forecasts –> 4 lectures • 17min.
- Table-Related Functions –> 3 lectures • 12min.
- Sparklines –> 2 lectures • 7min.
- Creating Charts in Excel –> 12 lectures • 28min.
- Formatting Charts in Excel –> 18 lectures • 36min.
- Data Models –> 5 lectures • 22min.
- PivotTables and PivotCharts –> 9 lectures • 37min.
- Power Pivot –> 7 lectures • 22min.
- Maps –> 15 lectures • 50min.
- Slicers and Timelines –> 4 lectures • 8min.
- Security Features –> 4 lectures • 10min.
- Making Macros –> 3 lectures • 8min.
- Using Online Templates –> 3 lectures • 5min.
- Legal Templates –> 4 lectures • 11min.
- Legal Business Functions –> 3 lectures • 10min.
- Simple IOLTA Management –> 3 lectures • 6min.
- Course Conclusion and Instructon Manual in PDF –> 1 lecture • 1min.
Requirements
Unlock the Power of Microsoft Excel for Lawyers with Our Comprehensive Tutorial!
Discover the world of Excel for Microsoft 365 like never before with “Mastering Excel Made Easy for Lawyers,” your go-to learning resource from TeachUcomp, Inc.
What Awaits You:
- 224 in-depth video lessons
- Over 9.5 hours of comprehensive instruction
- Suitable for beginners to advanced users
Our experienced instructor will be your guide as you embark on a step-by-step journey through each chapter and lesson. Learn effortlessly by watching and listening, as if your instructor is right there beside you.
Your Learning Arsenal:
- A detailed, 363-page printable classroom instruction manual
- Loaded with additional images and practice exercises for hands-on learning
When it comes to Microsoft Office programs, law firms have unique needs. This Excel for lawyers tutorial course includes our entire Excel curriculum plus training modules 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. Uncover the art of creating and formatting spreadsheets, crafting stunning charts, and mastering pivot tables, and much more. Each Excel function and feature comes to life during this media-rich learning experience.
The TeachUcomp Advantage:
- Built on years of classroom training experience and teaching expertise
- Crafted for ease of use and understanding
- Tailorable to your unique learning preferences
Whether you’re a complete Excel novice or making the leap from an older version, our Excel tutorial equips you with the knowledge and skills to become a proficient user. It’s like having a personal Excel mentor at your disposal.
Ready to Excel:
With just a click, your journey to Excel mastery begins. Dive into our complete Excel tutorial or explore the manual, and you’ll be well on your way to becoming an Excel pro!
Experience the convenience of learning and unleash your Excel potential – enroll in “Mastering Excel Made Easy for Lawyers” today!