Author
Released
12/9/2019- Working with alignment tools
- Adjusting numeric formats
- Tables, styles, and themes
- Row, column, and sheet adjustments
- Worksheet formatting tools
- Displaying data as an outline
- Adding and formatting images
- Power formatting techniques
Skill Level Intermediate
Duration
Views
- [Dennis] When you're working with Excel there's no question that appearances count. A dull, lifeless display will not 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 how to create and adjust numeric formats, how to work with styles and themes, and create outlines for dynamic display presentations. We will also explore working with pictures, word art, and numerous other tools that add flare and visual interest to your worksheets. Hi, I'm Dennis Taylor. I've been working with Excel for years and I'm looking forward to showing you the many different ways of using Excel's powerful formatting tools.
Related Courses
-
Excel: Advanced Formulas and Functions
with Dennis Taylor4h 35m Intermediate -
Excel: PivotTables in Depth
with Curt Frye3h 38m Intermediate -
Excel Tips Weekly
with Dennis Taylor33h 56m Intermediate
-
Introduction
-
1. Alignment Tools
-
Indent data and dollar signs2m 36s
-
2. Adjusting Numeric Formats
-
Build custom numeric formats5m 40s
-
Create custom date formats5m 44s
-
-
3. Tables, Styles, and Themes
-
Work with tables4m 26s
-
-
4. Row, Column, and Sheet Adjustments
-
5. Other Worksheet Formatting Tools
-
6. Displaying Data as an Outline
-
Set up data for outlines5m 40s
-
-
7. Formatting Images
-
Format picture styles3m 5s
-
-
8. Specialized Power Formatting Techniques
-
Create picture links4m 57s
-
Conclusion
-
Next steps25s
-
- 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: Harness the power of Excel formatting techniques