Excel for the web offers many powerful features, but because its interface differs from the interface of the desktop tool, most users only use its basic spreadsheet functionality. In this course, instructor Joshua Rischin shows you how to get more out of Excel for the web. Joshua explains some basics of data, including how to cleanse data and use Flash Fill to add data quickly. He gives several useful tips for using custom formatting, hyperlinks, and conditional formatting in Excel for the web. Joshua goes over how to customize your workbooks, as well as create Pivot Tables and Pivot Charts. He covers ways to collaborate, while still protecting your work, and discusses how to use Excel Desktop to get even more from your Excel for the web experience. He steps you through some advanced features, like Excel Ideas and scripts, then concludes with advice on how to apply what you’ve learned from the course.

Want to get more out of Excel? Get bite-sized tips designed to help you master some of the program's most useful functions and formulas.

Find out how Excel can help solve real-world problems. Learn how to use Excel to manage property, build seating charts, track chores, and more.

Excel is the most widely used data analysis software on the market, but many people in business are not using it to its full potential. Excel can be a great tool for building financial and operational models, allowing users to understand what may happen in the future and how the business can position itself. In this course, learn how to build effective and useful financial models in Excel to forecast sales and costs, profits, operational KPIs, business assets and liabilities, and much more. Instructor Michael McDonald covers rules and best practices for financial modeling and then shows how to set up single-sheet and multi-sheet financial models and add inputs and assumptions, external data, projections, and more. Plus, learn how to determine the accuracy and strength of your models and keep them up to date as the data evolves. By the end of this course, you will have the tools and tricks you need to become a master of Excel modeling for businesses ranging from restaurants and manufacturing firms to banks and software companies.

Take an in-depth look at PivotTables and PivotCharts, two powerful data analysis tools in Excel. Learn how to more efficiently evaluate your data, by using them together.

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