Excel Dashboard Reporting & Data Analysis

Excel Dashboard Reporting & Data Analysis

starstarstarstarstar_half 4.9 (105 ratings)

Language: English 


₹7999 88.12% OFF

₹950 including GST

 

LIFETIME ACCESS

4+ HOURS OF VIDEO

HD QUALITY CONTENT

RESPONSIVE DESIGN

CERTIFICATION

DOWNLOADABLE PDF

1. What is Excel Dashboard ?

Microsoft Excel is one of the most powerful & popular data analysis desktop application in the market today. Excel dashboard is used to display overview of large data tracks where elements like Tables, Charts & Gauges are used to show the overviews. The dashboards ease the decision making process by showing vital parts of data in the same window.

2. Who is this program for?

Experienced Microsoft Excel users who are looking to efficiently analyse large data sets & create dynamic dashboard reports.

Trainer profile

anjan banerjee

Microsoft Certified Office Specialist

Microsoft Excel Expert

Anjan, a highly experienced professional, holds certifications as a Microsoft Certified Office Specialist and Microsoft Certified Excel Expert. With a remarkable track record spanning over two decades, he specializes in training and consulting on a wide range of computer applications, such as Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Excel Dashboard, MS Power Query, Adobe Photoshop, Python Programming and many others.

Having a diverse background, Anjan is not only an expert in the Learning & Development field but also an entrepreneur. He possesses over a decade of corporate exposure in the Banking & Financial Services sector. In 2014, Anjan co-founded Infidea, an innovative organization at the forefront of the industry.

Anjan's teaching style revolves around creating engaging on-demand video lessons, attracting an impressive network of more than 25,000 active learners for his courses. He has successfully conducted various courses, accommodating different settings, from one-on-one interactions to large-scale groups of 100+ participants. His versatility is evident as he conducts live in-person classes, engaging webinar-style sessions online, and comprehensive live online courses. With his exceptional teaching skills and dedication, Anjan consistently garners top reviews for each course he delivers.

Course Curriculum

What will you learn

Powerful Lookup Functions

VLOOKUP(), INDEX()/MATCH()

Formatting Function

TEXT() Function

Function for Data Presentation

CHOOSE() Function

DATA SUMMARY
Learn to use Pivot Table & Pivot Charts

DYNAMIC CONTENT
Learn to use the magic of VBA Coding

INTERACTIVITY

Learn to create interactive & user friendly reports.

ADVANCED FILTER

Perform complex filtering with ease.

Course Feedback

FAQs

How do I sign up?

Once you make the payment, you will receive the credentials from our team to attend the same. As it is self paced learning with on-demand videos, you will need these credentials to join the training. You can attend this Masterclass from any Windows or Android based device - Laptop, Desktop, Tablet, Mobile, etc.

Do I have to take the course all at once?

The lessons are self-paced, online videos. Most of the videos are shorter in length and these are nicely organized by topic. Since the videos are short, we recommend watching one or two videos during your lunch break, or maybe one in the morning before you open your email. Each video lesson gets right to the point and packs in just enough information to allow you to learn and practice the techniques.

Why buy an online course when I can watch YouTube videos for free?

We look at it like building a house… If you just need to patch a roof or repair a leaky tap, then YouTube is an awesome way to learn. But what if you need to build the entire house? Where do you even start? Probably not with the roof. But other than that you would be doing a lot of searching and piecemeal learning to figure it out. This training course helps a learner connect the dots between “learning excel” and producing a work product that the business needs. We want to help people connect the dots between learning the new skill and getting a specific job done. Eventually, at the end, you need results and transformation.

What happens if I miss a class?

Don't Worry! These videos are designed for your Life Time access. You can view those videos at your own time, speed and convenience. So you will never miss a class.

What will be the teaching language?

Keeping in mind the majority of learners, it will be done in mix of Hindi and English. You will really find it easy to learn and enjoy the training since the course lessons are designed with simple yet in-depth explanations.

How do I contact customer support?

Drop in a mail to onlineservices@infidea.in and we shall be getting back to you.

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
Infidea 2024 Privacy policy Terms of use Contact us Refund policy