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 - When you start Excel 2016 for the first time, the program can be pretty intimidating. You are faced with a blank spreadsheet and literally hundreds of user interface options. Where do you begin? Well, rather than dive straight into the details of how to manipulate Excel, I'll take a few minutes to show you what's possible.
After you get a feel for what you can do in the program, I'll show you how to perform specific tasks. The most common task that you'll perform in Excel 2016 is to summarize collections of data. So let's say that you have a cash flow analysis worksheet that shows the amount of cash that you have on hand. I have one here on the left. You can see that I have a starting balance, January 1 of 2015, of $145,000.00, and it goes down to September 18 of 2015, and the balance is 107,742.00.
Sep 24, 2015 - Office 365 is a cloud-based subscription to a suite of programs. Mac users must purchase Office Home & Business 2016 for Mac). As you go up in Office 365 plans, features you can get in addition to the above include.
If I want to summarize the data here, I can do it in a number of ways. First, I can do it visually by creating a chart so that I can see how my cash level, my cash on hand, has changed. 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. Automating Workbooks Using Macros 13.
Automating Workbooks Using Macros. Conclusion Conclusion.