Guy's presentation style is straightforward and effective. found in Office for Windows 2010 didn't make it into Office for Mac 2011. Very direct training on each major part of the program. "I swear I thought excel was the most confusing program ever created.until I started following the simple examples in YOUR course. Anyone Mac user new to MS Excel wanting a user-friendly guide that introduces the program from the ground up.
Anyone who needs an understanding of Microsoft Office software as it applies to a professional work or academic environment.
Anyone who has used Microsoft Excel in the past but wanted a better understanding of its full range of features.
How to create fully compatible documents and projects that can be accessed by users working with Office for Mac products as well as Windows counterparts. How to manipulate and implement data across a wide range of projects. The Solver Parameters dialog should appear, in the language of your Microsoft Excel 2011 installation. When youre ready to use Solver, click the Solver button on the Data tab (the bundled version of Solver doesnt use the menu Tools Solver.). How to create professional quality spreadsheets, workbooks and presentation-ready charts with one of the world's leading office productivity tools. To use Solver, start Excel 2011 and create or open your workbook. Whether wanting to beef up your existing Excel skills or learn the program from the ground up this InfiniteSkills Excel course is a tremendous resource with over 50 lessons. You then create a functional expense claim form and a sales contact management sheet, exploring how you can easily manipulate text, and even create mail merges from within Excel. Moving to score sheets for a sports day, you will discover conditional formatting, lookups, and more. The course then moves on to creating a Profit and Loss report, building a solid understanding of formulas along the way. Beginning your training with the creation of a sheet to record and monitor sales data, you'll learn the basics of what you can do with spreadsheets. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts. This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. Visit the IT Help Center’s EndNote page. EndNote is bibliography management software for Mac and Windows.A Verifiable Certificate of Completion is presented to all students who undertake this course.
Find out how to organize your notes and your life with OneNote, discover how to get a free trial copy, and learn where to find out more. 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.reate a projection based on an existing series of data. Visit the IT Help Center’s Excel page for links to help and handouts on Microsoft Excel, the spreadsheet component of Microsoft Office. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes. Previous versions of Office for Macintosh are Office 2008 and Office 2004. You may also be interested in learning about purchasing Office 2011. Microsoft has a nice page explaining what’s new and how to get started with Office 2011: visit Microsoft’s Office 2011 how to page. Office 2011 for Macintosh was introduced in October 2010. Learn about Office 2007 and Office 2010 and the factors you or your department should consider before deciding to upgrade. Office 2010 and Office 2007 save in a file format that can’t be read by previous versions of Office without special conversion software. Office 2010 and Office 2007 (for Windows) See handouts from their tutorial program. This Excel 2011 tutorial covered the basic concepts of spreadsheets such as: Cells Rows Columns And then expanded on the more advanced Excel topics such as: Sheets Hyperlinks Ranges Each version of Excel can 'look and feel' completely different from another. The BU IT Help Center (Charles River Campus) offers tutorials on Word, Excel, PowerPoint and Photoshop. Excel 2011 is a version of Excel developed by Microsoft that runs on the Mac platform. Write a review New courses Recommendations More things to explore on CourseTalk Course Tracker Write a review. Learn Microsoft Excel 2011 for Mac at your own pace. The BUMC IT Service Desk provides technical support for several applications in the Microsoft Office suite, including Microsoft Word, Excel, PowerPoint, and Outlook. 0 reviews for Microsoft Excel 2011 for Mac Tutorial - Learn The Easy Way. Home » Support & Infrastructure » Software Support » Microsoft Office Office Applications