Linkedin - Excel - Advanced Formatting Techniques (2022)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 01. Introduction
• 001. Advanced formatting in Excel.en.srt (1.6 KB)
• 001. Advanced formatting in Excel.mp4 (11.3 MB)
02. Formatting and Aligning Text
• 002. Subscript, underline, and strikethrough text.en.srt (5.3 KB)
• 002. Subscript, underline, and strikethrough text.mp4 (41.8 MB)
• 003. Center across a selection vs. merged cells.en.srt (3.6 KB)
• 003. Center across a selection vs. merged cells.mp4 (28.1 MB)
• 004. Create angled text for readability and organization.en.srt (4.3 KB)
• 004. Create angled text for readability and organization.mp4 (34.8 MB)
• 005. Indent cell contents and add new lines within a cell.en.srt (8.4 KB)
• 005. Indent cell contents and add new lines within a cell.mp4 (62.7 MB)
• 006. Insert symbols Bullet points, stars, and François.en.srt (10.7 KB)
• 006. Insert symbols Bullet points, stars, and François.mp4 (82.3 MB)
03. Formatting Numbers and Dates
• 007. Dates and custom formatting.en.srt (9.1 KB)
• 007. Dates and custom formatting.mp4 (79.1 MB)
• 008. Make consistent entries with Find and Replace.en.srt (4.8 KB)
• 008. Make consistent entries with Find and Replace.mp4 (36.8 MB)
• 009. Positive and negative numbers.en.srt (5.2 KB)
• 009. Positive and negative numbers.mp4 (34.9 MB)
• 010. Format hours, minutes, and seconds.en.srt (5.2 KB)
• 010. Format hours, minutes, and seconds.mp4 (50.0 MB)
• 011. M for millions and K for thousands.en.srt (4.4 KB)
• 011. M for millions and K for thousands.mp4 (40.0 MB)
• 012. Format numbers with Power Query.en.srt (8.5 KB)
• 012. Format numbers with Power Query.mp4 (62.3 MB)
04. Working with Images and Shapes
• 013. Group and align shapes.en.srt (6.8 KB)
• 013. Group and align shapes.mp4 (54.7 MB)
• 014. Transform text into shapes with WordArt.en.srt (5.6 KB)
• 014. Transform text into shapes with WordArt.mp4 (48.8 MB)
• 015. Place text inside a shape.en.srt (4.5 KB)
• 015. Place text inside a shape.mp4 (37.0 MB)
05. Conditional Formatting
• 016. Conditional formatting for duplicates.en.srt (7.3 KB)
• 016. Conditional formatting for duplicates.mp4 (54.0 MB)
• 017. Highlight fast-approaching dates.en.srt (8.5 KB)
• 017. Highlight fast-approaching dates.mp4 (66.8 MB)
• 018. Conditional formatting for icons.en.srt (6.0 KB)
• 018. Conditional formatting for icons.mp4 (44.9 MB)
• 019. Conditional formatting for strikethrough fonts.en.srt (4.6 KB)
• 019. Conditional formatting for strikethrough fonts.mp4 (31.4 MB)
06. Formatting for Print
• 020. Page numbers and page breaks.en.srt (5.6 KB)
• 020. Page numbers and page breaks.mp4 (37.5 MB)
• 021. Print preview.en.srt (4.5 KB)
• 021. Print preview.mp4 (31.1 MB)
• 022. Format your worksheets to control what gets printed.en.srt (2.8 KB)
• 022. Format your worksheets to control what gets printed.mp4 (20.9 MB)
07. Workbooks and Worksheets
• 023. Format multiple sheets at once.en.srt (4.8 KB)
• 023. Format multiple sheets at once.mp4 (36.5 MB)
• 024. Set workbook defaults to open with your preferences.en.srt (2.2 KB)
• 024. Set workbook defaults to open with your preferences.mp4 (16.2 MB)
08. Tables, Slicers, Themes
• 025. Format tables.en.srt (5.2 KB)
• 025. Format tables.mp4 (40.6 MB)
• 026. Format slicers.en.srt (4.3 KB)
• 026. Format slicers.mp4 (35.2 MB)
• 027. Apply workbook themes and styles.en.srt (5.3 KB)
• 027. Apply workbook themes and styles.mp4 (36.7 MB)
09. Charts and Graphs
• 028. Grid lines, legends, and other chart formatting.en.srt (6.3 KB)
• 028. Grid lines, legends, and other chart formatting.mp4 (45.3 MB)
• 029. 3D, shadows, and other advanced chart formatting.en.srt (4.3 KB)
• 029. 3D, shadows, and other advanced chart formatting.mp4 (38.8 MB)
10. Advanced, Random, and Fascinating Formatting
• 030. Install and uninstall fonts.en.srt (5.1 KB)
• 030. Install and uninstall fonts.mp4 (42.9 MB)
• 031. Format your worksheet's background with an image.en.srt (3.6 KB)
• 031. Format your worksheet's background with an image.mp4 (31.1 MB)
• 032. Manage hyperlinks.en.srt (5.5 KB)
• 032. Manage hyperlinks.mp4 (37.8 MB)
• 033. Color-picker and RGB code for colors.en.srt (3.2 KB)
• 033. Color-picker and RGB code for colors.mp4 (27.8 MB)
• 034. Clear Formatting.en.srt (2.2 KB)
• 034. Clear Formatting.mp4 (16.2 MB)
11. Conclusion
• 035. Getting the most from Excel.en.srt (1.7 KB)
• 035. Getting the most from Excel.mp4 (11.7 MB)
• Bonus Resources.txt (0.4 KB)
Ex_Files_Excel_Advanced_Formatting_Techniques Exercise Files Chap 01 01_01
• Super Sub and Strike.xlsx (1.5 MB)
01_02
• Center vs Merge.xlsx (66.1 KB)
01_03
• Angled text and cell borders.xlsx (11.6 KB)
01_04
• Indent and add new line.xlsx (261.5 KB)
01_05
• Insert Symbols.xlsx (289.6 KB)
Chap 02 02_01
• Dates and Custom Formatting.xlsx (10.7 KB)
02_02
• Make consistent entries.xlsx (9.7 KB)
02_03
• Positive and negative numbers.xlsx (11.7 KB)
02_04
• Time Formatting.xlsx (269.1 KB)
02_05
• M for Millions.xlsx (257.1 KB)
02_06
• Formatting with power query.xlsx (14.7 KB)
Chap 03 03_01
• Objects.xlsx (11.0 KB)
03_02
• WordArt.xlsx (14.4 KB)
03_03
• Text and shapes.xlsx (214.6 KB)
Chap 04 04_01
• Conditional formatting - duplicates.xlsx (11.9 KB)
04_02
• Conditional formatting - upcoming dates.xlsx (167.3 KB)
04_03
• Conditional formatting - icons.xlsx (10.7 KB)
04_04
• Conditional formatting - strikethru.xlsx (51.3 KB)
Chap 05 05_01
• Page numbers and breaks.xlsx (16.2 KB)
05_02
• People Data.xlsx (13.6 KB)
05_03
• Control what gets printed.xlsx (12.9 KB)
Chap 06 06_01
• Format multiple sheets.xlsx (14.1 KB)
Chap 07 07_01
• Tables.xlsx (12.9 KB)
07_02
• Formatting Slicers.xlsx (9.6 KB)
07_03
• Themes and Styles.xlsx (24.4 KB)
Chap 08 08_01
• Graph features.xlsx (15.1 KB)
08_02
• Graph.xlsx (21.0 KB)
Chap 09 09_01
• Install Font.xlsx (581.0 KB)
09_02
• Add image to sheet background.xlsx (11.6 KB)
• Metropolis.jpg (3.2 MB)
09_03
• Hyperlinks.xlsx (8.5 KB)
09_04
• Colors.xlsx (215.1 KB)
09_05
• Clear Formatting.xlsx (13.5 KB)