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
Course Number : MOUS-8-0202
Duration : 8 hours
Real testimonials from our Students!
In December 2008, I found myself parting ways with my employer of the last 22 years. I had become rather specialized in the Lotus Notes field and found that computer skill no longer in high demand and the entire IT job market rather depressed. Several months later, I became aware of Global Information Technology and [...] Read more
William Kolis
Manish – I am writing to say thank you. I thank God for Global Information Technology. I thank God for you, because you genuinely care about the direction of the student. I thank God for believing in me, for coaching me, and for helping me. I thank God for everyone at Global Information Technology for [...] Read more
Samar Gorial
Global Information Technology: To whom it may concern: I was looking around for a training institution that offered Oracle 10g DBA program. I found only one school that offered this program at the best price and the right fit for me. The school name is Global Information Technology (Global I.T.). I still remember that moment [...] Read more
Vijaykumar Patel
I am writing this letter to express my sincere gratitude for the expertise shared throughout my studies in Global Information Technology, a superior training institute. I am thankful to all of the hardworking individuals at Global Information Technology especially to my instructors and career advisor. I had Oracle 10g Database Administrator and ASP .Net courses [...] Read more
Jawahar Babu
I want to take this opportunity to tell how pleased I am with having selected Global Information Technology for my training. About six months ago I requested information from several schools in the Detroit area. After speaking with each of them I chose Global Information Technology. I found your staff very friendly and professional. Your [...] Read more
Mike McCain