Conditional Formatting can be very useful when presenting data in a spreadsheet, or for allowing information to jump out to you easily.
In this video I go over the following uses of it:
- Formatting based on numerical value (greater than / less than / between)
- Formatting based on text contained
- Quick overview of Data Bars, Color Scales and Icon Sets
- How to use custom formula with Conditional Formatting to highlight entire row or other cells.
Make sure to download the most recent Master Workbook to follow along: excelexposure.com/workbook/
Formula Auditing and Formula Evaluation is a powerful component in Excel, and today's video lesson goes over the following topics:
- Show Formulas: How to change view to show formulas instead of cell results.
- Formula Evaluation: See how Excel views the formula as you walk your way through the calculations.
- Trace Precedents / Trace Dependents: Helps finding out where your data is coming from and/or going to.
- Watch Window: Allows for user to set certain cells into a window that can be viewed as you switched sheets.
Make sure to download the most recent Master Workbook to follow along: excelexposure.com/workbook
Today’s video lesson goes through some of the basic formatting techniques in Excel 2010:
- How to Use the Auto-Fill Drag Handle / Fill Series Options
- How to Use the Format Painter
- Freeze / Unfreeze Panes
- Sheet Formatting (Coloring Tabs / Renaming)
- Print Area Setup / Print Options
Download the latest Master Workbook to follow along with the video: excelexposure.com/workbook/
More stuff from “Formatting and Other”
Heads up: the shoutbox will be retiring soon. It’s tired of working, and can’t wait to relax. You can still send a message to the channel owner, though!
Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels.