Description
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.
Date: 2021-07-30 Start Time: End Time:
Learning Objectives
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
NALA ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Jill A. Trehearne-FatDAWGS.com
