Smart Financial Functionalities of MS Excel 2013
0.5 (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.
322 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Smart Financial Functionalities of MS Excel 2013 to your Wishlist.

Add to Wishlist

Smart Financial Functionalities of MS Excel 2013

Explore the easy solutions to financial data analysis to increase business efficiency
0.5 (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.
322 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Current price: $10 Original price: $200 Discount: 95% off
1 day 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 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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
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
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
Expand All 17 Lectures Collapse All 17 Lectures 01:38:18
+
Course Introduction
1 Lecture 01:59
+
Designing Aged Reports and understanding data bucketing concepts
2 Lectures 19:45

Designing Aged Reports and understanding data bucketing concepts Part 2
09:32
+
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
1 Lecture 13:46
+
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
1 Lecture 05:51
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
05:51
+
Datasets
1 Lecture 00:02
Datasets
00:02
+
Building simple financial statements
1 Lecture 08:51
+
Financial Functions in Excel
1 Lecture 05:39
Financial Functions in Excel
05:39
+
Time value for money - Present Value, Future Value
1 Lecture 08:30
Time value for money - Present Value, Future Value
08:30
+
Calculating depreciation
1 Lecture 07:54
Calculating depreciation
07:54
+
Finding data co-relation of financial data and forecasting values
2 Lectures 19:18
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
6 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
1,723 Reviews
21,068 Students
42 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.