Excel 2011 For Mac Training

Works On: Windows 7,Vista,XP- Mac OS X In this video tutorial for Microsoft Excel 2011 For Mac, expert author Guy Vaccaro teaches you to effectively utilize the features and functions of Excel through project based learning.

Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show.

Kursus yang berkaitan • • • • Transkrip Kursus - Hi, I'm Curt Frye. Welcome to Excel 2011 for Mac Essential Training. In this course, I'll teach you all the skills you need to use Excel 2011 effectively, whether you're an experienced user upgrading from an earlier version, or someone who's new to Excel. I'll start by showing you how to run Excel, how to navigate the program's user interface, and how to get help within the program or online. Then, I'll teach you how to manage your workbooks and the data they contain, such as by entering data quickly, adding and deleting worksheets, and by sorting and filtering your data so you can focus on just the information you need to make a decision.

The next part of the course covers formulas and formatting. I'll show you how to summarize your data using formulas that range from the simple to the not so simple, and how to make your headings and data stand out.

In the last part of the course, I'll teach you some slightly more advanced techniques that let you summarize your data visually using • Berlatih sementara anda belajar dengan fail latihan. Tonton kursus ini pada bila-bila masa, di mana-mana sahaja. Kandungan Kursus • Introduction Introduction • • • 1.

Getting Started with Excel 1. Getting Started with Excel • • • • • • 2. Managing Workbooks 2. Managing Workbooks • • • • • 3. Managing Worksheets, Cells, and Cell Data 3.

Managing Worksheets, Cells, and Cell Data • • • • • • • • • • • • • • • • 4. Adobe illustrator creative suite. Summarizing Data Using Formulas and Functions 4. Summarizing Data Using Formulas and Functions • • • • • • • • • • • • • • • • • • • 5.

Formatting Worksheet Elements 5. Formatting Worksheet Elements • • • • • • • • • • • 6. Working with Charts 6. Working with Charts • • • • • • • • • • • 7. Working with External Data 7. Working with External Data • • • • • • 8.

Working with Objects 8. Working with Objects • • • • • • • 9. Exploring PivotTable Reports 9.

Exploring PivotTable Reports • • • • • • • • • • • 10. Reviewing and Sharing Your Spreadsheets 10. Reviewing and Sharing Your Spreadsheets • • • • • • • • • 11. Automating Workbooks Using Macros 11. Automating Workbooks Using Macros • • • • • • • Conclusion Conclusion •.