Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.

Learn to use Excel functions for financial analysis. Find out how to calculate loan payments, depreciation, rate of return, and more, in Microsoft Excel.

Discover how to use Excel to create a balanced scorecard to measure business performance based on financial, process, customer, and learning and growth metrics.

Learn the basics of charts and graphs in Excel. Find how to create engaging data visualizations with these simple Excel chart tips.

Make your spreadsheet data more readable and compelling with these simple Excel formatting tips.

Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.

Excel macros allow you to automate routine tasks. Although working with macros involves the Visual Basic for Applications (VBA) programming language, you don’t need to be a programmer to use it. In this course, Excel guru and Microsoft content developer Chris "Smitty" Smith provides a quick introduction to macros and VBA. He walks through the steps of recording a basic macro, then demonstrates how to edit macros, including testing and adjusting, and making recorded macros dynamic. Learn how to do more with Excel using macros.

Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP.

Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).

Speed up your Excel workflow by recording macros that automate repetitive tasks. Learn how to begin working with macros—regardless of your level of technical expertise.

Explore ways to save time by automating tasks with macros in Microsoft Excel.

Learn how to use Excel for key managerial accounting tasks. In this hands-on course, explore performing variance analysis, doing activity-based costing, and using ratio analysis.

Leverage the power of Excel to become a more effective marketer. Learn how to use Excel to tackle product pricing, focus group response analysis, and more.

Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis.

Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.

Learn how to summarize and analyze data using the most powerful and most overlooked feature in Excel: PivotTables.

Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.

Learn about the time-saving capabilities of Power Query (Get & Transform) for easily importing, connecting, combining, and refining data in Excel with reusable queries.

If even a small part of your job entails using Microsoft Excel, there’s a good chance that at some point you’ve received a spreadsheet where the data is unorganized, disconnected, or generally not in great shape. And despite common practice, a long, heavy sigh is not officially part of any recommended Excel workflow. Rather than pull your hair out at the mess of data you see before you, you can use Power Query in Excel to help you import and clean data into something easier to work with. In this course, Excel expert Dave Ludwig takes you through the robust features set of Power Query. Dave shows you how to use Power Query to connect to your data source, filter data, and create conditional columns of data. He also shows off the significant cleansing capabilities of Power Query. Once your data is cleaned up, you can more easily create formulas, PivotTables, charts, and generally get on with your business.

Add powerful productivity tools to your Excel skill set. Learn shortcuts and hidden tools for supercharging your efficiency in Microsoft Excel.