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!
As a United States Army veteran, I participated in four (4) combat tours and a tour of duty to South Korea. I am a three (3) time veteran of Iraq, serving in various capacities in Operation Iraqi Freedom (OIF) I, III and Operation New Dawn (OND) which ended the war in Iraq in December 2011. [...] Read more
Christopher B. Amara, Jr.
US Army Veteran
This is an great day to say the educational experience has given me and my family an ultimate way knowing how lives can change through information as well as information technology. I don’t really have much to say on this matter because the challenges, the grinding work effort was a part of my personality since [...] Read more
Dell Williams
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 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
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
866-GO-GIT-GO