Get the answers to common Microsoft Excel questions. Learn tips for how to format cells, align rows and columns, calculate sums, generate series data automatically, and more.
Overview
Syllabus
Introduction
- Get fast answers to common Excel questions
- Fill in a series of data
- Quickly insert multiple rows and columns
- Insert hyperlinks
- Create and manage drop-down lists
- Summing rows
- Work with stock and geography data types
- Fill in contents with Flash Fill
- Quickly insert a total
- Extract part of a cell's contents
- Select specific rows or columns
- Find named ranges
- Change sort order
- Filter data
- Remove duplicate entries
- Convert formula values to plain numbers
- Transpose data from vertical to horizontal
- Text wrap
- Rotate and align cell data
- Copy cell formatting
- Apply international currency formats
- Apply cell styles
- Page options
- Adjust row height and column width
- Add headers and footers
- Align cells
- Add a watermark
- Conditional formatting by cell contents
- Copy and paste cell formatting
- Merge cells
- Change magnification
- Freeze and lock panel options
- Hide and unhide columns and rows
- Show and hide grouped data
- Insert and respond to comments
- Collaborate on an Excel file with others
- Highlight portions of a spreadsheet
- Draw and mark up spreadsheets
- Set document recovery options
- Encrypt a workbook with a password
- Restrict editing
- Save as other file type
- Inspect a spreadsheet
- Check for compatibility issues
- Add and reference worksheets
- Lock cells
Taught by
Jess Stratton, Nick Brazzi and Garrick Chow
