AJ Training
  • View Course Overviews:

  • Excel
  • Word
  • Outlook
  • PowerPoint
  • AJ Training.net
Back
Filter by Software:

How to use the AND formula?

  • Condition
  •  
  • Criteria
  •  
  • FALSE
  •  
  • Logic
  •  
  • TRUE

View

How to use the OR Formula?

  • Condition
  •  
  • Criteria
  •  
  • FALSE
  •  
  • Logic
  •  
  • TRUE

View

How to work out an average based on two criteria’s?

  • Average
  •  
  • Criteria
  •  
  • Multiple

View

How to add figures based on multiple criteria?

  • Criteria
  •  
  • Multiple
  •  
  • Sum

View

How to count items based on multiple criteria?

  • Count
  •  
  • Criteria
  •  
  • Multiple

View

How do I sum values based on a criteria?

  • Criteria
  •  
  • Range
  •  
  • Sum

View

How do I count items based on a criteria?

  • Count
  •  
  • Criteria
  •  
  • Range

View

How do I calculate the average based on a criteria?

  • Average
  •  
  • Criteria
  •  
  • Range

View
1 
Scroll

© AJ Training - 2017