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 was fascinated to work as an IT Technology Professional since grade school, but I had no clue where to start. After graduating from a community college with a degree in Computer Information Systems, I still found myself confused to jump right into IT career without accruing sufficient amount of knowledge and hands on experience. [...] Read more
Ripon Uddin
I began taking the Windows 2000 MCSE track in June of 2001. I decided to check out GIT after hearing an ad on the radio, and after viewing the facilities I signed up immediately. I attended classes on Tuesdays and Thursdays until the class ended in February 2002. I chose the MCSE course because I [...] Read more
David Warner
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
I joined Global IT’s Software QA & Testing, Oracle 12c SQL, and Oracle JAVA SE 8 programming from February 2018 to June 23, 2018. The Director at Global Information Technology tailored my courses to fit my career path and goals. The QA Testing course was perfect timing for me as well as relevant to the [...] Read more
Gilbert Lopez
Global Information Technology: To whom it may concern: I was looking around for a training institution that offered Oracle 10g DBA program. I found only one school that offered this program at the best price and the right fit for me. The school name is Global Information Technology (Global I.T.). I still remember that moment [...] Read more
Vijaykumar Patel
866-GO-GIT-GO