Pre-Requisites: Microsoft Excel® 2013 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® 2013 Advanced skills.
Advanced functions and formulas
Lookups and data tables
Advanced data management
Advanced charting
PivotTables and PivotCharts
Exporting and importing data
Analytical tools
Macros and Visual Basic
Accessibility and language features
Real testimonials from our Students!
My name is Ruth Byrd. I would like to take this opportunity to convey the meaningful connections between my professional past and the skills that I acquired from the Global IT training experience. Too often we progress through the ‘ropes of life’ and do not invest the time to express our gratitude and authentic value [...] Read more
Ruth Byrd
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
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
“This was, by far, the best class experience I have had since high school. I took the COMPTA+ and Networking+ classes at Global Information Technology, and within a few months of completing these classes, I had a Level II Technical support position. The instructors were fantastic and really cared about my learning. If I had [...] Read more
Jonathan Nimene
I am writing this letter with the utmost sincerest appreciation, respect and regard for the staff and faculty at Global Information Technology. Words cannot express the gratitude I have for everything you have done for me. When I began at GIT, I was unsure about a few things: the means to reach my goal and [...] Read more
William Dicks
866-GO-GIT-GO