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: Jess Stratton course • 2h 11m 42s • 4,891 viewers • Course Transcript - [Voiceover] Hi, I'm Curt Frye. Welcome to Excel for Mac 2016 Essential Training.

Looking for something that’s not listed here? Use the Search box in the upper right corner of this window. Use Flash Fill in Excel for Mac Flash Fill is a very popular feature that is now available in Excel for Mac. Some people have reported that Flash Fill is working using Control-e in this weeks general release update version 16.14.

In this course, I will teach you all of the skills you need to use Excel 2016 effectively, whether you're an experienced user upgrading from an earlier version, or someone who is new to Excel. I'll start by showing you how to run Excel, how to navigate the program to use your 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 end to leading worksheets, and by sorting and filtering your data so you can focus on just the information you need to make a decision.

I'll teach you some slightly more advanced techniques that will let you summarize your data visually using charts, work with external data, manage images and shapes, and even automate routine tasks using macros. In short, I'll show you everything you need to know so you can use Excel 2016 effectively.

Thanks again for • 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.

It also offers a decent amount of security including WPA2, WPA and WEP64 and 802.11x encryption levels that will keep you protected while you browse. For those who need a little extra Wi-Fi connectivity, this USB Wi-Fi adapter made by EDIMAX is a great option. Canon printer driver for mac. Due to the flexible technology and convenience size-wise, the D-Link is well worth the cost. This adapter takes up little space, so you won't need to worry about it becoming an ugly sore thumb. It may be a little on the pricey side, but the D-Link is an overall great device.

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.