Excel also comes with what Microsoft calls 'slicers' - buttons you can click to filter tables or pivot table data. Pivot tables let you quickly make sense of data in rows and columns by analyzing and displaying a summary of your data.

Pivot tables: Along with functions, Excel's not-so-secret weapon is the pivot table. Excel also comes with specialized functions for cube, database, date and time, engineering, financial, information, logical, lookup, math, statistical, text, and Web functions. Among the most useful are the SUM, IF, LOOKUP, VLOOKUP, MATCH, CHOOSE, DATE, DAYS, FIND, and INDEX functions. You can quickly access formulas via Excel's formula bar.Ī good part of what makes Excel so powerful is the breadth of its functions, which build on formulas. Tons of formulas and functions: With formulas, you can perform calculations on data in your Excel spreadsheet, such as finding the total for a row of numbers. The standalone version also doesn't include OneDrive services and Skype. The standalone Excel for Windows includes bug fixes and improvements, but it doesn't get you an upgrade to the next major edition of the software. Or buy Excel separately: If you don't need the other apps that make up the Office apps, you can get the Microsoft Excel 2016 separately for $129.99. If you'd rather just buy Office and be done with it, for $149.99, you can purchase the Office Home and Student 2016 for PC edition, which includes Word, Excel, PowerPoint, and OneNote. For $69.99 a year, get the Office 365 Personal edition, which along with Excel, comes with Word, the word-processing workhorse PowerPoint, the ubiquitous slideshow app OneNote, for note-taking across platforms Outlook, a full-featured email service OneDrive, Microsoft's cloud storage service and Skype, for voice and video calls.įor $99 a year, subscribe to the Office 365 Home edition, which includes the same productivity apps and lets you share your subscription with four other users. ProsĮxcel comes as part of Microsoft Office 365: Microsoft Excel is the spreadsheet portion of the Microsoft Office applications.

Microsoft Excel 2016 for Windows is a workhorse of a spreadsheet software, offering powerful methods for summarizing, analyzing, exploring, and presenting your data.

Excel 2013 free download mac