Author
Released
10/12/2016- Adjusting fonts, borders, and cell colors
- Aligning text
- Controlling numeric formatting
- Building custom numeric and date formats
- Creating value-based conditional formatting
- Working with tables
- Using styles and themes
- Adjusting row, column, and sheet sizes
- Outlining data
- Adding and formatting images
- Using specialized power formatting techniques
Skill Level Advanced
Duration
Views
- [Dennis] Hi, I'm Dennis Taylor, and welcome to Excel for Mac 2016, Advanced Formatting Techniques. 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 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 features that add flare and visual interest to your worksheets.
Excel gives you a ton of formatting tools that lets you eliminate any doubt about what your data means. And I'm looking forward to showing them to you during this course.
Related Courses
-
Excel for Mac 2016: Charts in Depth
with Dennis Taylor4h 22m Intermediate -
Excel for Mac 2016: Advanced Formulas and Functions
with Dennis Taylor6h 54m Intermediate
-
Introduction
-
Welcome44s
-
-
1. Controlling Fonts, Borders, and Cell Color
-
2. Alignment Tools
-
3. Adjusting Numeric Formats Quickly
-
Building custom date formats4m 37s
-
4. Accentuating Dynamic Data with Conditional Formatting
-
5. Tables, Styles, and Themes
-
Working with tables10m 8s
-
-
6. Row, Column, and Sheet Adjustments
-
7. Other Worksheet Formatting Tools
-
8. Displaying Data as an Outline
-
9. Adding Pictures
-
Formatting picture styles3m 50s
-
-
10. Specialized Power Formatting Techniques
-
Formatting column/row titles2m 35s
-
Conclusion
-
Goodbye37s
-
- 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