You've mastered the basics of Excel - now you're ready to explore advanced topics. Upon completion of the course, participants will be able to accomplish the following:
- Organize, protect, and display data using various tools.
- Create linking formulas, and manage links.
- Manage and arrange multiple workbooks, insert and manage multiple worksheets, and consolidate data from multiple sources.
- Create, modify, and customize charts to present data effectively, and to enhance their appearance.
- Create, apply and modify styles to format worksheets; use comments, text boxes to annotate worksheets.
Completion of this course will allow you to create complex and professional spreadsheets in an efficient manner. Take your Excel skills to the next level!
Prerequisite: Excel Essentials.