This Advanced Microsoft Excel 2013 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements
Some of the topics covered include :
- VLOOKUP: When and how to use it
- Create and manage drop-down lists
- Password protect workbooks and worksheets
- Print worksheets and workbooks
- Work with macros