Excel Level 3
Description:
Our Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if- analysis, and macros.
Outline:
Chapter 1: Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
Chapter 2: Advanced Formula
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
Chapter 3: Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
Chapter 4: Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
Chapter 5: Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
Chapter 6: Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
Scheduled Courses
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n
{ "Params": { "source": "Event", "layout": "List for Course Detail Page", "filterby": "Course", "filtervalue": "9344", "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": 9344, "Name": "Excel Level 3", "Url": "/course/excel-level-3", "Url_List": [ "/course/excel-level-3" ], "UrlSlug": "excel-level-3", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2024-09-16T10:36:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\nDescription:
\nOur Microsoft Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide\nadvanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions,\nauditing and error-handling, array functions, date and text functions, importing and exporting, what-if-\nanalysis, and macros.
\nOutline:
\nChapter 1: Logical and Lookup Functions
\n
- \n
- Module A: Decision-making functions \n
- Module B: Lookup and reference functions \n
Chapter 2: Advanced Formula
\n- \n
- Module A: Auditing and error-trapping \n
- Module B: Formula options \n
- Module C: Arrays \n
Chapter 3: Special functions
\n- \n
- Module A: Date and time functions \n
- Module B: Text functions \n
- Module C: Other functions \n
Chapter 4: Importing and Exporting
\n- \n
- Module A: The Power Pivot Data Model \n
- Module B: Exporting data \n
Chapter 5: Analysis
\n- \n
- Module A: What-if analysis \n
- Module B: The Analysis Toolpak \n
Chapter 6: Macros and Forms
\n- \n
- Module A: Recording macros \n
- Module B: Running macros \n
- Module C: Forms \n