Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints.
Make your data more intuitive and visually appealing by creating an interactive dashboard in Excel.
Combine DAX—Data Analysis Expressions—with Excel Power Pivot and take your Excel analysis skills to the next level.
Learn how to find free, public sources of data on a variety of business, education, and health issues and download the data for your own analysis in Excel.
Understand the different classes of analytics—descriptive, predictive, and discovery— and be able to deliver prescriptive actions rather than analytics without action.
Learn to perform basic data-analysis tasks, from measuring covariance and correlation to testing hypotheses and calculating Bayesian probabilities, with these Excel tutorials.
Discover how to work with charts and graphs in Excel, and visualize your data in a new way.
Get a new Microsoft Office tip every Tuesday. Take a five-minute break to improve your productivity and efficiency.
Extend Excel's capabilities and automate complex tasks with VBA. Create advanced filters, charts, and forms, and manage workbooks and worksheets with VBA code.
Learn how to create themes that can be used in all Office 2013 apps, and build the themes into templates that lock down content.
Find out how to use the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel.
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.
Learn how to use Excel and Excel SQL Server Analysis Services to perform basic data mining and analysis.
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.
Upgrading from Office 2010 to Office 2013? Get used to the new interface and touch controls, and explore the latest features in Word, Excel, PowerPoint, and Outlook.
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.
Get a high-level overview of the Microsoft BI stack, including its visualization and forecasting features, SQL Server 2012 Integration Services, and data warehousing options.
Discover the best tips and tricks in Excel 2013, and unleash the real power of this popular, powerful software.
Upgrading from Office 2007 to Office 2013? Get used to the new interface and touch controls, and explore the new features in each of the major application: Word, Excel, PowerPoint, and Outlook.
Learn how to clean up your Excel data with a few simple and easy-to-understand functions, commands, and techniques.
Learn how to create a simple database with Excel.
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 perform cluster analysis using Excel.
Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
Learn how to format and calculate dates and times in Excel 2013.
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.
Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.
Analyze hypothetical business cases using Excel formulas and variable data.
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013.
Drive your PowerPoint presentations with Excel data.
Present data to your audience in a more visually compelling way with charts in this Excel tutorial.
The 2013 update to our popular series of Excel tutorials demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.
Learn to summarize, sort, count, and chart your data with PivotTables in these Excel tutorials.
These comprehensive Excel tutorials reveal over 65 Excel tips, tricks, and shortcuts.
Take a look at suite-wide enhancements like cloud integration, Touch Mode, PDF editing, and Ribbon customization, as well as individual app improvements added to Office 2013.
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.