By the end of this course, you will be able to
Identify the top and bottom rules, format only top or bottom-ranked values, and then you will learn to use a formula to determine which cell to format.
Identify how to deal professionally with a group of functions in Excel: such as (Sum functions – Count functions – Average functions – Min and max functions).
Identify how to use (sum, sumif, sumifs, and dsum) as Sum functions, (count - counta -countblank, countif, countifs, dcount- dcounta) as Count functions, and more.
Course details
- 1 h 56 m/14 lessons
- Last updated: 21/4/2023
- 11 learning resources
- Course completion certificate
Course Content
Introduction
Sum Function
Introduction
Sum Function
sumif Function
sumifs Function
dsum Function
Count - counta -countblank Functions
Countif function
Countifs function
Dcount- Dcounta functions
Average – averageif functions
Averageifs - daverage functions
Min – minifs – dmin functions
Max – maxifs – dmax finctions
Course conclusion
About this course
Logical Operations in Excel could act as an additional brain for you, it enables you to organize different types of information using only one formula. In this course, you will learn and deal professionally with a group of functions such as (Sum functions – Count functions – Average functions – Min and max functions), and you will also learn about the different forms of errors that appear while working on the Excel file and knowing its causes and how to resolve it.
Course requirements and prerequisites
This course requires basic knowledge in MS Excel application, MS Office application, after 2010 editionMS, and a computer device. If you wish to have more information, we recommend you check parts one and two of this course.
Mentor
Abdelrahman Hashem
Organizational Skills Trainer
5,971 Learners
7 Courses
