MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Microsoft Excel 2013 Foundation Certification Training

Course Summary

This Microsoft Excel 2013 Foundation course will provide you with a comprehensive introduction to the basics of the Excel 2013 application and customizing Excel options. With this Excel beginners course, you will learn to create and manage worksheets and workbooks; format cells, ranges and tables; apply advanced formulas and functions; utilize pivot tools; create charts and insert objects.


  • +

    Course Syllabus


    Course preview

    Microsoft® Excel® 2013 Foundation: MOS Certification

    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

    That was just a sneak-peak into the lesson.
    Enroll for this course and get full access.
    Enroll now


Course Fee:
USD 149

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url