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 this letter today in recommendation of Global Information Technology (GIT). In the spring of 2008 I learned that my employment position was being off-shored. Of course this was devastating news. Even though I possess a bachelor’s degree in Information Systems, I realized I did not specialize in any specific IT area and [...] Read more
Lynda Wilson
I am writing this letter with extreme gratitude and appreciation. In the early spring of 2006 I decided to embark on a journey of your Network Engineering program. I knew the program would take much time and effort on both my part and yours. Before I started this program I wanted to make sure that [...] Read more
Brandon Mytty
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
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
I would like to take this opportunity to thank the entire team for providing the training and resources needed to get my career in Information Technology (IT) off to a great start. Having experienced a variety of jobs previously – including a stint as a Mortgage Officer for a large local Bank, and my prior [...] Read more
Garrett Mason