Learn Excel 2011 for Mac by Guy Hart-Davis Stay ahead with the world's most comprehensive technology and business learning platform. With Safari, you learn the way you learn best. Dec 10, 2014 - Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for.
Excel for Mac 2011 Customer support and troubleshooting for Office for Mac 2011 ends October, 2017. To get all the latest features, upgrade to Office 2016 for Mac. Make a one-time purchase, or buy an Office 365 subscription and stay up to date. Work with sheets and data Title Description Work with cells, rows, and columns. Use the Paste Special command to copy and paste special cell contents or attributes. Keep column headings visible while you scroll. Change the width of columns so that you can see all the data in cells.
Prevent unauthorized changes, moves, or deletions of important data. Change the appearance of cells based on certain criteria, for example, all cell values in the top 10% of a range. Work with functions, formulas, and lists Title Description Learn the elements of a formula as well as how to enter a formula on a sheet.
Learn about the different kinds of operators (for example, +, -, /, and.) and the order in which they are applied. Learn the difference between relative and absolute cell references and how to switch between them. Work with charts and graphics Title Description Learn the basics of charts, including the elements of a chart, which chart is appropriate for your data, and how to apply chart layouts and styles.
Add chart and axis titles, change the axis scale, add data labels, and more. Use error bars to indicate potential error amounts in relation to each data point. Add pictures or clip art to a worksheet by using the Media Browser. Analyze, share, and collaborate Title Description Learn the two different ways to create a Pivot Table and how to use the Pivot Table Field Lists to add, move, and arrange fields.
Create a projection based on an existing series of data. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes.
Explore other useful resources Title Description See the full list of keyboard shortcuts, organized into logical categories. Rearrange, show, and hide tabs on the ribbon. See a list of known issues as well as potential workarounds.
![Microsoft excel 2011 for mac free download full version Microsoft excel 2011 for mac free download full version](/uploads/1/2/5/3/125382049/199181481.gif)
Lesson 27: Free Resources for Learning Office for Mac /en/excel-tips/how-to-add-line-breaks-in-excel/content/ Free resources for learning Office for Mac Our tutorials are some of the most popular courses we offer. These tutorials, however, are designed for those using Office on computers with Microsoft Windows, so perhaps it's no surprise that we frequently hear from learners who want to know why we don't offer tutorials on Office for Mac.
While Office for Mac shares a lot of functionality with the Windows version, its interface and design are different enough that we would need to create entirely new courses. With our small staff, it would be a real challenge to produce the same kind of detailed tutorials for the Mac-friendly Office we provide for the Windows version. We may consider adding some type of Office for Mac tutorial in the future, but for now we'd like to share a number of excellent—and mostly free!—resources that can help you learn how to use Office for Mac.
Office 2016 for Mac is very similar to the Windows version. So if you have Office 2016 for Mac, check out our.
Free Office for Mac tutorials If you're using Office for Mac, the Office for Mac team has provided great series of tutorials and how-to guides to help you get started and even learn advanced skills:. If you're just getting started, check out the, which provide an overview of each Office for Mac product. If you're looking for even more, the and provide the latest news and step-by-step videos to guide you through. If you're using an earlier version of Office for Mac, check out the video below from the Office for Mac team on the Word 2011 Interface. Of course, you can also find help on the from the Office community and support team. If you need additional support, you might consider purchasing a subscription to to take advantage of its thorough.
It's not free, but it's still a great resource if you need to learn the software quickly. What if I use an older version of Office for Mac? If you use Office 2008 for Mac, you should be aware that Microsoft discontinued support for this version in late April 2013. While this doesn't mean the programs will stop working, it does mean it will be more difficult to get help from Microsoft if something goes wrong. If you're thinking of upgrading to the latest version of Office for Mac, you may want to consider purchasing a subscription to Office 365 instead of buying the stand-alone Office for Mac 2011 suite. A subscription includes a copy of Office for Mac on up to five computers, and you'll be able to upgrade to the latest version of Office for Mac when it becomes available. You can check out our lesson on to learn more about an Office 365 subscription.