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. By: Alicia Katz Pollock course.
This Excel Macro Tutorial for Beginners is accompanied by an Excel workbook containing the data and macros I use (including the macro I describe above). You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter.
3h 38m 3s. 865 viewers.
Course Transcript - 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.
Practice while you learn with exercise files. Watch this course anytime, anywhere. Course Contents.
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. 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.
If you need Excel skills to get a job you should begin with this course ( it also includes all of the Basic Skills material). Even if you’ve never used Excel before you’ll have no difficulty completing this course, most learners can complete it in two days or less. The will give you all the skills an employer would expect. By the end of the Essential Skills course your Excel skills will be better than most office workers. The Essential Skills are separate stand-alone products and each covers exactly the same course content. You can learn just as much as you need The may be all you need but if you decide to further expand your Excel education you’ll be able to use the other low-cost books in this series to master even the most advanced Excel features.
If you need to move your Excel skills up to the next level, check out the to see all of the skills you’ll learn to reach this high level of Excel proficiency. If you’re already an accomplished Excel user check out the to discover advanced skills that are rarely mastered (even by Excel power users).