Excel 365 for Busy People

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

Ratings 4.51 / 5.00

What You Will Learn!

Write basic formulas for addition, subtraction, multiplication and division.
Understand how to use any function.
Write formulas that combine and split text.
Create and modify Pivot Tables.
Create Lookup tables.
Calculate automatic subtotals.
Write functions that make decisions, like IF and SUMIF.
Use statistics formulas, like AVERAGE, VARIANCE and STANDARD DEVIATION.
Use exponents, square roots and logarithms.
Use financial functions to calculate payments and rate of return.
Control the display of error messages.
Learn how to automate Excel with macros and Python.

Description

We get it, you're busy! You don't have time or patience to sit through hours of long winded, boring Excel lectures. This course is for you! You get through comprehensive material quickly that's to-the-point and presented by an expert in an approachable, lighthearted manner.

You will learn how to write formulas and use functions. It isn't complicated or scary, and with this course’s friendly, understandable and approachable style, you can quickly become an Excel expert. You will learn functions useful in different fields, industries, careers and tasks, and will learn efficient, time-saving techniques. You get videos with new and completed class files and a PDF reference guide.

The material in this course covers older versions of Excel through the latest edition of 365. Most functions and features work on the Mac as well as Windows. A few feature works only in Windows and we make sure you know which those are.

We start with writing simple formulas and functions, then progress to Excel's commonly used functions, like adding, taking averages and finding the highest and lowest numbers in a range. You'll 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 that chapter are just for you. Math or finance? We have those, too. And who knew Excel worked great for manipulating text? We cover functions and features that will make your life easier.

We also cover Excel's data handling features like sorting and filtering tables, lookups, we have a chapter on data analysis that includes Pivot Tables, and how to manipulate data. You even get a chapter on how to create macros an even how to embed Python programs on a worksheet.