Explore all the steps for data modeling with Excel's Power Pivot plugin—adding data sources, setting up relationships, and adding hierarchies—and discover the power of DAX expressions.
Use Excel's data-analysis tools to create accurate and insightful forecasts.
Analyze past performance data and get a realistic picture of your company's future performance using Microsoft Excel.
Learn about the high-level concepts of business performance analysis, and find out how to make informed decisions about the financial future of your company.
Learn how to analyze the top line (aka revenue) for your company and identify areas of under- or overperformance with Excel.
Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.
Learn how to clean up your Excel data with a few simple and easy-to-understand functions, commands, and techniques.
Learn how you can easily search, access, and analyze data within and outside your organization in just a few clicks with Power BI—the business intelligence features that lie inside Microsoft Office.
Learn how to manage and analyze large amounts of data with sorting, filtering, and statistical and database analysis functions.
Learn how to use the data validation tools in Excel to control how users input data into workbooks and ensure data is entered consistently and accurately.
Analyze hypothetical business cases using Excel formulas and variable data.