Quality Seal Emagister EMAGISTER CUM LAUDE

Microsoft® Excel 2013 Foundation

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Important information

Opinions

R

19/03/2014
What I would highlight Very good training, very precise and to the point.

Would you recommend this course? Yes.

What you'll learn on the course

Ms Excel
Excel MS

Course programme

Course Preview
  • Microsoft® Excel® 2013 Foundation: MOS Certification
    • Lesson 00 - Overview of MOS Foundation15:0
      • 0.1 Welcome1:7
      • 0.2 Overview of MOS Foundation1:0
      • 0.3 Table of Content1:52
      • 0.4 Course Objective1:30
      • 0.5 Course Overview1:57
      • 0.6 Value of Excel for Professionals1:41
      • 0.7 Value of Excel for Organizations1:40
      • 0.8 Lessons Covered1:15
      • 0.9 Exam Pattern1:30
      • 0.10 MOS Excel 2013 Level 1 Certification2:31
      • 0.11 Sources of Information1:18
      • 0.12 Thank you1:9
    • Lesson 01 - Introduction to Excel 201327:24
      • 1.1 Introduction to Excel 20131:22
      • 1.2 Objectives1:29
      • 1.3 Excel 2013 Application User Interface2:5
      • 1.4 Excel 2013 Application User Interface contd1:31
      • 1.5 Excel 2013 Application Window1:27
      • 1.6 Excel 2013 Application Window Elements2:41
      • 1.7 Ribbon Options1:49
      • 1.8 Business Scenario2:29
      • 1.9 Demo Summary1:20
      • 1.10 Quick Access Toolbar1:30
      • 1.11 Customize Quick Access Toolbar1:22
      • 1.12 Business Scenario2:25
      • 1.13 Demo summary1:23
      • 1.14 Backstage View in Excel 20131:26
      • 1.15 New Features in Excel 20132:46
      • 1.16 Quiz0:0
      • 1.17 Summary2:3
      • 1.18 Thank You1:4
    • Lesson 02 - Create and Manage Workbooks and Worksheets147:20
      • 2.1 Create and Manage Workbooks and Worksheets1:22
      • 2.2 Objectives1:26
      • 2.3 Excel 2013 Workbooks2:11
      • 2.4 Create a Blank Workbook1:31
      • 2.5 Create a Workbook from a Template1:38
      • 2.6 Open an Existing Workbook1:25
      • 2.7 Business Scenario3:36
      • 2.8 Demo Summary1:19
      • 2.9 Native and Non native Files3:15
      • 2.10 Connect Import External Files3:6
      • 2.11 Connect Import External Files contd2:8
      • 2.12 Business Scenario4:8
      • 2.13 Demo summary1:33
      • 2.14 Worksheet Operations2:28
      • 2.15 Change Worksheet Tab Color1:32
      • 2.16 Hide or Unhide Worksheets1:28
      • 2.17 Business Scenario3:35
      • 2.18 Demo summary1:14
      • 2.19 Search and Replace Data1:28
      • 2.20 Go To and Name Box1:38
      • 2.21 Business Scenario3:30
      • 2.22 Demo summary1:23
      • 2.23 Insert Hyperlinks1:58
      • 2.24 Business Scenario2:14
      • 2.25 Demo summary1:19
      • 2.26 Modifying Workbook Themes1:49
      • 2.27 Modify Page Setup2:19
      • 2.28 Insert and Delete Columns and Rows1:0
      • 2.29 Modify Row Height and Column Width1:44
      • 2.30 Hide or Unhide Columns and Rows1:24
      • 2.31 Business Scenario4:38
      • 2.32 Demo summary1:44
      • 2.33 Insert Headers and Footers1:38
      • 2.34 Insert Headers and Footers contd1:33
      • 2.35 Business Scenario3:8
      • 2.36 Demo summary1:21
      • 2.37 Data Validation2:49
      • 2.38 Data Validation contd2:4
      • 2.39 Business Scenario5:1
      • 2.40 Demo summary1:25
      • 2.41 Enable Developer Tab1:37
      • 2.42 Macro Security Options2:36
      • 2.43 Record Macros2:38
      • 2.44 Business Scenario4:43
      • 2.45 Demo summary1:33
      • 2.46 Backward Compatibility2:32
      • 2.47 Workbook Views2:5
      • 2.48 Use Zoom for Workbooks1:43
      • 2.49 Freeze Panes2:4
      • 2.50 Split Window1:22
      • 2.51 Business Scenario3:23
      • 2.52 Demo summary1:19
      • 2.53 Show Formulas1:23
      • 2.54 Business Scenario2:47
      • 2.55 Demo summary1:12
      • 2.56 Add Values to Workbook Properties1:33
      • 2.57 Business Scenario2:7
      • 2.58 Demo summary1:14
      • 2.59 Save Workbooks in Alternate File Formats2:24
      • 2.60 Set Print Area and Print Workbooks1:46
      • 2.61 Business Scenario2:43
      • 2.62 Demo summary1:23
      • 2.63 Save Workbooks to Remote Locations1:50
      • 2.64 Quiz0:0
      • 2.65 Summary2:5
      • 2.66 Thank You1:6
    • Lesson 03 - Create Cells and Ranges90:32
      • 3.1 Create Cells and Ranges1:25
      • 3.2 Objectives1:27
      • 3.3 Cells and Ranges2:2
      • 3.4 Create Data using FillSeries2:16
      • 3.5 Business Scenario2:45
      • 3.6 Demo Summary1:16
      • 3.7 Create Data using AutoFill1:54
      • 3.8 Business Scenario3:28
      • 3.9 Demo Summary1:15
      • 3.10 Customize AutoFill Options1:44
      • 3.11 Business Scenario3:43
      • 3.12 Demo Summary1:19
      • 3.13 Paste Options1:43
      • 3.14 Paste Special3:9
      • 3.15 Format Cell Structure2:30
      • 3.16 Business Scenario3:12
      • 3.17 Demo Summary1:11
      • 3.18 Merge and Center2:17
      • 3.19 Business Scenario1:51
      • 3.20 Demo Summary1:11
      • 3.21 Format Cell Content2:14
      • 3.22 Business Scenario2:33
      • 3.23 Demo Summary1:15
      • 3.24 Cell Styles1:0
      • 3.25 Business Scenario2:53
      • 3.26 Demo Summary1:13
      • 3.27 Number Formats2:54
      • 3.28 Format Painter1:28
      • 3.29 Business Scenario2:21
      • 3.30 Demo Summary1:12
      • 3.31 Data Model with Advanced Conditional Format2:41
      • 3.32 Data Model with Advanced Conditional Format contd1:30
      • 3.33 Sparklines2:11
      • 3.34 Business Scenario2:34
      • 3.35 Demo Summary1:12
      • 3.36 Create Named Ranges2:8
      • 3.37 Business Scenario3:32
      • 3.38 Demo Summary1:14
      • 3.39 Data Group and Ungroup2:17
      • 3.40 Subtotals2:11
      • 3.41 Quiz0:0
      • 3.42 Summary2:27
      • 3.43 Thank You1:8
    • Lesson 04 - Create Tables60:48
      • 4.1 Create Tables1:22
      • 4.2 Objectives1:22
      • 4.3 Tables in Excel 20131:58
      • 4.4 Create and Format a Table1:34
      • 4.5 Business Scenario2:8
      • 4.6 Demo Summary1:19
      • 4.7 Define Table Names1:32
      • 4.8 Business Scenario2:34
      • 4.9 Demo Summary1:17
      • 4.10 Insert Table Rows and Columns1:46
      • 4.11 Business Scenario3:16
      • 4.12 Demo Summary1:17
      • 4.13 Delete Table Rows and Columns1:48
      • 4.14 Business Scenario2:27
      • 4.15 Demo Summary1:22
      • 4.16 Move Table Rows and Columns1:19
      • 4.17 Business Scenario3:10
      • 4.18 Demo Summary1:29
      • 4.19 Convert to Range1:22
      • 4.20 Business Scenario2:6
      • 4.21 Demo Summary1:21
      • 4.22 Remove Duplicates1:15
      • 4.23 Business Scenario2:42
      • 4.24 Demo Summary1:19
      • 4.25 Design Table Styles1:37
      • 4.26 Business Scenario1:52
      • 4.27 Demo Summary1:16
      • 4.28 Table Style Options2:4
      • 4.29 Filter Tables1:41
      • 4.30 Business Scenario3:1
      • 4.31 Demo Summary1:23
      • 4.32 Sort Table Data2:20
      • 4.33 Business Scenario2:0
      • 4.34 Demo Summary1:22
      • 4.35 Quiz0:0
      • 4.36 Summary2:8
      • 4.37 Thank You1:5
    • Lesson 05 - Apply Formulas and Functions114:40
      • 5.1 Apply Formulas and Functions1:22
      • 5.2 Objectives1:27
      • 5.3 Formulas and Functions2:4
      • 5.4 Cell References and Ranges in Formulas2:53
      • 5.5 Cell References and Ranges in Formulas contd1:30
      • 5.6 Business Scenario2:53
      • 5.7 Demo Summary1:27
      • 5.8 Formula Calculations Order2:47
      • 5.9 SUM Function2:4
      • 5.10 Business Scenario2:4
      • 5.11 Demo Summary1:17
      • 5.12 COUNT Function1:51
      • 5.13 COUNTA Function1:46
      • 5.14 Business Scenario5:34
      • 5.15 Demo Summary1:17
      • 5.16 AVERAGE Function1:44
      • 5.17 MIN Function1:42
      • 5.18 MAX Function1:39
      • 5.19 Business Scenario3:8
      • 5.20 Demo Summary1:21
      • 5.21 Conditional Logic in Functions1:51
      • 5.22 SUMIF Function2:5
      • 5.23 SUMIFS Function2:35
      • 5.24 Business Scenario5:6
      • 5.25 Demo Summary1:22
      • 5.26 COUNTIF Function1:54
      • 5.27 COUNTIFS Function2:20
      • 5.28 Business Scenario3:0
      • 5.29 Demo Summary1:21
      • 5.30 AVERAGEIF Function2:6
      • 5.31 AVERAGEIFS Function2:37
      • 5.32 Business Scenario4:36
      • 5.33 Demo Summary1:21
      • 5.34 LOWER PROPER UPPER and CONCATENATE Functions2:31
      • 5.35 TRIM Function1:25
      • 5.36 Business Scenario5:23
      • 5.37 Demo Summary1:21
      • 5.38 LEFT Function2:2
      • 5.39 RIGHT Function2:1
      • 5.40 mid Function1:53
      • 5.41 Business Scenario4:37
      • 5.42 Demo Summary1:23
      • 5.43 Quiz0:0
      • 5.44 Summary2:5
      • 5.45 Thank You1:5
    • Lesson 06 - Create Charts and Objects72:22
      • 6.1 Create Charts and Objects1:22
      • 6.2 Objectives1:22
      • 6.3 Introduction to Charts3:14
      • 6.4 Create Charts1:35
      • 6.5 Create Charts contd1:28
      • 6.6 Create Charts contd1:33
      • 6.7 Business Scenario6:22
      • 6.8 Demo Summary1:19
      • 6.9 Format Charts1:51
      • 6.10 Format Charts contd1:39
      • 6.11 Business Scenario3:32
      • 6.12 Demo Summary1:16
      • 6.13 Move and Resize Charts1:32
      • 6.14 Business Scenario2:53
      • 6.15 Demo Summary1:16
      • 6.16 Recommended Charts1:40
      • 6.17 Business Scenario2:37
      • 6.18 Demo Summary1:17
      • 6.19 Recommended Charts1:38
      • 6.20 Insert Picture Objects1:34
      • 6.21 Business Scenario2:50
      • 6.22 Demo Summary1:16
      • 6.23 Insert Other File Formats as Objects1:52
      • 6.24 Business Scenario3:47
      • 6.25 Demo Summary1:18
      • 6.26 Add Textboxes1:26
      • 6.27 Business Scenario3:29
      • 6.28 Demo Summary1:16
      • 6.29 Add SmartArt1:26
      • 6.30 Business Scenario4:13
      • 6.31 Demo Summary1:25
      • 6.32 Quiz0:0
      • 6.33 Summary2:17
      • 6.34 Thank You1:6

Additional information

  • What is this course about?

    Excel is a powerful spreadsheet application created by Microsoft which helps you to understand and analyze business functions. This application is mainly useful for business heads for taking decisions about their business.  Microsoft introduced a number of new features in Excel 2013, such as saving files in remote locations, new chart types, slicers and timeline feature to work with pivot tables, FlashFill, etc. All these features allow the user to work with data more efficiently and effectively.

    This course will provide you a comprehensive introduction to the basics of Excel 2013 application and customizing excel options. It will give an introduction to creating and managing worksheets and workbooks. We will learn about creating and formatting cells and ranges. The course will also cover the information about creating and formatting tables, applying formulas and functions, creating charts, and inserting objects.

    Demos are provided to show how to work with Excel application and get hands-on experience in Excel 2013. The target audience of the course is anyone who is interested in learning Excel 2013. No prerequisite skills are required for taking this course.


Compare this course with other similar courses
See all