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:
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.
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“.
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.
Along with above-discussed resources, you can also follow below resources (Blogs/ Discussions) to get updated with industry experts: