Microsoft Excel II

This workshop is designed to take Microsoft Excel users beyond the basics. You will learn to work in a multiple-worksheet environment, including techniques for entering formulas that calculate between worksheets and workbooks. You will gain a better understanding of how to use complex formulas and functions critical to the development of advanced spreadsheets such as the database functions and the IF and SumIf functions. Topics include: working with multiple worksheets; creating more complex formulas and functions; personalizing the Excel workspace; creating summary reports; creating reports with pivot tables; and using macros to automate tasks.