Microsoft Excel & Charting for Indian Students

Entry level course on Microsoft Excel spanning into more than three hours

Free of unnecessary expansion and dramatization, this course gives you knowledge on the core functionality of Excel. If you are a new bee to Excel, this course is just for you.

What you’ll learn

  • Learn the basics of Microsoft Excel including date arithmetic, looking up of data, sorting and filtering data..
  • Learn formatting the data beautifully with Microsoft Excel, including conditional formatting and cell styles..
  • Learn to use Excel in office environment for productivity and be noticed taking this course..
  • Learn the basic skills of Excel just spending a week on this three hours plus course and be proud of your Excel skills..
  • Learn how to make beautiful and well meaning Excel Chart, presenting actionable information..
  • Learn the basics of Microsoft Excel to eventually take advanced courses on Excel step by step..

Course Content

  • The Instructor –> 2 lectures • 2min.
  • The core course : Lecture 3 to 18 –> 16 lectures • 3hr 1min.
  • Graphs & Charts : Lecture 19 to 22 –> 4 lectures • 18min.
  • Extras –> 1 lecture • 14min.

Auto Draft

Requirements

  • There is no pre-requisite for this course, except that one should understand the language of instruction, which is English..
  • No previous experience in Excel is needed, you shall everything from the beginning step by step. Only requirement is you should not skip any step..

Free of unnecessary expansion and dramatization, this course gives you knowledge on the core functionality of Excel. If you are a new bee to Excel, this course is just for you.

After taking the course you shall be learning :

(a) Excel Environment ,
(b) Excel Short-cut Keys ,
(c) Naming of a Cell or Range of Cells,
(d) Absolute reference and relative reference ,
(e) Formatting of a Cell or a range of cells
(f) Excel Formatting tips for aesthetic presentation
(g)  Excel Operators,
(h) Date arithmetic with Excel,
(i) Working with Excel tables,
(j)  Auditing an Excel Spreadsheet,
(k)  Sorting and Sub-totaling of Data,
(l) Excel functions, mostly used functions only
(m)  Virtual lookup and nested if
(n) Circular reference
(o)  4 levels of protection in Excel
(p) Excel data validation
(q)  Picture Graphs
(r)  Other powerful graphs

There is a large downloadable Excel file associated with it, and can be used for practice.

If you are new bee you must first download the file and visit all the worksheets.
You should be able to connect the topics with the name of the worksheet intuitively.
Then you start taking the lesson keeping the Excel file opened in another tab.
This way you can learn the most.

Other exercises are also provided.

If you cannot understand a particular part revisit the lesson video again and then check it with the downloaded file.

The more you spread a spreadsheet, the better.
View it in full screen mode in Desktop, Laptop, Ipad or tablets.
Small screen mobile phones are not very good to view this course.

Happy learning !

 

 

Get Tutorial