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.9 Demo Summary 00:20

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.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.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.18 Demo summary 00:14

2.19 Search and Replace Data 00:28

2.20 Go To and Name Box 00:38

2.22 Demo summary 00:23

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.32 Demo summary 00:44

2.33 Insert Headers and Footers 00:38

2.34 Insert Headers and Footers contd 00:33

2.36 Demo summary 00:21

2.37 Data Validation 01:49

2.38 Data Validation contd 01:04

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.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.52 Demo summary 00:19

2.53 Show Formulas 00:23

2.55 Demo summary 00:12

2.56 Add Values to Workbook Properties 00:33

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.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.6 Demo Summary 00:16

3.7 Create Data using AutoFill 00:54

3.9 Demo Summary 00:15

3.10 Customize AutoFill Options 00:44

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.17 Demo Summary 00:11

3.18 Merge and Center 01:17

3.20 Demo Summary 00:11

3.21 Format Cell Content 01:14

3.23 Demo Summary 00:15

3.24 Cell Styles 01:00

3.26 Demo Summary 00:13

3.27 Number Formats 01:54

3.28 Format Painter 00:28

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.35 Demo Summary 00:12

3.36 Create Named Ranges 01:08

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.6 Demo Summary 00:19

4.7 Define Table Names 00:32

4.9 Demo Summary 00:17

4.10 Insert Table Rows and Columns 00:46

4.12 Demo Summary 00:17

4.13 Delete Table Rows and Columns 00:48

4.15 Demo Summary 00:22

4.16 Move Table Rows and Columns 00:19

4.18 Demo Summary 00:29

4.19 Convert to Range 00:22

4.21 Demo Summary 00:21

4.22 Remove Duplicates 00:15

4.24 Demo Summary 00:19

4.25 Design Table Styles 00:37

4.27 Demo Summary 00:16

4.28 Table Style Options 01:04

4.29 Filter Tables 00:41

4.31 Demo Summary 00:23

4.32 Sort Table Data 01:20

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.7 Demo Summary 00:27

5.8 Formula Calculations Order 01:47

5.9 SUM Function 01:04

5.11 Demo Summary 00:17

5.12 COUNT Function 00:51

5.13 COUNTA Function 00:46

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.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.25 Demo Summary 00:22

5.26 COUNTIF Function 00:54

5.27 COUNTIFS Function 01:20

5.29 Demo Summary 00:21

5.30 AVERAGEIF Function 01:06

5.31 AVERAGEIFS Function 01:37

5.33 Demo Summary 00:21

5.34 LOWER PROPER UPPER and CONCATENATE Functions 01:31

5.35 TRIM Function 00:25

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.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.8 Demo Summary 00:19

6.9 Format Charts 00:51

6.10 Format Charts contd 00:39

6.12 Demo Summary 00:16

6.13 Move and Resize Charts 00:32

6.15 Demo Summary 00:16

6.16 Recommended Charts 00:40

6.18 Demo Summary 00:17

6.19 Introduction to Objects 00:37

6.20 Insert Picture Objects 00:34

6.22 Demo Summary 00:16

6.23 Insert Other File Formats as Objects 00:52

6.25 Demo Summary 00:18

6.28 Demo Summary 00:16

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

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: