Essentials of Financial Analysis using MS Excel

A best course to familiarize with all Ms Excel advanced concepts related to Financial analysis
4.5 (2 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.
323 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 16
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course 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.

What are the requirements?

  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment

What am I going to get from this course?

  • 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

What is the target audience?

  • It has been designed for professionals who wish to explore the practical usage of advanced Excel functions with financial data.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Course Introduction
Preview
02:18
Section 2: Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
Preview
03:18
Section 3: Reverse Lookup techniques – using INDEX and MATCH
Reverse Lookup techniques – using INDEX and MATCH
Preview
10:29
Section 4: Effective Error handling – using ISERROR/IFERROR
Effective Error handling – using ISERROR/IFERROR
05:55
Section 5: Tracing formula dependents and precedents
Tracing formula dependents and precedents
08:47
Section 6: Using formula auditing tools to avoid errors
Using formula auditing tools to avoid errors
Preview
04:13
Section 7: Datasets
Datasets
Article
Section 8: Creating Pivot Tables using complex datasets
Creating Pivot Tables using complex datasets
16:43
Section 9: Generating Pivot Charts Instantly
Generating Pivot Charts Instantly
15:26
Section 10: Implementing Slicers to build Interactive dashboards
Implementing Slicers to build Interactive dashboards
15:05
Section 11: Grouping and Sub Total of Data in Pivots
Grouping and Sub Total of Data in Pivots
Preview
09:42
Section 12: Beautifying reports / tables using Sparklines
Beautifying reports / tables using Sparklines
10:03
Section 13: Datasets
Datasets
Article
Section 14: Additional Material
Additional Material
Article
Section 15: Exercises
Exercises
Preview
Article
Section 16: Mock Test
Mock Test
20 questions
Section 17: Course Conclusion
Review Appreciated!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., 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.

Ready to start learning?
Take This Course