back Alerts

Advance Excel Weekend (Batch-1) : 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.
  • Access to data for Practice to have hands on the task.

Batch has started from : 29 Oct, 2022

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

Free Mentoring Session

Register here for free 30 mins mentoring session

Why Safalta.com ?

Reasons to enroll with us

feature img

Live Interactive Sessions

feature img

Exclusive Mock Tests

feature img

Recorded Classes

feature img

Personalized Learning

About

Advance Excel Weekend (Batch-1) : 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 learnings.
 
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 Dashboard. (1 Hour) 
 
Job Opportunities after Course
 
  1. Data Analyst
  2. MIS Analyst
  3. Market Research Analyst
  4. Business Analyst
  5. Financial Analyst
  6. Administrative Assistant.
  7. Cost Estimator.
  8. Retail Store Manager
  9. Accountants
 Why Advanced Excel?
 
  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 field of Management of Information System, Data Analysis & Business Analysis.

With professional experience in the field 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

 
Frequently asked questions
 
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 jobs 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?
Ans: Students can directly inquiry more about this course Via Enquiry No. / WhatsApp/ mail
 
Admission Enquiry No: 9810191192 
WhatsApp No:                9310405008 

Email Us : [email protected]
feature

Live Interactive Classes

feature

Special Q&A Sessions

feature

Downloadable Pdf Notes

feature

Weekly Mock Tests

feature

Access on Desktop & Mobile Both

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

Subject Covered

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.

Class Timings

11:00 AM to 1:00 PM

Our Team of Expert Faculties

Teacher Name

Mr. Rajat Johari

Course Content

  • 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

    Master class on Linkedln | By Shajan Samuel Sir

    Master Class on Movie poster design

    Master Class on Movie poster design | By Divesh Giri Sir

    Interaction With Sir Shubhankar Rai APAC Product Lead - App Ads at Google

    Interaction With Sir Shubhankar Rai APAC Product Lead - App Ads at Google

    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

    UI-UX DESIGN IN ILLUSTRATOR

    UI-UX DESIGN IN ILLUSTRATOR | By Ishank Sir

    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)

    LOGO DESIGN in Illustrator

    LOGO DESIGN in Illustrator | By Ishank Tomar

    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
  • Advance Excel Weekend (Batch-1)
    4 lecture

    Data Cleaning & Overview of the Basic of Excel with Important Shortcuts, Absolute references

    Data Cleaning & Overview of the Basic of Excel with Important Shortcuts, Absolute references | By Rajat Johari Sir

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

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

    Pivot Table for Advance reporting and connecting charts with Pivot

    Pivot Table for Advance reporting and connecting charts with Pivot | By Rajat Johari Sir

    VLOOKUP , VLOOKUP + COLUMN

    VLOOKUP , VLOOKUP + COLUMN | By Rajat Johari Sir

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 Course for MIS (Batch-3) : 10 Hours of Live Interactive Classes!
Advance Excel Course for MIS (Batch-3) : 10 Hours of Live Interactive Classes!

Now at just ₹499 ₹129962% off

Advance Excel Course for MIS: 10 Hours of Live Interactive Classes!
Advance Excel Course for MIS: 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!
Advance Excel Course for MIS (Batch-2) : 10 Hours of Live Interactive Classes!

Now at just ₹499 ₹129962% off

Please wait...