Excel Microsoft 365 Advanced

Explore chapter one of Excel 365 advanced, focusing on understanding and creating macros, and learning how to run and edit macros in a workbook or worksheet.

Learn to automate repetitive data tasks in Excel 365 by creating and using macros, including recording a macro, adding a developer tab, and combining first and last names with headings.

Learn to run and edit macros in Excel 365, add a macro button to the quick access toolbar, customize the ribbon, and modify macro code in the Visual Basic editor.

Master pivot tables in Excel 365 advanced by creating and modifying pivots, grouping by date and time and factors, and using slicers and pivot charts to clarify and manipulate fields.

Change and manipulate pivot table data by filtering countries and products, format numbers as currency, adjust styles and headers, toggle grand totals, and refresh to update results.

Learn how to use slicers to clarify and manipulate fields in Excel pivot tables and pivot charts, including product slicers and timeline slicers for visual filtering.

Develop pivot charts tied to the pivot table, choose chart types like bar, line, pie, and 3D variants, and customize legends, data labels, and filters by country, product, or segment.

Explore chapter three of Excel 365 advanced, learning to work with lists, query data, and database functions, and how to outline and subtotal data.

Query data with database functions in Excel Microsoft 365 by defining a named sales list, applying criteria to revenue, and computing sums, counts, averages, max, and min for selected reps.

Learn to outline and subtotal data in Excel 365; sort by item or date, apply subtotals to show item totals and grand totals, and use expand/collapse outlines to analyze details.

Learn to subtotal data by date and by month, using insert blank rows and auto sum to create month-by-month revenues across two years; manage subtotals with copy-paste.

Use Solver, an Excel numerical tool, to optimize income by adjusting unit sold, price per unit, and cost per unit, using what-if analysis and integer constraints.

Explore data management in chapter five of Excel 365 advanced, mastering sorting, filters, and splitting data into multiple columns with flash fill, removing duplicate records, and applying validation tools.

Master filters with tables using the data tab to show specific products such as Montana and Amaria and to filter by unit sold above 1000 and by date ranges.

Learn how to use flash fill in Excel 365 to automatically complete patterns in data entry, recognizing patterns to fill names and cities.

Use data validation tools in Excel to enforce date values, require a list of regions (north, south, east, west), and configure input messages and error alerts for correct data entry.

Learn how to embed charts from Excel into Word, choosing destination formatting or linking data, and embed as pictures while adjusting layout, chart style, and text wrapping.

Link objects from Excel to Word to keep data and charts synchronized by pasting with link options, showing updates in Word when Excel data changes.

Learn to import objects into Excel by copying tables and pictures from a Word document, then paste with source or destination formatting and paste special for different formats.

Concluding the Excel 365 advanced course, we review macros, pivot tables, data analysis tools, data management, and exchanging XML data with other programs learned across beginner to advanced classes.