London ASU: 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

Access Microsoft Office here.

Maths and Statistics Support

Sigma hosts online drop-ins from Monday to Friday from 13:00 to 14:00. Click below to book your place below:

Online Drop-Ins