Create and format worksheet content in Excel.

Manage worksheet and workbook structures.

Use filtering and sorting techniques with large data blocks.

Use common formulas in a worksheet.

Recognize correct syntax for formula calculations.

Create a free Microsoft 365 account

Use functions with criteria in Microsoft Excel

Perform calculations with criteria input in Microsoft Excel

Find and replace data values in an Excel spreadsheet.

Sort rows of data in an Excel spreadsheet to reorganize data into a more useful sequence.

Apply filters to an Excel spreadsheet to select specific rows.

Recognize basic spreadsheet functions for data calculations and lookups.

Apply data validation and formatting rules to enhance data quality and readability.

Make connections between various sources within Microsoft Excel.

Use table functionalities in Microsoft Excel to organize, sort, and filter data.

Visually analyze data by highlighting cells on the basis of conditional formatting rules.

Explore trends by graphing data in the form of line and column charts, through the use of PivotTables.

Create an account with Microsoft Office 365 online and upload a document.

Use sorting and filtering tools to perform simple data analysis.

Use functions such as IF, VLOOKUP and create PivotTables to perform more advanced data analysis.

Use functions to prepare text data for effective analysis.

Use sorting and filtering tools to perform simple data analysis.

Use functions such as IF, VLOOKUP and create PivotTables to perform more advanced data analysis.

Create a dynamic data block using tables in Microsoft Excel.

Create a PivotTable in Microsoft Excel.

Use PivotTables and slicers to create a dynamic report in Microsoft Excel.   

Gather and export data in Microsoft Excel

Create charts in Microsoft Excel

Generate report in Microsoft Excel

Create PivotTables to assess specific relationships within the data.

Create line, bar, and pie charts to present the information from the PivotTables.

Compose a dashboard with the charts and tables created to present a global picture of the data.

Generate and manipulate data with Copilot in Excel

Chart data with Copilot in Excel

Gain insights with Copilot in Excel

You will learn how to effectively standardize, extract, classify, and generate data through the combined power of Excel and ChatGPT.

Learners will be able to transform raw financial data into persuasive Excel narratives, refining clarity and flow through peer feedback.

Collaborate in shared Excel workbooks using co-authoring, comments, and coordinated review workflows.

Manage workbook versions and protect approved Excel content during collaborative work.

Synthesize skills from across the Foundations of Excel for Business program by producing an integrated portfolio workbook.

Reflect on your learning path and identify next steps for continued development.