# Advance Excel Course for MIS (Batch-3) : 10 Hours of Live Interactive Classes!

• 10 Hours of Live interactive Classes
•  Live Practice session to clean the data.
• Creating Interactive Visualization of Data.
• Learn to create Interactive Dashboard.
• 50+ Advance Tricks and formulae for quick reporting.

### Why Safalta.com ?

Reasons to enroll with us

Live Interactive Sessions

Exclusive Mock Tests

Recorded Classes

Personalized Learning

Advance Excel Course for MIS (Batch-3) : 10 Hours of Live Interactive Classes!

The course includes Live Classes, Pdf Notes, Doubt Sessions, Case studies and much more. It covers advanced concepts as well as in-depth knowledge of all Advanced Excel Specialization. This course follows the latest pattern to enhance your learning.

Note : "Completion of Final Assessment is mandatory for Certification"

Module

Module 1: Overview of the Basic of Excel with Important Shortcuts (1 Hour)
Module 2: Using COUNTIF & COUNTIFS (1 Hour)
Module 3: Using SUMIF & SUMIFS (1 Hour)
Module 4: Data Validation (1 Hour)
Module 5: Working with Functions (VLOOKUP, VLOOKUP+COLUMNS) (1 Hour)
Module 6: Index & Match (1 Hour)
Module 7:  Offset Formula for Dynamic Lookup
Module 8: Charts, Dynamic charts (1 Hour)
Module 9: Macros (1 Hour)
Module 10: Creating a Dashboard (1 Hour)

Job Opportunities after Course

1. Data Analyst
2. MIS Analyst
3. Market Research Analyst
5. Financial Analyst
7. Cost Estimator.
8. Retail Store Manager
9. Accountants

1. The amount of data available is increasing day by day, so in order to comprehend it, you need to summarize and analyze it. This is only possible if you know the trick and skills of Advanced Excel.
2. Excel helps to analyze large amounts of data to discover trends and insights. With the use of graphs and charts, we can summarize the data and store it in an organized way.
3. Excel has lot of useful shortcuts that saves lot of time and improves productivity. Use of Macros also add to these benefits.
4.  With the help of features like Conditional Formatting in conjunction with various charts and graphs, we can identify trends and patterns easily.
Faculty

Mr. Rajat Johari
Advance Excel Faculty & MIS Analyst
Exp: 5+ Years

He has 5+ years of professional experience in the fields of Management of Information System, Data Analysis & Business Analysis.

With professional experience in the fields of MIS and Data Analysis as a Corporate Trainer. He has been associated with big organizations such as Tech Mahindra, Capgemini Noida with his skills and proficiency in the field of Advanced Excel.

He has trained more than 3000 students

Ques: Does this program cover practical Advanced Excel training?
Ans: Yes, we provide practical knowledge of Advanced Excel through assessments and industrial training.

Ques: What kind of job can I expect after this program?
Ans: MIS Analyst, Business Analyst, Market Research Analyst, Accountants, Retail Store Manager, Data Analyst, Administrative Assistant, Cost Estimator.

Ques: Does Safalta offer free demo classes for the Advanced Excel program?
Ans: Yes, you can attend a demo class free of cost.

Ques: What if we have any queries during training?
Ans: We have weekly doubt-clearing sessions for all our students and Mentorship sessions.

Ques: What if I miss any session?
Ans: Students will have access to pre-recorded sessions and the PDF notes.

Ques: When and how will I receive the certificate?
Ans: The certificate will be received post the completion of the course.

Ques: How to Connect with a support specialist team?

WhatsApp No:                93104 05008

Email Us : [email protected]

### Syllabus & Session plan

Best-in-class content by leading faculties and industry leaders in the form of videos, cases and projects

## Important Information

### Mode of instruction

Bilingual (Hindi+English) Classroom sessions

Microsoft Excel

### Target Audience

The course is designed for: Graduates/ Undergraduates, Professionals with 2- 3 years of Experience, Micro Entrepreneurs to be able to work in the Digital Marketing field.

2 PM to 3 PM

## Course Content

• Advance Excel Course for MIS (Batch 3)
10 lecture

Overview of the Basic of Excel with Important Shortcuts , Data Cleaning (1 Hour)

Overview of the Basic of Excel with Important Shortcuts , Data Cleaning (1 Hour) | By Rajat Sir

Using IF function, COUNTIF & COUNTIFS (1 Hour), SUMIF & SUMIFS

Using IF function, COUNTIF & COUNTIFS (1 Hour), SUMIF & SUMIFS | By Rajat Johari Sir

SUMIFS WITH WILD CARD CHARACTER

SUMIFS WITH WILD CARD CHARACTER | By Rajat Johari Sir

Working with Functions (VLOOKUP)

Working with Functions (VLOOKUP) | By Rajat Johari Sir

VLOOKUP + COLUMN , VLOOKUP + MATCH

VLOOKUP + COLUMN , VLOOKUP + MATCH | By Rajat Johari Sir

Index & Match (1 Hour)

Index & Match (1 Hour) | By Rajat Johari Sir

Pivot Table with Advance reporting | By Rajat Johari Sir

Data validation, Text to Column

Data validation, Text to Column | By Rajat Johari Sir

Charts, Dynamic charts (1 Hour)

Charts, Dynamic charts (1 Hour) | By Rajat Johari Sir

Dashboard

Dashboard | By Rajat Johari Sir
• Master Class
56 lecture

29 Jan 2022 Master Class 1

29 Jan 2022 Master Class 1 | By Surojit Mahato Sir, Digital Marketing Consultant

4 Feb 2022 कैसे बने समीर मोदी डिजिटल की दुनिया के सबसे ' Successful Founder' ?

4 Feb 2022 कैसे बने समीर मोदी डिजिटल की दुनिया के सबसे ' Successful Founder' ? | By Sameer Modi Sir

5 Feb 2022 Master Class 3

5 Feb 2022 Master Class 3 | By Amit Duggal Sir

12 Feb 2022 Master Class 4

12 Feb 2022 Master Class 4 | By Amit Duggal Sir

19 Feb 2022 Master Class 5

19 Feb 2022 Master Class 5 | By Mr. Shajan Samuel Sir

26 Feb 2022 Master Class 6

26 Feb 2022 Master Class 6 | By Ashok Sir

5 Mar 2022 Master Class 7

5 Mar 2022 Master Class 7 | By Arnab Roy Sir

12 Mar 2022 Master Class 8

12 Mar 2022 Master Class 8 | By Ankur Gupta Sir

26 Mar 2022 Master Class 9

26 Mar 2022 Master Class 9 | By Harish Sir

2 Apr 2022 The Secret Sauce to Creativity

2 Apr 2022 The Secret Sauce to Creativity | By Mr. Puneet Chawla Sir

9 Apr 2022 Master Session 11

9 Apr 2022 Master Session 11 | By Nishant Bhardwaj Sir

14 Apr 2022 Master Session 12

14 Apr 2022 Master Session 12 | By Saumya Pankaj Ma'am, Founder, The India Craft Project

16 Apr 2022 Master Session 13

16 Apr 2022 Master Session 13 | By Aastha Dabral Mam, Graphic Designer, BBC News

23 Apr 2022 It's Your time to grow through digital marketing

23 Apr 2022 It's Your time to grow through digital marketing | By Komal Baid Mam, CEO, KOKO Communications

29 Apr 2022 Graphic Design for Everyone

29 Apr 2022 Graphic Design for Everyone | By Divesh Sir

30 Apr 2022 Fast Track your career in Content Marketing, Content Creation and Blogging

30 Apr 2022 Fast Track your career in Content Marketing, Content Creation and Blogging | By Sanjay Dwivedi SIr

7 May 2022 Right Nutrition is the key to good health

7 May 2022 Right Nutrition is the key to good health | By Mam Pooja Makhija (Celebrity Nutritionist)

18 May 2022 New Age marketing, For the modern World

18 May 2022 New Age marketing, For the modern World | By Kamna Hazrati Mam (Entrepreneur Business Advisor and Consultant)

21 May 2022 Toon in to Careers in Animation Hear all about it from Sir Vinod A S.

21 May 2022 Toon in to Careers in Animation Hear all about it from Sir Vinod A S. (Vice President Academics, Toonz Animation)

28 May 2022 From Content Creator to Digital Stars Meet Manish Pandey India's Top content creator and Author

28 May 2022 From Content Creator to Digital Stars Meet Manish Pandey India's Top content creator and Author

6 June 2022 Master Session

6 June 2022 Master Session | By Tarun Sir

7 June 2022 Master session

7 June 2022 Master session | By Ashok Sir

8 June 2022 Master Session

8 June 2022 Master Session | By Shajan Sir

9 June 2022 Master Session

9 June 2022 Master Session | By Shajan Sir

10 June 2022 Graphic Design For Every One

10 June 2022 Graphic Design For Every One | By Sanjeev Singh Sir (Asst. Graphic Design Faculty)

16 June 2022 Master Class

16 June 2022 Master Class | By Ashok Sir

16 June 2022 Cracking the ice ceiling

16 June 2022 Cracking the ice ceiling I By Mam Baljeet Kaur

17 June 2022 Master Class

17 June 2022 Master Class | By Ashok Sir

18 June 2022 The Evolution of marketing over the past 5 years

18 June 2022 The Evolution of marketing over the past 5 years I By Mam Priyanka Bhatia

25 June 2022 Master Class Session on LinkedIn

25 June 2022 Master Class Session on LinkedIn | By Shajan Sir (CRO, Safalta.com)

2 July 2022 The power of PR and its impact on Brand Building

2 July 2022 The power of PR and its impact on Brand Building | By Dr. Pushyanti Shukla (Account Director at Adfactors PR )

9 July 2022 Master Class Session on LinkedIn

9 July 2022 Master Class Session on LinkedIn | By Shajan Sir (CRO, Safalta.com)

10 July 2022 Why Digital Marketing is a Core Skill?

10 July 2022 Why Digital Marketing is a Core Skill? | By Ashish Chauhan Sir

14 July 2022 Conventional vs Unconventional Careers How do you choose ?

14 July 2022 Conventional vs Unconventional Careers How do you choose ? | By Ma'am Vandana Vijay (UPSC CDR   AIR 1 | Founder and CEO at offbeat_Tracks | Ex-Facebook)

16 July 2022 Chai Pe Charcha

16 July 2022 Chai Pe Charcha | By Shajan Samuel Sir

23 July 2022 Master Class on Digital Marketing

23 July 2022 Master Class on Digital Marketing | By Sir Harish Pachouri | Marketing Head Amar Ujala Digital

6 Aug 2022 Transform Your Future With Digital Marketing

6 Aug 2022 Transform Your Future With Digital Marketing | By Sir Dr. Mayur Prasad

Case Study on Dunzo

Case Study on Dunzo | By Shajan Sir

Digital Revolution In India

Digital Revolution In India | By Ma'am Shweta Srivastava (Head of Digital Marketing for Global Markets, Dr. Reddy's)

Opportunities In Digital marketing

Opportunities In Digital marketing | By Ma'am Supriya Savre (Senior Manager, Digital Marketing)

MASTER CLASS ON MOCKUP DESIGNING

MASTER CLASS ON MOCKUP DESIGNING | By Divesh Sir

Master Class on Type of Masking

Master Class on Type of Masking | By Ishank Tomer Sir

Master class on Linkedln | By Shajan Samuel Sir

Master Class on Movie poster design

Master Class on Movie poster design | By Divesh Giri Sir

Matt Painting Design

Matt Painting Design | By Divesh Giri Sir

Resume Building Session

Resume Building Session | By Shajan Samuel Sir

Special Announcement

Special Announcement | By Safalta Team

Special Announcement

Special Announcement | By Himanshu Gautam (CEO & Co-Founder of Safalta)

The Design Language

The Design Language | By Dr. Balaji AC (Head of Department-Animation Manipal Academy of Higher education)

Chai Pe Charcha

Chai Pe Charcha | By Safalta Experts

Digital Marketing A New Frontier Abhinav Chetan

Digital Marketing A New Frontier Abhinav Chetan | By Safalta Experts

How To Develop A Winning Mindset

How To Develop A Winning Mindset | By Kapil Arora | CEO | Corporate Business Kisna Diamonds - HK Group

10 LESSONS I LEARNT IN THE LAST 10 YEARS | NEEL JADHAV

10 LESSONS I LEARNT IN THE LAST 10 YEARS | NEEL JADHAV | Ex Marketing Head Akasa Air

## Mock Test

Mock Tests are not available at present

## Demo Video

Demo videos are not available at present

## Ratings and Feedback

### Related Courses

##### Advance Excel for MIS: 10 Hours Course

Now at just ₹499 ₹129962% off

##### Advance Excel Weekend (Batch-1) : 10 Hours of Live Interactive Classes!

Now at just ₹499 ₹129962% off

##### Advance Excel Course for MIS (Batch-2) : 10 Hours of Live Interactive Classes!

Now at just ₹499 ₹129962% off