Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Excel: Formulas and Functions
Differentiate between manual and automated calculationsPreview the first lesson free — get full access to all 3 lessons.
Intermediate Provider : Bob Akbar 3 Lessons · 13m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Most users are aware of the formulas they commonly use in their industries and, therefore, will manually create functions they may require. This is time-consuming and often requires checking to ensure they are properly created. By using existing built-in functions offered for a wide range of common formulas, the user can focus on higher productivity rather than manual
These built-in functions not only can calculate numerical values but also can be used for dates as well as other data types. By understanding where to locate these, a user can also create custom formulas by combining these functions together. Some of these functions also have built-in filters so that the data being sought is automatically included. Some of the common functions include Sum, SumIF, Count, CountIF, GeoMean, Mode, and Average. These functions combined with financial, logical, text, date & time, lookup reference, math & trig, as well as others, can increase accuracy and save time.
What You'll Learn
- Understand the proper syntax for Excel formulas and functions
- Recognize when to use automated built-in functions instead of manually created formulas
- Identify how to combine multiple functions into a single formula
- Apply common functions such as Sum, SumIF, Count, CountIF, Average, Mode, Median, Max, and Min
- Describe how to input data into formulas and functions
Key Takeaways
- Excel offers built-in functions for a wide range of common formulas, freeing users from manually creating functions that are time-consuming and require checking for accuracy.
- Built-in functions can calculate numerical values and also work with dates and other data types.
- Users can create custom formulas by combining existing functions together, and some functions include built-in filters that automatically include the data being sought.
- Common functions include Sum, SumIF, Count, CountIF, GeoMean, Mode, and Average, spanning categories such as financial, logical, text, date & time, lookup reference, and math & trig.
- Using built-in functions can increase accuracy, save time, and let users focus on higher productivity.
Frequently Asked Questions
What topics does this course cover?
The course covers Excel formulas and functions, including proper syntax, inputting data into formulas and functions, when to use automated functions, and how to combine multiple functions into a single formula. Lessons address manual averages, functions such as Mode, Median, Max, and Min, and functions used within formulas such as SumIf.
What skills will I gain from this course?
You will build skills in Microsoft Excel, spreadsheets, Excel formulas, custom functions, Excel Services, and math functions.
Why use built-in functions instead of creating formulas manually?
Manually creating functions is time-consuming and often requires checking to ensure they are properly created. By using existing built-in functions, users can focus on higher productivity and increase accuracy while saving time.
Can Excel functions handle data other than numbers?
Yes. According to the course, these built-in functions can calculate numerical values and can also be used for dates as well as other data types.
