Excel Formatting: Cells, Ranges, and Advanced Formatting Techniques
Course
This course focuses on advanced Excel formatting techniques used to enhance data presentation beyond basic styling, while also providing a review of fundamental formatting concepts.
Skills you’ll gain: applying advanced conditional formatting, creating custom number formats, using cell styles and themes, combining formatting techniques strategically, using text functions for formatting, and automating formatting tasks using macros.
Here is the course outline:
1. Fundamental Cell Formatting TechniquesCovers a review of basic formatting techniques such as adjusting font styles, text alignment, and number formats, including standard and custom formats, and combining multiple formatting techniques to enhance data readability. 5 sections
|
|||||
|
2. Conditional Formatting and Visual EnhancementsFocuses on applying and customizing conditional formatting rules, including data bars, color scales, and icon sets, along with using borders and fill colors to visually highlight important data. 5 sections
|
|||||
|
3. Advanced Formatting, Styles, and AutomationCovers applying cell styles and themes, using text functions such as UPPER, LOWER, and PROPER for dynamic formatting, and automating formatting tasks by recording and running macros. 7 sections
|
|||||||
|
4. We want to hear from you!Learning Management System — NPS 1 section
|
|
|