Excel Level 2
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.
Outline:
Chapter 1: Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
Chapter 2: Named ranges
- Module A: Using names in formulas
Chapter 3: Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
Chapter 4: Summarizing data
- Module A: Consolidation
- Module B: Subtotals
Chapter 5: PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
Chapter 6: Presentation features
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
Chapter 7: Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
Chapter 8: Collaboration
- Module A: Permissions
- Module B: Comments
Scheduled Courses
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "22742", "sortby": "EventDateStart", "sortorder": "ASC", "limit": "9999", "enablepagination": "false", "emptymessage": "This course isn't currently on the schedule, but we can add it. Just let us know.
", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 22742, "Name": "Excel Level 2", "Url": "/course/excel-level-2", "Url_List": [ "/course/excel-level-2" ], "UrlSlug": "excel-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:34:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n\n
Description:
ur Microsoft Excel Level 2 builds on the basic concepts and skills of our Excel Level 1 course to provide\nmore advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage\ncomplex workbooks, build more complex functions, use data analysis tools, make an impact with powerful\nchart and presentation features, and collaborate with other users.
\n\nOutline:
\nChapter 1: Managing workbooks
\n
- \n
- Module A: Managing worksheets \n
- Module B: Customizing Excel \n
Chapter 2: Named ranges
\n- \n
- Module A: Using names in formulas \n
Chapter 3: Tables
\n- \n
- Module A: Sorting \n
- Module B: Filtering tables \n
- Module C: Structured references \n
- Module D: Validation \n
- Module E: Transposing data \n
Chapter 4: Summarizing data
\n- \n
- Module A: Consolidation \n
- Module B: Subtotals \n
Chapter 5: PivotTables
\n- \n
- Module A: Creating and formatting PivotTables \n
- Module B: Manipulating PivotTables \n
- Module C: PivotCharts \n
Chapter 6: Presentation features
\n- \n
- Module A: Conditional formats \n
- Module B: Custom Formats \n
- Module C: Graphics \n
Chapter 7: Advanced charts
\n- \n
- Module A: Special chart types \n
- Module B: Sparklines \n
- Module C: Quick Analysis \n
Chapter 8: Collaboration
\n- \n
- Module A: Permissions \n
- Module B: Comments \n