To be a more proficient Excel user and add value to your job or career, you should know how to use Excel's math and data management capabilities. That means writing formulas and using functions. It doesn’t have to be complicated or scary, and with this course’s friendly, understandable and approachable style, you can quickly become an Excel expert. In 4 chapters, we will learn 30 built-in functions useful in different fields, industries, careers and tasks, and will learn efficient, time-saving techniques. You get 90 minutes of videos with new and completed class files and a reference guide.

The material in this course covers all versions of Excel from 2016 through 365. And all the functions work on the Mac as well as Windows.

We start with writing simple formulas and functions, then progress to Excel's most commonly used functions, like adding, taking averages and finding the highest and lowest numbers in a range. Next, we learn how to use functions that make decisions, where the result can be two or more possibilities. Some of these functions are mashups of other functions you already know.

Do you need to work with statistics? You'll find several functions in the next chapter are just for you. Math or finance? We have a few of those, too. And who knew Excel worked great for manipulating text? We cover a few functions that will make your life easier.

In the next chapter, we cover sorting and filtering tables of data and how to write and edit macros so you can write custom programs in Excel.

And we have a bonus chapter with new functions introduced in the 2019 and 365 editions of Excel. You're really going to like these.