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!
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
While serving in the military I often found myself interested in pursuing a career within IT. Shortly after exiting the military, I started my journey and landed a position as an apprentice with a global consulting firm. I was quickly able to recognize that I was going to need more knowledge than just a web [...] Read more
Brian Cancel
I am a recent hire at CRC and subcontracted though the Department of Defense. This is the best job I have ever had my whole life thus far; and this is just the start of my Information Technology (IT) career. Previous to this I was a Sheet Metal fabricator at various sheet metal companies in [...] Read more
Jon Tarlo
I am writing this testimonial to express my utmost satisfaction and gratitude towards Global Information Technology for providing me with excellent training. My experience with Global IT has been nothing short of exceptional, and I wholeheartedly recommend their services to anyone seeking professional development in the field of information technology. From the moment I [...] Read more
Anita Singhal
I was faced with a layoff from my previous employer. Being in the auto industry really made me stop and think about my future. I have always enjoyed working with computers, so I started exploring my options. I was browsing the internet one evening and found Global Information Technology. My biggest concern was going back [...] Read more
Michael Kurtser