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

Course Summary

As the most commonly used spreadsheet software, Microsoft (MS) Excel skills are critical to almost any business managerial job. Many of the most powerful functions and capabilities of Excel go beyond what is intuitive in the interface and require expert skills. This course enables you to master advanced tools and features of MS Excel 2013 and prepare for the Microsoft 77-428 certification exam. MS Excel certification is a smart investment in building expertise in finance or business.


  • +

    Course Syllabus


    Course preview

    Microsoft® Excel 2013 Advanced: MOS Certification (Exam – 77-428)

    Lesson 01 - Manage and Share Workbooks 35:27

    1.1 Introduction 00:26

    1.2 Objectives 00:57

    1.3 Modify Workbook Templates 00:31

    1.4 - Business Scenario 00:30

    1.5 Demo - Modify Workbook Templates 01:27

    1.6 Merge Multiple Workbooks 00:52

    1.7 Business Scenario 00:30

    1.8 Demo - Merge Multiple Workbooks 02:12

    1.9 Manage Multiple Versions Of A Workbook 00:45

    1.10 Remove Workbook Metadata 00:54

    1.11 Copy Styles Between Tables 00:28

    1.12 Business Scenario 00:27

    1.13 Demo - Copy Styles Between Templates 00:51

    1.14 Copy Macros Between Workbooks 00:35

    1.15 Business Scenario 00:26

    1.16 Demo - Copy Macros Between Workbooks 01:04

    1.17 External Data Connections 01:13

    1.18 Business Scenario 00:27

    1.19 Demo - External Data Connections 02:26

    1.20 Protect Workbooks For Sharing 00:25

    1.21 Business Scenario 00:30

    1.22 Demo - Protect Workbooks For Sharing 00:39

    1.23 Protect Worksheet Structure 00:52

    1.24 Business Scenario 00:32

    1.25 Demo - Protect Worksheet Structure 01:01

    1.26 Set Tracking Options 01:13

    1.27 Business Scenario 00:25

    1.29 Restrict Editing And Limiting Editors 00:35

    1.30 Business Scenario 00:31

    1.31 Demo - Restrict Editing And Limiting Editors 02:01

    1.32 Encrypt Workbooks With A Password 00:48

    1.33 Business Scenario 00:37

    1.34 Demo - Encrypt Workbook With A Password 02:17

    1.35 Business Scenario 00:32

    1.36 Demo - Mark Workbooks As Final 00:45

    1.37 Control Calculations Options 01:02

    1.38 Business Scenario 00:30

    1.39 Demo - Control Calculations Options 01:27

    1.40 - Summary 00:55

    1.41 Mark Workbooks As Final 00:49

    1.42 Quiz

    Lesson 02 - Apply Custom Formats and Layouts 39:01

    2.1 Apply Custom Formats and LAyouts 00:25

    2.2 Objectives 00:49

    2.3 Create Custom Formats (number, Time, Date) 06:14

    2.4 Business Scenario 00:25

    2.5 Demo - Create Custom Formats Number Date 02:48

    2.6 Create Custom Accounting Formats 00:57

    2.7 Advanced Fill Series Options 01:56

    2.8 Business Scenario 00:32

    2.9 Demo - Advanced Fill Series Options 02:01

    2.10 Create Custom Templates 01:14

    2.11 Create And Modify Cell Styles 00:57

    2.12 Business Scenario 00:30

    2.13 Demo - Create And Modify Cell Styles 03:06

    2.14 Create Custom Color Formats 00:52

    2.15 Business Scenario 00:24

    2.16 Demo - Create Custom Color Formats 01:46

    2.17 Create Custom Font Formats 00:40

    2.18 Business Scenario 00:23

    2.19 Demo - Create Custom Font Formats 02:41

    2.20 Create Themes 00:37

    2.21 Business Scenario 00:25

    2.22 Demo - Create Themes 01:04

    2.23 Create Form Fields 02:50

    2.24 Business Scenario 00:29

    2.25 Demo - Create Form Fields 03:11

    2.26 Control The Tab Order Of Objects 00:56

    2.27 Summary 00:49

    2.28 Quiz

    Lesson 03 - Create Advanced Formulas 50:31

    3.1 Introduction 00:26

    3.2 Objectives 01:12

    3.3 Nested Functions 01:06

    3.4 If, And, Or Functions 01:49

    3.5 Business Scenario 00:31

    3.6 Demo - If And Or Functions 02:38

    3.7 Advanced Sumifs Function 01:44

    3.8 Business Scenario 00:40

    3.9 Demo - Advanced Sumifs Functions 05:55

    3.10 Advanced Countifs Function 01:18

    3.11 Business Scenario 00:37

    3.12 Demo - Advanced Countifs Functions 02:18

    3.13 Advanced Averageifs Function 01:17

    3.14 Business Scenario 00:36

    3.15 Demo - Advanced Averageifs Functions 03:09

    3.16 What-if-analysis Tools 01:32

    3.17 Watch Window 01:06

    3.18 Business Scenario 00:24

    3.19 Demo - Utilize Watch Window 01:26

    3.20 Goal Seek 00:55

    3.21 Business Scenario 00:37

    3.22 Demo - Goal Seek 01:10

    3.23 Create Scenarios 01:32

    3.24 Business Scenario 00:28

    3.25 Demo - Create Scenarios 05:27

    3.26 Create Data Table 02:32

    3.27 Business Scenario 00:25

    3.28 Demo - Data Table 00:41

    3.29 Consolidate Data 01:39

    3.30 Business Scenario 00:27

    3.31 Demo - Consolidate Data 00:57

    3.32 Financial Functions 02:55

    3.33 Summary 01:02

    3.34 Quiz

    Lesson 04 - Create Advanced Charts and Objects 16:25

    4.1 Introduction 00:25

    4.2 Objectives 00:31

    4.3 Pivotchart 01:32

    4.4 Create New Pivotcharts 04:17

    4.5 Business Scenario 00:26

    4.6 Demo - Create New Pivotcharts 01:32

    4.7 Pivotcharts With Animations 00:38

    4.8 Business Scenario 00:34

    4.9 Pivotcharts With Animations 00:56

    4.10 Manipulate Options In Existing Pivotcharts 00:48

    4.11 Business Scenario 00:23

    4.12 Manipulate Options In Existing Pivotcharts 01:34

    4.13 Pivotchart Styles 00:36

    4.14 Business Scenario 00:20

    4.15 Demo - Pivotcharts Styles 01:22

    4.16 Summary 00:31

    4.17 Quiz

    Lesson 05 - Excel 2013 Advance New Features 23:45

    5.1 Introduction 00:24

    5.2 Objectives 00:38

    5.3 Introduction To Apps For Office 04:17

    5.4 Installing Apps From Office Store 00:48

    5.5 Business Scenario 00:28

    5.6 Demo - Installing Apps From Office Store 01:31

    5.7 Inserting And Managing Apps 00:43

    5.8 Business Scenario 00:27

    5.9 Demo - Inserting And Managing Apps 01:14

    5.10 Timeline Filter 01:59

    5.11 Business Scenario 00:32

    5.12 Demo - Timeline Filter 01:25

    5.13 Introduction To Powerview Report 03:47

    5.14 Create Powerview Report 01:00

    5.15 Business Scenario 00:27

    5.16 Demo - Creating Powerview Reports 01:03

    5.17 Powerview Reports Options 01:17

    5.18 Business Scenario 00:29

    5.19 Demo - Powerview Reports Option 00:37

    5.20 Summary 00:39

    5.21 Quiz

    Lesson 06 - Creating Templates with Advanced Functions 38:58

    6.1 Introduction 00:24

    6.2 Objectives 00:57

    6.3 Creating Excel User Defined Templates 01:05

    6.4 Business Scenario 00:39

    6.5 Demo 1 - Creating Excel User Defined Templates 09:59

    6.6 Multiple List Box 00:58

    6.7 Business Scenario 00:37

    6.8 Demo 2 - Multiple List Box 02:55

    6.9 Advanced Validation Rule With Isnumber 00:41

    6.10 Business Scenario 00:37

    6.11 Demo 3 - Advanced Validation Rule With Isnumber 01:46

    6.12 Advanced Validation Rule With Istext 00:38

    6.13 Business Scenario 00:35

    6.14 Demo 4 - Advanced Validation Rule With Istext 01:12

    6.15 Combine Date And Logical Functions 00:36

    6.16 Business Scenario 00:43

    6.17 Demo 5 - Combine Date And Logical Functions 03:56

    6.18 Eomonth Function 01:26

    6.19 Business Scenario 00:30

    6.20 Demo 6 - Eomonth Function 01:10

    6.21 Match Function 03:06

    6.22 Business Scenario 00:26

    6.23 Match Function 00:37

    6.24 Business Scenario 00:30

    6.25 Index With Match Function 01:12

    6.26 ndex With Match Function 00:55

    6.27 Summary 00:48

    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