CourseChapTopicID | CourseChapTopicName | |
172 | Sharing and Maintaining Workbooks |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1616 | 172 | Apply workbook settings, properties and data options•Setting advanced properties; saving a workbook as a template; importing and exporting XML data |
Learn
| | |
1617 | 172 | Apply 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
| | |
1618 | 172 | Maintain shared workbooks•Merging workbooks; setting Track Changes options |
Learn
| | |
|
173 | Applying Formulas and Functions |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1619 | 173 | Audit formulas•Tracing formula precedents, dependents and errors; locating invalid data or formulas; correcting errors in formulas |
Learn
| | |
1620 | 173 | Manipulate formula options•Setting iterative calculation options; enabling or disabling automatic workbook calculation |
Learn
| | |
1621 | 173 | Perform data summary tasks•Using an array formula; using a SUMIFS function |
Learn
| | |
1622 | 173 | Apply functions in formulas•Finding and correcting errors in functions; applying arrays to functions; using Statistical, Date and Time, Financial, Text and Cube functions |
Learn
| | |
|
174 | Presenting Data Visually |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1623 | 174 | Apply advanced chart features•Using Trend lines, Dual axes, chart templates and Sparklines |
Learn
| | |
1624 | 174 | Apply data analysis•Using automated analysis tools; performing What-If analysis |
Learn
| | |
1625 | 174 | Apply and manipulate PivotTables•Manipulating PivotTable data; using the slicer to filter and segment your PivotTable data in multiple layers |
Learn
| | |
1626 | 174 | Apply and manipulate PivotCharts•Creating, manipulating and analysing PivotChart data |
Learn
| | |
1627 | 174 | Demonstrate how to use the slicer•Choosing data sets from external data connections |
Learn
| | |
|
175 | Working with Macros and Forms |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1628 | 175 | Create 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
| | |
1629 | 175 | Insert and manipulate form controls•Inserting form controls; setting form properties |
Learn
| | |
|