of Contents Course Information 3 Chapter 1 All Functions 4 – Chapter 2 The If Function 17 – Chapter 3 Using Functions to Crunch & Clean Data 22 – Chapter 4 Data Commands 40 – Chapter 5 - Macros 72 Chapter 6 Miscellaneous 75 – Chapter 7 XML Data 83 – Chapter 8 Quick Tips 91 – Chapter 9 New in Excel 2007 94 – Appendix - Instructor’s Biography 105
of Contents Course Information 3 Chapter 1 – All Functions 4 Chapter 2 – The If Function 17 Chapter 3 – Using Functions to Crunch & Clean Data 22 Chapter 4 – Data Commands 40 Chapter 5 - Macros 72 Chapter 6 – Miscellaneous 75 Chapter 7 – XML Data 83 Chapter 8 – Quick Tips 91 Chapter 9 – New in Excel 2007 94 Appendix - Instructor’s Biography 105
2009%20Excel%20Functions%20Macros%20and%20Data%20Commands%20Manual.docx