Learn how to use PivotTables—Microsoft's pivot table feature—to summarize, sort, and analyze your data in Excel for Mac 2016.
- Excel (26)
- Office (10)
- Office 365 (6)
- Excel for Mac (4)
- Office for Mac (3)
- Visual Basic for Applications (2)
- Word (2)
- Access (1)
- Office Online (1)
- OneNote (1)
- PowerPoint (1)
- Qlik (1)
- QlikView (1)
- Tableau (1)
- Tableau Software (1)
- Business (27)
- IT (11)
- Spreadsheets (11)
- Data Analysis (10)
- Business Intelligence (7)
- Finance (5)
- Home + Small Office (3)
- Productivity (3)
- Accounting (2)
- Computer Skills (Windows) (2)
- Developer (2)
- Programming Languages (2)
- Big Data (1)
- Charts + Graphs (1)
- Collaboration (1)
- Computer Skills (Mac) (1)
- Databases (1)
- Education + Elearning (1)
- Student Tools (1)
- Teacher Tools (1)
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.
Learn everything you need to master Excel for Mac 2016, including using functions, printing worksheets, and collaborating with others.
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.
Learn everything you need to master Excel for Mac—now accessible from anywhere with an Office 365 subscription.
Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints.
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.
Learn to perform basic data-analysis tasks, from measuring covariance and correlation to testing hypotheses and calculating Bayesian probabilities, with these Excel tutorials.
Extend Excel's capabilities and automate complex tasks with VBA. Create advanced filters, charts, and forms, and manage workbooks and worksheets with VBA code.
Keep your Microsoft Office documents secure and private with these tutorials for Office 2007, 2010, 2013, and even Office 365.
Learn how to create, edit, and share Microsoft Word, Excel, PowerPoint, and OneNote documents with Office Online.
Learn how to perform cluster analysis using Excel.
Analyze hypothetical business cases using Excel formulas and variable data.
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.
Introduces object-oriented programming and provides a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language.
Shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010.
Provides comprehensive, hands-on Excel tutorials on PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.
A comprehensive overview of Excel spreadsheet software for the Mac.
Introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance the features in Excel.
Shows business owners and managers how to use Excel to create useful budgets that help them manage resources prudently.
Shows how Excel 2010 will be a beneficial upgrade for all users.
Shows how simple data in Excel can be used to build exciting and updatable charts.
Set up an efficient and flexible invoice management system with these Excel tutorials.
Explains the benefits of upgrading from Excel 2003 to 2007 and shows how to make the switch and overcome compatibility issues.
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.
Shows how to create PivotTable reports, an amazing tool for data analysis, using internal Excel data and outside data sources.
Shows how to create Pivot Table reports, an amazing tool for data analysis, using internal Excel data and outside data sources.
Provides a basic fluency in corporate finance, enabling users to grasp the meaning behind the calculations.
“It is like taking college classes without leaving home. Great for total beginners and long-time veterans.” —Trevor C.
more from our members »