Excel: Advanced Formatting Techniques
- Offered byLinkedin Learning
Excel: Advanced Formatting Techniques at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
Excel: Advanced Formatting Techniques at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Excel: Advanced Formatting Techniques at Linkedin Learning Course details
- 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
Excel: Advanced Formatting Techniques at Linkedin Learning Curriculum
Introduction
Advanced formatting in Excel
Formatting and Aligning Text
Subscript, underline, and strikethrough text
Center across a selection vs. merged cells
Create angled text for readability and organization
Indent cell contents and add new lines within a cell
Insert symbols: Bullet points, stars, and François
Formatting Numbers and Dates
Dates and custom formatting
Make consistent entries with Find and Replace
Positive and negative numbers
Format hours, minutes, and seconds
M for millions and K for thousands
Format numbers with Power Query
Working with Images and Shapes
Group and align shapes
Transform text into shapes with WordArt
Place text inside a shape
Conditional Formatting
Conditional formatting for duplicates
Highlight fast-approaching dates
Conditional formatting for icons
Conditional formatting for strikethrough fonts
Formatting for Print
Page numbers and page breaks
Print preview
Format your worksheets to control what gets printed
Workbooks and Worksheets
Format multiple sheets at once
Set workbook defaults to open with your preferences
Tables, Slicers, Themes
Format tables
Format slicers
Apply workbook themes and styles
Charts and Graphs
Grid lines, legends, and other chart formatting
3D, shadows, and other advanced chart formatting
Advanced, Random, and Fascinating Formatting
Install and uninstall fonts
Format your worksheet's background with an image
Manage hyperlinks
Color-picker and RGB code for colors
Clear Formatting
Conclusion
Getting the most from Excel
Excel: Advanced Formatting Techniques at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?