Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • 37 Hrs of High Quality e-Learning content
  • 155 demo's with example on application
  • 34 Chapter End Quizzes
  • 8 Simulation Exams
  • Prepare for FNFP, Excel 77-420, 77-428 Exam

Course description

  • What is this course about?

    Simplilearn’s training program Finance for Non-Financial professionals is ideal for managers to enhance their skills in the current competitive business environment.
    The program is designed to provide necessary knowledge to understand:
    • Fundamental financial concepts
    • Financial documents
    • Managing budgets
    • Analyzing financial performance
    This program aims to equip managers with a knowledge of critical financial principles and the right skills to deal with the ever-changing business needs of an organization.

  • Why is this certification most sought-after?

    The goal of any finance function includes promoting or creating a business, gaining assets and conducting market surveys, which will assist in determining product or service costs. As finance plays a vital role in business functions, the need for non-financial managers to obtain the requisite skills has become a necessity.

    Simplilearn’s Finance for Non-Financial Professionals training program will help in enabling all the non-financial managers to:
    • Comprehend relevant financial information within the organization.
    • Comprehend the impact of various business decisions on the organization’s performance.
    • Demonstrate an understanding of financial management and accounting
    • Communicate effectively with financial specialists

  • What learning benefits do you get from Simplilearn’s training?

    At the end of Simplilearn’s training in Finance for Non-Financial Professionals, you will be able to:
    • Control a financial system to meet business objectives
    • Use a range of financial controls
    • Understand the sources and availability of finance for an organization

  • What are the career benefits of this course?

    Finance for Non-Financial Professionals is a globally recognized professional certification that enhances the career prospects of non-financial managers. Career benefits of this course are as follows:
    • Enhances one’s proficiency in financial domain
    • Provides complete working knowledge of financial concepts
    • Ability as an employee of the Organization to handle financial objectives and decisions
    • Effective communication with Finance Managers
    According to the recent surveys by payscale.com, the median salary of a certified professional in this field is $82,563 per year. FNFP certified professionals are on great demand in companies across the world.

  • Who should do this course?

    Finance for Non-Financial Professionals program is conceptualized and developed for non-financial managers.

    This course is ideal for you if you’re a manager who is not from a financial and accounting background, and you need a basic foundation in key financial documents and processes.

  • Why choose Simplilearn for your training?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course preview

    • Lesson 00 - Course Introduction 03:39
      • 1.1 Introduction03:39
    • Lesson 01 - Introduction to Financial Statements 32:16
      • 1.1 Introduction01:12
      • 1.2 Objectives00:17
      • 1.3 Importance of Financial Measures01:09
      • 1.4 Definition of Financial Accounting01:08
      • 1.5 Principles And Objectives Of Financial Accounting03:29
      • 1.6 Other Principles of Financial Accounting03:42
      • 1.7 Definition of Management Accounting01:04
      • 1.8 Objectives of Management Accounting01:51
      • 1.9 Financial Accounting vs Management Accounting02:48
      • 1.10 Real Personal and Nominal Accounts02:03
      • 1.11 The Four Types of Accounts03:09
      • 1.12 Accounting Cycle02:09
      • 1.13 The Three Financial Statements03:01
      • 1.14 Accounting Conventions03:55
      • 1.15 Quiz
      • 1.16 Topics Covered01:19
    • Lesson 02 - Profit and Loss Account 22:52
      • 2.1 Introduction01:12
      • 2.2 Objectives00:17
      • 2.3 Profit and Loss Account02:51
      • 2.4 Profit and Loss Account — (Contd)04:56
      • 2.5 Elements of Profit and Loss Account03:02
      • 2.6 Elements of Profit and Loss Account (contd.)06:48
      • 2.7 Costs in Profit and Loss Account01:55
      • 2.8 Calculation of Retained Earnings01:13
      • 2.9 Quiz
      • 2.10 Topics Covered00:38
    • Lesson 03 - Balance Sheet 31:37
      • 3.1 Introduction00:43
      • 3.2 Objectives00:20
      • 3.3 Definition of Balance Sheet01:26
      • 3.4 Sources and Uses of Funds00:27
      • 3.5 Sources of Funds-Owner's Equity02:04
      • 3.6 Sources of Funds - Reserve and Surplus03:24
      • 3.7 Sources of Funds - Term Liabilities03:21
      • 3.8 Sources of Funds03:20
      • 3.9 Uses of Funds05:31
      • 3.10 Balance Sheet Format04:30
      • 3.11 Interrelationship with the Profit and Loss Account06:02
      • 3.12 Quiz
      • 3.13 Topics Covered00:29
    • Lesson 04 - Cash Flow 24:10
      • 4.1 Introduction00:52
      • 4.2 Objectives00:20
      • 4.3 Profit and Cash05:10
      • 4.4 Elements of Cash Flow06:09
      • 4.5 Managing Cash and Loans06:21
      • 4.6 Practical Applications of Cash Flow04:45
      • 4.7 Quiz
      • 4.8 Topics Covered00:33
    • Lesson 05 - Costing Decisions 23:40
      • 5.1 Introduction00:53
      • 5.2 Objectives00:17
      • 5.3 Accounting Information System 01:18
      • 5.4 Uses of Cost Data01:26
      • 5.5 Types of Cost01:11
      • 5.6 Variable and Fixed Cost — Examples01:01
      • 5.7 Elements of Cost01:54
      • 5.8 Cost Structure and Methods — Classification of Cost03:58
      • 5.9 Cost Structure and Methods — Costing Methods02:05
      • 5.10 Break - Even Point01:59
      • 5.11 Product Costing07:06
      • 5.12 Quiz
      • 5.13 Topics Covered00:32
    • Lesson 06 - Introduction to Financial Analysis 27:08
      • 6.1 Introduction00:42
      • 6.2 Objectives00:39
      • 6.3 What Financial Analysis00:29
      • 6.4 Steps of Financial Analysis01:53
      • 6.5 Use of Financial Analysis01:51
      • 6.6 Sources of Data01:49
      • 6.7 Financial Analysis in Practice01:48
      • 6.8 Financial Ratio Categories01:35
      • 6.9 Profitability Ratio03:37
      • 6.10 Return on Investment00:54
      • 6.11 Liquidity Ratios02:37
      • 6.12 Activity Ratios02:10
      • 6.13 Leverage Ratios03:08
      • 6.14 Other Ratios03:32
      • 6.15 Quiz
      • 6.16 Topics Covered00:24
    • Lesson 07 - Investment Appraisal 17:14
      • 7.1 Introduction00:33
      • 7.2 Objectives00:15
      • 7.3 Cash Flow and Relevant Costs01:04
      • 7.4 Calculating Incremental Cash Flow04:05
      • 7.5 Payback02:53
      • 7.6 Present Value and Discounting03:08
      • 7.7 Discounted Cash Flow02:07
      • 7.8 Sensitivity Analysis02:29
      • 7.9 Quiz
      • 7.10 Topics Covered00:40
    • Lesson 08 - Profit Margin 11:01
      • 8.1 Introduction00:32
      • 8.2 Objectives00:24
      • 8.3 Profit Margin Ratio02:29
      • 8.4 Comparison by Industry - Gross Profit Margin00:31
      • 8.5 Comparison by Industry - Net Profit Margin01:18
      • 8.6 Comparison by Industry - Operating Profit Margin00:48
      • 8.7 Profit Margins for Supermarkets01:15
      • 8.8 Supermarkets - Sub Category Profit Margin01:23
      • 8.9 Profit Margins for Aircraft Manufacturing Industry00:41
      • 8.10 Profit Margins Flowcharts00:55
      • 8.11 Quiz
      • 8.12 Topics Covered00:45
    • Lesson 09 - Asset Turnover 17:26
      • 9.1 Introduction00:26
      • 9.2 Objectives00:33
      • 9.3 Asset Turnover04:56
      • 9.4 Working Capital Ratios05:14
      • 9.5 Fixed Asset Turnover01:45
      • 9.6 Other Concepts00:34
      • 9.7 Analysis by Industry - Supermarket01:37
      • 9.8 Analysis by Industry - Aircraft Manufacturing01:42
      • 9.9 Quiz
      • 9.10 Topics Covered00:39
    • Lesson 10 - Return on Capital Employed 07:23
      • 10.1 Introduction00:39
      • 10.2 Objectives00:18
      • 10.3 Return on Capital Employed01:35
      • 10.4 Elements of ROCE - Net Operating Profit01:25
      • 10.5 Comparison of ROCE01:45
      • 10.6 Financial Analysis with ROCE00:58
      • 10.7 Quiz
      • 10.8 Topics Covered00:43
    • Course Feedback
      • Course Feedback
    • Lesson 00 - Overview of MOS Foundation 07:30
      • 0.1 Welcome00:07
      • 0.2 Overview of MOS Foundation01:00
      • 0.3 Table of Content00:52
      • 0.4 Course Objective00:30
      • 0.5 Course Overview00:57
      • 0.6 Value of Excel for Professionals00:41
      • 0.7 Value of Excel for Organizations00:40
      • 0.8 Lessons Covered00:15
      • 0.9 Exam Pattern00:30
      • 0.10 MOS Excel 2013 Level 1 Certification01:31
      • 0.11 Sources of Information00:18
      • 0.12 Thank you00:09
    • Lesson 01 - Introduction to Excel 2013 13:12
      • 1.1 Introduction to Excel 201300:22
      • 1.2 Objectives00:29
      • 1.3 Excel 2013 Application User Interface01:05
      • 1.4 Excel 2013 Application User Interface contd00:31
      • 1.5 Excel 2013 Application Window00:27
      • 1.6 Excel 2013 Application Window Elements01:41
      • 1.7 Ribbon Options00:49
      • 1.8 Business Scenario01:29
      • 1.9 Demo Summary00:20
      • 1.10 Quick Access Toolbar00:30
      • 1.11 Customize Quick Access Toolbar00:22
      • 1.12 Business Scenario01:25
      • 1.13 Demo summary00:23
      • 1.14 Backstage View in Excel 201300:26
      • 1.15 New Features in Excel 201301:46
      • 1.16 Quiz
      • 1.17 Summary01:03
      • 1.18 Thank You00:04
    • Lesson 02 - Create and Manage Workbooks and Worksheets 1:13:10
      • 2.1 Create and Manage Workbooks and Worksheets00:22
      • 2.2 Objectives00:26
      • 2.3 Excel 2013 Workbooks01:11
      • 2.4 Create a Blank Workbook00:31
      • 2.5 Create a Workbook from a Template00:38
      • 2.6 Open an Existing Workbook00:25
      • 2.7 Business Scenario02:36
      • 2.8 Demo Summary00:19
      • 2.9 Native and Non native Files02:15
      • 2.10 Connect Import External Files02:06
      • 2.11 Connect Import External Files contd01:08
      • 2.12 Business Scenario03:08
      • 2.13 Demo summary00:33
      • 2.14 Worksheet Operations01:28
      • 2.15 Change Worksheet Tab Color00:32
      • 2.16 Hide or Unhide Worksheets00:28
      • 2.17 Business Scenario02:35
      • 2.18 Demo summary00:14
      • 2.19 Search and Replace Data00:28
      • 2.20 Go To and Name Box00:38
      • 2.21 Business Scenario02:30
      • 2.22 Demo summary00:23
      • 2.23 Insert Hyperlinks00:58
      • 2.24 Business Scenario01:14
      • 2.25 Demo summary00:19
      • 2.26 Modifying Workbook Themes00:49
      • 2.27 Modify Page Setup01:19
      • 2.28 Insert and Delete Columns and Rows01:00
      • 2.29 Modify Row Height and Column Width00:44
      • 2.30 Hide or Unhide Columns and Rows00:24
      • 2.31 Business Scenario03:38
      • 2.32 Demo summary00:44
      • 2.33 Insert Headers and Footers00:38
      • 2.34 Insert Headers and Footers contd00:33
      • 2.35 Business Scenario02:08
      • 2.36 Demo summary00:21
      • 2.37 Data Validation01:49
      • 2.38 Data Validation contd01:04
      • 2.39 Business Scenario04:01
      • 2.40 Demo summary00:25
      • 2.41 Enable Developer Tab00:37
      • 2.42 Macro Security Options01:36
      • 2.43 Record Macros01:38
      • 2.44 Business Scenario03:43
      • 2.45 Demo summary00:33
      • 2.46 Backward Compatibility01:32
      • 2.47 Workbook Views01:05
      • 2.48 Use Zoom for Workbooks00:43
      • 2.49 Freeze Panes01:04
      • 2.50 Split Window00:22
      • 2.51 Business Scenario02:23
      • 2.52 Demo summary00:19
      • 2.53 Show Formulas00:23
      • 2.54 Business Scenario01:47
      • 2.55 Demo summary00:12
      • 2.56 Add Values to Workbook Properties00:33
      • 2.57 Business Scenario01:07
      • 2.58 Demo summary00:14
      • 2.59 Save Workbooks in Alternate File Formats01:24
      • 2.60 Set Print Area and Print Workbooks00:46
      • 2.61 Business Scenario01:43
      • 2.62 Demo summary00:23
      • 2.63 Save Workbooks to Remote Locations00:50
      • 2.64 Quiz
      • 2.65 Summary01:05
      • 2.66 Thank You00:06
    • Lesson 03 - Create Cells and Ranges 44:46
      • 3.1 Create Cells and Ranges00:25
      • 3.2 Objectives00:27
      • 3.3 Cells and Ranges01:02
      • 3.4 Create Data using FillSeries01:16
      • 3.5 Business Scenario01:45
      • 3.6 Demo Summary00:16
      • 3.7 Create Data using AutoFill00:54
      • 3.8 Business Scenario02:28
      • 3.9 Demo Summary00:15
      • 3.10 Customize AutoFill Options00:44
      • 3.11 Business Scenario02:43
      • 3.12 Demo Summary00:19
      • 3.13 Paste Options00:43
      • 3.14 Paste Special02:09
      • 3.15 Format Cell Structure01:30
      • 3.16 Business Scenario02:12
      • 3.17 Demo Summary00:11
      • 3.18 Merge and Center01:17
      • 3.19 Business Scenario00:51
      • 3.20 Demo Summary00:11
      • 3.21 Format Cell Content01:14
      • 3.22 Business Scenario01:33
      • 3.23 Demo Summary00:15
      • 3.24 Cell Styles01:00
      • 3.25 Business Scenario01:53
      • 3.26 Demo Summary00:13
      • 3.27 Number Formats01:54
      • 3.28 Format Painter00:28
      • 3.29 Business Scenario01:21
      • 3.30 Demo Summary00:12
      • 3.31 Data Model with Advanced Conditional Format01:41
      • 3.32 Data Model with Advanced Conditional Format contd00:30
      • 3.33 Sparklines01:11
      • 3.34 Business Scenario01:34
      • 3.35 Demo Summary00:12
      • 3.36 Create Named Ranges01:08
      • 3.37 Business Scenario02:32
      • 3.38 Demo Summary00:14
      • 3.39 Data Group and Ungroup01:17
      • 3.40 Subtotals01:11
      • 3.41 Quiz
      • 3.42 Summary01:27
      • 3.43 Thank You00:08
    • Lesson 04 - Create Tables 29:54
      • 4.1 Create Tables00:22
      • 4.2 Objectives00:22
      • 4.3 Tables in Excel 201300:58
      • 4.4 Create and Format a Table00:34
      • 4.5 Business Scenario01:08
      • 4.6 Demo Summary00:19
      • 4.7 Define Table Names00:32
      • 4.8 Business Scenario01:34
      • 4.9 Demo Summary00:17
      • 4.10 Insert Table Rows and Columns00:46
      • 4.11 Business Scenario02:16
      • 4.12 Demo Summary00:17
      • 4.13 Delete Table Rows and Columns00:48
      • 4.14 Business Scenario01:27
      • 4.15 Demo Summary00:22
      • 4.16 Move Table Rows and Columns00:19
      • 4.17 Business Scenario02:10
      • 4.18 Demo Summary00:29
      • 4.19 Convert to Range00:22
      • 4.20 Business Scenario01:06
      • 4.21 Demo Summary00:21
      • 4.22 Remove Duplicates00:15
      • 4.23 Business Scenario01:42
      • 4.24 Demo Summary00:19
      • 4.25 Design Table Styles00:37
      • 4.26 Business Scenario00:52
      • 4.27 Demo Summary00:16
      • 4.28 Table Style Options01:04
      • 4.29 Filter Tables00:41
      • 4.30 Business Scenario02:01
      • 4.31 Demo Summary00:23
      • 4.32 Sort Table Data01:20
      • 4.33 Business Scenario02:00
      • 4.34 Demo Summary00:22
      • 4.35 Quiz
      • 4.36 Summary01:08
      • 4.37 Thank You00:05
    • Lesson 05 - Apply Formulas and Functions 56:50
      • 5.1 Apply Formulas and Functions00:22
      • 5.2 Objectives00:27
      • 5.3 Formulas and Functions01:04
      • 5.4 Cell References and Ranges in Formulas01:53
      • 5.5 Cell References and Ranges in Formulas contd00:30
      • 5.6 Business Scenario01:53
      • 5.7 Demo Summary00:27
      • 5.8 Formula Calculations Order01:47
      • 5.9 SUM Function01:04
      • 5.10 Business Scenario01:04
      • 5.11 Demo Summary00:17
      • 5.12 COUNT Function00:51
      • 5.13 COUNTA Function00:46
      • 5.14 Business Scenario04:34
      • 5.15 Demo Summary00:17
      • 5.16 AVERAGE Function00:44
      • 5.17 MIN Function00:42
      • 5.18 MAX Function00:39
      • 5.19 Business Scenario02:08
      • 5.20 Demo Summary00:21
      • 5.21 Conditional Logic in Functions00:51
      • 5.22 SUMIF Function01:05
      • 5.23 SUMIFS Function01:35
      • 5.24 Business Scenario04:06
      • 5.25 Demo Summary00:22
      • 5.26 COUNTIF Function00:54
      • 5.27 COUNTIFS Function01:20
      • 5.28 Business Scenario03:00
      • 5.29 Demo Summary00:21
      • 5.30 AVERAGEIF Function01:06
      • 5.31 AVERAGEIFS Function01:37
      • 5.32 Business Scenario03:36
      • 5.33 Demo Summary00:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions01:31
      • 5.35 TRIM Function00:25
      • 5.36 Business Scenario04:23
      • 5.37 Demo Summary00:21
      • 5.38 LEFT Function01:02
      • 5.39 RIGHT Function01:01
      • 5.40 mid Function00:53
      • 5.41 Business Scenario03:37
      • 5.42 Demo Summary00:23
      • 5.43 Quiz
      • 5.44 Summary01:05
      • 5.45 Thank You00:05
    • Lesson 06 - Create Charts and Objects 35:40
      • 6.1 Create Charts and Objects00:22
      • 6.2 Objectives00:22
      • 6.3 Introduction to Charts02:14
      • 6.4 Create Charts00:35
      • 6.5 Create Charts contd00:28
      • 6.6 Create Charts contd00:33
      • 6.7 Business Scenario05:22
      • 6.8 Demo Summary00:19
      • 6.9 Format Charts00:51
      • 6.10 Format Charts contd00:39
      • 6.11 Business Scenario02:32
      • 6.12 Demo Summary00:16
      • 6.13 Move and Resize Charts00:32
      • 6.14 Business Scenario01:53
      • 6.15 Demo Summary00:16
      • 6.16 Recommended Charts00:40
      • 6.17 Business Scenario01:37
      • 6.18 Demo Summary00:17
      • 6.19 Introduction to Objects00:37
      • 6.20 Insert Picture Objects00:34
      • 6.21 Business Scenario01:50
      • 6.22 Demo Summary00:16
      • 6.23 Insert Other File Formats as Objects00:52
      • 6.24 Business Scenario02:47
      • 6.25 Demo Summary00:18
      • 6.26 Add Textboxes00:26
      • 6.27 Business Scenario02:29
      • 6.28 Demo Summary00:16
      • 6.29 Add SmartArt00:26
      • 6.30 Business Scenario03:13
      • 6.31 Demo Summary00:25
      • 6.32 Quiz
      • 6.33 Summary01:17
      • 6.34 Thank You00:06
    • Lesson 00 - Overview Of MOS Intermediate Course 07:18
      • 0.1 Welcome00:08
      • 0.2 Overview Of MOS Intermediate Course00:44
      • 0.3 Table Of Content00:53
      • 0.4 Course Objectives00:27
      • 0.5 Course Overview00:55
      • 0.6 Value Of Excel For Professionals00:38
      • 0.7 Value Of Excel For Organizations00:50
      • 0.8 Lessons Covered00:15
      • 0.9 Exam Pattern00:29
      • 0.10 Microsoft Excel 2013 Mos Intermediate Certification01:29
      • 0.11 Sources Of Information00:19
      • 0.12 Thank You00:11
    • Lesson 01 - Manage And Share Workbooks In Ms Excel 2013 18:17
      • 1.1 Manage And Share Workbooks In Ms Excel 201300:22
      • 1.2 Objectives00:21
      • 1.3 Share Workbooks00:59
      • 1.4 Shareworkbooks (Contd.)00:42
      • 1.5 Business Scenario00:58
      • 1.6 Demo Summary00:11
      • 1.7 Track Changes02:06
      • 1.8 Highlight Changes And Comments01:13
      • 1.9 Business Scenario02:16
      • 1.10 Demo Summary00:23
      • 1.11 Accept And Reject Changes01:01
      • 1.12 Business Scenario02:38
      • 1.13 Demo Summary00:16
      • 1.14 Formula Errors01:21
      • 1.15 Error Tracing00:55
      • 1.16 Business Scenario01:09
      • 1.17 Demo Summary00:16
      • 1.18 Quiz
      • 1.19 Summary00:59
      • 1.20 Thank You00:11
    • Lesson 02 - Apply Custom Formats and Layouts 43:17
      • 2.1 Apply Custom formats and layouts00:28
      • 2.2 Objectives00:28
      • 2.3 Create Custom Conditional formats00:56
      • 2.4 Conditional Formatting Rule Types01:32
      • 2.5 Business Scenario01:48
      • 2.6 Demo Summary00:14
      • 2.7 Formatting cells Using Formulas00:35
      • 2.8 Formatting Celis Using Formulas (contd.)00:31
      • 2.9 Business Scenario03:37
      • 2.10 Demo Summary00:20
      • 2.11 Manage Conditional Format Rules01:13
      • 2.12 Manage conditional format Rules (contd.)00:48
      • 2.13 Business Scenario04:08
      • 2.14 Demo Summary00:21
      • 2.15 Create Advance Filters by Search00:39
      • 2.16 Business Scenario02:12
      • 2.17 Demo Summary00:19
      • 2.18 Create Advance Filters Using Values00:18
      • 2.19 Business Scenario02:57
      • 2.20 Demo Summary00:24
      • 2.21 Create Advance Filters by Colors00:23
      • 2.22 Business Scenario01:04
      • 2.23 Demo Summary00:17
      • 2.24 Modify Worksheets with Accessibility Tools01:08
      • 2.25 Modify Worksheets with Accessibility Tools (Contd.)01:09
      • 2.26 Business Scenario00:57
      • 2.27 Demo Summary00:09
      • 2.28 Display Data in Multiple international Formats01:00
      • 2.29 Business Scenario01:14
      • 2.30 Demo Summary00:19
      • 2.31 Proofing in other languages00:50
      • 2.32 Proofing in Other languages (Contd.)00:38
      • 2.33 Business Scenario02:18
      • 2.34 Demo Summary00:19
      • 2.35 Use international symbols00:50
      • 2.36 Use international Symbols (contd.)00:28
      • 2.37 Business Scenario01:05
      • 2.38 Demo Summary00:17
      • 2.39 Manage body and heading fonts00:48
      • 2.40 Manage body and Heading fonts (contd.)00:24
      • 2.41 Business Scenario02:12
      • 2.42 Demo Summary00:20
      • 2.43 Quiz
      • 2.44 Summary01:09
      • 2.45 Thank You00:11
    • Lesson 03 - Create Advanced Formulas in Excel 2013 59:23
      • 3.1 Create Advanced Formulas in Excel 201300:22
      • 3.2 Objectives00:20
      • 3.3 LOOKUP Functions00:48
      • 3.4 VLOOKUP Function00:56
      • 3.5 Syntax Arguments in VLOOKUP Function02:28
      • 3.6 Business Scenario03:05
      • 3.7 Demo Summary00:10
      • 3.8 HLOOKUP Function00:46
      • 3.9 Syntax Arguments in HLOOKUP Function02:11
      • 3.10 Business Scenario02:58
      • 3.11 Demo Summary00:10
      • 3.12 LOOKUP Function01:03
      • 3.13 Syntax Arguments in LOOKUP Function02:06
      • 3.14 Business Scenario02:37
      • 3.15 Demo Summary00:11
      • 3.16 TRANSPOSE Function00:58
      • 3.17 Business Scenario01:58
      • 3.18 Demo Summary00:10
      • 3.19 TODAY and NOW Functions00:41
      • 3.20 Business Scenario01:34
      • 3.21 Demo Summary00:11
      • 3.22 DAY MONTH and YEAR Functions01:00
      • 3.23 Business Scenario02:58
      • 3.24 Demo Summary00:12
      • 3.25 HOUR MINUTE and SECOND Functions01:18
      • 3.26 Business Scenario03:08
      • 3.27 Demo Summary00:10
      • 3.28 DATEVALUE and TIMEVALUE Functions00:50
      • 3.29 Business Scenario02:15
      • 3.30 Demo Summary00:13
      • 3.31 CONCATENATE Function00:56
      • 3.32 WEEKDAY and WEEKNUM Functions00:46
      • 3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function01:09
      • 3.34 Business Scenario03:42
      • 3.35 Demo Summary00:14
      • 3.36 WORKDAY and WORKDAY INTL Functions02:11
      • 3.37 Business Scenario04:23
      • 3.38 Demo Summary00:16
      • 3.39 NETWORKDAYS and NETWORKDAYS INTL Functions01:51
      • 3.40 Business Scenario04:32
      • 3.41 Demo Summary00:27
      • 3.42 Quiz
      • 3.43 Summary01:03
      • 3.44 Thank you00:06
    • Lesson 04 - Create Advanced Charts in Excel 2013 26:43
      • 4.1 Create Advanced Charts in Excel 201300:26
      • 4.2 Objectives00:23
      • 4.3 Trendlines01:24
      • 4.4 Linear Trendline00:39
      • 4.5 Logarithmic Trendline00:54
      • 4.6 Polynomial Trendline01:07
      • 4.7 Power Trendline00:50
      • 4.8 Exponential Trendline00:45
      • 4.9 Moving Average Trendline01:02
      • 4.10 Business Scenario05:08
      • 4.11 Demo Summary00:21
      • 4.12 Chart Elements01:22
      • 4.13 Filters in Charts00:26
      • 4.14 Dual Axis Charts01:11
      • 4.15 Business Scenario04:09
      • 4.16 Demo Summary00:27
      • 4.17 Create Custom Chart Templates01:16
      • 4.18 Business Scenario02:49
      • 4.19 Demo Summary00:51
      • 4.20 Quiz
      • 4.21 Summary01:07
      • 4.22 Thank You00:06
    • Lesson 05 - Create and Manage PivotTables 49:06
      • 5.1 Create and Manage PivotTables00:21
      • 5.2 Objectives00:22
      • 5.3 PivotTables01:00
      • 5.4 Create PivotTables00:55
      • 5.5 Create PivotTables contd01:36
      • 5.6 Create PivotTables contd02:05
      • 5.7 Create PivotTables contd00:28
      • 5.8 Business Scenario02:04
      • 5.9 Demo Summary00:13
      • 5.10 Recommended PivotTables Button00:38
      • 5.11 Business Scenario01:07
      • 5.12 Demo Summary00:12
      • 5.13 Format Pivot tables
      • 5.14 Business Scenario02:18
      • 5.15 Demo Summary00:14
      • 5.16 Modify Field Headers00:52
      • 5.17 Business Scenario02:03
      • 5.18 Demo Summary00:14
      • 5.19 Change the View of Data00:45
      • 5.20 Group Records00:36
      • 5.21 Business Scenario01:59
      • 5.22 Demo Summary00:12
      • 5.23 Calculated Field and Calculated Item00:45
      • 5.24 Calculated Field and Calculated Item contd00:43
      • 5.25 Business Scenario02:44
      • 5.26 Demo Summary00:19
      • 5.27 Slicers01:06
      • 5.28 Slicers contd00:30
      • 5.29 Business Scenario02:10
      • 5.30 Demo Summary00:12
      • 5.31 View Chart Animations00:36
      • 5.32 Business Scenario02:38
      • 5.33 Demo Summary00:15
      • 5.34 Install PowerPivot Add in00:25
      • 5.35 Business Scenario01:12
      • 5.36 Demo Summary00:15
      • 5.37 PowerPivot00:45
      • 5.38 PowerPivot contd00:33
      • 5.39 Business Scenario00:53
      • 5.40 Demo Summary00:09
      • 5.41 PowerPivot Relationships00:53
      • 5.42 Create Relationship between Tables00:17
      • 5.43 Create Relationship between Tables contd01:10
      • 5.44 Business Scenario02:17
      • 5.45 Demo Summary00:15
      • 5.46 Edit and Delete Relationship00:15
      • 5.47 Business Scenario01:55
      • 5.48 Demo Summary00:16
      • 5.49 Create PowerPivot Hierarchy00:34
      • 5.50 Business Scenario01:32
      • 5.51 Demo Summary00:13
      • 5.52 Modify PowerPivot Hierarchy00:54
      • 5.53 Business Scenario00:59
      • 5.54 Demo Summary00:11
      • 5.55 Quiz
      • 5.56 Summary00:57
      • 5.57 Thank You00:04
    • Lesson 01 - Manage and Share Workbooks 35:27
      • 1.1 Introduction00:26
      • 1.2 Objectives00:57
      • 1.3 Modify Workbook Templates00:31
      • 1.4 - Business Scenario00:30
      • 1.5 Demo - Modify Workbook Templates01:27
      • 1.6 Merge Multiple Workbooks00:52
      • 1.7 Business Scenario00:30
      • 1.8 Demo - Merge Multiple Workbooks02:12
      • 1.9 Manage Multiple Versions Of A Workbook00:45
      • 1.10 Remove Workbook Metadata00:54
      • 1.11 Copy Styles Between Tables00:28
      • 1.12 Business Scenario00:27
      • 1.13 Demo - Copy Styles Between Templates00:51
      • 1.14 Copy Macros Between Workbooks00:35
      • 1.15 Business Scenario00:26
      • 1.16 Demo - Copy Macros Between Workbooks01:04
      • 1.17 External Data Connections01:13
      • 1.18 Business Scenario00:27
      • 1.19 Demo - External Data Connections02:26
      • 1.20 Protect Workbooks For Sharing00:25
      • 1.21 Business Scenario00:30
      • 1.22 Demo - Protect Workbooks For Sharing00:39
      • 1.23 Protect Worksheet Structure00:52
      • 1.24 Business Scenario00:32
      • 1.25 Demo - Protect Worksheet Structure01:01
      • 1.26 Set Tracking Options01:13
      • 1.27 Business Scenario00:25
      • 1.29 Restrict Editing And Limiting Editors00:35
      • 1.30 Business Scenario00:31
      • 1.31 Demo - Restrict Editing And Limiting Editors02:01
      • 1.32 Encrypt Workbooks With A Password00:48
      • 1.33 Business Scenario00:37
      • 1.34 Demo - Encrypt Workbook With A Password02:17
      • 1.35 Business Scenario00:32
      • 1.36 Demo - Mark Workbooks As Final00:45
      • 1.37 Control Calculations Options01:02
      • 1.38 Business Scenario00:30
      • 1.39 Demo - Control Calculations Options01:27
      • 1.40 - Summary00:55
      • 1.41 Mark Workbooks As Final00:49
      • 1.42 Quiz
    • Lesson 02 - Apply Custom Formats and Layouts 39:01
      • 2.1 Apply Custom Formats and LAyouts00:25
      • 2.2 Objectives00:49
      • 2.3 Create Custom Formats (number, Time, Date)06:14
      • 2.4 Business Scenario00:25
      • 2.5 Demo - Create Custom Formats Number Date02:48
      • 2.6 Create Custom Accounting Formats00:57
      • 2.7 Advanced Fill Series Options01:56
      • 2.8 Business Scenario00:32
      • 2.9 Demo - Advanced Fill Series Options02:01
      • 2.10 Create Custom Templates01:14
      • 2.11 Create And Modify Cell Styles00:57
      • 2.12 Business Scenario00:30
      • 2.13 Demo - Create And Modify Cell Styles03:06
      • 2.14 Create Custom Color Formats00:52
      • 2.15 Business Scenario00:24
      • 2.16 Demo - Create Custom Color Formats01:46
      • 2.17 Create Custom Font Formats00:40
      • 2.18 Business Scenario00:23
      • 2.19 Demo - Create Custom Font Formats02:41
      • 2.20 Create Themes00:37
      • 2.21 Business Scenario00:25
      • 2.22 Demo - Create Themes01:04
      • 2.23 Create Form Fields02:50
      • 2.24 Business Scenario00:29
      • 2.25 Demo - Create Form Fields03:11
      • 2.26 Control The Tab Order Of Objects00:56
      • 2.27 Summary00:49
      • 2.28 Quiz
    • Lesson 03 - Create Advanced Formulas 50:31
      • 3.1 Introduction00:26
      • 3.2 Objectives01:12
      • 3.3 Nested Functions01:06
      • 3.4 If, And, Or Functions01:49
      • 3.5 Business Scenario00:31
      • 3.6 Demo - If And Or Functions02:38
      • 3.7 Advanced Sumifs Function01:44
      • 3.8 Business Scenario00:40
      • 3.9 Demo - Advanced Sumifs Functions05:55
      • 3.10 Advanced Countifs Function01:18
      • 3.11 Business Scenario00:37
      • 3.12 Demo - Advanced Countifs Functions02:18
      • 3.13 Advanced Averageifs Function01:17
      • 3.14 Business Scenario00:36
      • 3.15 Demo - Advanced Averageifs Functions03:09
      • 3.16 What-if-analysis Tools01:32
      • 3.17 Watch Window01:06
      • 3.18 Business Scenario00:24
      • 3.19 Demo - Utilize Watch Window01:26
      • 3.20 Goal Seek00:55
      • 3.21 Business Scenario00:37
      • 3.22 Demo - Goal Seek01:10
      • 3.23 Create Scenarios01:32
      • 3.24 Business Scenario00:28
      • 3.25 Demo - Create Scenarios05:27
      • 3.26 Create Data Table02:32
      • 3.27 Business Scenario00:25
      • 3.28 Demo - Data Table00:41
      • 3.29 Consolidate Data01:39
      • 3.30 Business Scenario00:27
      • 3.31 Demo - Consolidate Data00:57
      • 3.32 Financial Functions02:55
      • 3.33 Summary01:02
      • 3.34 Quiz
    • Lesson 04 - Create Advanced Charts and Objects 16:25
      • 4.1 Introduction00:25
      • 4.2 Objectives00:31
      • 4.3 Pivotchart01:32
      • 4.4 Create New Pivotcharts04:17
      • 4.5 Business Scenario00:26
      • 4.6 Demo - Create New Pivotcharts01:32
      • 4.7 Pivotcharts With Animations00:38
      • 4.8 Business Scenario00:34
      • 4.9 Pivotcharts With Animations00:56
      • 4.10 Manipulate Options In Existing Pivotcharts00:48
      • 4.11 Business Scenario00:23
      • 4.12 Manipulate Options In Existing Pivotcharts01:34
      • 4.13 Pivotchart Styles00:36
      • 4.14 Business Scenario00:20
      • 4.15 Demo - Pivotcharts Styles01:22
      • 4.16 Summary00:31
      • 4.17 Quiz
    • Lesson 05 - Excel 2013 Advance New Features 23:45
      • 5.1 Introduction00:24
      • 5.2 Objectives00:38
      • 5.3 Introduction To Apps For Office04:17
      • 5.4 Installing Apps From Office Store00:48
      • 5.5 Business Scenario00:28
      • 5.6 Demo - Installing Apps From Office Store01:31
      • 5.7 Inserting And Managing Apps00:43
      • 5.8 Business Scenario00:27
      • 5.9 Demo - Inserting And Managing Apps01:14
      • 5.10 Timeline Filter01:59
      • 5.11 Business Scenario00:32
      • 5.12 Demo - Timeline Filter01:25
      • 5.13 Introduction To Powerview Report03:47
      • 5.14 Create Powerview Report01:00
      • 5.15 Business Scenario00:27
      • 5.16 Demo - Creating Powerview Reports01:03
      • 5.17 Powerview Reports Options01:17
      • 5.18 Business Scenario00:29
      • 5.19 Demo - Powerview Reports Option00:37
      • 5.20 Summary00:39
      • 5.21 Quiz
    • Lesson 06 - Creating Templates with Advanced Functions 38:58
      • 6.1 Introduction00:24
      • 6.2 Objectives00:57
      • 6.3 Creating Excel User Defined Templates01:05
      • 6.4 Business Scenario00:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates09:59
      • 6.6 Multiple List Box00:58
      • 6.7 Business Scenario00:37
      • 6.8 Demo 2 - Multiple List Box02:55
      • 6.9 Advanced Validation Rule With Isnumber00:41
      • 6.10 Business Scenario00:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber01:46
      • 6.12 Advanced Validation Rule With Istext00:38
      • 6.13 Business Scenario00:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext01:12
      • 6.15 Combine Date And Logical Functions00:36
      • 6.16 Business Scenario00:43
      • 6.17 Demo 5 - Combine Date And Logical Functions03:56
      • 6.18 Eomonth Function01:26
      • 6.19 Business Scenario00:30
      • 6.20 Demo 6 - Eomonth Function01:10
      • 6.21 Match Function03:06
      • 6.22 Business Scenario00:26
      • 6.23 Match Function00:37
      • 6.24 Business Scenario00:30
      • 6.25 Index With Match Function01:12
      • 6.26 ndex With Match Function00:55
      • 6.27 Summary00:48
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • What are the exam prerequisites for this course?

    There are no prerequisites to take up FNFP course. However, candidates should complete 2 days training programme and FNFP online course within a stipulated time. They are also expected to clear the sample test papers with minimum 72%, before they appear for the final examination.

  • What is the exam pattern?

    The exam format for FNFP course is as follows:
    • Multiple-choice questions
    • 25 questions with 1 mark for each question
    • 18 marks required to pass (out of 25)-72%
    • Exam duration is 60 minutes
    • Closed book formata

Reviews

Very flexible and easy to understand.

I am now more well versed with financial terms relevant to operating a business.

Excellent course that provided the information I was in need of.

Great course! This is the kind of information I really need at this point in my life when I'm moving on to finance domain.

This course from Simplilearn has provided me an insight into the basic concepts of accounting and finance. Now I can effectively communicate with the financial managers.

Read more Read less

This course is great in explaining how to become better equipped in financial domain. The structure of the course has been well planned - each lesson is presented with great clarity.

Read more Read less

Excellent learning experience.

FAQs

  • How do I enroll for the online training?

    You can enroll for the online training through our website. You can make online payment using any of the following options:
    • Visa debit/credit card
    • American Express and Diners Club cards
    • Master Card
    • PayPal
    Once the online payment is done, you will automatically receive payment receipt, via email.

  • What will I get along with this training?

    You will have access to the online e-learning and practice tests along with the training.

  • Can I cancel my enrollment? Do I get a refund?

    Yes! You can cancel your enrollment. We will provide you complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Can I extend the access period?

    Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • Do you provide any course completion certificate?

    Yes! We offer course completion certificate after you successfully complete the training program.

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.