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
This lecture will demonstrate the following :
Here, we will look at the different methods of naming cells and Ranges. These would include:
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
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.
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
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.