Important COVID-19 Notice
We have postponed all classroom
training until further notice.
Instead we are offering online IT Training.
CLICK TO FIND OUT MORE

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Welcome to Course Builder

Create your own bespoke Course here!

With our unique Course Builder you are able to pick and choose which parts of the training best apply to your needs. That way you get training that is completely tailored to your requirements.

How to use Course Builder

  • Step 1 - Select course by clicking on drop down arrow below
  • Step 2 - Click on the topic required
  • Step 3 - Click the Add button
  • To add further topices repeat steps 1 to 3
  • Note: 1 day of training = 6 hours
  • Step 4 - To finish complete the form below and press the Send button

Course Builder


Microsoft Excel: Functions - SUMIFS and COUNTIFS

These two functions are great for summarising data, producing running totals that you can then refer to with no further effort. SUMIFS totals number under certain circumstances. For example, you might have a team of sales people selling different flavours of ice-cream. Using SUMIFS you could see at a glance the value of sales by person and flavour. COUNTIFS is similar but it would count the number of orders of each flavour by sales person. To use these effectively you really need to understand Absolute References (using a $ in a formula). Include that module if you aren't sure.

Duration: 1 hour(s) and 30 min(s)

Add


Your Selection

0 hour(s) and 0 min(s)


Please select a course module from above


Send Your Course