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!
After many months of searching for training with all the criteria and professionalism that I was looking for, I was fortunate enough to have been recommended to Global Information Technology. I followed up on the recommendation given to me and went to speak to a representative, who gave me a tour of the facility and [...] Read more
Leslie McKenzie
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
7/10/2018 I enjoyed working for Global Information Technology on project as well as at the class. The management is very helpful and approachable when needed. I got very good opportunity to learn new tools and technologies and also to implement them. They provide very good support for their students in determining their areas of interest, [...] Read more
Megha Kashinkunti
My name is Willie M. Williams, I became unemployed after nine years of service to one of the big three companies in April 2009. The majority of my department (ISS) was terminated indefinitely. I thought to myself, ok, I’ll just find another job in the IT field because I knew I had a Master’s degree [...] Read more
Willie M. Williams
I wish to thank GIobal Information Technology for helping me restart my career after taking a break of almost 8-9 years. During my career break, I had not kept my skills updated and before getting back into my career search, I decided to get re-trained. While researching the training institutions, in late 2009, I came [...] Read more
Nalini Sanku
866-GO-GIT-GO