CourseChapTopicID | CourseChapTopicName | |
208 | Manage and share workbooks |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1721 | 208 | Manage multiple workbooks•Modify existing templates, merge multiple workbooks, manage versions of a workbook, copy styles from template to template, copy macros from workbook to workbook, link to external data |
Learn
| | |
|
209 | Apply custom formats and layouts |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1722 | 209 | Apply custom data formats•Create custom formats (Number, Time, Date), create custom accounting formats, use advanced Fill Series options |
Learn
| | |
1723 | 209 | Apply custom styles and templates•Create custom colour formats, create and modify cell styles, create and modify custom templates, create form fields |
Learn
| | |
|
210 | Create advanced formulas |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1724 | 210 | Apply functions in formulas•Use the IF function in conjunction with other functions, use AND/OR functions, use nested functions, use SUMIFS, AVERAGEIFS and COUNTIFS functions |
Learn
| | |
1725 | 210 | Create scenarios•Use the watch window, consolidate data, enable iterative calculations, use What-If analysis tools (including Goal Seek), use the Scenario Manager, use financial functions |
Learn
| | |
|
211 | Create advanced charts and tables |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1726 | 211 | Create and manage PivotCharts•Create new PivotCharts, manipulate options in existing PivotCharts, apply styles to PivotCharts |
Learn
| | |
|