Course Overview

Key Features

  • 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

Training Options

Self-Paced Learning

$ 199

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Finance for Non-Financial Managers

    Preview
    • Lesson 00 - Course Introduction

      03:39Preview
      • 1.1 Introduction
        03:39
    • Lesson 01 - Introduction to Financial Statements

      32:16Preview
      • 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:52Preview
      • 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:37Preview
      • 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.008 Sources of Funds
        03:20
      • 3.9 Uses of Funds
        05:31
      • 3.010 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:07Preview
      • 4.1 Introduction
        00:52
      • 4.2 Objectives
        00:20
      • 4.003 Profit and Cash
        05:07
      • 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:40Preview
      • 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.013 Topics Covered
        00:32
    • Lesson 06 - Introduction to Financial Analysis

      27:08Preview
      • 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:14Preview
      • 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

      08:41Preview
      • 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.005 Comparison by Industry - Net Profit Margin
        01:18
      • 8.6 Comparison by Industry - Operating Profit Margin
        00:48
      • 8.007 Profit Margins for Supermarkets
        00:37
      • 8.008 Profit Margins for Aircraft Manufacturing Industry
        00:24
      • 8.009 Profit Margins Flowcharts
        00:53
      • 8.11 Quiz
      • 8.12 Topics Covered
        00:45
    • Lesson 09 - Asset Turnover

      15:19Preview
      • 9.1 Introduction
        00:26
      • 9.2 Objectives
        00:33
      • 9.003 Asset Turnover
        04:53
      • 9.004 Working Capital Ratios
        05:05
      • 9.5 Fixed Asset Turnover
        01:45
      • 9.6 Other Concepts
        00:34
      • 9.007 Analysis by Industry – Supermarket
        01:24
      • 9.8 Quiz
      • 9.09 Topics Covered
        00:39
    • Lesson 10 - Return on Capital Employed

      07:23Preview
      • 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
  • Free Course
  • Microsoft® Excel® 2013 Foundation: MOS Certification

    Preview
    • Lesson 00 - Overview of MOS Foundation

      07:30Preview
      • 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:12Preview
      • 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

      01:12:04Preview
      • 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
        00:41
      • 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:46Preview
      • 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:54Preview
      • 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:50Preview
      • 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:40Preview
      • 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
  • Free Course
  • Microsoft® Excel® 2013 Intermediate: MOS Certification

    Preview
    • Lesson 00 - Overview Of MOS Intermediate Course

      07:18Preview
      • 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:17Preview
      • 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:17Preview
      • 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:23Preview
      • 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:43Preview
      • 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:06Preview
      • 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
  • Free Course
  • Microsoft® Excel 2013 Advanced: MOS Certification (Exam – 77-428)

    Preview
    • Lesson 01 - Manage and Share Workbooks

      35:27Preview
      • 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:01Preview
      • 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:31Preview
      • 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:25Preview
      • 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:45Preview
      • 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:58Preview
      • 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

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.

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

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

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

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

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

  • Prasun Choudhury

    Prasun Choudhury

    Manager - Technical Support & Service Desk Operations

    Excellent learning experience.

prevNext

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

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.