B.Tech from NIT, Durgapur. Summer Intern at IIT Guwahati. UI/UX designer & front-end developer (HTML/CSS/Javascript).

Prasanta Kr Dutta

In today's world, Microsoft Excel has become highly important whether it is for research purpose, work purpose or for studying purpose. These lessons are created with an objective-focused approach, so that after every lesson, the students are able to accomplish a particular task. The depth of instruction is such that it is easy for a beginner to understand and expert to master. The general flow of the lessons is from basic to advanced which is synonymous with the difficulty levels. For someone already familiar with Excel, every lesson can be used as a standalone guide to accomplish a particular goal. 

Courses that would help you introspect and harness your innate potential. Watch them and garner skills that would take you a notch higher.

Personal Development

English

Microsoft Excel - From Beginner To Becoming A Pro

Microsoft Office 365

Tips & Tricks

Knowledge & Learning

Knowledge, Learning & Leadership

Personal and Skill Development

Develop your coding skills, learn a new language or prepare for campus placements and job interviews, you can do it all with these awesome courses.

This lesson talks about the overview of the course on Microsoft Excel which will teach you from basics to becoming a Pro at it. It begins with providing an objective as to what someone will gain out of this course, who all can benefit from this course along with the topics Prasanta would be covering in the upcoming lessons. 

Overview Of The Course: Microsoft Excel - From Beginner To Becoming A Pro

This lesson begins with providing a brief history of the Spreadsheets as well as Microsoft Excel. Thereby it is being discussed that why one should learn this software. In this lesson, Prasanta is providing basic information that one requires when one opens Microsoft Excel: the workbook, the rows, the columns, cell, name box, menu bar and formatting section. 

Introduction To Microsoft Excel

This lesson talks about how to create a worksheet. In a very basic and illustrative manner, Prasanta is explaining step wise procedure of the same. He is teaching how to add data to your worksheet, formatting the font, formatting the alignment. After the necessary changes, it is very important to save your work, which is explained in a very lucid manner in this lesson. Also, did you know that you can save your work in different formats? Well, watch this lesson to know more. 

Creating Your First Worksheet

The next step is changing the layout of your worksheet. But firstly you should know about what is a layout, what is themes panel for and how to use the same. Prasanta also talks about Page Setup Panel, Scale and Sheet options and Arrange Panel. All the features of Microsoft Excel are explained with the help of illustrations for a clearer understanding.

Changing The Layout Of A Worksheet

This lesson discusses why formatting of data is important in mIcrosoft Excel. Prasanta explains this entire topic with the help of examples. He covers topics like Format cells, Fill option, Heading Styles. He also throws light on Conditional formatting and various features available under this with the help of illustrations. 

Formatting Data In A Worksheet

This lesson talks about sorting data in a worksheet. The various features available under Sort and Filter: A to Z, Z to A and Custom Sort are being discussed along with real-time shots from excel. Thereby Prasanta talks about filtering data and searching data in the worksheet and how we can process the various features available under this. 

Sorting And Filtering Data In A Worksheet

Did you know that you can do a lot more than just adding numbers in a worksheet? Get to know about inserting various elements such as tables, pictures, shapes, smart art, graphs and much more. This lesson will help you in understanding the stepwise method of adding these to your worksheets with the help of illustrations and thereby also how each of these can be altered as per the requirements. 

Inserting Elements In A Worksheet

Learn how to create graphs and charts in this 10-minute lesson. This lesson will discuss the many features available while inserting a chart: the templates, the columns, the stock, the treemap and many more features. Thereby learn how to change the chart type, addition and removal of chart elements, formatting of data series with the help of illustration and examples. 

Working With Charts And Graphs

The calculation of a huge amount of data in Microsoft excel can be tedious. What one needs to find the correct formulae. In this lesson understand what is a formula and basics of an Excel formula. Learn how to fill the cells with consecutive numbers and inserting a formulae in cells. Prasanta also elaborates on relative referencing and absolute referencing. 

Inserting A Formulae In Worksheets

This lesson throws light on the certain functions of Microsoft excel such as calculating range between dates, splitting names, changing rows to columns, data validation and making decisions. Watch this lesson to understand why these features are important to learn, what they mean and how one can process them in MS Excel. All these are explained with the screenshots of Worksheet as well as examples.

Exploring Functions In MS Excel

This lesson discusses a very important function of Microsoft Excel, i.e. VLOOKUP. It elaborates on what is actually VLOOKUP and ion which all scenarios VLOOKUP can be used. This lesson explains the entire feature with the help of the example. Another feature of 'Error handling' is also discussed along with the real-time Excel Images. 

Exploring VLOOKUP With An Example

Pivot tables are a highly useful feature of Microsoft Excel. It helps to concise data and draw conclusions from a large variety of information. This lesson elaborates over what are actually Pivot Table, preparing data for Pivot Table, creating a Pivot table, designing Pivot Table layout with the help of examples and screenshot of Worksheets for a better understanding.

Learn How To Create Pivot Tables

This lesson throws light on what are macros and how to create them. This lesson has to be watched very carefully and Prasanta has explained this in a very lucid manner using a lot of examples and screenshots from Microsoft Excel. 

How To Create Macros In MS Excel

There is so much Microsoft Excel can do other than just adding data. This lesson talks about all those cool features. Did you know that 'Breathing City Map' by Darkhorse Analytics, Traditional Japnese Art by Tatsuo Horiuchi, 'Arena' video games by Cary  Walkin, 'Five Years of Fatalities' by IDV Solutions, 'Stop Motion Animation' by Jow Penna, all these were created by using various elements of MS Excel. Well, learn how all these were created and how even you can create something amazing using these features of Excel.  

Beyond Data In MS Excel

Tushar Mehra

This course helps in Learning to play guitar And high level musical theory in Just within 3 months.

(Hindi) Complete Guide to Guitar Extension

A mentor to 50k+ students- Anmol Sir's contribution to NEET UG is immense. Check out his classes to watch Biology unfold like never before!

Anmol Sharma

In this Session we will deal with how Unacademy helping students to achieve success in entrance exam.

(Hindi) How Unacademy Help in Learning

chemistry educator || M.Sc.-Chemistry , B.ed || 9 years teaching experince || referral code- "VISHWAUP10"|| Youtuber || JEE NEET 

Vishwa Vivek Sharma

In this course, the educator discusses a brief introduction about our famous Hindi poet Dr Kumar Vishwas. He will also present his best creation in Hindi literature.

(Hindi) Indian Poet: Dr Kumar Vishwas

I am a social worker in state government of Jammu and KASHMIR and counsel patients and their relatives about general health and well being.

Akhtar Ulnisa

The course gives a glimpse of the future options available to the students of class 10th who are about to chose a career stream in class 10 and looking forward to a bright career in either science, commerce or humanities

Streams to choose after Class X

Son, Value Investor, Liberal Arts, Serial Reader

Karan Shukla

Investment pertaining to the stock market has always remained as a challenging task. The stock market dynamics are very much unpredictable that brokers, analysts, and investors always tend to stay in a state of confused mindset. Hence to make one understand the reasons behind this and to reveal what does an investor think, why markets bubble and burst, right strategies to keep investment in the stock market in track, and much more such fascinating facts from the book Stocks to Riches which was written by Parag Parikh has been summarized by Karan. The summary is segregated into several topics and each topic will be discussed in separate lessons.

Book Summary: 'Stocks to Riches: Insights on Investor Behaviour by Parag Parikh'

Writer, Educator, Ex-IRS Officer, Author of books on 'Ethics, Integrity and Aptitude' & 'Essay and Answer Writing'  for UPSC Civil Services

Awdhesh Singh

This course provides the practical wisdom contained in Bhagavad Gita. Gita is the pride of India and it is also a part of Ethics paper in Civil Services. The course explains the complex philosophy of Gita in simple words that can be understood by anyone. Everyone would find the course useful to lead a better life.

Lessons

14 lessons • 1h 35m

Invalid Date

NaN

Overview Of The Course: Microsoft Excel - From Beginner To Becoming A Pro

Invalid Date

NaN

Introduction To Microsoft Excel

Invalid Date

NaN

Creating Your First Worksheet

Invalid Date

NaN

Changing The Layout Of A Worksheet

Invalid Date

NaN

Formatting Data In A Worksheet

Invalid Date

NaN

Sorting And Filtering Data In A Worksheet

Invalid Date

NaN

Inserting Elements In A Worksheet

Invalid Date

NaN

Working With Charts And Graphs

Invalid Date

NaN

Inserting A Formulae In Worksheets

Invalid Date

NaN

Exploring Functions In MS Excel

+ See all lessons