Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Product ID: 408843EAU
 
Credit & Course Provided by:

Helpful Microsoft Excel® Uses for Savvy Paralegals

OnDemand Webinar (93 minutes)

Get comfortable utilizing Microsoft® Excel® to process and analyze data in a legal environment.Microsoft Excel® is all about managing data. Using O365 (Office 2016) desktop version, this topic will show how to manipulate that data with cell formatting, template and themes, conditional formatting, and not forgetting concatenate or not to concatenate. Learn how charts and pivot tables can help with getting that data under control. And delve into that world of functions and formulas.

Authors

Jill A. Trehearne, FatDAWGS.com

Agenda

Formatting Cells

• F4 Factor

• Paste Special

• Keyboard Shortcuts

Template or Themes

• Manipulating Themes

• Changing Your Default Settings

Manipulating Data

• Concatenate or Not Concatenate

• Groups

• Go to

• Sorting It All out

• Keyboard Shortcuts for Scrolling

• Protect Your Worksheets/Workbooks

Charts

• Bars, Pies, Histograms - Oh My

• Creating Charts

PivotTables

• How PivotTables Are Used in Data Analysis

• Creating a PivotTable

Calculate It

• Difference Between Formulas and Functions

• Formulas

• Functions

• Relative vs. Absolute

• Operators