Category:

Course Description:

Quickly learn how to work with Excel VBA IF, THEN, ELSE, ELSEIF, AND statements. This way you can write Excel macros that are dependent on multiple conditions. We take a look at looping through a set range of cells in an Excel table, checking their value and then changing the cell color based on that value. In addition to learning the IF THEN statement and how to loop through cells, you also learn how to quickly get the color code of a specific cell so you can refer to it in your Excel macro. I’ll show you a trick with the immediate window and how you can test, and query code in there. Course Length: 12:09 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.