This is the Course Details

Undernoted courses basic learning have been illustrated in the undernoted link to learn the basic of the the all courses  tutorials.  After Buying the exam voucher , you will get 40hrs courses extra to complete the project base tutorials  through office 365 / shere point platform . for that you required to learn oneNote

You have selected  the  Microsoft Corporation  for the  Microsoft Office Specialist (MOS)  course in  Exam: 77‐888 MOS Excel 2010 Expert  

172 Sharing and Maintaining Workbooks
1616172Apply workbook settings, properties and data options•Setting advanced properties; saving a workbook as a template; importing and exporting XML data Learn   
1617172Apply protection and sharing properties to workbooks and worksheets•Protecting the current sheet; protecting the workbook structure; restricting permissions; requiring a password to open a workbook Learn   
1618172Maintain shared workbooks•Merging workbooks; setting Track Changes options Learn   
173Applying Formulas and Functions
1619173Audit formulas•Tracing formula precedents, dependents and errors; locating invalid data or formulas; correcting errors in formulas Learn   
1620173Manipulate formula options•Setting iterative calculation options; enabling or disabling automatic workbook calculation Learn   
1621173Perform data summary tasks•Using an array formula; using a SUMIFS function Learn   
1622173Apply functions in formulas•Finding and correcting errors in functions; applying arrays to functions; using Statistical, Date and Time, Financial, Text and Cube functions Learn   
174Presenting Data Visually
1623174Apply advanced chart features•Using Trend lines, Dual axes, chart templates and Sparklines Learn   
1624174Apply data analysis•Using automated analysis tools; performing What-If analysis Learn   
1625174Apply and manipulate PivotTables•Manipulating PivotTable data; using the slicer to filter and segment your PivotTable data in multiple layers Learn   
1626174Apply and manipulate PivotCharts•Creating, manipulating and analysing PivotChart data Learn   
1627174Demonstrate how to use the slicer•Choosing data sets from external data connections Learn   
175 Working with Macros and Forms
1628175Create and manipulate macros•Running a macro; running a macro when a workbook is opened; running a macro when a button is clicked; recording an action macro; assigning a macro to a command button; creating a custom macro button on the Quick Access Toolbar; applying modifications to a macro Learn   
1629175Insert and manipulate form controls•Inserting form controls; setting form properties Learn   


© 2024 - CodeHub India 2015   

data-share="true" data-width="450" data-show-faces="true">