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

    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

Related Posts:

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

Back to Top