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 attending GIT in January, 2008. Prior to this decision I researched several schools, and found that GIT offers so much more in class opportunities and is the most economical. I must be honest, I was quite apprehensive about going back to school; it had been along time since I attended any classes. However [...] Read more
Katrina Larmon
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
Dear Global Information Technology: If it were not for you my future in Information Technology would be completely uncertain. My name is Meontre and before Global IT I was working low paying side computer repair jobs and retail computer/computer part sales. During that time in my life I learned some minor basic computer stuff but [...] Read more
Meontre Byrd
After being laid-off and getting frustrated looking for work in the current market with outdated AS/400 and Mainframe skills, I decided to visit a few training providers to investigate some tech training to upgrade my skills set. The third one I visited was Global Information Technology. My first impression was very positive. The representative’s passionate [...] Read more
David Hamel
Global Information Technology is a fantastic place where I was able to learn & grow my skills and further my professional development. Despite the circumstances of 2020 and the classes being virtual, I was able to learn so much as the instructors were accommodating with everyone’s learning styles. I am grateful to Michigan Works! for [...] Read more
Snigdha Suvarna