Take your data management to the next level! This course is for the intermediate and advanced Microsoft Excel user. This course will show you how to utilize the full power of Microsoft Excel. In this 3-day practical and project-oriented workshop series, you will learn about the use and take advantage of Excel's Pivot Table and how to manage and analyze data by creating subtotals, Pivot Tables, and Pivot Charts. You will learn how to create informative data representation using advanced functions of Excel such as INDEX and MATCH. Financial functions such as PMT, IPMT, PPMT, FV, and NPV are explored in detail. You will learn how to manipulate data using specialized functions such as date, logical, lookup database, and financial. Conditional formatting, multiple worksheet management and the use of range names to simplify entering ranges into the financial functions will be covered. Forecasting will be briefly covered.