CourseChapTopicID | CourseChapTopicName | |
204 | Manage and share workbooks |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1714 | 204 | Manage workbook changes •Track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes |
Learn
| | |
|
205 | Apply custom formats and layouts |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1715 | 205 | Apply advanced conditional formatting and filtering •Write custom conditional formats, use functions to format cells, create advanced filters, manage conditional formatting rules |
Learn
| | |
1716 | 205 | Prepare a workbook for internationalisation and accessibility •Modify tab order among workbook elements and objects, display data in multiple international formats, modify worksheets for use with accessibility tools, utilise international symbols, manage multiple options for +Body and +Heading fonts |
Learn
| | |
|
206 | Create advanced formulas |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1717 | 206 | Look up data with functions •Use the LOOKUP function, use the VLOOKUP function, use the HLOOKUP function, use the TRANSPOSE function |
Learn
| | |
1718 | 206 | Apply advanced date and time functions •Use the NOW and TODAY functions, use functions to serialise dates and times |
Learn
| | |
|
207 | Create advanced charts and tables |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1719 | 207 | Create advanced chart elements •Add trendlines to charts, create dual axis charts, create custom chart templates, view chart animations |
Learn
| | |
1720 | 207 | Create and manage PivotTables •Create new PivotTables, modify field selections and options, create a slicer, group records, utilise calculated fields, format data, utilise PowerPivot, manage relationships |
Learn
| | |
|