EXCEL, Conditional Formatting EXPLAINED, [IGCSE ICT 0417] скачать в хорошем качестве

EXCEL, Conditional Formatting EXPLAINED, [IGCSE ICT 0417]

Learn all about conditional formatting in Excel. Use the pre set rules, create your own rules or apply conditional formatting using Formulas. Learn how conditional formatting works with cell references. Video primarily for students taking the Cambridge ICT IGCSE exams but is a great learning resource for everyone. Link to the video regarding Absolute/Mixed and Relative references as referenced in the tutorial:    • Excel References, Relative, Absolute and M...   0:00 Intro 2:35 Applying conditional formatting using a cell reference 4:45 understanding Absolute references added by Excel when a cell is used as a reference 7:46 Applying some of the preset conditional formatting rules based on values based on text 11:55 Creating our own conditional formatting rules Based on cell values 13:12 Based on cells that contain 14:44 Top/ Bottom ranked values 15:23 Above or below average 16:04 Based on Duplicate or unique values 17:00 Using formulas to apply conditional formatting Using an extra column to understand how references are used in conditional formatting with formulas 20:18 Applying conditional formatting on cells not being used in a formula 23:29 Analysing why we need Mixed or Relative references 27:53 clearing conditional formatting from selected cells or entire spreadsheet 28:24 Formatting a row instead of just a cell Analysing the formula and references for 2 dimensions 34:52 Summary