Finance for Non-Financial Managers Certification Training by Certified Experts | Simplilearn

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 Introduction 03:39
    • Lesson 01 - Introduction to Financial Statements 32:16
      • 1.1 Introduction 01:12
      • 1.2 Objectives 00:17
      • 1.3 Importance of Financial Measures 01:09
      • 1.4 Definition of Financial Accounting 01:08
      • 1.5 Principles And Objectives Of Financial Accounting 03:29
      • 1.6 Other Principles of Financial Accounting 03:42
      • 1.7 Definition of Management Accounting 01:04
      • 1.8 Objectives of Management Accounting 01:51
      • 1.9 Financial Accounting vs Management Accounting 02:48
      • 1.10 Real Personal and Nominal Accounts 02:03
      • 1.11 The Four Types of Accounts 03:09
      • 1.12 Accounting Cycle 02:09
      • 1.13 The Three Financial Statements 03:01
      • 1.14 Accounting Conventions 03:55
      • 1.15 Quiz
      • 1.16 Topics Covered 01:19
    • Lesson 02 - Profit and Loss Account 22:52
      • 2.1 Introduction 01:12
      • 2.2 Objectives 00:17
      • 2.3 Profit and Loss Account 02:51
      • 2.4 Profit and Loss Account — (Contd) 04:56
      • 2.5 Elements of Profit and Loss Account 03:02
      • 2.6 Elements of Profit and Loss Account (contd.) 06:48
      • 2.7 Costs in Profit and Loss Account 01:55
      • 2.8 Calculation of Retained Earnings 01:13
      • 2.9 Quiz
      • 2.10 Topics Covered 00:38
    • Lesson 03 - Balance Sheet 31:37
      • 3.1 Introduction 00:43
      • 3.2 Objectives 00:20
      • 3.3 Definition of Balance Sheet 01:26
      • 3.4 Sources and Uses of Funds 00:27
      • 3.5 Sources of Funds-Owner's Equity 02:04
      • 3.6 Sources of Funds - Reserve and Surplus 03:24
      • 3.7 Sources of Funds - Term Liabilities 03:21
      • 3.8 Sources of Funds 03:20
      • 3.9 Uses of Funds 05:31
      • 3.10 Balance Sheet Format 04:30
      • 3.11 Interrelationship with the Profit and Loss Account 06:02
      • 3.12 Quiz
      • 3.13 Topics Covered 00:29
    • Lesson 04 - Cash Flow 24:10
      • 4.1 Introduction 00:52
      • 4.2 Objectives 00:20
      • 4.3 Profit and Cash 05:10
      • 4.4 Elements of Cash Flow 06:09
      • 4.5 Managing Cash and Loans 06:21
      • 4.6 Practical Applications of Cash Flow 04:45
      • 4.7 Quiz
      • 4.8 Topics Covered 00:33
    • Lesson 05 - Costing Decisions 23:40
      • 5.1 Introduction 00:53
      • 5.2 Objectives 00:17
      • 5.3 Accounting Information System 01:18
      • 5.4 Uses of Cost Data 01:26
      • 5.5 Types of Cost 01:11
      • 5.6 Variable and Fixed Cost — Examples 01:01
      • 5.7 Elements of Cost 01:54
      • 5.8 Cost Structure and Methods — Classification of Cost 03:58
      • 5.9 Cost Structure and Methods — Costing Methods 02:05
      • 5.10 Break - Even Point 01:59
      • 5.11 Product Costing 07:06
      • 5.12 Quiz
      • 5.13 Topics Covered 00:32
    • Lesson 06 - Introduction to Financial Analysis 27:08
      • 6.1 Introduction 00:42
      • 6.2 Objectives 00:39
      • 6.3 What Financial Analysis 00:29
      • 6.4 Steps of Financial Analysis 01:53
      • 6.5 Use of Financial Analysis 01:51
      • 6.6 Sources of Data 01:49
      • 6.7 Financial Analysis in Practice 01:48
      • 6.8 Financial Ratio Categories 01:35
      • 6.9 Profitability Ratio 03:37
      • 6.10 Return on Investment 00:54
      • 6.11 Liquidity Ratios 02:37
      • 6.12 Activity Ratios 02:10
      • 6.13 Leverage Ratios 03:08
      • 6.14 Other Ratios 03:32
      • 6.15 Quiz
      • 6.16 Topics Covered 00:24
    • Lesson 07 - Investment Appraisal 17:14
      • 7.1 Introduction 00:33
      • 7.2 Objectives 00:15
      • 7.3 Cash Flow and Relevant Costs 01:04
      • 7.4 Calculating Incremental Cash Flow 04:05
      • 7.5 Payback 02:53
      • 7.6 Present Value and Discounting 03:08
      • 7.7 Discounted Cash Flow 02:07
      • 7.8 Sensitivity Analysis 02:29
      • 7.9 Quiz
      • 7.10 Topics Covered 00:40
    • Lesson 08 - Profit Margin 11:01
      • 8.1 Introduction 00:32
      • 8.2 Objectives 00:24
      • 8.3 Profit Margin Ratio 02:29
      • 8.4 Comparison by Industry - Gross Profit Margin 00:31
      • 8.5 Comparison by Industry - Net Profit Margin 01:18
      • 8.6 Comparison by Industry - Operating Profit Margin 00:48
      • 8.7 Profit Margins for Supermarkets 01:15
      • 8.8 Supermarkets - Sub Category Profit Margin 01:23
      • 8.9 Profit Margins for Aircraft Manufacturing Industry 00:41
      • 8.10 Profit Margins Flowcharts 00:55
      • 8.11 Quiz
      • 8.12 Topics Covered 00:45
    • Lesson 09 - Asset Turnover 17:26
      • 9.1 Introduction 00:26
      • 9.2 Objectives 00:33
      • 9.3 Asset Turnover 04:56
      • 9.4 Working Capital Ratios 05:14
      • 9.5 Fixed Asset Turnover 01:45
      • 9.6 Other Concepts 00:34
      • 9.7 Analysis by Industry - Supermarket 01:37
      • 9.8 Analysis by Industry - Aircraft Manufacturing 01:42
      • 9.9 Quiz
      • 9.10 Topics Covered 00:39
    • Lesson 10 - Return on Capital Employed 07:23
      • 10.1 Introduction 00:39
      • 10.2 Objectives 00:18
      • 10.3 Return on Capital Employed 01:35
      • 10.4 Elements of ROCE - Net Operating Profit 01:25
      • 10.5 Comparison of ROCE 01:45
      • 10.6 Financial Analysis with ROCE 00:58
      • 10.7 Quiz
      • 10.8 Topics Covered 00:43
    • Course Feedback
      • Course Feedback
    • Lesson 00 - Overview of MOS Foundation 07:30
      • 0.1 Welcome 00:07
      • 0.2 Overview of MOS Foundation 01:00
      • 0.3 Table of Content 00:52
      • 0.4 Course Objective 00:30
      • 0.5 Course Overview 00:57
      • 0.6 Value of Excel for Professionals 00:41
      • 0.7 Value of Excel for Organizations 00:40
      • 0.8 Lessons Covered 00:15
      • 0.9 Exam Pattern 00:30
      • 0.10 MOS Excel 2013 Level 1 Certification 01:31
      • 0.11 Sources of Information 00:18
      • 0.12 Thank you 00:09
    • Lesson 01 - Introduction to Excel 2013 13:12
      • 1.1 Introduction to Excel 2013 00:22
      • 1.2 Objectives 00:29
      • 1.3 Excel 2013 Application User Interface 01:05
      • 1.4 Excel 2013 Application User Interface contd 00:31
      • 1.5 Excel 2013 Application Window 00:27
      • 1.6 Excel 2013 Application Window Elements 01:41
      • 1.7 Ribbon Options 00:49
      • 1.8 Business Scenario 01:29
      • 1.9 Demo Summary 00:20
      • 1.10 Quick Access Toolbar 00:30
      • 1.11 Customize Quick Access Toolbar 00:22
      • 1.12 Business Scenario 01:25
      • 1.13 Demo summary 00:23
      • 1.14 Backstage View in Excel 2013 00:26
      • 1.15 New Features in Excel 2013 01:46
      • 1.16 Quiz
      • 1.17 Summary 01:03
      • 1.18 Thank You 00:04
    • Lesson 02 - Create and Manage Workbooks and Worksheets 1:13:10
      • 2.1 Create and Manage Workbooks and Worksheets 00:22
      • 2.2 Objectives 00:26
      • 2.3 Excel 2013 Workbooks 01:11
      • 2.4 Create a Blank Workbook 00:31
      • 2.5 Create a Workbook from a Template 00:38
      • 2.6 Open an Existing Workbook 00:25
      • 2.7 Business Scenario 02:36
      • 2.8 Demo Summary 00:19
      • 2.9 Native and Non native Files 02:15
      • 2.10 Connect Import External Files 02:06
      • 2.11 Connect Import External Files contd 01:08
      • 2.12 Business Scenario 03:08
      • 2.13 Demo summary 00:33
      • 2.14 Worksheet Operations 01:28
      • 2.15 Change Worksheet Tab Color 00:32
      • 2.16 Hide or Unhide Worksheets 00:28
      • 2.17 Business Scenario 02:35
      • 2.18 Demo summary 00:14
      • 2.19 Search and Replace Data 00:28
      • 2.20 Go To and Name Box 00:38
      • 2.21 Business Scenario 02:30
      • 2.22 Demo summary 00:23
      • 2.23 Insert Hyperlinks 00:58
      • 2.24 Business Scenario 01:14
      • 2.25 Demo summary 00:19
      • 2.26 Modifying Workbook Themes 00:49
      • 2.27 Modify Page Setup 01:19
      • 2.28 Insert and Delete Columns and Rows 01:00
      • 2.29 Modify Row Height and Column Width 00:44
      • 2.30 Hide or Unhide Columns and Rows 00:24
      • 2.31 Business Scenario 03:38
      • 2.32 Demo summary 00:44
      • 2.33 Insert Headers and Footers 00:38
      • 2.34 Insert Headers and Footers contd 00:33
      • 2.35 Business Scenario 02:08
      • 2.36 Demo summary 00:21
      • 2.37 Data Validation 01:49
      • 2.38 Data Validation contd 01:04
      • 2.39 Business Scenario 04:01
      • 2.40 Demo summary 00:25
      • 2.41 Enable Developer Tab 00:37
      • 2.42 Macro Security Options 01:36
      • 2.43 Record Macros 01:38
      • 2.44 Business Scenario 03:43
      • 2.45 Demo summary 00:33
      • 2.46 Backward Compatibility 01:32
      • 2.47 Workbook Views 01:05
      • 2.48 Use Zoom for Workbooks 00:43
      • 2.49 Freeze Panes 01:04
      • 2.50 Split Window 00:22
      • 2.51 Business Scenario 02:23
      • 2.52 Demo summary 00:19
      • 2.53 Show Formulas 00:23
      • 2.54 Business Scenario 01:47
      • 2.55 Demo summary 00:12
      • 2.56 Add Values to Workbook Properties 00:33
      • 2.57 Business Scenario 01:07
      • 2.58 Demo summary 00:14
      • 2.59 Save Workbooks in Alternate File Formats 01:24
      • 2.60 Set Print Area and Print Workbooks 00:46
      • 2.61 Business Scenario 01:43
      • 2.62 Demo summary 00:23
      • 2.63 Save Workbooks to Remote Locations 00:50
      • 2.64 Quiz
      • 2.65 Summary 01:05
      • 2.66 Thank You 00:06
    • Lesson 03 - Create Cells and Ranges 44:46
      • 3.1 Create Cells and Ranges 00:25
      • 3.2 Objectives 00:27
      • 3.3 Cells and Ranges 01:02
      • 3.4 Create Data using FillSeries 01:16
      • 3.5 Business Scenario 01:45
      • 3.6 Demo Summary 00:16
      • 3.7 Create Data using AutoFill 00:54
      • 3.8 Business Scenario 02:28
      • 3.9 Demo Summary 00:15
      • 3.10 Customize AutoFill Options 00:44
      • 3.11 Business Scenario 02:43
      • 3.12 Demo Summary 00:19
      • 3.13 Paste Options 00:43
      • 3.14 Paste Special 02:09
      • 3.15 Format Cell Structure 01:30
      • 3.16 Business Scenario 02:12
      • 3.17 Demo Summary 00:11
      • 3.18 Merge and Center 01:17
      • 3.19 Business Scenario 00:51
      • 3.20 Demo Summary 00:11
      • 3.21 Format Cell Content 01:14
      • 3.22 Business Scenario 01:33
      • 3.23 Demo Summary 00:15
      • 3.24 Cell Styles 01:00
      • 3.25 Business Scenario 01:53
      • 3.26 Demo Summary 00:13
      • 3.27 Number Formats 01:54
      • 3.28 Format Painter 00:28
      • 3.29 Business Scenario 01:21
      • 3.30 Demo Summary 00:12
      • 3.31 Data Model with Advanced Conditional Format 01:41
      • 3.32 Data Model with Advanced Conditional Format contd 00:30
      • 3.33 Sparklines 01:11
      • 3.34 Business Scenario 01:34
      • 3.35 Demo Summary 00:12
      • 3.36 Create Named Ranges 01:08
      • 3.37 Business Scenario 02:32
      • 3.38 Demo Summary 00:14
      • 3.39 Data Group and Ungroup 01:17
      • 3.40 Subtotals 01:11
      • 3.41 Quiz
      • 3.42 Summary 01:27
      • 3.43 Thank You 00:08
    • Lesson 04 - Create Tables 29:54
      • 4.1 Create Tables 00:22
      • 4.2 Objectives 00:22
      • 4.3 Tables in Excel 2013 00:58
      • 4.4 Create and Format a Table 00:34
      • 4.5 Business Scenario 01:08
      • 4.6 Demo Summary 00:19
      • 4.7 Define Table Names 00:32
      • 4.8 Business Scenario 01:34
      • 4.9 Demo Summary 00:17
      • 4.10 Insert Table Rows and Columns 00:46
      • 4.11 Business Scenario 02:16
      • 4.12 Demo Summary 00:17
      • 4.13 Delete Table Rows and Columns 00:48
      • 4.14 Business Scenario 01:27
      • 4.15 Demo Summary 00:22
      • 4.16 Move Table Rows and Columns 00:19
      • 4.17 Business Scenario 02:10
      • 4.18 Demo Summary 00:29
      • 4.19 Convert to Range 00:22
      • 4.20 Business Scenario 01:06
      • 4.21 Demo Summary 00:21
      • 4.22 Remove Duplicates 00:15
      • 4.23 Business Scenario 01:42
      • 4.24 Demo Summary 00:19
      • 4.25 Design Table Styles 00:37
      • 4.26 Business Scenario 00:52
      • 4.27 Demo Summary 00:16
      • 4.28 Table Style Options 01:04
      • 4.29 Filter Tables 00:41
      • 4.30 Business Scenario 02:01
      • 4.31 Demo Summary 00:23
      • 4.32 Sort Table Data 01:20
      • 4.33 Business Scenario 02:00
      • 4.34 Demo Summary 00:22
      • 4.35 Quiz
      • 4.36 Summary 01:08
      • 4.37 Thank You 00:05
    • Lesson 05 - Apply Formulas and Functions 56:50
      • 5.1 Apply Formulas and Functions 00:22
      • 5.2 Objectives 00:27
      • 5.3 Formulas and Functions 01:04
      • 5.4 Cell References and Ranges in Formulas 01:53
      • 5.5 Cell References and Ranges in Formulas contd 00:30
      • 5.6 Business Scenario 01:53
      • 5.7 Demo Summary 00:27
      • 5.8 Formula Calculations Order 01:47
      • 5.9 SUM Function 01:04
      • 5.10 Business Scenario 01:04
      • 5.11 Demo Summary 00:17
      • 5.12 COUNT Function 00:51
      • 5.13 COUNTA Function 00:46
      • 5.14 Business Scenario 04:34
      • 5.15 Demo Summary 00:17
      • 5.16 AVERAGE Function 00:44
      • 5.17 MIN Function 00:42
      • 5.18 MAX Function 00:39
      • 5.19 Business Scenario 02:08
      • 5.20 Demo Summary 00:21
      • 5.21 Conditional Logic in Functions 00:51
      • 5.22 SUMIF Function 01:05
      • 5.23 SUMIFS Function 01:35
      • 5.24 Business Scenario 04:06
      • 5.25 Demo Summary 00:22
      • 5.26 COUNTIF Function 00:54
      • 5.27 COUNTIFS Function 01:20
      • 5.28 Business Scenario 03:00
      • 5.29 Demo Summary 00:21
      • 5.30 AVERAGEIF Function 01:06
      • 5.31 AVERAGEIFS Function 01:37
      • 5.32 Business Scenario 03:36
      • 5.33 Demo Summary 00:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions 01:31
      • 5.35 TRIM Function 00:25
      • 5.36 Business Scenario 04:23
      • 5.37 Demo Summary 00:21
      • 5.38 LEFT Function 01:02
      • 5.39 RIGHT Function 01:01
      • 5.40 mid Function 00:53
      • 5.41 Business Scenario 03:37
      • 5.42 Demo Summary 00:23
      • 5.43 Quiz
      • 5.44 Summary 01:05
      • 5.45 Thank You 00:05
    • Lesson 06 - Create Charts and Objects 35:40
      • 6.1 Create Charts and Objects 00:22
      • 6.2 Objectives 00:22
      • 6.3 Introduction to Charts 02:14
      • 6.4 Create Charts 00:35
      • 6.5 Create Charts contd 00:28
      • 6.6 Create Charts contd 00:33
      • 6.7 Business Scenario 05:22
      • 6.8 Demo Summary 00:19
      • 6.9 Format Charts 00:51
      • 6.10 Format Charts contd 00:39
      • 6.11 Business Scenario 02:32
      • 6.12 Demo Summary 00:16
      • 6.13 Move and Resize Charts 00:32
      • 6.14 Business Scenario 01:53
      • 6.15 Demo Summary 00:16
      • 6.16 Recommended Charts 00:40
      • 6.17 Business Scenario 01:37
      • 6.18 Demo Summary 00:17
      • 6.19 Introduction to Objects 00:37
      • 6.20 Insert Picture Objects 00:34
      • 6.21 Business Scenario 01:50
      • 6.22 Demo Summary 00:16
      • 6.23 Insert Other File Formats as Objects 00:52
      • 6.24 Business Scenario 02:47
      • 6.25 Demo Summary 00:18
      • 6.26 Add Textboxes 00:26
      • 6.27 Business Scenario 02:29
      • 6.28 Demo Summary 00:16
      • 6.29 Add SmartArt 00:26
      • 6.30 Business Scenario 03:13
      • 6.31 Demo Summary 00:25
      • 6.32 Quiz
      • 6.33 Summary 01:17
      • 6.34 Thank You 00:06
    • Lesson 00 - Overview Of MOS Intermediate Course 07:18
      • 0.1 Welcome 00:08
      • 0.2 Overview Of MOS Intermediate Course 00:44
      • 0.3 Table Of Content 00:53
      • 0.4 Course Objectives 00:27
      • 0.5 Course Overview 00:55
      • 0.6 Value Of Excel For Professionals 00:38
      • 0.7 Value Of Excel For Organizations 00:50
      • 0.8 Lessons Covered 00:15
      • 0.9 Exam Pattern 00:29
      • 0.10 Microsoft Excel 2013 Mos Intermediate Certification 01:29
      • 0.11 Sources Of Information 00:19
      • 0.12 Thank You 00:11
    • Lesson 01 - Manage And Share Workbooks In Ms Excel 2013 18:17
      • 1.1 Manage And Share Workbooks In Ms Excel 2013 00:22
      • 1.2 Objectives 00:21
      • 1.3 Share Workbooks 00:59
      • 1.4 Shareworkbooks (Contd.) 00:42
      • 1.5 Business Scenario 00:58
      • 1.6 Demo Summary 00:11
      • 1.7 Track Changes 02:06
      • 1.8 Highlight Changes And Comments 01:13
      • 1.9 Business Scenario 02:16
      • 1.10 Demo Summary 00:23
      • 1.11 Accept And Reject Changes 01:01
      • 1.12 Business Scenario 02:38
      • 1.13 Demo Summary 00:16
      • 1.14 Formula Errors 01:21
      • 1.15 Error Tracing 00:55
      • 1.16 Business Scenario 01:09
      • 1.17 Demo Summary 00:16
      • 1.18 Quiz
      • 1.19 Summary 00:59
      • 1.20 Thank You 00:11
    • Lesson 02 - Apply Custom Formats and Layouts 43:17
      • 2.1 Apply Custom formats and layouts 00:28
      • 2.2 Objectives 00:28
      • 2.3 Create Custom Conditional formats 00:56
      • 2.4 Conditional Formatting Rule Types 01:32
      • 2.5 Business Scenario 01:48
      • 2.6 Demo Summary 00:14
      • 2.7 Formatting cells Using Formulas 00:35
      • 2.8 Formatting Celis Using Formulas (contd.) 00:31
      • 2.9 Business Scenario 03:37
      • 2.10 Demo Summary 00:20
      • 2.11 Manage Conditional Format Rules 01:13
      • 2.12 Manage conditional format Rules (contd.) 00:48
      • 2.13 Business Scenario 04:08
      • 2.14 Demo Summary 00:21
      • 2.15 Create Advance Filters by Search 00:39
      • 2.16 Business Scenario 02:12
      • 2.17 Demo Summary 00:19
      • 2.18 Create Advance Filters Using Values 00:18
      • 2.19 Business Scenario 02:57
      • 2.20 Demo Summary 00:24
      • 2.21 Create Advance Filters by Colors 00:23
      • 2.22 Business Scenario 01:04
      • 2.23 Demo Summary 00:17
      • 2.24 Modify Worksheets with Accessibility Tools 01:08
      • 2.25 Modify Worksheets with Accessibility Tools (Contd.) 01:09
      • 2.26 Business Scenario 00:57
      • 2.27 Demo Summary 00:09
      • 2.28 Display Data in Multiple international Formats 01:00
      • 2.29 Business Scenario 01:14
      • 2.30 Demo Summary 00:19
      • 2.31 Proofing in other languages 00:50
      • 2.32 Proofing in Other languages (Contd.) 00:38
      • 2.33 Business Scenario 02:18
      • 2.34 Demo Summary 00:19
      • 2.35 Use international symbols 00:50
      • 2.36 Use international Symbols (contd.) 00:28
      • 2.37 Business Scenario 01:05
      • 2.38 Demo Summary 00:17
      • 2.39 Manage body and heading fonts 00:48
      • 2.40 Manage body and Heading fonts (contd.) 00:24
      • 2.41 Business Scenario 02:12
      • 2.42 Demo Summary 00:20
      • 2.43 Quiz
      • 2.44 Summary 01:09
      • 2.45 Thank You 00:11
    • Lesson 03 - Create Advanced Formulas in Excel 2013 59:23
      • 3.1 Create Advanced Formulas in Excel 2013 00:22
      • 3.2 Objectives 00:20
      • 3.3 LOOKUP Functions 00:48
      • 3.4 VLOOKUP Function 00:56
      • 3.5 Syntax Arguments in VLOOKUP Function 02:28
      • 3.6 Business Scenario 03:05
      • 3.7 Demo Summary 00:10
      • 3.8 HLOOKUP Function 00:46
      • 3.9 Syntax Arguments in HLOOKUP Function 02:11
      • 3.10 Business Scenario 02:58
      • 3.11 Demo Summary 00:10
      • 3.12 LOOKUP Function 01:03
      • 3.13 Syntax Arguments in LOOKUP Function 02:06
      • 3.14 Business Scenario 02:37
      • 3.15 Demo Summary 00:11
      • 3.16 TRANSPOSE Function 00:58
      • 3.17 Business Scenario 01:58
      • 3.18 Demo Summary 00:10
      • 3.19 TODAY and NOW Functions 00:41
      • 3.20 Business Scenario 01:34
      • 3.21 Demo Summary 00:11
      • 3.22 DAY MONTH and YEAR Functions 01:00
      • 3.23 Business Scenario 02:58
      • 3.24 Demo Summary 00:12
      • 3.25 HOUR MINUTE and SECOND Functions 01:18
      • 3.26 Business Scenario 03:08
      • 3.27 Demo Summary 00:10
      • 3.28 DATEVALUE and TIMEVALUE Functions 00:50
      • 3.29 Business Scenario 02:15
      • 3.30 Demo Summary 00:13
      • 3.31 CONCATENATE Function 00:56
      • 3.32 WEEKDAY and WEEKNUM Functions 00:46
      • 3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function 01:09
      • 3.34 Business Scenario 03:42
      • 3.35 Demo Summary 00:14
      • 3.36 WORKDAY and WORKDAY INTL Functions 02:11
      • 3.37 Business Scenario 04:23
      • 3.38 Demo Summary 00:16
      • 3.39 NETWORKDAYS and NETWORKDAYS INTL Functions 01:51
      • 3.40 Business Scenario 04:32
      • 3.41 Demo Summary 00:27
      • 3.42 Quiz
      • 3.43 Summary 01:03
      • 3.44 Thank you 00:06
    • Lesson 04 - Create Advanced Charts in Excel 2013 26:43
      • 4.1 Create Advanced Charts in Excel 2013 00:26
      • 4.2 Objectives 00:23
      • 4.3 Trendlines 01:24
      • 4.4 Linear Trendline 00:39
      • 4.5 Logarithmic Trendline 00:54
      • 4.6 Polynomial Trendline 01:07
      • 4.7 Power Trendline 00:50
      • 4.8 Exponential Trendline 00:45
      • 4.9 Moving Average Trendline 01:02
      • 4.10 Business Scenario 05:08
      • 4.11 Demo Summary 00:21
      • 4.12 Chart Elements 01:22
      • 4.13 Filters in Charts 00:26
      • 4.14 Dual Axis Charts 01:11
      • 4.15 Business Scenario 04:09
      • 4.16 Demo Summary 00:27
      • 4.17 Create Custom Chart Templates 01:16
      • 4.18 Business Scenario 02:49
      • 4.19 Demo Summary 00:51
      • 4.20 Quiz
      • 4.21 Summary 01:07
      • 4.22 Thank You 00:06
    • Lesson 05 - Create and Manage PivotTables 49:06
      • 5.1 Create and Manage PivotTables 00:21
      • 5.2 Objectives 00:22
      • 5.3 PivotTables 01:00
      • 5.4 Create PivotTables 00:55
      • 5.5 Create PivotTables contd 01:36
      • 5.6 Create PivotTables contd 02:05
      • 5.7 Create PivotTables contd 00:28
      • 5.8 Business Scenario 02:04
      • 5.9 Demo Summary 00:13
      • 5.10 Recommended PivotTables Button 00:38
      • 5.11 Business Scenario 01:07
      • 5.12 Demo Summary 00:12
      • 5.13 Format Pivot tables
      • 5.14 Business Scenario 02:18
      • 5.15 Demo Summary 00:14
      • 5.16 Modify Field Headers 00:52
      • 5.17 Business Scenario 02:03
      • 5.18 Demo Summary 00:14
      • 5.19 Change the View of Data 00:45
      • 5.20 Group Records 00:36
      • 5.21 Business Scenario 01:59
      • 5.22 Demo Summary 00:12
      • 5.23 Calculated Field and Calculated Item 00:45
      • 5.24 Calculated Field and Calculated Item contd 00:43
      • 5.25 Business Scenario 02:44
      • 5.26 Demo Summary 00:19
      • 5.27 Slicers 01:06
      • 5.28 Slicers contd 00:30
      • 5.29 Business Scenario 02:10
      • 5.30 Demo Summary 00:12
      • 5.31 View Chart Animations 00:36
      • 5.32 Business Scenario 02:38
      • 5.33 Demo Summary 00:15
      • 5.34 Install PowerPivot Add in 00:25
      • 5.35 Business Scenario 01:12
      • 5.36 Demo Summary 00:15
      • 5.37 PowerPivot 00:45
      • 5.38 PowerPivot contd 00:33
      • 5.39 Business Scenario 00:53
      • 5.40 Demo Summary 00:09
      • 5.41 PowerPivot Relationships 00:53
      • 5.42 Create Relationship between Tables 00:17
      • 5.43 Create Relationship between Tables contd 01:10
      • 5.44 Business Scenario 02:17
      • 5.45 Demo Summary 00:15
      • 5.46 Edit and Delete Relationship 00:15
      • 5.47 Business Scenario 01:55
      • 5.48 Demo Summary 00:16
      • 5.49 Create PowerPivot Hierarchy 00:34
      • 5.50 Business Scenario 01:32
      • 5.51 Demo Summary 00:13
      • 5.52 Modify PowerPivot Hierarchy 00:54
      • 5.53 Business Scenario 00:59
      • 5.54 Demo Summary 00:11
      • 5.55 Quiz
      • 5.56 Summary 00:57
      • 5.57 Thank You 00:04
    • Lesson 01 - Manage and Share Workbooks 35:27
      • 1.1 Introduction 00:26
      • 1.2 Objectives 00:57
      • 1.3 Modify Workbook Templates 00:31
      • 1.4 - Business Scenario 00:30
      • 1.5 Demo - Modify Workbook Templates 01:27
      • 1.6 Merge Multiple Workbooks 00:52
      • 1.7 Business Scenario 00:30
      • 1.8 Demo - Merge Multiple Workbooks 02:12
      • 1.9 Manage Multiple Versions Of A Workbook 00:45
      • 1.10 Remove Workbook Metadata 00:54
      • 1.11 Copy Styles Between Tables 00:28
      • 1.12 Business Scenario 00:27
      • 1.13 Demo - Copy Styles Between Templates 00:51
      • 1.14 Copy Macros Between Workbooks 00:35
      • 1.15 Business Scenario 00:26
      • 1.16 Demo - Copy Macros Between Workbooks 01:04
      • 1.17 External Data Connections 01:13
      • 1.18 Business Scenario 00:27
      • 1.19 Demo - External Data Connections 02:26
      • 1.20 Protect Workbooks For Sharing 00:25
      • 1.21 Business Scenario 00:30
      • 1.22 Demo - Protect Workbooks For Sharing 00:39
      • 1.23 Protect Worksheet Structure 00:52
      • 1.24 Business Scenario 00:32
      • 1.25 Demo - Protect Worksheet Structure 01:01
      • 1.26 Set Tracking Options 01:13
      • 1.27 Business Scenario 00:25
      • 1.29 Restrict Editing And Limiting Editors 00:35
      • 1.30 Business Scenario 00:31
      • 1.31 Demo - Restrict Editing And Limiting Editors 02:01
      • 1.32 Encrypt Workbooks With A Password 00:48
      • 1.33 Business Scenario 00:37
      • 1.34 Demo - Encrypt Workbook With A Password 02:17
      • 1.35 Business Scenario 00:32
      • 1.36 Demo - Mark Workbooks As Final 00:45
      • 1.37 Control Calculations Options 01:02
      • 1.38 Business Scenario 00:30
      • 1.39 Demo - Control Calculations Options 01:27
      • 1.40 - Summary 00:55
      • 1.41 Mark Workbooks As Final 00:49
      • 1.42 Quiz
    • Lesson 02 - Apply Custom Formats and Layouts 39:01
      • 2.1 Apply Custom Formats and LAyouts 00:25
      • 2.2 Objectives 00:49
      • 2.3 Create Custom Formats (number, Time, Date) 06:14
      • 2.4 Business Scenario 00:25
      • 2.5 Demo - Create Custom Formats Number Date 02:48
      • 2.6 Create Custom Accounting Formats 00:57
      • 2.7 Advanced Fill Series Options 01:56
      • 2.8 Business Scenario 00:32
      • 2.9 Demo - Advanced Fill Series Options 02:01
      • 2.10 Create Custom Templates 01:14
      • 2.11 Create And Modify Cell Styles 00:57
      • 2.12 Business Scenario 00:30
      • 2.13 Demo - Create And Modify Cell Styles 03:06
      • 2.14 Create Custom Color Formats 00:52
      • 2.15 Business Scenario 00:24
      • 2.16 Demo - Create Custom Color Formats 01:46
      • 2.17 Create Custom Font Formats 00:40
      • 2.18 Business Scenario 00:23
      • 2.19 Demo - Create Custom Font Formats 02:41
      • 2.20 Create Themes 00:37
      • 2.21 Business Scenario 00:25
      • 2.22 Demo - Create Themes 01:04
      • 2.23 Create Form Fields 02:50
      • 2.24 Business Scenario 00:29
      • 2.25 Demo - Create Form Fields 03:11
      • 2.26 Control The Tab Order Of Objects 00:56
      • 2.27 Summary 00:49
      • 2.28 Quiz
    • Lesson 03 - Create Advanced Formulas 50:31
      • 3.1 Introduction 00:26
      • 3.2 Objectives 01:12
      • 3.3 Nested Functions 01:06
      • 3.4 If, And, Or Functions 01:49
      • 3.5 Business Scenario 00:31
      • 3.6 Demo - If And Or Functions 02:38
      • 3.7 Advanced Sumifs Function 01:44
      • 3.8 Business Scenario 00:40
      • 3.9 Demo - Advanced Sumifs Functions 05:55
      • 3.10 Advanced Countifs Function 01:18
      • 3.11 Business Scenario 00:37
      • 3.12 Demo - Advanced Countifs Functions 02:18
      • 3.13 Advanced Averageifs Function 01:17
      • 3.14 Business Scenario 00:36
      • 3.15 Demo - Advanced Averageifs Functions 03:09
      • 3.16 What-if-analysis Tools 01:32
      • 3.17 Watch Window 01:06
      • 3.18 Business Scenario 00:24
      • 3.19 Demo - Utilize Watch Window 01:26
      • 3.20 Goal Seek 00:55
      • 3.21 Business Scenario 00:37
      • 3.22 Demo - Goal Seek 01:10
      • 3.23 Create Scenarios 01:32
      • 3.24 Business Scenario 00:28
      • 3.25 Demo - Create Scenarios 05:27
      • 3.26 Create Data Table 02:32
      • 3.27 Business Scenario 00:25
      • 3.28 Demo - Data Table 00:41
      • 3.29 Consolidate Data 01:39
      • 3.30 Business Scenario 00:27
      • 3.31 Demo - Consolidate Data 00:57
      • 3.32 Financial Functions 02:55
      • 3.33 Summary 01:02
      • 3.34 Quiz
    • Lesson 04 - Create Advanced Charts and Objects 16:25
      • 4.1 Introduction 00:25
      • 4.2 Objectives 00:31
      • 4.3 Pivotchart 01:32
      • 4.4 Create New Pivotcharts 04:17
      • 4.5 Business Scenario 00:26
      • 4.6 Demo - Create New Pivotcharts 01:32
      • 4.7 Pivotcharts With Animations 00:38
      • 4.8 Business Scenario 00:34
      • 4.9 Pivotcharts With Animations 00:56
      • 4.10 Manipulate Options In Existing Pivotcharts 00:48
      • 4.11 Business Scenario 00:23
      • 4.12 Manipulate Options In Existing Pivotcharts 01:34
      • 4.13 Pivotchart Styles 00:36
      • 4.14 Business Scenario 00:20
      • 4.15 Demo - Pivotcharts Styles 01:22
      • 4.16 Summary 00:31
      • 4.17 Quiz
    • Lesson 05 - Excel 2013 Advance New Features 23:45
      • 5.1 Introduction 00:24
      • 5.2 Objectives 00:38
      • 5.3 Introduction To Apps For Office 04:17
      • 5.4 Installing Apps From Office Store 00:48
      • 5.5 Business Scenario 00:28
      • 5.6 Demo - Installing Apps From Office Store 01:31
      • 5.7 Inserting And Managing Apps 00:43
      • 5.8 Business Scenario 00:27
      • 5.9 Demo - Inserting And Managing Apps 01:14
      • 5.10 Timeline Filter 01:59
      • 5.11 Business Scenario 00:32
      • 5.12 Demo - Timeline Filter 01:25
      • 5.13 Introduction To Powerview Report 03:47
      • 5.14 Create Powerview Report 01:00
      • 5.15 Business Scenario 00:27
      • 5.16 Demo - Creating Powerview Reports 01:03
      • 5.17 Powerview Reports Options 01:17
      • 5.18 Business Scenario 00:29
      • 5.19 Demo - Powerview Reports Option 00:37
      • 5.20 Summary 00:39
      • 5.21 Quiz
    • Lesson 06 - Creating Templates with Advanced Functions 38:58
      • 6.1 Introduction 00:24
      • 6.2 Objectives 00:57
      • 6.3 Creating Excel User Defined Templates 01:05
      • 6.4 Business Scenario 00:39
      • 6.5 Demo 1 - Creating Excel User Defined Templates 09:59
      • 6.6 Multiple List Box 00:58
      • 6.7 Business Scenario 00:37
      • 6.8 Demo 2 - Multiple List Box 02:55
      • 6.9 Advanced Validation Rule With Isnumber 00:41
      • 6.10 Business Scenario 00:37
      • 6.11 Demo 3 - Advanced Validation Rule With Isnumber 01:46
      • 6.12 Advanced Validation Rule With Istext 00:38
      • 6.13 Business Scenario 00:35
      • 6.14 Demo 4 - Advanced Validation Rule With Istext 01:12
      • 6.15 Combine Date And Logical Functions 00:36
      • 6.16 Business Scenario 00:43
      • 6.17 Demo 5 - Combine Date And Logical Functions 03:56
      • 6.18 Eomonth Function 01:26
      • 6.19 Business Scenario 00:30
      • 6.20 Demo 6 - Eomonth Function 01:10
      • 6.21 Match Function 03:06
      • 6.22 Business Scenario 00:26
      • 6.23 Match Function 00:37
      • 6.24 Business Scenario 00:30
      • 6.25 Index With Match Function 01:12
      • 6.26 ndex With Match Function 00:55
      • 6.27 Summary 00: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.

Contact Us

+1-844-532-7688

(Toll Free)

Request more information

For individuals
For business
Name*
Email*
Phone Number*
Your Message (Optional)
We are looking into your query.
Our consultants will get in touch with you soon.

A Simplilearn representative will get back to you in one business day.

First Name*
Last Name*
Email*
Phone Number*
Company*
Job Title*
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line