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: