Financial Data Analysis using Excel 2013
4.3 (8 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.
306 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Data Analysis using Excel 2013 to your Wishlist.

Add to Wishlist

Financial Data Analysis using Excel 2013

A Practical course explores the easy solutions to accurately analyze economic inputs and to financial data analysis
4.3 (8 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.
306 students enrolled
Created by GreyCampus Inc.
Last updated 12/2015
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 13 Articles
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
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
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
48 Lectures
05:36:09
+
Course Introduction
1 Lecture 03:44
+
Starting Microsoft Excel
6 Lectures 51:20

Understanding Cell References
13:06

The Backstage view - Analysis Perspective
10:36


Excel protection features (password Protecting sheets, and hiding Formula)
06:29

Exporting Excel data to other formats - CSV, PDF, and others
08:14
+
Mastering Conditional Functions
6 Lectures 01:06:19
Handling conditional structures using IF Functions Part 1
11:35


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
+
Datasets
1 Lecture 00:02
Datasets
00:02
+
Additional Material
1 Lecture 00:02
Additional Material
00:02
+
Exercises
1 Lecture 00:03
Exercises
00:03
+
Performing complex calculations efficiently
8 Lectures 01:00:24
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
+
Datasets
1 Lecture 00:02
Datasets
00:02
+
Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
5 Lectures 01:08:54
Creating Pivot Tables using complex datasets
18:06

Generating Pivot Charts Instantly
15:26

Implementing Slicers to build Interactive dashboards
15:05


Beautifying reports / tables using Sparklines
10:35
+
Datasets
1 Lecture 00:02
Datasets
00:02
10 More Sections
About the Instructor
GreyCampus Inc.
4.0 Average rating
1,982 Reviews
25,072 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.