Excel tutorials for mac 2011

Intermediate excel skills, tips, and tricks tutorial duration. 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. Excel for mac 2011 essential training linkedin learning. Lesson 2 explore the excel 2011 user interface youtube. Excel for mac empirical reasoning center barnard college. This handson microsoft excel 2011 for mac course shows you how. Use excel for mac 2011 to check out a sharepoint file so that only you can make changes. Our microsoft office tutorials are some of the most popular courses we offer. Excel 2011 is a version of excel developed by microsoft that runs on the mac plaform. This microsoft excel class will make you a master of microsoft excel. Microsoft excel for mac 2011 represents the largest step forward for. Congratulations, you have completed the excel 2011 tutorial. Introduction to functions in excel for mac youtube. Excel is a powerful spreadsheet and data analysis application, but to use it most effectively.

Lesson 2 explore the excel 2011 user interface officeformac. In excel for mac 2011 essential training, author curt frye gives a comprehensive overview of excel, the fullfeatured spreadsheet software. Use these quick steps for your most common activities. 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. Follow this roadmap of training and help topics to learn how to use microsoft excel for mac 2011 in a systematic, stepbystep approach. Rename a worksheet doubleclick a sheet tab to change its name.

Source code for learn excel 2011 for mac by guy hartdavis apress learnexcel2011 for mac. The functions are the same for both windows and mac but the way you use insert function or the formula builder is different. Some of the exercises use data from the new york city census tracts. 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 all mac office or needing to coordinate with pc counterparts. The office for mac 2011 training downloads include portable document format. Microsoft excel for mac from beginner to expert in 7 hours udemy. Productivity downloads microsoft excel by microsoft and many more programs are available for instant and free download.

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. This excel 2011 tutorial covered the basic concepts of spreadsheets such as. Excel for mac 2011 is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the. 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. In excel for mac 2011 essential training, author curt frye gives a comprehensive overview of excel, the fullfeatured spreadsheet software from microsoft. A verifiable certificate of completion is presented to all students who undertake this course.