Intermediate Microsoft Excel Using Conditional Formatting

Learn to apply Colour Scaling Techniques by value using Conditional Formatting Data Bars, Icons, Colours and Much More!

3.60 (267 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Intermediate Microsoft Excel Using Conditional Formatting
18,252
students
1 hour
content
Dec 2014
last update
$19.99
regular price

What you will learn

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

Why take this course?

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. 

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.


WHAT YOU’LL LEARN IN THIS COURSE

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.


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.


TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach

Screenshots

Intermediate Microsoft Excel Using Conditional Formatting - Screenshot_01Intermediate Microsoft Excel Using Conditional Formatting - Screenshot_02Intermediate Microsoft Excel Using Conditional Formatting - Screenshot_03Intermediate Microsoft Excel Using Conditional Formatting - Screenshot_04

Reviews

George
January 11, 2015
This is a very simple and good course. Jed explains concepts very clearly, screen shots are good. The thing that could be improved is to bunch some of the short videos into one larger video of 5-6 minutes. This will eliminate some of the repetition of navigating menu screens.
Dan
January 10, 2015
Course is broken down into bite size chucks with very easy to follow examples. Sample document makes following at home easy.
George
January 9, 2015
what i liked about this course was that it broke the different functions down into individual snipets focusing only on that piece. I could jump around and see the part i wanted to review without watching the entire course. It was concise, to the point.
Ma'ruf
January 9, 2015
Jed, Thank you for putting this up. I've learned a very useful tool within 30 minutes! Will definitely be recommending it to my friends! Great work, keep it up!
Marie
January 8, 2015
Really like the fact that the short videos make it easy to find a method quickly and you don't have to scroll to look for it. Clearly set out and easy to follow.
Candice
January 7, 2015
Very clear and concise, explained the information in a way that I excited to use in the future. Definitely upped my Excel knowledge.
Jerry
January 6, 2015
The training is so easy to follow and clearly understood. Looking forward to more of the instructor's materials.
Tim
January 5, 2015
Enjoying the class. Really like have you have each section broken down into bit sizes. Makes the info stick better than long winded sections.
Donna
January 4, 2015
The course is formatted (no pun intended) well and provides a good introduction/review to the various formatting capabilities to assist someone in applying quick analysis techniques to their data.
Tripti
January 3, 2015
I did not use conditional formatting for long time. I was looking for a review course. This has helped me in review. This course is engaging and covers all the features of conditional formatting other than custom formatting. Course is well designed for people learning conditional formatting for the first time. Jed is good at explaining conditional formatting. Video quality is good with clear visual presentation and good audio. I will recommend this as a good introductory conditional formatting course.
ShelleB
January 2, 2015
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.
Antonio
January 1, 2015
Very well presented. Good short videos that are easy to follow. Methodical and repetitive gets you to understand the process.
Doraisinna@gmail.com
December 31, 2014
A very good course. Each lesson is short and simple. easy to understand and follow. If the resolution of the Excel Menu bars can be made sharper it would make the viewing better. Nevertheless a very well structured course. Thank you for sharing.
Cristian
December 31, 2014
This course focuse you in a specific topic of Excel: Conditional Formatting. I think this is a great idea to improve Excel skills, by learning a single function in detail.
ALLISON
December 30, 2014
I always wanted to make my spreadsheets work better for me but didn't understand formatting. This course got me started. Looking forward to learning more.

Charts

Price

Intermediate Microsoft Excel Using Conditional Formatting - Price chart

Rating

Intermediate Microsoft Excel Using Conditional Formatting - Ratings chart

Enrollment distribution

Intermediate Microsoft Excel Using Conditional Formatting - Distribution chart

Related Topics

375985
udemy ID
12/23/2014
course created date
11/6/2019
course indexed date
Bot
course submited by