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 Intermediate Certification Training

### Course Summary

Become a pro in handling advanced formulas and tools in Excel.

• +

### Course Syllabus

Course preview

MicrosoftÂ® ExcelÂ® 2013 Intermediate: MOS Certification

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

1.7 Track Changes 02:06

1.8 Highlight Changes And Comments 01:13

1.10 Demo Summary 00:23

1.11 Accept And Reject Changes 01:01

1.13 Demo Summary 00:16

1.14 Formula Errors 01:21

1.15 Error Tracing 00:55

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

2.7 Formatting cells Using Formulas 00:35

2.8 Formatting Celis Using Formulas (contd.) 00:31

2.10 Demo Summary 00:20

2.11 Manage Conditional Format Rules 01:13

2.12 Manage conditional format Rules (contd.) 00:48

2.14 Demo Summary 00:21

2.15 Create Advance Filters by Search 00:39

2.17 Demo Summary 00:19

2.18 Create Advance Filters Using Values 00:18

2.20 Demo Summary 00:24

2.21 Create Advance Filters by Colors 00:23

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

2.28 Display Data in Multiple international Formats 01:00

2.30 Demo Summary 00:19

2.31 Proofing in other languages 00:50

2.32 Proofing in Other languages (Contd.) 00:38

2.34 Demo Summary 00:19

2.35 Use international symbols 00:50

2.36 Use international Symbols (contd.) 00:28

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

3.8 HLOOKUP Function 00:46

3.9 Syntax Arguments in HLOOKUP Function 02:11

3.11 Demo Summary 00:10

3.12 LOOKUP Function 01:03

3.13 Syntax Arguments in LOOKUP Function 02:06

3.15 Demo Summary 00:11

3.16 TRANSPOSE Function 00:58

3.18 Demo Summary 00:10

3.19 TODAY and NOW Functions 00:41

3.21 Demo Summary 00:11

3.22 DAY MONTH and YEAR Functions 01:00

3.24 Demo Summary 00:12

3.25 HOUR MINUTE and SECOND Functions 01:18

3.27 Demo Summary 00:10

3.28 DATEVALUE and TIMEVALUE Functions 00:50

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

3.36 WORKDAY and WORKDAY INTL Functions 02:11

3.38 Demo Summary 00:16

3.39 NETWORKDAYS and NETWORKDAYS INTL Functions 01:51

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

4.17 Create Custom Chart Templates 01:16

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

5.10 Recommended PivotTables Button 00:38

5.12 Demo Summary 00:12

5.13 Format Pivot tables

5.15 Demo Summary 00:14

5.18 Demo Summary 00:14

5.19 Change the View of Data 00:45

5.20 Group Records 00:36

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

5.27 Slicers 01:06

5.28 Slicers contd 00:30

5.30 Demo Summary 00:12

5.31 View Chart Animations 00:36

5.33 Demo Summary 00:15

5.34 Install PowerPivot Add in 00:25

5.36 Demo Summary 00:15

5.37 PowerPivot 00:45

5.38 PowerPivot contd 00:33

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

5.46 Edit and Delete Relationship 00:15

5.48 Demo Summary 00:16

5.49 Create PowerPivot Hierarchy 00:34

5.51 Demo Summary 00:13

5.52 Modify PowerPivot Hierarchy 00:54

5.54 Demo Summary 00:11

5.55 Quiz

5.56 Summary 00:57

5.57 Thank You 00:04

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: