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 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?

    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.

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
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.

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.