Financial Data Analysis using Excel 2013

A Practical course explores the easy solutions to accurately analyze economic inputs and to financial data analysis
4.1 (5 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.
296 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 48
  • Length 5.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 12/2015 English

Course Description

In this ever-changing business environment, being able to accurately analyze economic inputs is a critical skill for business users. Microsoft Excel comes with several built-in financial functions which perform many of the commonly used financial calculations.

Whether you are new to Excel or an advanced user, Grey Campus Excel courses will cover what you need to know to become an expert in using Microsoft Excel as a sophisticated Financial Analysis tool.

This is a practical course that explores the easy solutions to financial data analysis and thus helps in increasing efficiency of business users. It has been designed for professionals who wish to explore the practical usage of advanced Excel functions with financial data.

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

  • Appreciate some of the frequently used functions in Excel
  • Explore the protection features of Excel
  • Work with conditional structures and related functions
  • Explore the various components of Pivot Tables and Charts
  • Implement Slicers and Sparklines to build interactive dashboards
  • Explore Financial functions of MS Excel
  • Understand co-relation of financial data and forecast related values

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?

  • Explore the protection features of Excel
  • Work with conditional structures and related functions
  • Explore the various components of Pivot Tables and Charts
  • Implement Slicers and Sparklines to build interactive dashboards
  • Explore Financial functions of MS Excel
  • Understand co-relation of financial data and forecast related values

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
03:44
Section 2: Starting Microsoft Excel
Navigating worksheets
Preview
07:14
Understanding Cell References
13:06
The Backstage view - Analysis Perspective
10:36
Printing Worksheets - Print Area, Headers /Footers
Preview
05:41
Excel protection features (password Protecting sheets, and hiding Formula)
06:29
Exporting Excel data to other formats - CSV, PDF, and others
08:14
Section 3: Mastering Conditional Functions
Handling conditional structures using IF Functions Part 1
11:35
Handling conditional structures using IF Functions Part 2
Preview
09:33
Using Nested IF conditions
09:03
Using Operators with IF – AND, OR, NOT
10:25
Advanced Excel Functions – SUMIFS, COUNTIF, SUMPRODUCT and related functions
17:19
Creating Mega-Formula using multiple functions
08:24
Section 4: Datasets
Datasets
Article
Section 5: Additional Material
Additional Material
Article
Section 6: Exercises
Exercises
Article
Section 7: Performing complex calculations efficiently
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
04:55
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 2
14:09
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 3
09:21
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 4
01:30
Reverse Lookup techniques – using INDEX and MATCH
10:29
Effective Error handling – using ISERROR/IFERROR
05:55
Tracing formula dependents and precedents
08:47
Using formula auditing tools to avoid errors
05:18
Section 8: Datasets
Datasets
Article
Section 9: Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
Creating Pivot Tables using complex datasets
18:06
Generating Pivot Charts Instantly
15:26
Implementing Slicers to build Interactive dashboards
15:05
Grouping and Sub Total of Data in Pivots
Preview
09:42
Beautifying reports / tables using Sparklines
10:35
Section 10: Datasets
Datasets
Article
Section 11: Additional Material
Additional Material
Article
Section 12: Exercises
Exercises
Article
Section 13: Advanced Data Validation and Analysis (What-If-Analysis)
Designing Aged Reports and understanding data bucketing concepts
11:24
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
13:46
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
Preview
07:15
Section 14: Datasets
Datasets
Article
Section 15: Financial Forecasting and Capital Budgeting
Building simple financial statements
09:36
Financial Functions in Excel
05:39
Time value for money - Present Value, Future Value New
08:30
Calculating depreciation
07:54
Finding data co-relation of financial data and forecasting values
12:56
Calculating Return of Investment, and depicting Breakeven
06:49
Section 16: Datasets
Datasets
Article
Section 17: Additional Material
Additional Material
Article
Section 18: Exercises
Exercises
Article
Section 19: Mock Test
Mock Test
30 questions
Section 20: Course Conclusion
Review Appreciated!
Article
Quick Bonus for You!
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