The complete Financial Analyst course

10 weeks

Get the expertise and skills required to be hired as a Financial Analyst with this comprehensive course

Designed by
MRSPTU
4.0

Call us now

+91-788-9105509

9 am - 5 pm IST
60%
Minimum Salary Hike
150+
Students placed
4.8/5
Placement Reviews

Course Overview

Highlights:

What you'll learn

You will learn how to build a career in Finance with a toppaying entry-level job in the market. Acquire practical skills that will give you an edge over other candidates. Work comfortably with Microsoft Excel. Format spreadsheets in a professional way. Pick up speed in regular tasks. Create professional charts in Microsoft Excel. Work with large amounts of data easily. Understand Accounting and Bookkeeping principles.

Who is this course for?

Students and Learners interested in a career in Finance. Professionals wanting to strengthen their grip over the subject. Finance enthusiasts with no prior experience.

Potential Jobs in FInance

Financial Analyst, Financial Planning Manager

Lorem Ipsum it to make a type specimen book.

-MRSPTU

Course Modules

10 weeks

10+ online classes with offline logistics support

1000+ job openings

  • Microsoft Excel – Quick Introduction
  • Microsoft Excel: The World’s #1 Office Software
  • Excel Made Easy: A Beginner’s Guide to Excel Spreadsheets
  • Data Entry Techniques in Excel
  • How to Make Your Spreadsheets Look Professional
  • Data Entry Techniques in Excel
  • Inserting, Deleting, and Modifying Rows & Columns
  • Excel Formulas for Beginners
  • A Beginner’s Introduction to Excel Functions

  • Microsoft Excel – Useful Tools
  • Inserting a Line Break with Alt + Enter
  • Do More with Your Sales Data with Excel’s Text to Columns Feature
  • Do More with Your Sales Data with Excel’s Text to Columns Feature
  • Create Easily Printable Excel Documents
  • How to Wrap Text in Excel and Adjust a Cell’s Size
  • Insert Hyperlinks into Excel Spreadsheets
  • Using Excel’s Freeze Panes to Handle Large Datasets
  • Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do

  • Microsoft Excel – Beginner, Intermediate & Advanced Functions
  • Key Excel Functions: IF
  • Enlarge the Formula Bar
  • Key Excel Functions: SUM, SUMIF, SUMIFS
  • Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
  • Key Excel Functions: AVERAGE & AVERAGEIF
  • Working with Text in Excel
  • Find the Highest and Lowest Values in a Range: Max & Min

  • Microsoft Excel – Financial Functions in Excel
  • Discounting Cash Flows in Microsoft Excel
  • Calculating Internal Rate of Return (IRR) in Excel
  • Using the PMT Function to Create a Complete Loan Schedule

  • Microsoft Excel – Building Professional Charts in Excel
  • Introduction to Excel Charts
  • Beginner’s Guide to Inserting Charts in Excel
  • Modifying Excel Charts – The Easy Way
  • Making Your Excel Charts Sexier – Proven Tips
  • Creating a Bridge Chart in Excel 2016 – As Easy as It Gets
  • New Ways to Visualise Your Data – Treemap Charts

  • Microsoft Excel – Working with Pivot Tables in Excel
  • Pivot Tables – Excel’s Dynamic and Interactive Tables
  • Creating a Pivot Table: Choosing Row and Column Parameters
  • Design the Layout and Format of Your Pivot Tables
  • Additional Techniques That Will Ease Your Work with Pivot Tables
  • One of the Most Useful Excel Functions – GETPIVOTDATA
  • Welcome to the Future – Pivot Table Slicers

  • Modelling in Excel – Building a Complete 3-statement Mode
  • Building an Output P&L Sheet
  • Filling in the Output P&L Sheet with Historical Financials
  • Calculating Percentage Variances and Applying Conditional Formatting
  • Building an Output Balance Sheet
  • Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet

  • Accounting – Introduction to Accounting & Bookkeeping
  • Accounting: The Science Behind Financial Figures
  • What is Accounting and Why Do You Need It
  • The Importance of Bookkeeping – Good Accounting Records Are Essential
  • An Introduction to Financial Accounting

Know Your Mentor

Lorem Ipsum it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Proudly flaunt your Certification

on your Resume & on LinkedIn

  • Authentic Certification
  • Issued by the prestigious Maharaja Ranjit Singh Punjab Technical University
  • Universal Validity

Additional benefits of enrolling

Lorem Ipsum it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

How To Enroll

Step 1
Purchase Course Online

To take the firststep towards learning.

Step 2
Deposit Logistics Centre Fee

Visit your nearest JnanJug Logistics Centre and Deposit fee

Step 3
Access Course Content

Get accessto the learning modules and kickstart your learning journey with us.

Fee Structure

Course Fee (with offline logistics support)

INR 3999 + 1500

logistics support center fee is monthly basis*

Confused about the right Course for you?

Call us at +91-788-9105509

(or)

Drop in your number and we'll call you back

Browse more courses

Database Management Systems

6 weeks

Basics of Automobile Engineering

10 weeks

Computer Networks

8 weeks

Sign in to JnanJug

Need help logging in?