Microsoft Excel 365 Masterclass

Format your spreadsheet values by selecting cells, opening the format cells dialog, and choosing date or currency categories to apply specific formats such as date, currency, accounting, or custom rules.

Apply conditional formatting in Excel to highlight values greater than 50 USD and less than 50, using highlight cells rules and color formats.

Select the cells, open alignment options, rotate text to 80 degrees or adjust text direction, and apply center, left, or right alignment with top or bottom positioning.

Learn to change font styles and cell styles in Microsoft Excel by selecting cells, using the Home menu, and applying text effects to highlight data.

Copy cell formats with the format painter in the Microsoft Excel 365 masterclass by selecting a formatted cell, clicking format painter in the home menu, and dragging to other cells.

Learn to add a watermark to an Excel sheet by inserting a picture into the header and adjusting its size for a subtle watermark using header and footers.

Hide or show zero values in an Excel sheet and in specific cells by using file options under advanced display, or apply a custom format with zero and semicolon codes.

Create and apply custom number formats in excel to display numbers as currency, decimals, or text. Use the custom formats dialog to set US dollars for unit prices.

Learn how to sort data in a Microsoft Excel 365 table, including single and multi-column sorts, A to Z and custom multi-level sorts using the sort and filter tools.

Learn to use Excel's custom auto filter to display data in a range by using the data tab filter, number filter, and between operators to show values 21 to 50.

Total the data in an Excel table by formatting the data as a table, enabling the total row, and selecting average, max, or min for quick summaries.

Learn how to create and use slicers in Excel to filter a data table by category such as gender and job, and quickly clear filters to view full data.

Explore the basics of formulas and functions in Microsoft Excel, including addition, subtraction, multiplication, division, and power, with guided practice using cell references to convert human steps into computer calculations.

Learn to use the sum function in Microsoft Excel to total numbers with the sum formula, by selecting a range and pressing enter.

Explore sumif and sumifs to sum values by two or more criteria, selecting item ranges like apples and honeycrisp, and pairing criteria with the corresponding sum ranges.

Learn to count values with countif and countifs by selecting a range and applying single or multiple criteria, using apples, lemons, and bananas as examples.

Learn how to use ifs statements in Microsoft Excel, set conditions, compare values, and apply true or false outcomes with proper comma and bracket syntax.

Learn to use vlookup to find values in a data table, select the lookup value, define the table range, pick the column index, and set false for an exact match.

Master date and time calculations in Excel by using date and time functions to compute today’s date, birthdays, due dates, grace periods, and daily work hours with lunch breaks.

Learn to combine text from two or more cells into one cell using an Excel formula. See how the formula is built with equal signs, quotes, spaces, and commas.

In the Microsoft Excel 365 masterclass, learn to use the left and right formulas to extract numbers or text from cells, with six-digit right extractions and four-character left extractions.

Learn to count characters in text or any cell using the length formula. Type =length, select a cell, and press enter to view the character count.

Master left, right, and len in Excel 365 to extract text and numbers from cells, then chain left and right with len to pull six-digit sequences using a template.

Learn to use min and max in Excel to find the smallest and largest values in a data range. Select a range, apply min or max formula, and press enter.

Learn to perform descriptive statistics in Excel using the Analysis ToolPak. Calculate mean, median, standard deviation, and other statistics for monthly income quickly.

Learn to create a chart from start to finish in Excel by selecting data, using recommended charts, switching rows and columns, and adding data labels for clear visuals.

Learn to add and remove chart titles in the Microsoft Excel 365 masterclass, using chart elements, outline, and chart title option to label charts such as a quarterly sales report.

Learn to format chart elements in Excel by adding axis titles, labeling the x and y axes, and adjusting chart layouts to clearly present the data by quarter.

Learn to show or hide chart legends and data tables in Excel 365 by selecting a chart and using the element toggles near the chart, including data labels.

Learn to add a trendline or moving average to a chart in Excel 365, select a data series, apply the trendline by quarter, and remove it when needed.

Learn to analyze data instantly by using Excel's quick analyze tool to select data, preview charts, and add data labels or trend lines for clear visualization.

Select the chart, highlight the data, and edit values to update the bars; see how changing data to 150 updates the chart and reveals updated data labels.

Learn to visualize data trends with sparklines in Excel by selecting data and using Quick Analysis to insert line sparklines for quarterly sales.

Visualize country-level data in Excel by using the maps feature, selecting data, and setting country names and the forested area percentage as the series values.

Learn how to create a pivot table from a well-formatted data sheet in Microsoft Excel, including grouping by product and counting customers across quarters using rows and values.

Refresh your pivot tables to reflect updates from the data sheets, choosing refresh source to update sums in q1 and understand when refresh all is needed.

Master pivot table values in Microsoft Excel 365 by creating a pivot table and switching formulas from sum to average, maximum, and more for product sales.

Create a pivot table, drag product and sales amount, and use calculate values to switch from sum to count or maximum, revealing product sales insights.

Learn to create a calculated field in pivot tables by multiplying the sale amount by 50% to calculate net profit from gross sale.

Create pivot charts from your data to visualize product types by quarter using pivot tables, customize colors by point, and switch between column, line, or pie charts.

Learn to create and use slicers to filter pivot table data in Excel 365, selecting fields such as regions, and clear filters with a single click.

Learn to add a pivot table timeline by inserting a timeline for the order date field, filter by date ranges, and clear selections as needed.

Connect pivot tables to external data sources such as files on this computer or Google Spreadsheets, select the dataset, set up the pivot, and drag regions to rows to count.

Change the data source for a pivot table by selecting a new dataset, switching from table one to Temple 13, then click okay and refresh the pivot table.