A step-by-step video series that will help you get familiar with basics to intermediate concepts of Formula Building. Highly sophisticated Formulas can be built using Excel to get results most users might not even imagine. This course aims at helping students develop that logical thinking that would guide them in the right direction when it comes to Excel Formulas
The course starts with clarifying basics along with some Do's & Dont's while using Excel. It also spends some quality time to make students understands the power of Excel functions by themselves. It then moves ahead to teach how these functions can be used together to build Powerful Excel Formulas to derive some pretty complicated results.
I also touch base upon Array formulas, which is a pretty advanced concept.
In this course you will learn -
1) Usage of Excel functions
2) Basics of Building Formulas
3) Using functions to build complex Excel formulas
4) Array Formula Basics
5) Some helpful examples for hands on training along with other important Tips & tricks
The course contains easy to understand video lessons & other reading material and should take approximately 2 hours to finish. Easy to follow along with the help of exercise files that are provided with lessons wherever required for practice.
Those who have been using Excel and are looking learn some advanced stuff, this course will provide a good foundation to build upon.What are you going to get from this course?
Various parts of an Excel workbook explained, along with clarification of concepts like the functions library etc.
Different types of Cell references explained
Quiz On Different Types Of Cell References
Various types of Text Functions explained
Math and Stats Functions
Understand Date Calculations In Excel
Learn how Information Functions can be used
Some important things you should know to work with Excel efficiently
Which one of the two functions is not case-sensitive?
Seperate 1st & Last Names
Match used with Index
Usage of Indirect Function Explained
Usage of SumIFs with 4 criteria
Learn how to use Search, Iserror & IF functions together to assign code
Learn how to use the Lookup functions and also how to use True's & False's
Index & Match used with Col_Num argument as 0
Count only unique names from a list of Duplicate names
Lean how to use sumproduct. Also understand usage of double negatives.
Max used with IF
Earning money by teaching Microsoft Excel was never my primary objective, but helping people get better at it certainly was. I started off teaching Excel because of my love for Excel. Watching people do things for hours which could possibly be done in seconds used to pain me, and I could not help it but to go and help them steer in the right direction. The joy on their faces after seeing what Excel was capable of was something that amazed me.
Today, teaching Excel is a very important part of my life. I have conducted many training sessions is various companies in India along with numerous one on one training sessions to train 500+ individuals and helped them get better at Excel.
This one being my first online course, I am looking forward to interacting with quite a few students here and there from different parts of the world and help them get better at Microsoft Excel.