Pre-Requisites: Microsoft Excel® 2010 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® 2010 Advanced skills.
Unit 1: Advanced functions
Unit 2: Lookups and data tables
Unit 3: Advanced list management
Unit 4: PivotTables and PivotCharts
Unit 5: Exporting and importing
Unit 6: Analytical options
Unit 7: Macros and custom functions
Unit 8: Conditional formatting and SmartArt
Real testimonials from our Students!
This is just a note of thanks to you and your staff to express how pleased I am with the education I am receiving from Global Information Technology. In March, 2007 I was without employment for the second time within four months. Even though I had a Master of Arts Degree in Education, the lack [...] Read more
Debbie Leveski
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
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
My name is Cedric Porties, and I am currently employed as a systems administrator for Electronic data Systems. I was made aware of Global Information Technology from a local computer magazine. After much speculation due to a situation from another private school I previously attended, I decided to go in and speak with a representative. [...] Read more
Cedric Porties
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
866-GO-GIT-GO