Intermediate Microsoft Excel Using Conditional Formatting


success 100%

Coupon Details

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

What Will I 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
  • Pen and paper to take notes
  • Microsoft Excel 2007 or later
  • Access to computer/internet


  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.



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.



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.


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.


  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.


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

Who 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

107 Responses to "Intermediate Microsoft Excel Using Conditional Formatting"

  • firtukloimutrzas says:

    I like this post, enjoyed this one appreciate it for posting. “The basis of optimism is sheer terror.” by Oscar Wilde.

  • tor onion directory. says:

    354536 718670Keep up the fantastic piece of function, I read couple of posts on this internet website and I think that your internet weblog is really intriguing and contains lots of superb data. 14851

  • says:

    739700 203504I was suggested this internet site by my cousin. Im not certain whether this post is written by him as no 1 else know such detailed about my trouble. Youre great! Thanks! xrumer 910151

  • Barbershop Saratoga Springs says:

    667696 145260one of the best system I know, thank you very much . 579052

  • wikipedia deep web says:

    624834 432899Hello I located the No cost Simple Shopping Icons Download | Design, Tech and Internet post quite intriguing therefore Ive included our track-back for it on my own webpage, continue the fantastic job:) 257693

  • tor onion websites says:

    288169 606224Some times its a discomfort within the ass to read what blog owners wrote but this internet website is actually user genial ! . 48835

  • forum says:

    911046 832338Some truly excellent articles on this internet site , thankyou for contribution. 70925

  • sherlyn popelka says:

    276525 704188I adore gathering useful information, this post has got me even more information! . 784367

  • forum says:

    570136 794256Gratitude for building this send! I in reality understand the no cost info. 208319

  • opinie says:

    73143 252134Hello there, just became alert to your weblog by way of Google, and found that it is truly informative. Im gonna watch out for brussels. Ill be grateful in case you continue this in future. A lot of folks will likely be benefited from your writing. Cheers! 631652

  • forum says:

    958554 863992An fascinating discussion may possibly be valued at comment. I do believe that you just write read more about this subject, it may possibly not often be a taboo topic but normally persons are too few to dicuss on such topics. To a higher. Cheers 640615

  • opinie says:

    687767 665763Very properly written story. It is going to be valuable to anyone who usess it, including yours truly . Maintain up the great function – canr wait to read far more posts. 78954

  • Hair Salon in Longview TX says:

    253311 982855I believe this internet web site has some rattling wonderful info for everyone : D. 5336

  • steeze says:

    824572 900357I was just seeking this info for some time. After six hours of continuous Googleing, finally I got it in your site. 490794

  • forum says:

    833529 261966This internet web site is my aspiration, very superb design and Perfect articles. 363253

  • Cycling Tour says:

    353062 279988I genuinely prize your work , Excellent post. 166374

  • 8togel says:

    197063 20959I besides believe therefore , perfectly composed post! . 32290

  • 바카라사이트 says:

    799345 912336I got what you intend,bookmarked , really good internet site . 171660

  • agencia de viajes en managua says:

    53989 733522As I site possessor I believe the content material matter here is rattling great , appreciate it for your efforts. You need to maintain it up forever! Best of luck. 911464

  • Google says:

    Usually posts some pretty fascinating stuff like this. If you are new to this site.

  • Amalfi coast tour says:

    905988 962714An fascinating discussion is worth comment. I believe that you ought to write much more on this topic, it may possibly not be a taboo topic but typically folks are not enough to speak on such topics. Towards the next. Cheers 55114

  • villa in teneriffa says:

    667689 157436Wonderful internet site you got here! Please maintain updating, I will def read much more. Itll be in my bookmarks so better update! 332442

  • 488451 119455Howdy! I just wish to give a huge thumbs up for the wonderful info you might have here on this post. I will probably be coming back to your weblog for far more soon. 521962

  • Traveling to Malta says:

    78731 920358Perfectly written topic material , thanks for selective info . 738844

  • says:

    226000 116798OK very first take a excellent appear at your self. What do you like what do you not like so a lot. Work on that which you do not like. But do not listen to other men and women their opinions do not matter only yours does. Work on having the attitude that this really is who youre and if they dont like it they can go to hell. 73659

  • vtyuExids says:

    [url=]cialis[/url] buy generic cialis buy cialis online

  • South African News Today says:

    775514 714717Interesting, but not perfect. Are you going to write far more? 116101

  • Tree cutting says:

    185959 919194What is your most noted accomplishment. They might want very good listeners rather than excellent talkers. 837416

  • 744901 182596Sweet internet web site , super design , truly clean and utilize genial . 873529

  • 크롬캐스트 뷰잉 says:

    326432 661054Youd outstanding guidelines there. I did a search about the field and identified that really likely the majority will agree with your internet page. 344900

  • บาคาร่า says:

    709521 97379I truly appreciated this wonderful blog. Make certain you keep up the excellent function. All of the finest !!!! 416157

  • binance says:

    559907 136578Youre so cool! I dont suppose Ive read anything such as this before. So good to get somebody with some original thoughts on this topic. realy we appreciate you starting this up. this fabulous web site are some items that is required on the internet, somebody with a bit originality. beneficial work for bringing a new challenge on the world wide internet! 454208

  • Barber Shop in Irmo South Carolina says:

    204729 931208I surely didnt know that. Learnt 1 thing new these days! Thanks for that. 797061

  • Despacho de Abogados en Zaragoza says:

    Very informative and fantastic anatomical structure of content, now that’s user pleasant (:.

  • sibutramine for sale says:

    629659 72294This was an incredible post. Actually loved studying your site post. Your data was extremely informative and valuable. I think youll proceed posting and updating regularly. Seeking forward to your subsequent one. 552360

  • 스포츠토토 says:

    886558 687850hey I was really impressed with the setup you used with this weblog. I use blogs my self so good job. definatly adding to bookmarks. 691619

  • Toddlers says:

    921911 208815I observe there is really a lot of spam on this blog. Do you want support cleaning them up? I may well assist in between courses! 619329

  • الربح من الانترنت says:

    300044 886966There is noticeably a bundle to learn about this. I assume you produced positive excellent points in capabilities also. 976298

  • elevator wallpaper says:

    597463 897075Get started with wales ahead almost every planking. Ones wales truly are a compilation of huge planks 1 specific depth advisors definitely could be the identical to the entire hull planking however with even bigger density to successfully thrust outward beyond the planking. planking 515673

  • where to buy canvas art says:

    502888 619620Yay google is my king aided me to uncover this excellent web site ! . 162646

  • says:

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove people from that service? Bless you!

  • I was reading this says:

    Good V I should definitely pronounce, impressed with your web site. I had no trouble navigating through all tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or something, website theme . a tones way for your customer to communicate. Nice task..

  • HIFU says:

    861254 68293Hey! Nice stuff, do tell us when you post something like that! 169644

  • This Contact Form says:

    Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get actually enjoyed account your blog posts. Anyway I’ll be subscribing to your feeds and even I achievement you access consistently quickly.

  • says:

    hello!,I like your writing very much! share we communicate more about your post on AOL? I need an expert on this area to solve my problem. Maybe that’s you! Looking forward to see you.

  • says:

    I believe this is one of the such a lot vital information for me. And i’m happy studying your article. But should statement on some basic issues, The website taste is wonderful, the articles is in reality excellent : D. Good job, cheers

  • directory says:

    I do not even know how I ended up here, but I thought this post was good. I do not know who you are but certainly you are going to a famous blogger if you are not already 😉 Cheers!

  • good says:

    Everyone loves what you guys are usually up too. This sort of clever work and exposure! Keep up the amazing works guys I’ve incorporated you guys to my personal blogroll.

  • NFL Stream says:

    I¦ve recently started a site, the info you provide on this web site has helped me tremendously. Thank you for all of your time & work.

  • Check It Out says:

    Keep functioning ,terrific job!

  • Google says:

    Very few web sites that happen to be comprehensive below, from our point of view are undoubtedly nicely worth checking out.

  • NBA says:

    I have been surfing online more than three hours nowadays, but I never discovered any interesting article like yours. It is beautiful value enough for me. In my opinion, if all web owners and bloggers made good content as you probably did, the internet will probably be a lot more helpful than ever before. “I finally realized that being grateful to my body was key to giving more love to myself.” by Oprah Winfrey.

  • rugby sevens stream says:

    The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

  • killer deal says:

    Hiya, I’m really glad I’ve found this information. Nowadays bloggers publish only about gossips and web and this is actually irritating. A good site with interesting content, that’s what I need. Thank you for keeping this web-site, I will be visiting it. Do you do newsletters? Can not find it.

  • mlb stream says:

    You have brought up a very great points, thanks for the post.

  • กู้เงิน ขอนแก่น says:

    520514 306466I like this internet internet site its a master peace ! Glad I detected this on google . 764818

  • ufc fight pass free stream says:

    You have observed very interesting points! ps decent internet site.

  • Tennis says:

    Hello there, I discovered your site by the use of Google at the same time as searching for a similar topic, your site got here up, it seems good. I’ve bookmarked it in my google bookmarks.

  • page says:

    Super-Duper website! I am loving it!! Will be back later to read some more. I am bookmarking your feeds also.

  • read this post here says:

    I definitely wanted to type a comment so as to appreciate you for all of the remarkable information you are giving on this site. My extended internet investigation has finally been paid with beneficial points to share with my relatives. I would tell you that many of us readers actually are undeniably blessed to dwell in a wonderful place with so many perfect professionals with helpful hints. I feel extremely blessed to have used your entire web site and look forward to really more enjoyable moments reading here. Thanks again for all the details.

  • says:

    Thanks for the sensible critique. Me and my neighbor were just preparing to do some research about this. We got a grab a book from our area library but I think I learned more clear from this post. I’m very glad to see such wonderful information being shared freely out there.

  • espn live stream says:

    You have remarked very interesting points! ps nice site.

  • vipleague ufc says:

    I am glad to be one of the visitants on this great website (:, thanks for posting.

  • this contact form says:

    Magnificent goods from you, man. I have understand your stuff previous to and you are just extremely fantastic. I actually like what you’ve acquired here, really like what you are saying and the way in which you say it. You make it enjoyable and you still take care of to keep it smart. I can’t wait to read far more from you. This is actually a great site.

  • says:

    obviously like your web-site but you have to check the spelling on several of your posts. Many of them are rife with spelling problems and I find it very bothersome to inform the reality on the other hand I will surely come again again.

  • will speak says:

    Dead written subject matter, Really enjoyed reading.

  • Nicole Junkermann says:

    Hey! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no data backup. Do you have any methods to stop hackers?

  • website url says:

    It?¦s really a great and useful piece of info. I?¦m happy that you simply shared this helpful info with us. Please stay us up to date like this. Thanks for sharing.

  • best site says:

    Hey, you used to write fantastic, but the last few posts have been kinda boring… I miss your great writings. Past few posts are just a little out of track! come on!

  • click for more info says:

    Good info and right to the point. I am not sure if this is truly the best place to ask but do you people have any ideea where to employ some professional writers? Thx 🙂

  • for says:

    I really like your writing style, fantastic info, appreciate it for posting :D. “Let every man mind his own business.” by Miguel de Cervantes.

  • discover more says:

    I love your blog.. very nice colors & theme. Did you create this website yourself? Plz reply back as I’m looking to create my own blog and would like to know wheere u got this from. thanks

  • this says:

    I’m still learning from you, but I’m improving myself. I absolutely love reading everything that is posted on your blog.Keep the information coming. I liked it!

  • look here says:

    I was very pleased to find this web-site.I wanted to thanks for your time for this wonderful read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post.

  • see post says:

    Saved as a favorite, I really like your blog!

  • go to my site says:

    It is the best time to make some plans for the future and it is time to be happy. I have read this post and if I could I wish to suggest you few interesting things or advice. Maybe you could write next articles referring to this article. I desire to read even more things about it!

  • a knockout post says:

    Those are yours alright! . We at least need to get these people stealing images to start blogging! They probably just did a image search and grabbed them. They look good though!

  • blog link says:

    I’ve recently started a site, the information you provide on this site has helped me greatly. Thank you for all of your time & work. “The word ‘genius’ isn’t applicable in football. A genius is a guy like Norman Einstein.” by Joe Theismann.

  • discover more here says:

    I¦ve learn some just right stuff here. Certainly value bookmarking for revisiting. I wonder how much attempt you set to create one of these fantastic informative site.

  • read says:

    naturally like your web site however you need to test the spelling on quite a few of your posts. Several of them are rife with spelling problems and I to find it very bothersome to inform the truth on the other hand I will certainly come again again.

  • right here says:

    It is in point of fact a nice and useful piece of information. I am glad that you simply shared this helpful information with us. Please keep us up to date like this. Thanks for sharing.

  • Click here says:

    Well I truly enjoyed reading it. This tip procured by you is very effective for correct planning.

  • Google says:

    Here are some hyperlinks to sites that we link to due to the fact we assume they may be really worth visiting.

  • Google says:

    Here are some of the web pages we recommend for our visitors.

  • Google says:

    We prefer to honor lots of other world wide web web pages around the net, even if they arent linked to us, by linking to them. Beneath are some webpages really worth checking out.

  • Google says:

    We like to honor quite a few other world-wide-web websites around the net, even if they arent linked to us, by linking to them. Below are some webpages worth checking out.

  • Google says:

    Sites of interest we have a link to.

  • Google says:

    Sites of interest we’ve a link to.

  • Google says:

    Wonderful story, reckoned we could combine a handful of unrelated data, nonetheless genuinely worth taking a appear, whoa did one discover about Mid East has got more problerms as well.

  • Google says:

    Sites of interest we’ve a link to.

  • Google says:

    Wonderful story, reckoned we could combine a few unrelated information, nevertheless genuinely worth taking a search, whoa did one learn about Mid East has got more problerms as well.

  • vdbxPrusa says:

    prozac medication [url=]fluoxetine 10 mg[/url] fluoxetine fluoxetina prozac generic

  • Google says:

    We like to honor lots of other net internet sites on the net, even when they arent linked to us, by linking to them. Below are some webpages really worth checking out.

  • Google says:

    Check beneath, are some absolutely unrelated websites to ours, nevertheless, they’re most trustworthy sources that we use.

  • ETIAS Visa says:

    No matter if some one searches for his essential thing, thus he/she wants to be available that in detail, thus that thing is maintained over here.

  • Google says:

    Usually posts some incredibly intriguing stuff like this. If you are new to this site.

  • Google says:

    Sites of interest we’ve a link to.

  • Google says:

    Here are some of the web-sites we recommend for our visitors.

  • Google says:

    Very few web-sites that come about to be in depth beneath, from our point of view are undoubtedly nicely worth checking out.

  • Google says:

    Usually posts some extremely fascinating stuff like this. If youre new to this site.

  • Google says:

    Here are some links to web sites that we link to because we feel they may be worth visiting.

  • Google says:

    Sites of interest we have a link to.

  • yjgcPaist says:

    sildenafil online [url=]sildenafil 100mg[/url] sildenafil citrate 50mg sildenafil citrate 50mg sildenafil generic

  • Google says:

    Here is a great Weblog You may Uncover Fascinating that we encourage you to visit.

  • Google says:

    Here is a great Weblog You may Obtain Intriguing that we encourage you to visit.

  • Google says:

    Sites of interest we’ve a link to.

  • Big Mountain Builders LLC AZ says:

    Hey there! I know this is kind of off topic but I was wondering which blog platform are you using for this site?
    I’m getting fed up of WordPress because I’ve had issues with hackers
    and I’m looking at options for another platform.
    I would be great if you could point me in the direction of a good platform.

Leave a Reply