Excel 365 for Busy People
What you'll 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.
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.
Who this course is for:
- This is a level 2 course, so take it if you’ve already completed an introductory course or have experience using basic Excel tasks.
Instructor
- 4.7 Instructor Rating
- 128 Reviews
- 706 Students
- 2 Courses
Bob Flisser has been a trainer and technical writer since the 1980s. He has had over a dozen video courses released by several commercial publishers, and was the co-author of a series of books of tips and shortcuts for Microsoft Word, Excel, PowerPoint, and Windows. He has also written magazine articles and training manuals, and created training centers for companies large and small.
Since 1995, Bob has been the vice president and the web and multimedia developer at Software School, Inc., a software training and graphic design company in New Jersey.
Bob is a graduate of The George Washington University with a degree in financial economics and international business and holds US gold and silver medals in dragon boat racing.