Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course uses a series of videos and downloadable materials to explain the use of statistical, logical,text etc functions in Microsoft Excel. No previous knowledge is needed as the basics are covered.
The Student will need a desktop of laptop computer with Microsoft Excel installed to get the best out of the course.
The course takes about 10 hours to complete if you just want to watch the videos but (and this is a big but) this is definitely not the approach that i encourage. Instead, the student is advised to download the Excel workbooks that i have included in the course and use them to follow through the videos with. This would give the student the hands-on approach that is most needed and in doing so get the best out of the course. This approach would take 10 days approximately. Remember the old saying that: The best teacher is practice.
I have broken down the course into summation, string, logical and statistical functions.
Understanding Excel Functions is the heart-beat to becoming a top level Data Analyst or Excel Developer
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Cell and Cell Ranges|
This lecture will demonstrate the following :
|We will look at the following in this lecture:
Here, we will look at the different methods of naming cells and Ranges. These would include:
More on Cells and Ranges Continue
|Section 2: The Count Function|
This video will cover the use of the count function in MS Excel. You will be able to use the function effectively in Excel after completing the course and following on with the downloadable material
Use of the counta function
Use of the countblank function
Use of the countif function
This function is used when you need to count rows in a given worksheet which meet more than 1 condition or criteria.For example to count the number of women (sex=female) and country of birth USA using data in a spreadsheet which has amongst other columns those of sex and nationality.
|Section 3: String Functions|
Use of the Upper,Lower,Concatenate and Proper function
Use of the Search and MID functions
Use of the LEN, LEFT,RIGHT and Rept functions
Use of the substitute function
Use of the Choose function
Use of the Trim function
Data manipulation continues
Data Manipulation Continues
Data Manipulation Continues
More On the Choose function
|Section 4: Intersection Functions|
The syntax and use of the Match function would be discussed exhaustively with many real world examples.
The syntax and use of the index function would be exhaustively discussed
Offset Function continues
The Range Intersection command
|Section 5: The Lookup Functions|
The Vlookup Function
The Vlookup Continues...
The HLookup Function
|Section 6: Ranking Functions|
The Rank Function
The Rank Function Continues
The Round, Product, Max and Min Functions
The Large, Small and Dollar functions
|Section 7: Logical Functions|
The IF function
The AND function
The Or Function
More on the OR function
|Section 8: Average Functions|
The Average Function
The AverageIf Function
The AverageIfs Function
The Avedev Function
The Averagea Function
|Section 9: Sum Functions|
The Sum Function
The Sumif Function
The Sumifs Function
The Sumproduct Function
Real World Scenarios
The SUMSQ, SUMX2PY2, SUMX2MY2 and the SUMXMY2 Functions
The SUBTOTAL Function
|Section 10: The Date and Time Functions|
Use the Text function
More use of the Text Function
Even More use of the Text Function
|Section 11: Bonus Lectures|
Dynamic Vertical Range
Horizontal Dynamic Range
Absolute and Relative Referencing Revisited
The Value Function
The N function
I am an electrical engineer and an IT professional. I hold a masters degree Computer Networks security and Programming. I am also a Microsoft Certified Personal (MCP) in a number of courses including Microsoft Excel at the Expert Level. I also hold the ECDL as an examiner.
I have worked as a Data Analyst for more than five years and in the process have developed all kinds spreadsheets / reports such as dashboards, using Excel as a backend to develop financial applications etc.
I have a solid understanding of mathematics and that has allowed me to be able to make the seemingly difficult concepts in Excel to be quite understandable to many of my colleagues that i have worked with over the years.
My experience in real life situations using microsoft Excel is certainly a key skill that my students will benefit from when they take my course.