Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks. Instructor. 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. Skills covered in this course. Course Transcript - Instructor The Excel for Mac team has added several new chart types to the Office 365 version of the product. In this movie, I will describe four new chart types, and those are Funnel, Waterfall, Histogram, and Pareto.

My sample file has four worksheets, and I've started out on Funnel. Funnel charts are fairly straightforward, and they're used most often to describe sales relationships. So for example, you might have a number of prospects to follow up with at 400. You contact them, and you get positive responses from 150, and you actually close sales with 25 of them. And that's what's called the sales funnel. It goes from prospects to responses and sales. If you want to depict the sales funnel as a chart, you can select your data, go to the Insert tab of your ribbon, and then on the top row of icons, you'll see Waterfall, click that.

Pareto Analysis (free Version Download For Mac Download

And the first chart type is Funnel. When you click there, Excel creates a Funnel chart, and you see prospects, responses, and sales with the numbers. 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. Working with Worksheets, Cells, and Cell Data 3.

Working with Worksheets, Cells, and Cell Data. 4. Sorting, Filtering, and Managing Worksheets 4.

Sorting, Filtering, and Managing Worksheets. 5. Summarizing Data Using Formulas and Functions 5. Summarizing Data Using Formulas and Functions. 6. Analyzing Data and Formulas 6. Analyzing Data and Formulas.

7. Formatting Worksheet Elements 7. Formatting Worksheet Elements.

8. Working with Charts 8. Working with Charts. 9.

Working with External Data 9. Working with External Data. 10. Working with Objects 10. Working with Objects. 11.

Exploring PivotTables 11. Exploring PivotTables. 12.

Reviewing and Sharing Your Spreadsheets 12. Reviewing and Sharing Your Spreadsheets. 13.

Pareto Analysis (free Version Download For Mac)

Automating Workbooks Using Macros 13. Automating Workbooks Using Macros.

Pareto Analysis (free Version Download For Mac

Conclusion Conclusion.