Get quick, bite-sized answers that tell you exactly what you want to know about working with Microsoft Excel.
Overview
Syllabus
Introduction
- Get answers to common Excel questions
- Fill in a series of data
- Quickly insert multiple rows and columns
- Insert links
- Create and manage dropdown lists
- Summing rows
- 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
- 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 panes
- Hide and unhide columns and rows
- Show and hide grouped data
- Insert and respond to comments
- Collaborate on an Excel file
- Highlight portions of a spreadsheet
- Draw and mark up spreadsheets
- Encrypt a workbook with a password
- Restrict editing
- Save as PDF or CSV
- Inspect a spreadsheet
- Check for compatibility issues
- Add and reference worksheets
- Lock cells
Taught by
Dennis Taylor
