Master Functions in Excel
This course is designed for those, who can perform basic calculations and can navigate in Excel 2016.
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.
- 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
Who this course is for:
- As you progress with Excel, you’ll need to know how to ask Excel more complex questions about your data and to get the answers you expect.