- Create value-based formatting using data bars, color scales, and icons-473602.mp427.6 MiB
- Set special formats for dates, times, phone numbers, and zip codes-473597.mp425.1 MiB
- Apply border styles and adjust gridlines-473586.mp421.7 MiB
- Build custom numeric formats-473598.mp420.9 MiB
- Adjust horizontal and vertical cell alignment-473589.mp418.1 MiB
- Create formats based on formulas-473603.mp418.1 MiB
- Apply underline, strikethrough, subscript, and superscript formatting-473585.mp416.2 MiB
- Control titles and headings using Wrap Text and Shrink to Fit-473593.mp416.1 MiB
- Work with numeric formatting options-473595.mp415.3 MiB
- Adjust fonts, font sizes, and font colors-473584.mp414.9 MiB
- Build custom date formats-473599.mp414.6 MiB
- Master the numeric formatting keyboard shortcuts-473596.mp413.6 MiB
- Use fill color and patterns for cell backgrounds-473587.mp413.6 MiB
- Simplify title adjustments using the Merge and Center button-473592.mp413.5 MiB
- Create value-based formatting using logical operators-473601.mp412.3 MiB
- Create angled text variations for greater variety and readability-473590.mp49.55 MiB
- Welcome-473580.mp46.34 MiB
- Indent data and dollar signs-473591.mp45.47 MiB
- About the exercise files-473582.mp41.09 MiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_09_Pictures.xlsx554 KiB
- Prerequisites for this course-473581.mp4489 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_10_PowerTechniques.xlsx167 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_04_ConditionalFormatting.xlsx151 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_07_OtherFormatting.xlsx121 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_06_RowColumnAdjustments.xlsx86.4 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_05_TablesStylesThemes.xlsx82.8 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_08_Outlines.xlsx75.1 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_03_Numeric.xlsx66.6 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_02_Alignment.xlsx37.2 KiB
- Ex_Files_Excel_2016_Formatting/Exercise Files/Ch_01_FontsBorders.xlsx30.7 KiB