Excel: Beginner to Advanced

Excel: Beginner to Advanced

Learn to manipulate complex data and derive insights through various visualization techniques by using the most popular tool and functions of Excel.
full starfull starfull starfull starhalf star
4.8
350+
Enrollments
7 weeks
Avg. Completion Time
Designed by experts from
Company Image 1Company Image 2Company Image 3
Offers on this course
  • Flat 50% off
  • Additional exclusive discount of 20% for SVAT clearers
₹16,555
₹33,110
Objective of this course

Excel is the most popular tool and a life skill that one must learn to survive in the corporate world irrespective of the department or the designation. Start from the basics and move up to learn advanced concepts and be able to automate daily redundant tasks and derive insights from data effortlessly. 

  • Learn to use formulas to perform complex calculations and derive insights from data
  • Automate daily tasks using macros and named ranges. And, present data through various visualization techniques.
  • Create interactive and beautiful dashboards for everyone to use with the help of pivots.
Syllabus for this course

Chapter

1

Kick Start Microsoft Excel

Understand the different features of the excel interface - navigation, selection of cells, and data entry along with basic calculations.

2h

Kick Start Microsoft Excel

Understand the different features of the excel interface - navigation, selection of cells, and data entry along with basic calculations.


video10 Video

quiz7 Quiz

Chapter

2

Working with formula

Learn to write the most frequently used excel functions in calculations such as SUM, AVERAGE, MAX, and MIN.

0h 50m

Working with formula

Learn to write the most frequently used excel functions in calculations such as SUM, AVERAGE, MAX, and MIN.


video5 Video

quiz4 Quiz

Chapter

3

Formatting

Learn the tools to format datasets using border formatting, alignment, cell, and font formatting. Insert pictures and learn to make them visually appealing in workbooks.

1h 10m

Formatting

Learn the tools to format datasets using border formatting, alignment, cell, and font formatting. Insert pictures and learn to make them visually appealing in workbooks.


video6 Video

quiz4 Quiz

Chapter

4

Modifying workbooks and worksheets

Learn the tools, techniques, and tricks to manage and structure the workbook. Conditional formatting will be taught in this chapter too.

1h 20m

Modifying workbooks and worksheets

Learn the tools, techniques, and tricks to manage and structure the workbook. Conditional formatting will be taught in this chapter too.


video6 Video

quiz5 Quiz

Chapter

5

Text and Date functions

This chapter will introduce you to some basic functions to work with dates and texts to extract relevant information.

0h 40m

Text and Date functions

This chapter will introduce you to some basic functions to work with dates and texts to extract relevant information.


video4 Video

quiz2 Quiz

Gain a competitive advantage

  • Excel as a certified professional

    Excel as a certified professional

    Earn a certificate upon completion

  • Access multi-format content

    Access multi-format content

    Learn via videos, projects, and more

  • Live-Classes by Experts

    Live-Classes by Experts

    Learn from the masters of industries

  • Get instant clarifications

    Get instant clarifications

    Resolve doubts immediately

Need more information?
Share your details. Don’t worry about spam. Our academic counselors will contact you within 24 hours.
Earn a certificate and boost your career
  • Be recognised by top 100+ hiring firms
  • Enhance your abilities and salaries
  • Scale up at work with a promotion
Sample Certificate

Testimonials

Anshul Gupta

Anshul Gupta

Flipkart

Frequently Asked Questions