Course details
- 2 h 37 m/25 lessons
- Last updated: 21/4/2023
- 23 learning resources
- Course completion certificate
Course Content
Introduction
Highlight cells rules - greater than - less than - between
Highlight cells rules - equal to - text that contain
Introduction
Highlight cells rules - greater than - less than - between
Highlight cells rules - equal to - text that contain
Highlight cells rules - date occurring - duplicate values
Top / Bottom 10 items
Top / bottom 10%
Above - below average
Data Bars
Color scale
Icon Sets
Based on cell value
Based on specific text
Date - blanks & no blanks - errors & no errors
Manage numbers rules
Manage date rules
Manage text rules
Top - bottom values
Absolut Reference
Function
Conditional Formatting Formula 1
Conditional Formatting Formula 2 - Managing expire dates
Conditional Formatting Formula 3 - SIMPLE STOCK CONTROL EXAMPLE
Conditional Formatting Formula 4 - START END DATE MANAGMENT
Conditional Formatting Formula 5 - DATA COMPARATION
Conditional Formatting Formula 6 - FILTER LIST
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 the skills of managing mathematical and statistical operations that require processing a set of conditions to extract results, through a group of conditional functions such as (simple if – nested if – complex if – ifs – ifna – iferror), and you will also learn about the different forms of errors that appears 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 part one of this course.
Mentor
Abdelrahman Hashem
Organizational Skills Trainer
5,971 Learners
7 Courses
