Take your PivotTable skills to the next level. Review practical case studies that showcase how this powerful data analysis tool is used in the real world.

Learn quick ways to become more organized and efficient when using Power Query, a tool inside Microsoft Excel that lets you search, connect, and shape data.

Take your Excel skills to the next level with these advanced challenges from an Excel MVP.

The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time.

Get the answers to common Microsoft Excel questions. Learn tips for how to format cells, align rows and columns, calculate sums, generate series data automatically, and more.

Learn statistics. Dr. Joseph Schmuller uses Microsoft Excel to teach the fundamentals of descriptive and inferential statistics.

Learn more statistics fundamentals. Find out how to perform ANOVA, regression, and correlation testing and run simulations in Microsoft Excel.

Did you know you can record and run Solver macros, generate random inputs, run multiple simulations, and more, in Excel? Moreover, you can do all this without buying expensive specialty software. In this course, instructor Curt Frye shows how to enhance your supply chain analysis using the Solver add-in in combination with VBA. Working from an example transportation problem, Curt steps through creating a reference to the Solver VBA library, recording and running a Solver macro, generating random inputs, and defining a loop structure to run multiple simulations. Then he moves on to enabling detailed analysis by writing model output, creating a results dashboard to analyze your model output, exploring alternative scenarios with a Solver model, and more.

Learn how to use Excel to conceptualize, set up, and solve inventory problems to minimize purchasing cost and reduce the risk and cost of stockouts.

Learn how to use Microsoft Excel to conceptualize, set up, and solve transportation problems in order to minimize costs in a supply chain.

Get a new productivity-boosting tip every Tuesday from Excel expert Dennis Taylor.

Creating filters Chaining and combining filter criteria Determining whether workbooks and worksheets exist, with VBA Opening, closing, and saving workbooks Using VBA to calculate data via Excel's built-in functions Creating charts with sparklines Adding fields to UserForms Manipulating PivotTables with VBA

Learn how to use Excel and VBA for business process modeling. Find out how to create and run simulations for customer flow, queuing, and manufacturing.

Build your Excel skills, one week at a time. Accept a new challenge every Friday to learn and practice Excel.

Learn advanced formatting techniques in Excel that can help you create effective and appealing spreadsheets.

Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.

Leverage some of the most powerful analytics techniques for Excel. Learn how to conduct outlier detection, perform Monte Carlo simulations, use CUBE functions, and more.

Learn how to evaluate and visualize cash flows using Microsoft Excel.

Discover how to analyze your marketing performance using Microsoft Excel.