Adv. Certification in Advanced Excel

INTRODUCTION

Advanced Excel is a comprehensive course that provides a good insight into the latest and advanced features available in Microsoft Excel latest versions.

OBJECTIVE OF ADV. CERTIFICATION IN Advanced Excel

Learn the expert features and functions in Microsoft Excel alongside our expert trainers to help you get you beyond the basics and have advanced-level proficiency within the Excel.

COURSE OUTLINE OF ADV. CERTIFICATION IN Advanced Excel

• To take your basic Excel skills to the next level
• To be able to use Microsoft Excel in a commercial environment
• To gain a solid understanding of the more powerful features and functions in Excel

COURSE BREAKDOWN OF ADV. CERTIFICATION IN Advanced Excel

MODULE 1

Excel New Features

• Excel – Chart Recommendations
• Advanced Excel – Format Charts
• Advanced Excel – Chart Design
• Advanced Excel – Richer Data Labels
• Advanced Excel – Leader Lines
• Advanced Excel – New Functions

MODULE 2

Fundamental Data Analysis

• Excel – Instant Data Analysis
• Excel – Sorting Data By Color
• Advanced Excel – Slicers
• Advanced Excel – Flash Fill

MODULE 3

Powerful Data Analysis

• Excel – PivotTable Recommendations

MODULE 4

Powerful Data Analysis – 1

• Advanced Excel – Data Model
• Advanced Excel – Power Pivot
• Excel – External Data Connection
• Advanced Excel – Pivot Table Tools

MODULE 5

Powerful Data Analysis – 2

• Advanced Excel – Power View
• Advanced Excel – Visualizations
• Advanced Excel – Pie Charts
• Advanced Excel – Additional Features
• Advanced Excel – Power View Services
• Advanced Excel – Format Reports
• Advanced Excel – Handling Integers

MODULE 6

Other Features

• Advanced Excel – Templates
• Advanced Excel – Inquire
• Advanced Excel – Workbook Analysis
• Advanced Excel – Manage Passwords
• Advanced Excel – File Formats
• Excel – Discontinued Features

MODULE 7

Advanced Excel Useful Resources

• Advanced Excel – Quick Guide
• Advanced Excel – Useful Resources
• Advanced Excel – Discussion

BY THE END OF Advanced Excel COURSE,  STUDENTS WOULD BE ABLE TO

• To take your basic Excel skills to the next level
• To be able to use Microsoft Excel in a commercial environment
• To gain a solid understanding of the more powerful features and functions in Excel
• Breaks even the most complex applications down into simplistic steps.
• Visual training method, offering users increased retention and accelerated learning.

CAREER OPTIONS AFTER COURSE IN ADV. CERTIFICATION IN Advanced Excel

Students who complete this course have the following career options

• Data Analyst
• Metrics and Analytics Specialist

WHY TGC INDIA?

TGC India is a leading data analyst  Institute in Delhi with branches across the country. Among the numerous high level courses it offers Adv. Certification in Advanced Excel

It provides an educational environment that houses both local and foreign students who share ideas to develop their visual communication skills.

It boasts of well trained and highly experienced staff who are both friendly and courteous and ready to train using Live projects and the interactive learning system whose benefits outweigh online tutorials or self help books.

Upcoming Batches: