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!
June 2, 2020. Before Global Information Technology I found myself in a “great job market” with no callbacks on the dozens of applications I submitted to companies all over metro Detroit. I was in a particular bind because I had work experience AND a graduate degree, but all of the offers I received were well [...] Read more
Stephanie Holley
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
My name is Tiffanie Bradley; I was a Mainframe Programmer Analyst by profession and was laid off from Compuware Corporation in 2004. I have been in the Information Technology (IT) field for over 15 years and have experienced a successful career. Upon being laid off and seeking further employment, I recognized that my skills were [...] Read more
Tiffanie Bradley
May 28,2020. My experience with Global Information Technology has proven to be exceedingly beneficial. Through the VA VET TEC program and my attendance at Global IT, I was able to complete the IT Professional 4 courses. Along with the valuable training and resources that GIT has provided, I not only have a better understanding of [...] Read more
Rachel Smith
I was hired into Global I.T. late May, coming from three separate jobs that I had been working simultaneously. Manish gave me the chance to start with Global IT to pursue Office Assistant and also suggested that I take the MS Office Suites class that they offered. I was constantly surrounded by people that encouraged [...] Read more
Mieh Khatib