Learn everything about Analytics

Home Best Resources to learn Microsoft Excel

Best Resources to learn Microsoft Excel

Step 0: Basics

Here, we are suggesting to go through the excel tutorial on GCFLearnFree.org. This tutorial has both video and text based content and it is designed for beginners only. This tutorial has following content:

  • Basics of Excel (Open, Save, New, Cell Basic, Formatting, Layouts)
  • Formula & Functions
  • Working with Data (Sort, Filter, Data Validation, Group/ Sub-total, Table)
  • Charts & Sparklines
  • Conditional Formatting, What-if Analysis

Step 1: More Functions

Excel has various functions to perform different operations like Financial, Text, Date & Time, Mathematical, Statistical, LookUp & Reference & More advanced functions. Excel Easy has explained these functions with examples and in a very simple manner.

Step 2: Advance Charts

Apart from these basic excel charts (Bar, Column, Line, Pie ..), we can plot more advanced charts also by playing with different chart metrics. Below is the list of advance excel charts with resources:

Additionally, you can also refer article written by Chandoo, “Select right chart for data representation“.

Step 3: Basics of VBA (Macro)

Here, I suggest you to have a basic understanding about VBA. It will help you to perform various tasks, those can not be performed directly by excel inbuilt functions. Excel-Pratique has designed a free Excel-VBA course for the beginners.

Step 4: Other Resources

Along with above-discussed resources, you can also follow below resources (Blogs/ Discussions) to get updated with industry experts:

 

Leave A Reply

Your email address will not be published.

Join 50,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.