Start learning with our library of video tutorials taught by experts. Get started

Excel 2010: Advanced Formatting Techniques
Illustration by Neil Webb

Excel 2010: Advanced Formatting Techniques

with Dennis Taylor

Video: Welcome

Hi! I am Dennis Taylor and I am pleased to present Excel 2010: Advanced Formatting Techniques. When you're working with Excel, there is no question that appearances count. A dull lifeless display won't get the attention it deserves. You need to know the scope of Excel's formatting features and the quickest and best ways to get to them. In this course, I'll show you those features that enhance the appearance of worksheets, giving them wide visual appeal, as well as making them clearer and easier to understand.
Expand all | Collapse all
  1. 1m 16s
    1. Welcome
      49s
    2. Using the exercise files
      27s
  2. 33m 29s
    1. Working with the numeric formatting options
      8m 10s
    2. Learning the important formatting keystroke shortcuts
      6m 50s
    3. Setting special formats for dates, times, phone numbers, fractions, etc.
      6m 30s
    4. Building custom numeric formats
      6m 41s
    5. Building custom date formats
      5m 18s
  3. 16m 0s
    1. Applying and adjusting fonts and font colors
      3m 26s
    2. Adding custom formats with font color variations
      2m 24s
    3. Applying underline, strikethrough, subscript, and superscript formatting
      2m 59s
    4. Applying border styles and adjusting gridlines
      4m 27s
    5. Using fill color and patterns for cell backgrounds
      2m 44s
  4. 17m 30s
    1. Adjusting horizontal and vertical cell alignment
      4m 3s
    2. Creating angled text variations for greater variety and readability
      3m 15s
    3. Indenting data and dollar signs
      2m 34s
    4. Simplifying title adjustments with the versatile Merge and Center commands
      3m 16s
    5. Controlling titles and headings with the Wrap Text and Shrink to Fit options
      4m 22s
  5. 15m 24s
    1. Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar
      2m 42s
    2. Applying different formatting styles within the same cell
      2m 48s
    3. Copying formats quickly with dragging techniques and the Format Painter
      4m 20s
    4. Formatting text from Word or the web with the Justify feature
      3m 42s
    5. Adding a background image to a worksheet
      1m 52s
  6. 14m 13s
    1. Adjusting single and multiple row heights and column widths without commands
      4m 12s
    2. Working with rows, columns, and sheets
      5m 24s
    3. Working with the Hide/Unhide options
      4m 37s
  7. 9m 25s
    1. Setting up data for outlining
      5m 48s
    2. Using outlining symbols and levels
      3m 37s
  8. 36m 22s
    1. Converting data into a table and reformatting it
      6m 17s
    2. Using styles and themes for consistent formatting
      7m 6s
    3. Understanding the options in shape formatting
      4m 56s
    4. Fine-tuning shape effects
      7m 32s
    5. Learning the WordArt essentials for titles and headings
      2m 37s
    6. Formatting Sparklines for optimum impact
      7m 54s
  9. 8m 57s
    1. Converting a chart to a picture and adding new images
      3m 30s
    2. Applying picture styles
      2m 24s
    3. Adding borders and effects to pictures
      3m 3s
  10. 16m 56s
    1. Creating value-based formatting using logical operators
      4m 37s
    2. Creating value-based formatting using data bars and color scales
      6m 32s
    3. Creating formats based on formulas
      5m 47s
  11. 12m 54s
    1. Hiding repeating titles in a column to clarify printed output
      2m 26s
    2. Restoring missing title data in a column
      3m 30s
    3. Displaying large values without using formulas
      3m 7s
    4. Formatting column/row titles
      1m 58s
    5. Formatting a list for double-spaced printing
      1m 53s
  12. 27s
    1. Final thoughts
      27s

Watch this entire course now —plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2010: Advanced Formatting Techniques
3h 2m Intermediate Feb 10, 2011

Viewers: in countries Watching now:

In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course.

Topics include:
  • Saving time with keyboard shortcuts
  • Adjusting fonts, cell borders, and fills
  • Setting themes
  • Formatting numeric data with cell formats
  • Using conditional formatting
  • Hiding repeating column information
  • Printing double-spaced data
  • Elbow formatting
Subjects:
Business Spreadsheets
Software:
Excel Office
Author:
Dennis Taylor

Welcome

Hi! I am Dennis Taylor and I am pleased to present Excel 2010: Advanced Formatting Techniques. When you're working with Excel, there is no question that appearances count. A dull lifeless display won't get the attention it deserves. You need to know the scope of Excel's formatting features and the quickest and best ways to get to them. In this course, I'll show you those features that enhance the appearance of worksheets, giving them wide visual appeal, as well as making them clearer and easier to understand.

Excel gives you formatting tools that allow you to eliminate any doubt about what your data means. I'm looking forward to showing them to you in Excel 2010: Advanced Formatting Techniques.

Find answers to the most frequently asked questions about Excel 2010: Advanced Formatting Techniques .


Expand all | Collapse all
please wait ...
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2010: Advanced Formatting Techniques.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.