Discover how to analyze your sales pipeline using Salesforce and Microsoft Excel.

Prevent common errors from occurring in your Excel data with this short course.

Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.

Conditional formatting sounds more complicated than it is. This powerful tool in Microsoft Excel allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this short course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Learn how to use all the rules and options, such as data bars and icon sets, and apply conditional formatting across many rows of data.

Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.

Learn how to create data-rich Excel dashboards using Power Query.

Discover how to easily create, track, and manage invoices in Microsoft Excel.

Learn how to design, create, and maintain robust business budgets using Microsoft Excel.

Learn how to save time and ensure more accurate data by creating drop-down lists in Excel.

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.