Day Four Review: Covered functions such as Max ifs, Min ifs, sum ifs, countifs, error handling using if error and if n functions. Explained the difference between if error and if na error functions.
Mixed Referencing and Conditional Formatting: Introduced mixed referencing and began a discussion on conditional formatting. Demonstrated how to use conditional formatting to highlight values based on specific conditions.
Using Conditional Formatting for Entire Rows: Showed how to highlight an entire row based on certain criteria using mixed referencing. Demonstrated how to clear previously set rules.
Introduction to Data Bars in Conditional Formatting: Discussed the concept of data bars as a visual representation of data, allowing users to visualize data in relation to each other, especially useful when presenting confidential data.
Practical Use Case: Described a scenario where only bars can be shown without displaying actual numbers, beneficial when presenting sensitive information like employee salaries to showcase relative comparison without revealing exact figures.
Leading Courses
Data Science: https://360digitmg.com/india/data-science-certification-course-training-institute
Data Analytics: https://360digitmg.com/india/data-analytics-certification-course-training-institute
Data Engineering: https://360digitmg.com/india/data-engineering
MLOps: https://360digitmg.com/india/mlops-engineering-course-training
If you are looking for data science classroom centers in India, visit
Hyderabad: https://360digitmg.com/india/hyderabad/data-science-certification-course-training-institute
Bangalore: https://360digitmg.com/india/bangalore/data-science-certification-course-training-institute
Chennai: https://360digitmg.com/india/chennai/data-science-certification-course-training-institute
SUBSCRIBE TO 360DigiTMG’s YOUTUBE CHANNEL NOW
https://www.youtube.com/c/360DigiTMG
We have specifically created a Facebook Group for all our Data Science aspirants. You can use the below link to join.
In addition to this, we are going to host 2 FREE training sessions Every Single Month on various topics inside this group.
Join FREE Data Science Facebook Group
https://www.facebook.com/groups/DataScience.MachineLearning.ArtificialIntellegence/
CONNECT WITH 360DigiTMG ON SOCIAL MEDIA
Facebook: https://www.facebook.com/360Digitmg/
LinkedIn: https://www.linkedin.com/company/360digitmg/
Instagram: https://www.instagram.com/360digitmg_india/
YouTube: https://www.youtube.com/c/360DigiTMG
About 360DigiTMG
360DigiTMG is a 9-year-old training & consulting organization led by stalwarts of the industry who are alumnus of premier institutions like the Indian Institute of Technology, Indian Institute of Management and Indian School of Business. 360DigiTMG since its inception has been the forerunner in the space of management and niche programs that aid in up-skilling and cross skilling executives across various levels and domains. 360DigiTMG has been conducting training programs across the globe for corporate and individuals alike.
360DigiTMG is one stop solution to all the trainings in emerging technologies such as Artificial Intelligence, Machine Learning, Big Data, Project Management, Quality Management, etc. 360DigiTMG is a training company, which is a division of the analytics consulting firm Innodatatics Inc.
For more Information Contact us @::
India : 1800-212-654321
Malaysia: +603 2092 9488
Email: [email protected]
Web: https://360digitmg.com/
Did you find this video helpful? Leave a comment below!
#DataScience #ArtificialIntelligence #interviews #DataAnalytics #360DigiTMG