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 would like to take this opportunity to thank the entire team for providing the training and resources needed to get my career in Information Technology (IT) off to a great start. Having experienced a variety of jobs previously – including a stint as a Mortgage Officer for a large local Bank, and my prior [...] Read more
Garrett Mason
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
Global IT Changed My Life I remember the day I attended Global Information Technology. I met with the administrator who gave a lot of good information. My name is Larry Todd Sr. and I like to tell you about Global IT. Global IT really changed my life. If you are serious about starting a career, [...] Read more
Larry Todd
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 faced with a layoff from my previous employer. Being in the auto industry really made me stop and think about my future. I have always enjoyed working with computers, so I started exploring my options. I was browsing the internet one evening and found Global Information Technology. My biggest concern was going back [...] Read more
Michael Kurtser
866-GO-GIT-GO