Microsoft Excel Part 3: Color-Coding, Logic, and More
If you know a little Excel, you know how to throw a bunch of data into a spreadsheet. But with a little knowledge, you can turn a merely functional Excel workbook into something that’s readable, interactive, and—perhaps—even beautiful! In Part 3 of our beloved four-part Excel course, you’ll find out how to:
Color-code your data automatically with Conditional Formatting
Protect your workbook from accidental changes
Check your work using Data Validation
Remove duplicate entries in a blink
Write amazing formulas with logical functions
And more!
If you attended the class live and just want to see the exercise omitted from the live class, head to this timestamp:
1:31:36
Find the example file and handout at:
https://cals.link/excel-3-files/
This is the third part of a four-part Excel course. If you'd like to register for upcoming live sessions, visit:
https://cals.org/events-classes/?trib...
This class was presented live on Zoom 11/17/2020 by CALS Digital Literacy Specialist Nathan Smith.