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!
After being laid-off and getting frustrated looking for work in the current market with outdated AS/400 and Mainframe skills, I decided to visit a few training providers to investigate some tech training to upgrade my skills set. The third one I visited was Global Information Technology. My first impression was very positive. The representative’s passionate [...] Read more
David Hamel
I was fortunate to meet Manish, the Director of Global-IT, and started to discuss classes that would assist me with Project Management, as a Training Consultant. My experience has been nothing but positive, but also, confidence building. My instructor was phenomenal who taught my PMP course. He not only is available any time, but is [...] Read more
Soraya Meri
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 worked 17 yrs in manufacturing as a Hilo driver, a material processor and 9 yrs as a Quality assurance technician and was let go due to the economy in February 2007. During that time I’d always had a passion for the computing arena so after weighing my options and overcoming the fear that can [...] Read more
Ralph Cook
I’d just like to thank you and Global Information Technology for getting my career back on the right track. I had been unemployed for nearly 2 years after being laid off from ACCESS and I have been trying to find the right job. Couple months after applying to the unemployment, Michigan Works office approved me [...] Read more
Racha Ramdan
866-GO-GIT-GO