Master Functions in Excel

Are you looking to take your skills with Microsoft Office Excel 2016 to the next level? While simple calculations can make your job easier, relying on manual formula entry will only get you so far. In order to fully leverage the power of Excel and perform more complex calculations, it’s important to understand how to work with its many built-in functions. With over 300 functions to choose from, it can be overwhelming to know where to start.

This course is designed for individuals who want or need to perform more advanced calculations, such as working with date and time or basing calculations on specific criteria. Instead of trying to learn all of the available functions, you will focus on the most important and useful functions in each category. By the end of the course, you will have a better understanding of the difference between formulas and functions, and will know how to work with cell names, logical functions, date and time functions, and text functions.

Additionally, by understanding the principles behind how functions work, you’ll be able to easily locate and work with other functions you may need in the future.

You will

• Understand the difference between formulas and functions
• Work with cell names instead of the cell addresses
• Work with logical functions
• Work with DATE and TIME functions
• Work with TEXT functions