探索 Excel - 动态图表和条件格式
Explore Excel - Dynamic Charts and Conditional Formatting
- 1 - Introduction and Course Overview
- 1 -Introduction Your Journey starts here
- 2 -Optimize Your Course Experience Essential Steps
- 2 - MASTERING CONDITIONAL FORMATTING
- 1 -Conditional Formatting Fundamentals Getting Started
- 2 -ICON SETS
- 3 -DATABARS
- 4 -FILTERS
- 5 -COLOR SCALES
- 6 -Custom Formatting Trend Arrows for Data Insights
- 7 -Custom Formatting Mastering Color-Coded Trend Arrows
- 3 - ADVANCED CONDITIONAL FORMATTING TECHNIQUES
- 1 -Spotting Duplicates
- 2 -Structured Data Highlighting Alternate cells, Part- I
- 3 -Structured Data Highlighting Alternate cells– Part- II
- 4 -Data Spotlight Smart Search & Highlight Techniques
- 4 - CHART MASTERY Basics
- 1 -Beginner’s Guide to Excel Charts
- 2 -Charting Essentials - Line and Pie Charts Explained
- 3 -SPARKLINE Mastery
- 4 -Chart Fusion (Combo Charts)
- 5 -Chart featuring Trend Arrows & Customized Labels
- 5 - CHART MASTERY Dynamic Visuals
- 1 -Form Controls CHECK BOX
- 2 -Interactive Chart with Checkbox
- 3 -Fundamental Formulas for Dynamic Chart Creation-I
- 4 -Fundamental Formulas for Dynamic Chart Creation-II
- 5 -Form Controls COMBO BOX
- 6 -Interactive Chart with Combo Box
- 7 -Form Controls SCROLL BAR
- 8 -Data manipulation for Dynamic chart
- 9 -Dynamic Chart Mastery- Part I
- 10 -Dynamic Chart Mastery- Part II
- 6 - Expanded Chart Series
- 1 -Target Meter Chart
- 2 -Horizontal Axis Grouping
- 3 -SPEEDOMETER Chart- Part I
- 4 -SPEEDOMETER Chart- Part II
- 5 -THERMOMETER Chart
- 6 -SCATTER Scout Chart
- 7 - Final Tips and Practical Takeaways
- 1 -Congratulations and Keep Exploring