Lesson 9 of 14 • 48 upvotes • 9:38mins
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.
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