Excel 365 Essentials:

UP and Running

Time: 1.5 Hours

Course Description:

Excel is the industry-standard spreadsheet program, and almost all of us find ourselves using this app at law firms at one point or another. In this class, you will learn the fundamental skills you need to work with Excel, starting with the basics like entering and formatting numbers and text, then moving on to creating a formula using Excel's built-in functions.

Course Material:

A customized step-by-step Quick Reference Card with screenshots is included in this class which covers each topic you will learn.

Course Outline:

  • Create a new workbook

  • Create a New Worksheet

  • To Move a Worksheet

  • To Copy a Worksheet

  • Rename a Worksheet

  • Move or copy entire cells

  • Insert moved or copied cells between existing cells

  • Use the fill handle to fill data

  • Fill in a series of numbers, dates, or other built-in series items

  • Number formatting

  • Copy Cell Width Settings

  • Copy Cell Values, Cell Formats, or Formulas Only

  • Insert rows on a worksheet

  • Insert columns on a worksheet

  • Creating Simple Formulas

  • Use AutoSum to Sum Numbers

  • Copy a Formula to Adjacent Cells

  • Using Quick Analysis to Insert Formulas

  • Find and Replace

  • Finding Text or Numbers

  • Replace