Designed to give users an understanding of intermediate MS Excel 2010, Beyond The Basics course will you to give you a firm grasp of many useful Excel features beyond the essentials. Productivity in Automation workbooks are designed to help you "learn by doing." After completing the lessons you can continue to use this book as a reference. In this course you will learn to: Work with Multiple Worksheets Use Excel functions: PMT(), IF(), VLookup(), & More Use Intermediate charting features Protect worksheets and Data Validation Create Excel Templates