2011 excel for mac tutorials

Office for mac 2011, excel i am using office 2011 for mac and i opened an excel file tonight and got a msg that the file was locked for editing. The functions here include today, now, average, max, min and if. Pdf learn excel 2011 for mac by guy hartdavis free downlaod publisher. Create a projection based on an existing series of data. Excel for mac 2011 essential training linkedin learning. In excel for mac 2011 essential training, author curt frye gives a comprehensive overview of excel, the fullfeatured spreadsheet software.

Congratulations, you have completed the excel 2011 tutorial. This excel 2011 tutorial covered the basic concepts of spreadsheets such as. Use excel for mac 2011 to check out a sharepoint file so that only you can make changes. Microsoft word, powerpoint, excel, onenote, outlook, and onedrive logos. Introduction to functions in excel for mac youtube. The office for mac 2011 training downloads include portable document format.

Excel basics 3 notice that a blank workbook workbook1 appears. Easily generate barcodes in microsoft excel for mac 2004 or 2011 with. And then expanded on the more advanced excel topics such as. There are more tutorials specifically for other functions on our channel or. You will learn to leverage the power of the most important features excel 2011 has to offer the apple user, whether youre working in an allmac office or needing to. Hints to create a new blank workbook at any time in excel, on the filemenu, click new workbookalso written as file new workbook in this tutorial. Excel for mac 2011 is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. If youre using an earlier version of office for mac, check out the video below from the office for mac team on the word 2011 interface. Lesson 2 explore the excel 2011 user interface youtube. Of course, you can also find help on the microsoft office for mac support page from the office community and support team. Or, create your own custom list for items that dont sort well alphabetically. Excel for mac 2011 is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the. Source code for learn excel 2011 for mac by guy hartdavis apress learnexcel2011 for mac.

Follow this roadmap of training and help topics to learn how to use microsoft excel for mac 2011 in a systematic, stepbystep approach. Learn excel 2011 for mac by guy hartdavis is a practical, handson approach to learning all of the details of excel 2011 in order to get work done efficiently on mac os x. Rename a worksheet doubleclick a sheet tab to change its name. Excel for mac online courses, classes, training, tutorials on lynda. Learn the basics of using microsoft excel for mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so its easier to read and use, and more. Sort a list of data in excel for mac excel for mac. Microsoft excel for mac 2011 represents the largest step forward for serious mac spreadsheet jockeys in many years, more so than either excel 2004 or excel. Microsoft excel 2011 for mac tutorial learn the easy way. How to stay in charge of spreadsheets in excel 2008 for mac. The office for mac 2011 training downloads include portable. Excel for mac 2011 help excel for mac office support office 365. Excel is a powerful spreadsheet and data analysis application, but to use it most effectively. Getting started online course is offered multiple times in a variety of locations and training topics.

Excel 2011 is a version of excel developed by microsoft that runs on the mac plaform. This course features tons of tips to make excel for mac 2011 users more proficient and productive with the popular spreadsheet program. In excel for mac 2011 essential training, author curt frye gives a comprehensive overview of excel, the fullfeatured spreadsheet software from microsoft. Published on may 9, 2011 excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. 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. In excel for mac, you can sort a list of data by days of the week or months of the year. From using formulas and functions to creating databases, from analyzing data to automating tasks, youll learn everything you need to know to put this powerful application to use for a variety of tasks.