Staff Skills academy+
Home » Courses » Microsoft Excel Advanced Certification » Module 51: Sparkline Charts in Excel
Module 51: Sparkline Charts in Excel
51.1 Sparkline Charts in Excel Sparklines are not like regular charts, in that they are not objects. A Sparkline is a tiny chart contained within a cell’s background. Because a Sparkline is embedded within a cell, you can also use text with the Sparkline as a background. Sparklines are useful for allowing you to spot patterns within your data. Having numeric data in column or row form is useful, but patterns do not always stand out. With a Sparkline in a cell next to your data (this ...
Lessons
- Module 1: Add a Password
- Module 2 : AND Function
- Module 3 : Auto Updating Drop-down Lists
- Module 4 : CEILING Formula
- Module 5 : Charts that Update Automatically
- Module 6 : CHOOSE Formula
- Module 7 : Compare 2 Lists with VLOOKUP Function
- Module 8 : CORREL Function
- Module 9 : Create an Advanced Calculator
- Module 10 : Create a Combo Chart
- Module 11 : Create a Custom Tab
- Module 12 : Create a Pivot Chart
- Module 13 : Create Visual In-cell Indicators
- Module 14 : Create Visual In-cell Indicators with Icon Sets
- Module 15: Customise the Status Bar
- Module 16: DATEDIF Function
- Module 17: DATEVALUE Function
- Module 18: DAVERAGE Function
- Module 19 : DCOUNT Function
- Module 20 : DCOUNTA Function
- Module 21 : Depreciation Formula
- Module 22 : DGET Function
- Module 23 : DMAX Function
- Module 24 : DPRODUCT
- Module 25: DSUM Function
- Module 26: EDATE Function
- Module 27: EOMONTH Function
- Module 28: Find and Replace
- Module 29: FIND Function
- Module 30: INDEX Function
- Module 31: INDEX MATCH Function
- Module 32: INDIRECT Function
- Module 33: Insert Serial Number Automatically
- Module 34: IPMT Function
- Module 35: ISBLANK Function
- Module 36: ISERR Function
- Module 37: ISLOGICAL Function
- Module 38: ISNONTEXT Function
- Module 39: ISNUMBER Function
- Module 40: ISODD Function
- Module 41: Isolate First Name
- Module 42: ISTEXT Formula
- Module 43: LEFT Function
- Module 44: LEN Function
- Module 45: MATCH Function
- Module 46: VLOOKUP Multiple Results at Once
- Module 47: OR Function
- Module 48: PMT Function
- Module 49: REPLACE Function
- Module 50: Select all Cells with Comments
- Module 51: Sparkline Charts in Excel
- Module 52: Straight Line Depreciation
- Module 53: Strikethrough
- Module 54: Sum of Years Depreciation
- Module 55: Timeline in Pivot Table
- Module 56: VLOOKUP with 2 Criteria
- Module 57: VLOOKUP with DropDown List
- Module 58: VLOOKUP with MAX
- Module 59: VLOOKUP with MIN
- Module 60: Watch Window In Excel
