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!
Global IT Changed My Life I remember the day I attended Global Information Technology. I met with the administrator who gave a lot of good information. My name is Larry Todd Sr. and I like to tell you about Global IT. Global IT really changed my life. If you are serious about starting a career, [...] Read more
Larry Todd
I just wanted to express my feelings about Global Information Technology and their staff. First let me say I have never encountered an organization that cares about the students as much as GIT. After working many years for an automotive supplier in the auto industry I found myself unemployed, without a degree or any certifications [...] Read more
Aubrey Carvine
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 wanted to take an opportunity to provide an update on my career since deciding to take classes with Global Information Technology. As you know, after nearly 15 years with a major player in the field of IT solutions, I was laid off from my job in December of 2008. After taking stock of what [...] Read more
Robert Franklin
Having stagnated as an IT professional, as well as finding the demands in the market are for later technologies, it became evident that I had to re-tool to remain, indeed become, marketable. I needed a training venue that offered a breadth of curriculums, that was affordable, that was convenient and that was geared to the [...] Read more
Ray Hodge
866-GO-GIT-GO