Excel: Introduction to Formatting

Focused View

Mynda Treacy

1:06:37

108 View

01 - Introduction

01 - Save time with effective Excel formatting.mp4

00:50

02 - 1. Cell Formats

01 - Formatting with fonts.mp4

03:57

02 - Cell fill and borders.mp4

05:35

03 - Alignment options and what to avoid.mp4

04:36

04 - Important number formats.mp4

02:44

03 - 2. Custom Formats

01 - Custom number formats.mp4

02:19

02 - Scaling.mp4

03:00

03 - Date and time formats.mp4

04:46

04 - Symbols in formats.mp4

03:51

05 - Conditional color formats.mp4

03:48

06 - Leading and trailing characters.mp4

01:58

04 - 3. Cell Styles and Themes

01 - Default styles.mp4

02:54

02 - Custom styles.mp4

03:11

03 - Themes.mp4

04:31

05 - 4. Conditional Formatting

01 - Built-in rules.mp4

02:57

02 - Data bars.mp4

02:28

03 - Color scales.mp4

02:51

04 - Icons.mp4

02:28

05 - Conditional formatting formulas.mp4

03:50

06 - Manage rules.mp4

03:23

06 - Conclusion

01 - Where to learn more.mp4

00:40

Description

Get a quick crash course in Excel formatting that will help transform your spreadsheets from boring to compelling. Microsoft Excel MVP Mynda Treacy takes you through the fundamentals of formatting in Excel and along the way drops pro tips and tricks she has accumulated in over 20 years of working with Excel. Topics include how to emphasize data with fonts, borders, colors, and the pitfalls to avoid. Learn how to control alignment, write custom number formats, accentuate dynamic data with conditional formatting, and use styles to transform the look and feel of spreadsheets with one click.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Mynda Treacy

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.