Day 12 - UPskill your EXCEL Skill - Morning Batch | #StayHome #LearnExcelOnline with Excel In Excel

More than 80% companies worldwide, use Excel for doing daily tasks. It is an incredibly powerful tool in business. Learning excel helps to climb the career ladder comparatively faster.

To learn MS Excel and enhance your skills, enrol in our upcoming Excel course.

*Duration*: 20 Hours
Starting from 23rd Nov 2020
Mon – Fri: 7:00 am – 8:30 am IST
Live on Zoom (NO PRE-RECORDED)

Investment:
MRP : ₹ 7,999 + GST
Diwali Offer Price: ₹ 3,999 + GST
(Use promo code *DIWALI*, Limited Period Offer)


To know more about the course, click on the below mentioned link:
https://excelinexcel.in/eielearning


This is the live recording of the training done on Day 12, 08th Apr 2020 (Morning Batch), as part of our program “Upskill your EXCEL Skills in 21 Hours”.

Know all about Conditional Formatting.
In basic terms, it is the formatting of cells or range of cells based on one or more criteria.

The course content that is covered in this video are as below:
00:00 - Get Started
04:25 - What is a formatting
06:00 - Conditional Formatting
06:19 - Highlight blank cells
12:56 - Highlight duplicate cells
23:03 - Highlight negative values
25:12 - Hight cell values greater than
30:25 -Difference between two dates
34:30 - text formula explained
39:32 - Extract Calendar details of a date
44:14 - EDATE in a real-life scenario
51:15 - EOMONTH
54:42 - ISNUMBER
1:18:00 - ISTEXT
1:02:05 - Convert text to number
1:02:45 - Various Error types
1:04:32 - Circular reference
1:06:52 - Data Validation

About this program:
Upskill your EXCEL Skills in 21 Hours
During this shutdown for three weeks in India, what better way to make use of this time available than to learn new skills?
We, at Excel In Excel, are committed to keeping India safe and upskilled, with an opportunity for you to learn from the comforts of your home.

Case Study Courtesy - Rishabh Pugalia, Yoda Learning