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 are the course objectives?

    Simplilearn’s finance training program for non-financial professionals is designed for managers to enhance their fundamental financial skills and understanding of how financial principles impact the business.  The program will introduce you to core financial concepts and show you how to understand financial documents, manage budgets, analyze financial performance and implement a range of financial controls to meet business objectives. You will develop the right financial skillsets to operate effectively in today’s complex business environments and address the ever-changing business needs of your organization.

  • Why is this certification so desirable?

    The finance function plays a vital role in creating and running an effective business, controlling costs and ensuring an organization’s financial health. There is a great need for non-financial managers to obtain vital financial skills to improve business performance. This training program helps non-financial professionals to: 
    • Comprehend relevant financial information within the organization.
    • Understand the impact of various business decisions on the organization’s performance.
    • Demonstrate an understanding of financial management and accounting
    • Communicate effectively with financial specialists
     
    According to the recent surveys by payscale.com, the median salary of a certified professional in this field is $82,563 per year. Certified professionals are in great demand in companies around the world.

  • What skills will you learn?

    At the end of Simplilearn’s training in Finance for Non-Financial Professionals, you will be able to:
    • Read and analyze basic financial statements
    • Control a financial system to meet business objectives
    • Use a range of financial controls
    • Understand the sources and availability of finance for an organization
    • Develop an ability to “think finance” and translate performance into financial terms
    • Develop a proactive working relationship with financial teams

  • Who should take this course?

    This course is ideal for managers or other professionals who do have financial or accounting backgrounds and need a basic foundation in key financial documents and processes.

  • Why choose Simplilearn for your training?

    • Simplilearn is one of the world’s largest certification training providers, with more than 500,000 professionals trained globally
    • Trusted by Fortune 500 companies as their learning provider for career growth and training
    • Thousands of certified and experienced trainers conducting trainings around the world
    • Robust learning management system (LMS) designed to ensure you pass your certification tests on the first attempt.
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute, APMG, CFA Institute, GARP, ASTQB, IIBA and others
    • Our high-touch support model with 24/7 teaching assistance provides a fulfilling online learning experience, from the moment you start your training to the day you get your certification

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?

    There are no prerequisites to take this course. However, candidates should complete the online course within the stipulated time and pass the sample test papers with minimum 72% before they appear for the final examination.

  • What is the exam format?

    The exam format is as follows:
    • Multiple-choice questions
    • 25 questions with one point for each question
    • 18 points required to pass (72%)
    • Exam duration is 60 minutes
    • Closed book format

Reviews

Johanna Castellares
Johanna Castellares Quality Leader at GE Oil & Gas

Very flexible and easy to understand.

Brian Woidan
Brian Woidan Practice Manager, VMware Healthcare TAM Program at VMware

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

Edward Hall
Edward Hall Logistics Analyst | M.S. Business Intelligence | Data Management | Materials Management & Forecasting

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

Deepali Kumar
Deepali Kumar Team Lead at Sutherland Global Services

I have enrolled in Finance for Non-Financial Professionals course at Simplilearn. It was a great learning. The course content is really good and helpful for professionals. I would love to recommend Simplilearn to my friends. Thanks to Simplilearn for enhancing my Financial and excel skills.

Read more Read less
Prasun Choudhury
Prasun Choudhury Manager - Technical Support & Service Desk Operations

Excellent learning experience.

Macy Baldwin
Macy Baldwin

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.

Lucille Klein
Lucille Klein

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
Harley Espinoza
Harley Espinoza

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

FAQs

  • How do I enroll for the online training?

    You can enroll for this training on our website and make an online payment using any of the following options:
    • Visa Credit or Debit Card
    • MasterCard
    • American Express
    • Diner’s Club
    • PayPal 
    Once payment is received you will automatically receive a payment receipt and access information via email.

  • What does this training include?

    You will have access to the online e-learning content, chapter-end quizzes and practice tests.

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

    Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.

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

    Yes. We do offer a money-back guarantee for many of our training programs. Refer to our Refund Policy and submit 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 contact our Help and Support portal for more information.

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

    Once you register for this course, you will have 24/7 access to the e-learning content on our website. An automated course purchase confirmation will guide you through the process.

  • What is Global Teaching Assistance?

    Our teaching assistants are a dedicated team of subject matter experts here to help you get certified in your first attempt. They engage students proactively to ensure the course path is being followed and help you enrich your learning experience, from class onboarding to project mentoring and job assistance. Teaching Assistance is available during business hours.

  • What is covered under the 24/7 Support promise?

    We offer 24/7 support through email, chat, and calls. We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

  • I am not able to access the online course. Who can help me?

    Contact us using the form on the right of any page on the Simplilearn website, select the Live Chat link or contact Help & Support.

  • Do you provide any course completion certificate?

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

  • How can I learn more about this training program?

    Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives can provide you with more details.

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