Advanced Excel Course Details

 This Advanced Microsoft Excel 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.
This course is intended for students who have intermediate skills with Microsoft Excel who want to learn more advanced skills or students who want to learn the topics covered in this course.


• Chapter1–Excel Advanced Concepts
• Chapter2–Excel & the Internet
• Chapter3–Functions
• Chapter4–The=IF Functions
• Chapter5–Using Functions to Clean & Crunch data
• Chapter6–Data Commands
• Chapter7–Macros
• Chapter8–Solver
• Chapter9–Example Case Studies
o 1.  Gantt Chart
o 2.  Combo Chart
o 3.  Organizational Chart
o 4.  Portfolio–Investment Mix and Performance Tracking
• Chapter10–Digging Deeper into Excel’s Fundamentals
• Chapter11–XML
• Chapter12–Using Excel with Your Accounting System

Last modified: Sunday, 31 July 2016, 11:32 PM