Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks. Instructor. Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis.
He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show. Skills covered in this course.
Office 365 is Microsoft's office software package, which includes programs like Word, Excel, and PowerPoint. With this software, you can open and edit all MS Office file types, including TXT, XLSX, and PPT. This is a trial version that is available for one month. 3 days ago - Everything you need to know about Office for Mac and Office 365, including advice about which version. How much does Office for Mac cost?
Course Transcript - Voiceover Hi, I'm Curt Frye. Welcome to Office 365 for Mac: Excel Essential Training.
If you subscribe to Office 365, then you have access to the entire suite of Microsoft Office productivity tools, which currently includes Excel 2016 for Mac. In this course, I'll teach you all the skills you need to use Excel 2016 effectively. I'll start by showing you how to run Excel, how to navigate the program's user interface, and how to get help within the program or online. In the last part of the course, I'll teach you some slightly more advanced techniques that will let you summarize your data visually using charts, work with external data, manage images and shapes, and even automate routine tasks, using macros. So let's being with Office 365 for Mac: Excel Essential Training.
Practice while you learn with exercise files. Watch this course anytime, anywhere.
Course Contents. Introduction Introduction. 1. Getting Started with Excel 1. Getting Started with Excel. 2. Managing Workbooks 2.
Managing Workbooks. 3. Working with Worksheets, Cells, and Cell Data 3.
Working with Worksheets, Cells, and Cell Data. 4. Sorting, Filtering, and Managing Worksheets 4. Sorting, Filtering, and Managing Worksheets. 5.
Summarizing Data Using Formulas and Functions 5. Summarizing Data Using Formulas and Functions.
6. Analyzing Data and Formulas 6. Analyzing Data and Formulas.
7. Formatting Worksheet Elements 7. Formatting Worksheet Elements. 8. Working with Charts 8.
![365 365](/uploads/1/2/5/4/125417451/644310668.png)
Working with Charts. 9. Working with External Data 9. Working with External Data. 10.
Working with Objects 10. Working with Objects. 11. Exploring PivotTables 11. Exploring PivotTables.
12. Reviewing and Sharing Your Spreadsheets 12. Reviewing and Sharing Your Spreadsheets.
13. Automating Workbooks Using Macros 13. Automating Workbooks Using Macros. Conclusion Conclusion.
Microsoft on Tuesday its new Office 2013 and Office 365 productivity software suites. Lost in the announcement, however, was what (if anything) those suites would mean to Mac users. Macworld spoke to Microsoft representatives to get some clarification. Microsoft Office for Mac 2011 For starters, Office 2013 doesn’t mean anything to the Mac: it’s for Windows computers only.
Office 365, on the other hand, does impact Mac users, but it doesn’t introduce any new features; rather, it’s essentially a new licensing model for Office for Mac. A subscription to Office 365 ($10 per month, or $100 per year) gives you the right to download Office software to up to five computers.
For Mac users, what you'll download is Office for Mac 2011—it's pretty much the same version of the suite that we've been using for a couple of years now, but it's been updated to include activation for Office 365 Home Premium. Your subscription must be renewed monthly or annually in order to continue to use the software. (A that runs on two computers is available for $80.) If you currently own Office for Mac 2011, you must uninstall that software when you sign up for Office 365. You will then download and install Office for Mac 2011 through your Office 365 account—again, on up to five Macs. Mac users who sign up for Office 365 will also get 20GB of SkyDrive storage (up from the 5GB that comes with a free account) and 60 minutes per month of Skype calls. One of the marquee new features of Office 365 is, a service that allows a PC without Word, Excel, or PowerPoint installed to run those programs via Internet streaming.
But Office on Demand is a Windows-only feature; it remains to be seen whether it will be available to Mac users when the next version of Office for Mac is released. Word Web app Mac users do have an alternative to Office on Demand:, which have been available since 2010. Accessible through a account, those apps let you create and edit Word documents, Excel spreadsheets, and PowerPoint presentations using Web-based versions of those apps, then save those documents to your SkyDrive or Mac. However, those Web apps aren’t as full-featured as the desktop versions; SkyDrive does provide the option to open a document directly in the desktop version of each program (provided that app is on your Mac).
Unrelated to the Office 365/Office 2013 announcement, Microsoft released an on Tuesday. The update provides several fixes to Outlook and PowerPoint. Editor's note: Updated on 1/29/13 at 7pm PT to clarify what the downloaded version of Office for Mac 2011 offers.