Excel Microsoft 365 Intermediate

Sort data and apply filters to isolate pencil sales, then refine results by central region, date, and cost in a large Excel worksheet.

Learn to create and use Excel tables with insert, headers, and filters. Name the table, enable the total row, and apply design styles for easy data analysis.

Add charts and graphics to worksheets in Excel 365 intermediate, distinguish charts from graphs, and create, enhance, modify, and format charts with shapes and pictures.

Create a chart to compare items sold using a clustered column chart from recommended charts, then use filters to focus on specific items and explore a pivot chart.

Enhance your Excel charts by selecting individual chart elements, applying design styles, adjusting colors, and moving or resizing charts across worksheets for clear, customizable visuals.

Explore how to change chart types in Excel Microsoft 365 intermediate, switching between column, line, pie, and surface charts to better visualize income and shipping costs.

Format charts in Excel by applying chart design templates, adjusting shape styles, borders, colors, backgrounds, and fonts to customize bar graphs and overall chart appearance.

Insert pictures into a bar chart by selecting the plot area and using the format tab to apply a background image, texture, or gradient.

Create in-cell sparklines to display mini charts in a single cell, using a column sparkline. Highlight high and low points, first and last points, and adjust styles.

Learn to use Excel's statistical functions—counta, count, average, median, minimum, and maximum—via the formula bar and the statistics menu for range analysis.

learn to calculate the present value of a loan in excel using the pv function, applying the monthly rate, total payment periods, and monthly payment to find the loan amount.

Learn to compute monthly loan payments with Excel's PMT function and determine payoff time with the end per function, using rate, present value, and payment signs.

Explore text functions in Excel 365, using proper to capitalize names, replace to fix underscores, and concat to create a full name for mailing labels.

Copy formula values in Excel by selecting cells, choosing paste values to keep only the results and remove all formulas, then reuse the values elsewhere.

Explore the if functions and how to use VLOOKUP with exact and approximate matches, along with COUNTIF, in Excel 365 intermediate.

Learn to use the if function in Excel to return a true or false value based on a condition, with examples for total hours, regular hours, and overtime hours.

Explore proofing and research tools in Excel, including spell check, translate, and the review tab, to look up terms, apply changes, and insert suggested edits.

Learn how to adjust page breaks by moving the dotted line, choosing where the next page begins in the printed copy, and manually repositioning the break.

Learn how to add headers and footers to a worksheet for printing, using the page layout tools to insert the file name, sheet name, date, time, and page numbers.

Learn to add hyperlinks in Excel to navigate between worksheets and cells, link to web pages, and move quickly around the workbook using the insert hyperlink feature.

email a workbook in Excel Microsoft 365 by sharing it and attaching it as an Excel workbook or PDF, then send from your default email with a prefilled subject.

Learn to unlock cells and protect worksheets with passwords, creating a read-only sheet and selectively unlocking regions such as the region column while keeping the unit price locked.

Learn to assign a password to open Excel workbooks, encrypting it so it cannot be opened without a password. Go to File, Info, Protect Workbook, Encrypt with a password, confirm.

Learn to coauthor Excel workbooks in Office 365, replacing the old shared workbook, by sharing via OneDrive or SharePoint, enabling real-time collaboration with multiple editors.

Conclude the Excel 365 intermediate course by reviewing how to create tables and charts, use if, look up, count if, and ifs, and finalize, save, and share workbooks.