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!
I am writing you this letting in praise of GIT, its wonderful staff and the learning experience I had in my time there. I have been an IT professional for 10+ years but never took the time to obtain any credentials or certifications along the way. When I finally decided it was time to do [...] Read more
De McCadney
September 28, 2021 The skills I obtained from the Project Management Professional and the Business Analyst class from GIT were phenomenal. After over a year off due to COVID pandemic, I was able to further my education with these two wonderful classes, which were cross functional for me as what I learned in the one [...] Read more
Annie M. Sadecki
I am writing this letter to inform you of my satisfaction with my son’s ( John Parkinson II) learning experience at Global Information Technology. He enrolled in your A+ , MCSE 2003 and CCNA programs in August 2007. The training provided by Global Information Technology became the foundation for his now growing IT career. After [...] Read more
John Parkinson II
9/30/2020 G.I.T, Global Information Technology, one the “stomping grounds”, for me to get a head-start in my career in IT was very foundational. Coming from where I did-nonetheless, how I did, this school was ‘almost’ like a sanctuary for me to tune in, stay focused, and connect with individuals from all walks of life pursuing [...] Read more
William Jones
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
866-GO-GIT-GO