Financial Analysis perspective of Excel 2013
2.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.
66 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Analysis perspective of Excel 2013 to your Wishlist.

Add to Wishlist

Financial Analysis perspective of Excel 2013

A Practical course helps to use Excel as a Financial Analysis Tool
2.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.
66 students enrolled
Last updated 1/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
Have a coupon?
What Will I Learn?
Understand Excel’s backstage view
Understand the primary concepts of Cell references – a must for writing formulas
Appreciate some of the frequently used functions in Excel
Explore the protection features of Excel
Work with conditional structures and related functions
Learn and implement nested functions
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

This course focuses on some of the best practices for using Excel as a financial analysis tool. Keep a close watch as we reveal some of the interesting facts and tricks of MS Excel 2013.

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:

  • Understand the primary concepts of Cell references – a must for writing formulas
  • Understand Excel’s backstage view
  • Appreciate some of the frequently used functions in Excel
  • Explore the protection features of Excel
  • Work with conditional structures and related functions
  • Learn and implement nested functions
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:56:49
+
Course Introduction
1 Lecture 02:10
+
Navigating worksheets
1 Lecture 06:10
+
Understanding Cell References
1 Lecture 13:06
+
The Backstage view - Analysis Perspective
1 Lecture 10:36
The Backstage view - Analysis Perspective
10:36
+
Printing Worksheets - Print Area, Headers /Footers
1 Lecture 05:41
+
Excel protection features (password Protecting sheets, and hiding Formula)
1 Lecture 06:29
Excel protection features (password Protecting sheets, and hiding Formula)
06:29
+
Exporting Excel data to other formats - CSV, PDF, and others
1 Lecture 07:06
+
Handling conditional structures using IF Functions
2 Lectures 20:31
Handling conditional structures using IF Functions Part 1
10:58

Handling conditional structures using IF Functions Part 2
09:33
+
Using Nested IF conditions
1 Lecture 09:03
Using Nested IF conditions
09:03
+
Using Operators with IF – AND, OR, NOT
1 Lecture 10:25
Using Operators with IF – AND, OR, NOT
10:25
7 More Sections
About the Instructor
GreyCampus Inc.
4.1 Average rating
1,630 Reviews
19,462 Students
37 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.