Smart Financial Functionalities of MS Excel 2013

Explore the easy solutions to financial data analysis to increase business efficiency
5.0 (1 rating) 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.
319 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 17
  • 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

Microsoft Excel comes with many built-in financial functions which perform many of the commonly used financial calculations. This course explores the easy solutions to financial data analysis and thus helps in increasing efficiency of business users.

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 data exploration utilities in Excel
  • Use ‘What-If-Analysis’ and Data representation techniques
  • 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?

  • Appreciate data exploration utilities in Excel
  • Use ‘What-If-Analysis’ and Data representation techniques
  • 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
01:59
Section 2: Designing Aged Reports and understanding data bucketing concepts
Designing Aged Reports and understanding data bucketing concepts
Preview
10:13
Designing Aged Reports and understanding data bucketing concepts Part 2
09:32
Section 3: Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
Preview
13:46
Section 4: Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
05:51
Section 5: Datasets
Datasets
Article
Section 6: Building simple financial statements
Building simple financial statements
Preview
08:51
Section 7: Financial Functions in Excel
Financial Functions in Excel
05:39
Section 8: Time value for money - Present Value, Future Value
Time value for money - Present Value, Future Value
08:30
Section 9: Calculating depreciation
Calculating depreciation
07:54
Section 10: Finding data co-relation of financial data and forecasting values
Finding data co-relation of financial data and forecasting values
12:56
Finding data co-relation of financial data and forecasting values Part 2
06:22
Section 11: Calculating Return of Investment, and depicting Breakeven
Calculating Return of Investment, and depicting Breakeven
06:19
Section 12: Datasets
Datasets
Article
Section 13: Additional Material
Additional Material
Article
Section 14: Exercises
Exercises
Preview
Article
Section 15: Mock Test
Mock Test
20 questions
Section 16: 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