8: Microsoft Excel Advanced Skills Last updated Save as PDF Page ID 46384 Learning Objectives Sparklines More Formatting and Layout Pivot Tables Macros Functions and Formulas Add-Ins Internet and Excel 8.1: Why It Matters- Microsoft Excel Advanced Skills 8.2: Introduction to Sparklines 8.3: Sparklines 8.4: Introduction to More Formatting and Layout 8.5: Conditional Formatting 8.6: Viewing a Worksheet 8.7: Introduction to Pivot Tables 8.8: Pivot Tables 8.9: Introduction to Macros 8.10: Macros 8.11: Recording a Macro 8.12: Introduction to Statistical Functions and Formulas 8.13: What is a Function? 8.14: Lookup Functions and Formulas 8.15: Logical Functions and Formulas 8.16: Financial Functions and Formulas 8.17: Introduction to Add-Ins 8.18: Add-Ins 8.19: Introduction to Internet and Excel 8.20: Internet and Excel 8.21: Putting It Together- Microsoft Excel Advanced Skills 8.22: Assignment- Create Macro for Car Loan Spreadsheet 8.23: Discussion- Excel Worksheet as a Webpage