To be a more proficient Excel user and add value to your job or career, you should know how to use Excel's math capabilities. That means writing formulas and using functions, some of which are new in Excel 2016. 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.
If it’s been a while since you’ve used Excel or if you just learned the fundamentals, this lesson gives you a short review of the basics.
Add and subtract numbers on a simple worksheet. Learn how to save time with the AutoFill feature.
Excel has over 400 built-in functions. This lesson shows you the starting point for how they all work.
Usually, you want Excel to rewrite your formulas when you copy and paste and move data around. Learn how to prevent that from happening when the need arises.
Test your knowledge of chapter 2.
Calculating averages manually can lead to incorrect results. Learn how to use a function that gets it right.
In a range of cells, find the highest and lowest numbers, and count how many there are.
Learn the functions and formulas to calculate and manipulate dates and time.
Let Excel create automatic subtotals and other calculations in a long worksheet.
We'll show you how to write formulas that can span multiple worksheets and even multiple workbooks.
Test your knowledge of chapter 3.
Use the IF function when you want the value of one cell to depend on the value of another cell.
Combine the SUM and AVERAGE functions with the decision making ability of the IF function.
New functions for 2016! Evaluate several criteria at once without complicated formula nesting.
New functions for 2016! Find the highest or lowest number in a range based on a value that you specify.
VLOOKUP lets you use Excel as a small database. Enter one piece of information and Excel will use that to return other information for that row.
Test your knowledge of chapter 4.
Use functions that calculate exponents, square roots, common, natural and any-base logarithms.
Learn how to calculate four common statistical functions.
Plug in the amount you're borrowing, the interest rate and payback period to find out how much the payments will be.
Is an investment worth the money? Use a net present value calculation to help you decide.
Use a function to make the worksheet display helpful messages instead of errors.
Use some of Excel's powerful functions for manipulating text… and learn how to cheat!
Test your knowledge of chapter 5
A whole Excel worksheet might look like a table, but tables have specific features that let you manipulate, sort, format and manipulate data like a small database.
Brief introduction to what macros are, how to create and edit them, and how to store them.
The most simple way to create a macro is by recording your keystrokes and mouse clicks. You can them play them back later.
To edit macros or write them from scratch, you use Visual Basic for Applications (VBA). It's a programming language used by all the Microsoft Office applications. In this lesson, we go into the VBA editor to examine the code Excel created when we recorded the macro in the previous lesson, and make two changes to the code.
Test your knowledge of chapter 6.
Bob Flisser has been a trainer and technical writer since the 1980s. He currently has 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. He is also a board member of the Mediatech Foundation, which provides free technology access to his community.
Bob is a graduate of The George Washington University with a degree in financial economics and international business.