COM 140 (2025): Excel

COM 140

Excel

Can you demonstrate your knowledge by working with Excel data, parts of a table, sorting data, formatting tables with styles,? Can you also create, open, save, close, navigate, and print a workbook.enter and create formulas, such SUM and COUNT functions, and create patterned text with Flash? Do you know how to format styles and merge cells? Now, let's set the print area, insert page breaks, add print titles, create headers and footers, and set margins.Insert functions, perform a what-if analysis, use the Quick Analysis tool, and Lookup functions, use Auto Fill series and formulas and set relative and absolute cell references.Use the PMT (payment) function to calculate a loan payment. Create and format chart elements such as an embedded pie chart, clustered column chart, stacked column chart, line chart, combination chart, histogram, and Pareto chart. All in Excel!

Excel and AI

How to use Copilot in Excel

First, make sure to format your data in a table or supported range for Copilot to read.
Select the Copilot icon. Select from the listed options to create something new, suggest formulas or formatting, summarize data, or something else.
Choose Chat with Copilot to open the chat window. Here you can choose from one of the prompt ideas or ask Copilot for help with something else.

Get insights about your data

Note: To use the feature described here, you need a work or school account with a qualifying Microsoft 365 business subscription, and a Microsoft 365 Copilot add-on license. See How Copilot works with and without a Microsoft 365 Copilot license.

Open Excel.
Make sure to format your data in a table or supported range.
From the Home tab on the ribbon, select Copilot > App Skills.
Ask Copilot to find the insights you're looking for. Type something in your own words, or modify one of the example prompts. The more specific your question, the better the answer Copilot can find. If you want your insights in a specific format, such as a PivotTable, specify that in your prompt.
Copilot analyzes your data to show insights as charts, PivotTables, summaries, trends, or outliers.
Review the insights provided to find ones that help you the most.
To add a generated chart to a sheet, select Add to a new sheet. If Copilot provided you multiple insights, you can add all insights to a grid in a new sheet.
Select Undo if you want to remove the insights from your new sheet.