Excel Conditional Formatting from Basics to Formulas- SMASH!

Excel Conditional Formatting from Basics to Formulas- SMASH!

Learn all about Conditional Formatting. From Beginner Level to Formula/Function Based Advanced Exercises

What you’ll learn

  • Highlight Cells Greater/Smaller/Between a certain Value
  • Data Bars, Color Scales, Icon Sets
  • To Use Some functions to Format your data (includes AND, IF, SUM, SUMIF, COUNTIF, VLOOKUP, MATCH and more..)
  • Highlight Top/Bottom Values & Above and below Average
  • Formula base Formating
  • Productivity
  • Presenting Information

Requirements

  • Having Excel installed, any excel version will do

Who this course is for:

  • People Learning Excel
  • People who want to learn Excel Conditional Formatting
  • Advanced users who might need to do a review and go back to the basics on excel conditional formatting
  • Beginners to Intermediate Users who want to develop their excel skills
  • People learning Microsft Office tools (Word, access etc.) that want to fill their knowledge gap with excel
  • Highschool, College Students Needing Excel for their Academic Works
  • Controllers that work with excel, power bi python and so on that will find conditional formatting very useful for developing their controls and alerts to the next level
  • Working Professionals in general as excel is needed in most professions (Accountants, Controllers, Engineers, Architects, Analysts, Managers, Human Resources Managers, Teachers, Professors etc.)

Tags:

Tutorial Bar
Logo