Microsoft Excel 2007 Advanced Function Writing
Book Now - 1 Delivery Method Available:Scheduled Online Onsite
It introduces you to additional keyboard commands, shortcuts and features related to writing functions. The target students for this course are people who want to get the most out of their data by learning various analysis functions. Whether you are an account manager, an IT worker or someone who needs to regularly manipulate Microsoft Excel 2007 worksheet data, this course will show many functions and their capabilities. You will use the advanced features of Microsoft Excel 2007 to attain a high degree of proficiency as an Excel power user within the area of writing functions. This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation.
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Course Outline (11 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 2007 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 2007: Level 1 Microsoft Office Excel 2007: Level 2 Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.