Pre-Requisites: Microsoft Excel® 2013 Intermediate skills.
This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel tools and features. Students will learn to apply custom formatting, and to use LOOKUP functions as well as how to use lists. Students will also learn how to customize and automate Excel using macros.
This course is intended for students learning Microsoft Excel® 2013 Advanced skills.
Advanced functions and formulas
Lookups and data tables
Advanced data management
Advanced charting
PivotTables and PivotCharts
Exporting and importing data
Analytical tools
Macros and Visual Basic
Accessibility and language features
Real testimonials from our Students!
I cannot begin to tell you how fortunate I am to have found Global Information Technology (GIT). I had been laid off in the spring and was looking for a new job. The Web Program sparked my interest. I have degrees in Advertising and Graphic Design but learning to design web sites was something I [...] Read more
Jennifer Dudek
I have always prided myself in further educating myself. I have a bachelors, and during that time while working, I got my MBA. Throughout my career, I was lead to believe that loyalty and education will keep you ahead of the game and employed. One day, after 18 years of service at my job, I [...] Read more
Isaac Hatcher
1/9/2025. The Business Data Analytics (BDA) course at Global Information Technology (GIT) was a game-changer for my career. The course provided me with in-depth knowledge of key technologies such as Power BI, SQL, and Advanced Excel, along with hands-on experience through real-world projects. The expert instructors and their practical approach helped me develop the skills [...] Read more
Tejaswini Mokashi
I’d like to take my time to thank you and GIT for your wonderful assistance with getting me into a successful IT Career. You and your staff demonstrated great care in ensuring that I was able to be placed in a great job after completing my classes at the school, offering help with resume creation [...] Read more
Christopher Leimback
First of all I would like to start out by saying a big  thank you to Global Information Technology who not only provided me with my CompTIA A+ and Network+ training, however they helped me to get full time employment with benefits. The Director at Global Information Technology requested, I try and get some funding [...] Read more
Haitham Muhsin
866-GO-GIT-GO