1. Excel For Mac 2011 Training
2. Advanced Manual On Excel 2011 Mac Free

Excel For Mac 2011 Training

Course Info

Advanced Manual On Excel 2011 Mac Free

• Duration:6h 13m 51s
• Skill Level:Advanced
• Released:December 10, 2014
• Viewers:32,140

Learn the most in-demand business, tech and creative skills from industry experts.

• Overview
• Transcripts
• Exercise Files
• View Offline

Although it’s true that you can gain a better knowledge of any application if you visit its preferences and try to figure them out, it’s almost essential for Excel for Mac 2011. Choose Excel→Preferences from the menu bar to display the Preferences dialog. When you have an inkling or thought about a setting you want.

• Course details

  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.

  Skills covered in this course

  Related courses

• Welcome

  - [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

  Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

  Download the exercise files for this course. Get started with a free trial today.

• Download courses and learn on the go

  Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

  Download on the App StoreGet it on Google Play

  Watch this course anytime, anywhere. Get started with a free trial today.

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