Essentials of Financial Analysis using MS Excel
4.1 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
346 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Essentials of Financial Analysis using MS Excel to your Wishlist.

Add to Wishlist

Essentials of Financial Analysis using MS Excel

A best course to familiarize with all Ms Excel advanced concepts related to Financial analysis
4.1 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
346 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 5 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Appreciate the usage of Lookup functions – VLOOKUP and HLOOKUP
  • Explore Reverse Lookup techniques – using INDEX and MATCH
  • Handle formula related errors effectively and perform auditing on the same
  • Generate Pivot Tables and Charts from complex datasets, instantly
  • Explore the various components of Pivot Tables and Charts
  • Implement Slicers and Sparklines to build interactive dashboards
  • Learn the techniques to implement Sparklines in reports
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

This course takes the hands-on approach while getting familiarized with some of the Excel’s advanced concepts. The analysis and dash-boarding capabilities are hence practiced to the fullest.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Appreciate the usage of Lookup functions – VLOOKUP and HLOOKUP
  • Explore Reverse Lookup techniques – using INDEX and MATCH
  • Handle formula related errors effectively and perform auditing on the same
  • Generate Pivot Tables and Charts from complex datasets, instantly
  • Explore the various components of Pivot Tables and Charts
  • Implement Slicers and Sparklines to build interactive dashboards
  • Learn the techniques to implement Sparklines in reports

Each and every topic mentioned above are explained in detail in the Hands-on videos. Exercises and datasets included in this course are useful to practice and implement the concepts learned in this course. For your reference,additional materials are also provided

This course is is intended for the financial analysts and business users who are willing to explore the advanced tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

Who is the target audience?
  • It has been designed for professionals who wish to explore the practical usage of advanced Excel functions with financial data.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:42:25
+
Course Introduction
1 Lecture 02:18
+
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
1 Lecture 03:18
+
Reverse Lookup techniques – using INDEX and MATCH
1 Lecture 10:29
+
Effective Error handling – using ISERROR/IFERROR
1 Lecture 05:55
Effective Error handling – using ISERROR/IFERROR
05:55
+
Tracing formula dependents and precedents
1 Lecture 08:47
Tracing formula dependents and precedents
08:47
+
Using formula auditing tools to avoid errors
1 Lecture 04:13
+
Datasets
1 Lecture 00:02
Datasets
00:02
+
Creating Pivot Tables using complex datasets
1 Lecture 16:43
Creating Pivot Tables using complex datasets
16:43
+
Generating Pivot Charts Instantly
1 Lecture 15:26
Generating Pivot Charts Instantly
15:26
+
Implementing Slicers to build Interactive dashboards
1 Lecture 15:05
Implementing Slicers to build Interactive dashboards
15:05
7 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
1,982 Reviews
25,094 Students
51 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.