Intermediate Microsoft Excel Using Conditional Formatting

Learn to apply Colour Scaling Techniques by value using Conditional Formatting Data Bars, Icons, Colours and Much More!
4.5 (128 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,695 students enrolled
$20
Take This Course
  • Lectures 29
  • Contents Video: 1 hour
    Other: 5 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

JOIN MY COMMUNITY OF OVER 11,000 STUDENTS AND LEARN AMAZING TECHNIQUES, TIPS, TRICKS AND SECRETS THAT I'VE ACCUMULATED OVER 15 YEARS OF ACADEMIC AND PROFESSIONAL TRAINING!

+++++++++++++++++++++++++++

Created: 27 December 2014

Last Updated: 17 April 2015

+++++++++++++++++++++++++++

Course Achievements

  1. Over 2,600 Students in first month of release!
  2. Over 35 Reviews in first month of release
  3. Average of 5,000 minutes consumed every month

+++++++++++++++++++++++++++

Course Description: Conditional Formatting

This is an amazing tool in Excel that will allow you to literally see the colours of the rainbow in your data no matter how big it is!

With this technique you can visualize your data and give it a whole new dimension using colours and symbols allowing you to understand your critical information on a deeper level.

++++++++++++++++++++++++++

Course Details

  1. This course has the shortest and simplest tutorial video's you will ever see! Clear, concise and to the point!
  2. It is designed for the beginner/intermediate but if you're looking to freshen up on your skills, come on in!
  3. I've intentionally made the video's around 2 minutes or less so that you get your information instantly. NO MORE USELESS CHATTER!!
  4. FULL AND FREE LIFETIME ACCESS
  5. All future lectures, videos, documents and upgrades included FREE

+++++++++++++++++++++++++++

Instructor Achievements

  1. Member of the Udemy Council
  2. +19,000 students (totalling ~40,000 enrolments)
  3. Average of 300-500 enrolments per day (Highest enrolment rate in one day was 1400 students)
  4. +500 Positive Reviews (5 Star Average Rating across all courses)
  5. +18 Live courses (+20 courses in production)
  6. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers

+++++++++++++++++++++++++++

What Udemy has said about the Instructor

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'

+++++++++++++++++++++++++++

What students have already said about this course

  1. ShelleB This course is hands-down the best on Excel conditional formatting and it's only half an hour long! I took it to prep for an upcoming college statistical analysis course with heavy Excel usage and got so much more out of it than I thought. He uses simple language, short bursts of lecture and provides a simple download for your own practice.
  2. Fauziya Shariff The course is simple and easy to understand. The instructor is simply superb.
  3. Hermant Namdeo I never knew about conditional formatting in excel and after seeing the advantages of it, I regret how I missed it so long. A great course.
  4. Anupam Prasad Absolutely to the point. I saved a lot of time learning a new way of handling my data. The short clip approach binds to the content. Absolute must for busy souls.
  5. Jerry The training is so easy to follow and clearly understood. I'm looking forward to more of Jed's material's.
  6. Imraan Jed, you are superb and I must say it was very useful to go through this in 30 minutes.

+++++++++++++++++++++++++++

Enrol Now and Experience the Benefits

  1. I'll show you step-by-step, I'll explain and highlight every single button I press, I'll draw around important area's and icons with on-screen drawing tools, I'll zoom into small and hard to see area's so you don't miss a single thing!
  2. With over 15 years of experience using Microsoft Excel, I'll let you look over my shoulder as I teach you the fundamentals.
  3. I'll show you exactly how to master this technique in a fraction of the time it takes the average person to learn on their own from books, YouTube videos, blogs and forums!
  4. By mastering this technique you'll become the most productive and most efficient person at your job and at home!
  5. New doors and opportunities will begin opening up for you personally and professional with each new technique you acquire!

Click the “TAKE THIS COURSE" button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

What are the requirements?

  • Pen and paper to take notes
  • Microsoft Excel 2007 or later
  • Access to computer/internet

What am I going to get from this course?

  • Apply and modify Conditional Formats
  • Perform multiple conditional formats on the same fields/cells
  • Execute Highlight Cell Rules
  • Execute Top and Bottom Rules
  • Execute Icon Sets
  • Create a basic automated calculation with Conditional Formats

What is the target audience?

  • If you’re intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!
  • Basic Knowledge Excel
  • People from any country
  • People of all ages

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Quick Demonstration and Uses
Demonstration
Preview
03:07
Conditional Format Uses
Preview
01:53
Downloadable Practice Files
Article
Section 2: Case Study and Quick Start Example
Case Study - Jed's Computer Business
Preview
01:05
Quick Start Application
Preview
02:12
Removing Conditional Formats
01:26
Section 3: Data Bars and Multiple Conditional Formats
Data Bars
Preview
02:18
Multiple Conditional Formats
Preview
02:20
Section 4: Highlight Cell rules
Greater Than
02:18
Less Than and Different Text Format
02:00
Between Function
01:39
Equal To
01:44
Text That Contains
01:47
Date Preparation
01:53
Date Conditional Format
01:29
Duplicate Conditional Format
01:39
Section 5: Top and Bottom rules
Top and Bottom Conditional Format
01:36
Top and Bottom % Conditional Format
01:16
Above and Below Average Conditional Average
01:11
Section 6: Icon sets
Icon Sets Explained
01:57
Direction Icon Sets
Preview
01:58
Shapes and Indicators Icon Sets
01:57
Ratings Icon Sets
Preview
02:09
Section 7: Formula’s and Filters (Bonus Functions)
Dynamic Data Updating and Conditional Formatting Combination
01:38
Filters and Conditional Formatting
Preview
02:04
Section 8: Congratulations
All My Courses!
Article
Help Me Inspire More People!
Article
Congratulations
01:03
Check us out on Facebook!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jed Guinto, Aerospace Engineer, Researcher, Entrepreneur, Programmer

Udemy Start Date: July 2014

What Udemy has said about my courses:

'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust!'

PC Mag:

'Jed Guinto is something of an Udemy wunderkind!'

'There are all-stars, such as Mr. Guinto, who do well by any metric!'

Achievements

  1. Member of the Udemy Council
  2. +43,000 students
  3. +2800 Positive Reviews
  4. Incorporated my Udemy courses into RMIT University Laboratory Tutorials for Undergraduate Aerospace Engineers

Quick Biography

Jed Guinto is an Australian technical trainer who specialises in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering (RMIT 2006-07), a Bachelor's Degree in Aerospace Engineering with Honours (RMIT 2008-10), a Graduate Certificate in Engineering Management (RMIT 2011) and is currently doing his Ph.D. in Advanced Composite Structures and Nonlinear Acoustic Systems (RMIT 2015-Present). He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world.

In 2011 he travelled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747.

In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics.

From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries.

In 2015, he was awarded the ARC Discovery Grant Scholarship and granted Full Research Funding for the next 3 years from the Australian Government to begin his Ph.D studies at RMIT. His focus is on Damage Diagnosis of Composite Structures through the use of Nonlinear Ultrasonic Techniques. His research will have applications in the Aerospace, Mechanical and Computer Engineering fields with additional applications in Health and Medicine.

He will be researching under renowned Aerospace Engineers such as Professor Chun Wang, former Head of Advanced Composites Technologies Research for Air Vehicles, Defence Science and Technology for Australia and current Professor and Director of the Sir Lawrence Wackett Aerospace Centre at RMIT University. He will also be working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students.

Complete Biography

Jed was born in Philippines but grew up in Melbourne, Australia. He has achieved success in the fields of aerospace engineering design, project management, database development and space research. One such achievement was his Final Year Undergraduate Thesis research and design of an Extra-Vehicular Activity (EVA) Space Glove to be used by astronauts on space walks. His design involved the use of Shape Memory Alloy Polymers as artificial muscles to increase strength, mobility, longevity, dexterity and control of astronauts. His designs earned him the award for research from the National Committee for Space and Radio Science (NCSRS) and the National Space Society of Australia (NSSA) at the largest Space Conference in Australia; the Australian Space and Science Conference (ASSC) held at the University of Queensland in 2010.

In the same year, he managed a team of 11 students in the design of an Environmentally Friendly Commercial Jetliner the size of the Airbus A320 and Boeing 737. He facilitated the conceptual design, preliminary design, documentation, presentation, research and analysis which earned each and every student no less than a Distinction as their final grade.

Additional research he performed was Dynamic Stability Analysis of an aircraft at the Royal Australian Air Force (RAAF). This involved flying to an altitude of one kilometre and using lasers to determine aerodynamic behaviour through a variety of manoeuvres. Once again, under his leadership, the team of 10 students were awarded nothing less than a Distinction.

In 2011, he earned the privilege of working and studying at Consaro GmbH, a German Engineering company with 25 years of expertise in the field of Aerospace Engineering, Lightweight Structures and Composites, located in Augsburg, Germany. There he performed Structural Strength Analysis on lightweight aircraft structures such as the Airbus A320, Airbus A330, Airbus A340, Airbus A350 and the Boeing 747-400 series. Investigations he performed included load path analysis of complex mechanical systems, component strength analysis and stability analysis on thin walled structures.

In 2012, he began volunteering for organisations such as Edmund Rice Community Refugee Services and the Smith Family Services. Here he educated and mentored underprivileged and disadvantage youth students ranging from 7 to 18 years old in the fields of physics, english, biology, chemistry and mathematics. This experience has been one of the turning points in his life which have resulted in the educational courses he has now developed.

It was in Germany he began his journey into computer programming, application development and large scale data analysis with data sets reaching into the millions. He went on to refine these skills and was employed as the Ford Motor Company Asia Pacific and Africa Tooling Systems Engineer for Global Asset Management (2013-2014). His contributions in the field of data management, database design, software automation and statistical analysis have been utilised across several continents around the world.

His vision for the future is to share as much of his knowledge as he can to others around the world so that they have the tools to better their lives and those around them. To make learning and education fun, simple, accessible and affordable for those who have long given up on it. His belief is that it is never too late to learn and that curiosity is the key to all success.

Ready to start learning?
Take This Course