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 started training at Global I.T. in January of 2002 with the Web Pro course, then after successfully completing that course, I elected to take the Java Pro. I liked my instructors because they were always willing to help before and after class, as well as by appointment. The material was good because it explained [...] Read more
Lisa Majewski
My name is Cedric Porties, and I am currently employed as a systems administrator for Electronic data Systems. I was made aware of Global Information Technology from a local computer magazine. After much speculation due to a situation from another private school I previously attended, I decided to go in and speak with a representative. [...] Read more
Cedric Porties
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
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland
I’d just like to thank Global IT for getting my career back on track. Before joining your school I was at a major crossroads in my life; I had depleted my unemployment benefits and was deciding on which direction to take my career. The economy was making companies close their doors and companies which did [...] Read more
Daniel Vitale