Author
Released
2/10/2011- 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
Skill Level Intermediate
Duration
Views
- Hi, I'm Dennis Taylor and I'm pleased to present Excel 2010 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 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.
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate
-
Introduction
-
Welcome45s
-
-
1. Adjusting Numeric Formats Quickly
-
Building custom date formats5m 18s
-
2. Controlling Fonts, Borders, and Cell Colors
-
3. Alignment Tools
-
4. Other Valuable Formatting Tools
-
5. Row, Column, and Sheet Adjustments
-
6. Displaying Data as an Outline
-
7. Tables, Themes, Styles, and Other Essential Data Visualization Tools
-
Fine-tuning shape effects7m 32s
-
8. Adding Pictures
-
Applying picture styles2m 24s
-
9. Dynamically Accentuating Data with Conditional Formatting
-
10. Specialized Power Formatting Techniques
-
Formatting column/row titles1m 58s
-
Conclusion
-
Final thoughts27s
-
- Mark as unwatched
- Mark all as unwatched
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.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome