Description:
“Course that dives into the fundamentals of using Microsoft Excel from a practical use perspective. The course covers principles of data collection and analysis, building functional spreadsheets, Excel tools, and macros. Emphasis is placed on practicality. Learning outcomes: – Navigate Microsoft Excel and demonstrate a basic understanding of its functionality – Determine what categories of data are relevant to a given business scenario, and present collected data in an organized, logical format – Employ Microsoft Excel tools, in varying levels of complexity, to present and analyze business data (including calculated cells, logical statements and other functions, charts and pivot tables, and filtering) – Understand basic syntax of Microsoft Visual Basic within the context of macro code – Record macros and write simple code for macros