In this intermediate Excel course, you will master complex functionalities to improve data management and analysis efficiency. You'll learn advanced worksheet management, including grouping and linking, and enhance your formula skills with relative, absolute, and mixed references. The course covers advanced functions like SUM, AVERAGE, MIN, MAX, and COUNT, and teaches data analysis and visualization through sorting, analyzing, and creating charts. An introduction to Pivot Tables will be provided, as well as data validation and security techniques and the use of Excel add-ins. Essential keyboard shortcuts to boost workflow efficiency are also included. By the end of this course, you'll be proficient in managing, analyzing, and visualizing data with intermediate Excel features.
After successfully completing the course, students will be able to:
Thank you for submitting your registration form!
One of our team members will reach out shortly to help you complete your registration and submit payment.
For more information, please email us.