COURSE OVERVIEW
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.
Advanced Excel Courses aid students in becoming world-class financial analysts in firms such as private equity, investment banking, equity research, corporate development, and Financial Planning and Analysis sectors.
Pre-requisite: Advanced Excel Courses aid students in becoming world-class financial analysts in firms such as private equity, investment banking, equity research, corporate development, and Financial Planning and Analysis sectors.
ADVANCED EXCEL COURSE MODULES
DESIGN AND RISK IN EXCEL
• Efficiency and Risk
• Data Validation
ADVANCED TECHNIQUES
• Array Formulae
• LOOKUP functions
• Advanced Range Names
• What If Analysis
• Problem Solving
EXCEL INTERACTIVITY
• Visual Basic and Macros
• VBA Programming
SPREADSHEET IMPACT
• Conditional Formatting
• Graphics Tricks and Techniques
TURNING DATA INTO DECISIONS
• Advanced Uses of PivotTables
• PowerPivot
• Reporting with PowerPivot
ADVANCED EXCEL COURSE RESOURCES
Click on the button below to access all exercises for this course
COURSE ORGANISATION & TIMING
This course is part of City & Guilds Qualifications
The course is modular. Courses are hands-on(25% theory, 75% practice)
- Monday - Friday (Between 10am - 5pm)
- Course Materials and Online Content Provided
- Duration is indicative and may include off-campus assignments and exams questions
- Flexible Timetable
- Special Packages + Payment Facilities
BENEFITS OF THIS COURSE
There are many benefits in taking an Advanced Excel course.
RELATED COURSES - ARTICLES
Why IT Kids?
Unleash Your Child’s Digital Potential This Summer with Fun, Hands-On IT Courses! As the summer holidays roll around, it’s time to think beyond the textbooks
THE BELBIN MODEL
The Belbin Model, also known as Belbin Team Roles, is a framework for understanding the roles individuals naturally adopt in a team setting. Developed in
Writing a Critical Appraisal
INTRODUCTION How do you write a critical appraisal? Many people find difficulties doing this at the end of their project or dissertation. A critical appraisal
PRIVACY IN THE MODERN WORLD
What is Privacy? It is the right of an individual to keep their personal information and activities from being disclosed to others without their consent. In our article, we shall review the following: What are the top risks to privacy today, What are the technical solutions to protect privacy, The legal aspect and what is GDPR, How privacy varies across cultures, How new technologies could challenge privacy in the future
7 Habits of Highly Effective IT Managers
In the dynamic world of Information Technology (IT), the role of IT managers has evolved from mere technical supervisors to strategic leaders. With the growing
SportsTech – New Technologies at FIFA 2022
A smart home is a residence that uses internet-connected devices to enable the remote monitoring and management of appliances and systems, such as lighting and heating.
GET IN TOUCH
Infoclub Ltd has proudly served IT Professionals seeking to enhace their skillsets with the latest certification in IT with excellence for over 30 years.
You can contact us through the following:
Email: Infoclubltd@yahoo.com
Phone & Whatsapp: +230 2411533
Or fill in the form on the right.
