1. 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/

    # vimeo.com/41571682 Uploaded 913K Plays 0 Comments
  2. 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

    # vimeo.com/43128237 Uploaded 34.9K Plays 0 Comments
  3. 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/

    # vimeo.com/49158184 Uploaded 276K Plays 0 Comments

Formatting and Other

Excel Exposure Plus

Browse This Channel

Shout Box

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.