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

Excel 2013: Advanced Formatting Techniques

Excel 2013: Advanced Formatting Techniques

with Dennis Taylor

Video: Welcome

Hi.
Expand all | Collapse all
  1. 1m 17s
    1. Welcome
      51s
    2. Using the exercise files
      26s
  2. 15m 39s
    1. Adjusting fonts, font sizes, and font colors
      4m 39s
    2. Applying underline, strikethrough, subscript, and superscript formatting
      3m 48s
    3. Applying border styles and adjusting gridlines
      3m 56s
    4. Using fill color and patterns for cell backgrounds
      3m 16s
  3. 17m 3s
    1. Adjusting horizontal and vertical cell alignment
      4m 9s
    2. Creating angled text variations for greater variety and readability
      2m 40s
    3. Indenting data and dollar signs
      1m 44s
    4. Simplifying title adjustments with the Merge & Center button
      3m 23s
    5. Controlling titles and headings with the Wrap Text and Shrink to Fit options
      5m 7s
  4. 28m 25s
    1. Working with numeric formatting options
      6m 21s
    2. Essential numeric formatting keystroke shortcuts
      5m 34s
    3. Setting special formats for dates, times, phone numbers, ZIP codes, etc.
      4m 53s
    4. Building custom numeric formats
      5m 53s
    5. Building custom date formats
      5m 44s
  5. 22m 50s
    1. Creating value-based formatting using logical operators
      3m 17s
    2. Creating value-based formatting using data bars, color scales, and icons
      7m 39s
    3. Creating formats based on formulas
      6m 15s
    4. Conditional formatting in PivotTables
      5m 39s
  6. 14m 6s
    1. Working with tables
      8m 34s
    2. Using styles and themes for consistent formatting
      5m 32s
  7. 17m 43s
    1. Adjusting single and multiple row heights and column widths without commands
      5m 12s
    2. Working with rows, columns, and sheets
      6m 9s
    3. Working with the Hide and Unhide options
      6m 22s
  8. 12m 49s
    1. Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar
      2m 47s
    2. Applying different formatting styles within the same cell
      2m 45s
    3. Copying formats quickly with dragging techniques and the Format Painter
      4m 14s
    4. Formatting text from Word or the web with the Justify feature
      3m 3s
  9. 10m 55s
    1. Setting up data for outlining
      7m 15s
    2. Using outlining symbols and levels
      3m 40s
  10. 16m 1s
    1. Formatting picture styles
      3m 12s
    2. Adding borders and effects to pictures
      4m 7s
    3. Formatting sparklines for optimum impact
      6m 15s
    4. Using WordArt for formatted titles and headings
      2m 27s
  11. 21m 35s
    1. Hiding repeating titles in a column to clarify printed output
      2m 23s
    2. Restoring missing title data in a column
      4m 3s
    3. Displaying large values without using formulas
      3m 37s
    4. Creating linked worksheet images
      7m 37s
    5. Formatting column and row titles
      2m 1s
    6. Formatting a list for double-spaced printing
      1m 54s
  12. 29s
    1. Goodbye
      29s

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 2013: Advanced Formatting Techniques
2h 58m Advanced Dec 10, 2013

Viewers: in countries Watching now:

Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques that take the drudgery out of formatting even the largest amounts of data.

Topics include:
  • Adjusting fonts, cell borders, and fills
  • Aligning text
  • Indenting data
  • Setting special formats for dates, times, phone numbers, zip codes, and more
  • Creating formats based on formulas with conditional formatting
  • Applying styles and themes
  • Adjusting row heights and column widths
  • Adding background images and pictures
  • Outlining data
  • Printing double-spaced data
Subjects:
Business Spreadsheets
Software:
Excel
Author:
Dennis Taylor

Welcome

Hi. I'm Dennis Taylor, and I'm happy to present Excel 2013: Advanced Formatting Techniques. When you're working with Excel, there's 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 keystroke shortcuts to format numeric cells, how to use conditional formatting to apply formats dynamically, the most efficient ways to copy formats quickly, and numerous tools that add flair and visual interest to your worksheets.

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 2013: Advanced Formatting Techniques.

There are currently no FAQs about Excel 2013: Advanced Formatting Techniques.

Share a link to this course
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.
Upgrade now


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.

Upgrade now

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 2013: 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 preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



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.

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