Excel 365 for Busy People

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

Created by: Bob Flisser
Trainer, author, web & multimedia developer

What Will I 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.

Requirements

• Before starting this course, you should know the basics of Excel, including how to open, save and close files, how to enter text and numbers on a worksheet, and how to edit cells. The course begins with a brief refresher on how to enter basic formulas.

Target audience

• This is a level 2 course, so take it if you’ve already completed an introductory course or have experience using basic Excel tasks.