This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
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
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock