Learn Excel Formulas & Functions in Only 90 Minutes

Learn Excel Formulas & Functions in Only 90 Minutes

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.

Quickly take control of Excel's powerful features, for Windows and Macintosh

Url: View Details

What you will learn

• Write basic formulas for addition, subtraction, multiplication and division.
• Learn new functions introduced in winter 2016.
• Write formulas that combine and split text.

Rating: 4.4

Level: Intermediate Level

Duration: 4 hours

Instructor: Bob Flisser