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 2008 ( ). There are literally.

That versions 15.34 and earlier are not supported, and you may not be able to launch the apps. You are advised to update to 15.35 or later, but even that’s no guarantee. Not all Office functionality may be available, and you may encounter stability problems where apps unexpectedly quit.

During the beta period for macOS 10.13 High Sierra, no formal support is available for this Office configuration. We strongly recommend that you back up your existing data before trying the software. If you encounter issues using Office 2016 for Mac on High Sierra, please send us feedback so we can address them. The company also advises that support for the 2011 suite ends next month – including security updates. All applications in the Office for Mac 2011 suite are reaching end of support on October 10th, 2017. As a reminder, after that date there will be no new security updates, non-security updates, free or paid assisted support options or technical content updates. Notes that Mac users of get second-class service from the company, offered only five years of security updates instead of the ten years given to Windows users, alongside often long-delayed porting of new features.

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 users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios. Instructor •. Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training.

Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes.

He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Dennis Taylor course • 2h 2m 34s • 28,863 viewers • Course Transcript - [Voiceover] Hi, I'm Dennis Taylor and I'm happy to present Excel 2011 for the Mac: Mastering Formulas and Functions. For many Excel users, the central focus of what they do is writing formulas and functions. If you really want to take advantage of Excel's power, you need exposure to its many functions. I'll start off by showing you some great shortcuts for building formulas and functions, numerous variations on the if and V look up functions, vital statistical and math functions, and some date functions that could prove to be indispensable.

I'll show you how text functions can help you clean up flawed data, how powerful array formulas and functions give you even more analytical possibilities, and I'll show you how to use functions in combination with one another to achieve even greater power. Welcome to Excel 2011 for the Mac: Mastering Formulas and Functions. • Practice while you learn with exercise files. Watch this course anytime, anywhere.

Course Contents • Introduction Introduction • • • 1. Formula and Function Tools 1. Formula and Function Tools • • • • • • • 2.

Formula and Function Tips and Shortcuts 2. Formula and Function Tips and Shortcuts • • • • • • • • • • 3. IF and Related Functions 3. IF and Related Functions • • • • 4. Lookup and Reference Functions 4. Lookup and Reference Functions • • • • • • • • • • 5.

Statistical Functions 5. Statistical Functions • • • • • • 6. Power Functions 6. Power Functions • • • 7. Selected Financial Functions 7. Selected Financial Functions • • • • 8.

Selected Math Functions 8. Selected Math Functions • • • • • • • • • 9. Date and Time Functions 9. Date and Time Functions • • • • • • • • • 10. Text Functions 10.

Text Functions • • • • • • • • 11. Array Formulas and Functions 11. Array Formulas and Functions • • • • • • • 12. Reference Functions 12. Reference Functions • • • • 13. Information Functions 13. Information Functions • • • • Conclusion Conclusion •.