Lesson 2 of 14 • 210 upvotes • 5:36mins
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.
14 lessons • 1h 35m
Overview Of The Course: Microsoft Excel - From Beginner To Becoming A Pro
5:55mins
Introduction To Microsoft Excel
5:36mins
Creating Your First Worksheet
7:20mins
Changing The Layout Of A Worksheet
6:14mins
Formatting Data In A Worksheet
7:07mins
Sorting And Filtering Data In A Worksheet
7:13mins
Inserting Elements In A Worksheet
9:05mins
Working With Charts And Graphs
7:59mins
Inserting A Formulae In Worksheets
9:38mins
Exploring Functions In MS Excel
8:47mins
Exploring VLOOKUP With An Example
6:46mins
Learn How To Create Pivot Tables
4:48mins
How To Create Macros In MS Excel
3:52mins
Beyond Data In MS Excel
5:17mins