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 got married young, had two amazing boys. At age 31 I found myself at a low paying job as an Office Assistant that wasn’t challenging me at all. So I visited Global IT and met with the Director. After looking at my background and doing a personal assessment, he suggested I become a Business [...] Read more
Shazia Rashid
1/9/2025. The Business Data Analytics (BDA) course at Global Information Technology (GIT) was a game-changer for my career. The course provided me with in-depth knowledge of key technologies such as Power BI, SQL, and Advanced Excel, along with hands-on experience through real-world projects. The expert instructors and their practical approach helped me develop the skills [...] Read more
Tejaswini Mokashi
8/10/2017. My experience Global Information Technology was something I wouldn’t trade for the world. When I went there looking for A+ Training, I had been jobless for eight months. I was desperate to find something, anything that would change my life. Global Information Technology did just that. After completing the training program there, I actually [...] Read more
Wesley Cicotte
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
It gives me immense pleasure to recommend Global Technology Information (GIT) to any technical inclined person who is seeking to become a top-notch Information Technology Technician (ITT). GIT is a unique technology school that I had the pleasure of attending. It is true that it is dedicated to providing high quality and cost effective training [...] Read more
Eddie Henderson