CUG Libraries - Video Hub: Excel

Excel Basics

• Getting Started with Excel

• Creating and Opening Workbooks

• Saving and Sharing Workbooks

Working with Cells and Sheets

• Cell Basics

• Modifying Columns, Rows, and Cells

• Formatting Cells

Formulas and Functions

• Intro to Formulas

• Creating More Complex Formulas

• Relative and Absolute Cell References

• Functions

Working with Data

• Basic Tips for Working with Data

• Freezing Panes and View Options

• Sorting Data

• Filtering Data

• Groups and Subtotals

• Tables

• Charts

• Conditional Formatting

Doing More with Excel

• Comments and Co-authoring

• Inspecting and Protecting Workbooks

• Intro to PivotTables

• Doing More with PivotTables

• What-if Analysis

• Understanding Number Formats

• Working with Multiple Worksheets

• Using Find & Replace

• Checking Spelling

• Page Layout and Printing

Microsoft Office (online)

Access Office using your usual University email address and password.

Microsoft Office (app/desktop)

Install Office apps by following the instructions in the video above.