Microsoft Excel 2010 Advanced Function Writing
This course has been superseded by the Microsoft Excel Advanced Function Writing course.
Course Outline. (10 topics)
- Function Writing Review
- Review of Basic Functions
- The IF Functions
- Nested Functions
- Array Functions
- Date and Time Functions
- Working with Text Functions
- Lookup and Reference Functions
- Rounding Numbers
- Miscellaneous Statistical Functions
Before attending this course, students need to be able to: Demonstrate a good working knowledge of Microsoft Windows Demonstrate a good working knowledge of Microsoft Excel 2010 Understand basic functions such as Sum and Average and how they are written Write and edit a variety of basic formulas using Excel functions To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained: Microsoft Office Excel 2010: Level 1 Microsoft Office Excel 2010: Level 2 Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.