Excel: Advanced Formatting Techniques

Focused View

Oz du Soleil

2:42:22

232 View

01. Introduction

001. Advanced formatting in Excel.mp4

01:17

02. Formatting and Aligning Text

002. Subscript, underline, and strikethrough text.mp4

04:50

003. Center across a selection vs. merged cells.mp4

03:14

004. Create angled text for readability and organization.mp4

04:00

005. Indent cell contents and add new lines within a cell.mp4

07:14

006. Insert symbols Bullet points, stars, and Francois.mp4

09:31

03. Formatting Numbers and Dates

007. Dates and custom formatting.mp4

09:09

008. Make consistent entries with Find and Replace.mp4

04:16

009. Positive and negative numbers.mp4

04:02

010. Format hours, minutes, and seconds.mp4

05:46

011. M for millions and K for thousands.mp4

04:37

012. Format numbers with Power Query.mp4

07:11

04. Working with Images and Shapes

013. Group and align shapes.mp4

06:19

014. Transform text into shapes with WordArt.mp4

05:38

015. Place text inside a shape.mp4

04:17

05. Conditional Formatting

016. Conditional formatting for duplicates.mp4

06:15

017. Highlight fast-approaching dates.mp4

07:42

018. Conditional formatting for icons.mp4

05:10

019. Conditional formatting for strikethrough fonts.mp4

03:36

06. Formatting for Print

020. Page numbers and page breaks.mp4

04:21

021. Print preview.mp4

03:35

022. Format your worksheets to control what gets printed.mp4

02:24

07. Workbooks and Worksheets

023. Format multiple sheets at once.mp4

04:14

024. Set workbook defaults to open with your preferences.mp4

01:53

08. Tables, Slicers, Themes

025. Format tables.mp4

04:38

026. Format slicers.mp4

04:03

027. Apply workbook themes and styles.mp4

04:13

09. Charts and Graphs

028. Grid lines, legends, and other chart formatting.mp4

05:14

029. 3D, shadows, and other advanced chart formatting.mp4

04:29

10. Advanced, Random, and Fascinating Formatting

030. Install and uninstall fonts.mp4

04:56

031. Format your worksheet's background with an image.mp4

03:34

032. Manage hyperlinks.mp4

04:22

033. Color-picker and RGB code for colors.mp4

03:13

034. Clear Formatting.mp4

01:51

11. Conclusion

035. Getting the most from Excel.mp4

01:18

Description

Formatting is not just font colors and pretty graphs. Get simple, powerful tips for making Excel data more readable and understandable in this advanced formatting course from Excel MVP Oz du Soleil. Oz begins with formatting and aligning text, numbers, and dates. Next, he shows how to work with images and shapes. Oz covers advanced features in the conditional formatting menu, and shows how to optimize spreadsheets for print. He also covers formatting tips for tables, slicers, charts, and graphs. Oz concludes with an assortment of interesting, and useful formatting features in Excel. This course not only shows how to make data more readable, it also shows ways to customize your work environment inside Excel to make it more pleasant to work in.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Dashboard

Oz du Soleil

Instructor's Courses

Microsoft Excel MVP | YouTube Channel: Excel on Fire | Author, Guerrilla Data Analysis Version 2. Co-authored with Mr Excel, Bill Jelen | Excel Trainer & Instructor | Speaker. I've been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information. Presented at: #Northwestern University #University of Illinois at Chicago #IgniteChicago #ExcelTV Courses taught: Excel Formulas Data Visualization in Excel 2013 Pivot Tables & Dashboards Excel for Nonprofits: Measuring Fundraising Effectiveness Introduction to Programming VBA

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.