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: MOS Certification (77-428)

Course Summary

Learn ALL the advance skills, tools of excel in this course & get certified


  • +

    Course Syllabus

    • Manage and Share Workbooks
      • Introduction
      • Objectives
      • Modify Workbook Templates
      • Business Scenario
      • Demo - Modify Workbook Templates
      • Merge Multiple Workbooks
      • Business Scenario
      • Demo - Merge Multiple Workbooks
      • Manage Multiple Versions Of A Workbook
      • Remove Workbook Metadata
      • Copy Styles Between Tables
      • Business Scenario
      • Demo - Copy Styles Between Templates
      • Copy Macros Between Workbook
      • Business Scenario
      • Demo - Copy Macros Between Workbooks
      • External Data Connections
      • Business Scenario
      • Demo - External Data Connections
      • Protect Workbooks For Sharing
      • Business Scenario
      • Demo - Protect Workbooks For Sharing
      • Protect Worksheet Structure
      • Business Scenario
      • Demo - Protect Worksheet Structure
      • Set Tracking Options
      • Business Scenario
      • Demo - Set Tracking Options
      • Restrict Editing And Limiting Editors
      • Business Scenario
      • Demo - Restrict Editing And Limiting Editors
      • Encrypt Workbooks With A Password
      • Business Scenario
      • Demo - Encrypt Workbook With A Password
      • Mark Workbooks As Final
      • Business Scenario
      • Demo - Mark Workbooks As Final
      • Control Calculations Options
      • Business Scenario
      • Demo - Control Calculations Options
      • Summary
      • Quiz
    • Apply Custom Formats and Layouts
      • Apply Custom Formats and Layouts
      • Objectives
      • Create Custom Formats (number, Time, Date)
      • Business Scenario
      • Demo - Create Custom Formats Number Date
      • Create Custom Accounting Formats
      • Advanced Fill Series Options
      • Business Scenario
      • Demo - Advanced Fill Series Options.
      • Create Custom Templates
      • Create And Modify Cell Styles
      • Business Scenario
      • Demo - Create And Modify Cell Styles
      • Create Custom Color Formats
      • Business Scenario
      • Demo - Create Custom Color Formats
      • Create Custom Font Formats
      • Business Scenario
      • Demo - Create Custom Font Formats
      • Create Themes
      • Business Scenario
      • Demo - Create Themes
      • Create Form Fields
      • Business Scenario
      • Demo - Create Form Fields
      • Control The Tab Order Of Objects
      • Summary
      • Quiz
    • Create Advanced Formulas
      • Create Advanced Formulas
      • Objectives
      • Nested Functions
      • If, And, Or Functions
      • Business Scenario
      • Demo - If And Or Functions
      • Advanced Sumifs Function
      • Business Scenario
      • Demo - Advanced Sumifs Functions
      • Advanced Countifs Function
      • Business Scenario
      • Demo - Advanced Countifs Functions
      • Advanced Averageifs Function
      • Business Scenario
      • Demo - Advanced Averageifs Functions
      • What-if-analysis Tools
      • Watch Window
      • Business Scenario
      • Demo - Utilize Watch Window
      • Goal Seek
      • Business Scenario
      • Demo - Goal Seek
      • Create Scenarios
      • Business Scenario
      • Demo - Create Scenarios
      • Create Data Table
      • Business Scenario
      • Demo - Data Table
      • Consolidate Data
      • Business Scenario
      • Demo - Consolidate Data
      • Financial Functions
      • Summary
      • Quiz
    • Create Advanced Charts and Objects
      • Create Advanced Charts and Objects
      • Objectives
      • Pivotchart
      • Create New Pivotcharts
      • Business Scenario
      • Demo - Create New Pivotcharts
      • Pivotcharts With Animations
      • Business Scenario
      • Demo - Pivotcharts With Animations
      • Manipulate Options In Existing Pivotcharts
      • Business Scenario
      • Demo - Manipulate Options In Existing Pivotcharts
      • Pivotchart Styles
      • Business Scenario
      • Demo - Pivotcharts Styles
      • Summary
      • Quiz
    • Excel 2013 Advance New Features
      • Introduction
      • Objectives
      • Demo - Installing Apps From Office Store
      • Introduction To Apps For Office
      • Installing Apps From Office Store
      • Business Scenario
      • Inserting And Managing Apps
      • Business Scenario
      • Demo - Inserting And Managing Apps
      • Timeline Filter
      • Business Scenario
      • Demo - Timeline Filter
      • Introduction To Powerview Report
      • Create Powerview Report
      • Business Scenario
      • Demo - Creating Powerview Reports
      • Powerview Reports Options
      • Business Scenario
      • Demo - Powerview Reports Option
      • Summary
      • Quiz
    • Creating Templates with Advanced Functions
      • Introduction
      • Objectives
      • Creating Excel User Defined Templates
      • Business Scenario
      • Multiple List Box
      • Business Scenario
      • Demo 1 - Creating Excel User Defined Templates
      • Advanced Validation Rule With Isnumber
      • Business Scenario
      • Demo 2 - Multiple List Box
      • Advanced Validation Rule With Istext
      • Business Scenario
      • Demo 3 - Advanced Validation Rule With Isnumber
      • Combine Date And Logical Functions
      • Business Scenario
      • Demo 4 - Advanced Validation Rule With Istext
      • Eomonth Function
      • Business Scenario
      • Demo 5 - Combine Date And Logical Functions
      • Match Function
      • Business Scenario
      • Demo 6 - Eomonth Function
      • Index With Match Function
      • Business Scenario
      • Demo - Index With Match Function
      • Match Function
      • Summary
    • Microsoft Excel 2013 Advanced MOS Certification Exam 77-428 Test Papers
      • Microsoft Excel 2013 Advanced MOS Certification Exam 77-428 Test Paper 1
      • Microsoft Excel 2013 Advanced MOS Certification Exam 77-428 Test Paper 2
      • Microsoft Excel 2013 Advanced MOS Certification Exam 77-428 Test Paper 3


Course Fee:
USD 199

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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