Training: Excel – Giving visual impact to your spreadsheets

Module 1: Conditional Formatting

• Setting up simple conditional formatting
• Understanding and applying conditional formatting of different types
• Managing conditional formatting rules
• Setting up complex conditional formatting with formulas
• Reproducing conditional formatting
• Find cells with conditional formatting
• Modify conditional formatting
• Delete conditional formatting

Module 2: Themes

• Understanding how themes work in Excel
• Modifying a theme
• Customizing a theme and save it
• Understanding the difference between theme colors and standard colors

Module 3: Sparkline Charts

• Create a sparkline chart
• Highlight specific values in a sparkline chart
• Display and customize axis settings