Excel Basics

Courses

1. Preview

   Getting Started with Excel

   If you’re new to Excel, start here. This course introduces the concepts of cells, rows and columns, shows how to navigate Excel 2016 for Windows, and describes the basics of entering data and doing calculations.

   • Excel Basics
   • Microsoft Office
2. Preview

   Calculations

   The true power of Excel is its ability to perform calculations. This course explains how calculations work and introduces concepts such as formulas and relative and absolute cell references.

   • Excel Basics
   • Microsoft Office
3. Preview

   Formatting

   The formatting tools available in Excel that can make worksheets clean and easy to follow. Includes text wrapping, cell alignment, and formatting numbers and dates.

   • Excel Basics
   • Microsoft Office
4. Preview

   Copying and Moving Data

   Copying and moving data in Excel is similar to how it works in Word, but there are some differences. This course focuses on features that are particular to Excel, including inserting cells, rows and columns and moving and deleting worksheets.

   • Excel Basics
   • Microsoft Office
5. Preview

   Creating Charts

   How to create and format charts in Excel.

   • Excel Basics
   • Microsoft Office
6. Preview

   Printing

   This course covers the main things to know about printing in Excel. Includes selecting the print area, repeating rows and columns, adding headers and footers and fitting data onto a single page.

   • Excel Basics
   • Microsoft Office
7. Preview

   Using Excel and Word Together

   Sometimes it’s more efficient to use Excel and Word together than it is to use Word on its own. This course explains when and how, including when working with charts and tables.

   • Excel Basics
   • Microsoft Office
8. Preview

   Collaborating on Files

   An explanation of the tools available in Excel that make collaborating on an Excel file secure and efficient, including using comments, protecting files and hiding data.

   • Excel Basics
   • Microsoft Office
9. Preview

   Working with Large Data Sets

   Lawyers often have to deal with large sets of data when working on a litigation or transaction. This course covers the Excel features that make it easier to work with large data sets, including filtering and sorting data, freezing panes and splitting the window.

   • Excel Basics
   • Microsoft Office
10. Preview

    Functions

    Excel functions are preset formulas that make it easy to perform specific calculations. Here's a summary of some useful functions for lawyers, and a description of how functions are structured.

    • Excel Basics
    • Microsoft Office
11. Preview

    PivotTables

    A PivotTable can be useful for summarizing and analyzing large sets of data. This course describes how to create and work with PivotTables.

    • Excel Basics
    • Microsoft Office
12. Preview

    Error Messages

    A summary of common error messages in Excel and how to find and fix errors. Includes descriptions of #VALUE!, #######, #DIV/0!, #NULL!, #N/A, #NAME? and #REF!.

    • Excel Basics
    • Microsoft Office
13. Preview

    Time-Saving Tricks: Keyboard Shortcuts, Autofill and More

    Tips and tricks to help you work more efficiently in Excel.

    • Excel Basics
    • Microsoft Office