MICROSOFT EXCEL INTERMEDIATE (IN PERSON)
Take your Excel skills to the next level and get more out of the power of Excel with this hands-on course designed for experienced users.
At the end of this course you will know how to: • Use advanced formulas and functions
• Create and use Named Ranges in formulas
• Perform calculations with links across multiple worksheets and workbooks
• Filter and sort data
• Create, modify and format charts
• Perform analysis with PivotTables and Pivot Charts
• Create macros to automate Excel tasks Please bring a USB drive to copy class exercises for reference after class.
Prerequisites: Before taking this course, you are recommended to take the Introduction to Microsoft Excel 2010 course or have equivalent knowledge of Excel.