Learn the most important text, numeric, logical and lookup functions in Microsoft Excel in this free online course.

MS Excel is capable of analyzing data, computing statistics, creating pivot tables, and displaying data in the form of a chart or graphs. Massive amounts of data are generated by organizations all over the world and this data is useless unless it is sorted and organized so that meaningful information can be extracted from it. Excel is one of the tools that businesses around the world use to extract this valuable information and generate meaningful reports. The use of mathematical formulas known as functions allow you to quickly and easily perform calculations that would otherwise be difficult to perform manually. People who are proficient with this tool are in high demand and have a competitive advantage over those who are not and this Microsoft Excel certification focuses on the most fundamental and useful Excel functions.

A function consists of three basic components: the ‘=' sign, which indicates the beginning of the function, the function name, and the parameters or arguments. Each of these components are critical to the function's proper execution. As a result, proper syntax writing is required, and this will be covered in this course. Microsoft Excel functions are divided into several categories, including text functions, numeric functions, logical functions, lookup functions, and many others. To begin, you will learn the most basic numeric functions such as SUM, AVG and COUNT. After you've learned how to write and execute a simple function, you will move on to other important text functions like UPPER, LOWER, and PROPER. Following that, various logical functions and scenarios in which logical functions can be used will be demonstrated. Excel contains a number of functions that can assist in the generation of random numbers and two of these are RAND and RANDARRAY,  which will both be covered in the following section.

In Excel, a person must frequently search for a value in a pool of data. It can be a time-consuming process if done manually, so Excel includes functions such as VLOOKUP and XLOOKUP to help with the search. This Microsoft Excel tutorial will also cover the various ways to configure lookup functions. Finally, the use of pivot tables for data filtering will be illustrated. Learning Excel functions simplifies your work and raises the quality of your reports and other information sheets and Excel formulas allow you to do more while saving time. If you know how to use Excel formulas and functions, you can exponentially increase your productivity, whether you are a manager or a new employee. This course is appropriate for students, professionals, or anyone looking to improve their skills and add the most in-demand skill in the market to their portfolio. Enrol today and make the most of this opportunity by mastering Excel functions.