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!
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
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
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
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
This letter is recognition of Global Information Technology for their outstanding computer training courses. I have been attending courses at GIobal IT and have recently completed my course work for Microsoft Office Professional. I found the experience to be both enriching and gratifying. The instruction was easy to follow and very thorough. I highly recommend [...] Read more
David Taylor