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!
This is just a note of thanks to you and your staff to express how pleased I am with the education I am receiving from Global Information Technology. In March, 2007 I was without employment for the second time within four months. Even though I had a Master of Arts Degree in Education, the lack [...] Read more
Debbie Leveski
I spent years working as an electrical technician for a tier one automotive supplier. Recently with the down turn with the big 3, my job like many others became very unstable and I spent a lot of time laid off or underemployed. After filing for unemployment for the third time that year I spoke with [...] Read more
Anthony Castleberry
I want to thank Global Information Technology for assisting with my job search and training needs. With the help of Michigan Works I was able to attend the Network Engineering Professional training class, consisting of CompTIA A+ and Network+, Microsoft desktop and server operating systems, Linux and Cisco CCNA. I am very impressed with all my teachers, [...] Read more
Weston Tatem
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
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
866-GO-GIT-GO