Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
How to Make Beautifully Formatted Excel Spreadsheets Very Quickly
Welcome to the course
Welcome to the course (1:51)
Downloadable files
Downloadable Course Spreadsheet
Basic Formatting
Format painter, quick access toolbar, font, font size (2:29)
Bold, italics, underline, borders, clear formats (2:52)
Fill, color, alignment, fill series (2:23)
Merge cells, wordwrap (1:51)
Formatting as currency and percentages (1:36)
Advanced Formatting
Conditional formatting, highlight, data bars, color scales (3:54)
Format as table (2:29)
Style, format dropdown (3:03)
Strikethrough, superscript (1:37)
Gridlines - how to remove them, add them back and print out with them (3:03)
Working with dates
Formatting dates (5:29)
How to sort and calculate with dates (2:18)
Conditional formatting, highlight, data bars, color scales
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock