A Foundation for Better Spreadsheets-Introduction: Basic rules for expert users
Introduction
Introduction: Excel Course for Professionals
()
5 Excel Blunders that show how important safe Excel use is
A Foundation for Better Spreadsheets-Use the right tool for the job
Expert Video: Ingeborg Hawighorst - Is Excel the answer?
()
Match the correct solution to the problem
A Foundation for Better Spreadsheets-Get, clean, and reshape your input data
Expert Video: Importance of good input data, and how to check it
()
Testing your input data
A Foundation for Better Spreadsheets-Set your standards for consistent formatting
Expert Video: The importance of Formatting in Excel
()
How to format consistently in Excel
A Foundation for Better Spreadsheets-Apply accurate documentation from the start
Expert Video: Why is documentation important?
()
The importance of documentation
Good Use of Formulas and Functions-Recap & look forward
Recap “Fundamentals” and Intro “Functions & Formulas” in Excel
()
Good Use of Formulas and Functions-Find & Search Functions
Expert Video: Pitfalls of commonly used Functions & Formulas
()
Find & Search Functions
Good Use of Formulas and Functions-Calculation Functions
Expert Video: Functions and Formulas
()
Calculation Functions
Good Use of Formulas and Functions-Other Functions
Expert Video: Functions and Alternatives
()
Other Functions
Spreadsheet Structure and Logical Flow-Recap & look forward
Recap “Functions & Formulas” and Intro “Structure & Flow” in Excel
()
Spreadsheet Structure and Logical Flow-Maintain a logical spreadsheet flow
Expert Video: Linear and logical spreadsheet flow
()
Linear and logical spreadsheet flow
Spreadsheet Structure and Logical Flow-Keep it simple
Expert Video: Keep it Simple
()
Keep it Simple
Spreadsheet Structure and Logical Flow-When possible, protect, don’t hide
Expert Video: Protection and Hidden Information
()
Protection & Hidden Information
Finishing Touches -Recap & look forward
Recap “Structure & Flow” and Intro “Finishing Touches” in Excel
()
Finishing Touches -Charts and Reporting
Charts, Pivot Tables, and Reporting (Gasper Kamensek)
()
Charts, Pivot Tables, and Reporting (Henk Vlootman)
()
Charts and Reporting
Finishing Touches -Checking, Testing, and Validation
Expert Video: Checking, Testing, and Validation
()
Checking, Testing, and Validation
Finishing Touches -Final things to check and double check
Expert Video: Finalization
()
Finalization