70
68 379

2023 Higher Admin & IT DB Task - Query + Report

16:48

2023 Higher Admin & IT - SS Task - COUNTIF & SUMIF

3:44

2023 Higher Admin IT - SS Task - VLOOKUP

6:15

2023 Higher Admin & IT - SS Task - Intro & Complex IF

8:38

2023 Higher Admin & IT - SS Pivot Task

3:53

How to Remove Duplicates in Excel

2:40

N5 2023 Admin & IT - Spreadsheet Task 2 (a) and (b)

Question 2a and 2b from the 2023 N5 paper. There's a wee bit of formatting to do, use of the countif and sum functions as well as multiplying in task 2a. In task 2.b, data is required from the first worksheet to complete the second. There's arithmetical formulas as well as an IF statement in there.

Відео

2023 Higher Admin & IT DB Task - Query + Report

16:48

2023 Higher Admin & IT DB Task - Query + Report

Переглядів 72610 місяців тому

A work through of the database question in the 2023 Assignment. Using the NFS Clients database there is a query and from the query, a report.

2023 Higher Admin & IT - SS Task - COUNTIF & SUMIF

3:44

2023 Higher Admin & IT - SS Task - COUNTIF & SUMIF

Переглядів 58810 місяців тому

A work through for the third spreadsheet task from the 2023 Assignment. COUNTIF and SUMIF are complete the Analysis Sheet in the Employee Wages spreadsheet.

2023 Higher Admin IT - SS Task - VLOOKUP

6:15

2023 Higher Admin IT - SS Task - VLOOKUP

Переглядів 69810 місяців тому

A work through for the second spreadsheet task in the Employee Wages workbook in the 2023 Higher Admin & IT Assignment. A VLOOKUP is required to complete the Gross Pay worksheet.

2023 Higher Admin & IT - SS Task - Intro & Complex IF

8:38

2023 Higher Admin & IT - SS Task - Intro & Complex IF

Переглядів 76010 місяців тому

A work through for the first spreadsheet task from the 2023 Assignment. A brief introduction to the project then completion of the Employee Wages spreadsheet - Pay Rates sheet using a nested if or IFS function.

3:53

2023 Higher Admin & IT - SS Pivot Task

Переглядів 63710 місяців тому

A work through for the Pivot Table Spreadsheet task from the 2023 Assignment.

2:40

How to Remove Duplicates in Excel

Переглядів 183Рік тому

A short video showing how to find duplicates using conditional formatting, how to remove duplicates permanently how to use the Unique function.

2022 Higher Admin & IT DB Task (Part 2) - Report

11:25

2022 Higher Admin & IT DB Task (Part 2) - Report

Переглядів 1,2 тис.Рік тому

The second part of the first question in the assignment. This report is based on the query we did in the last video.

4:53

2022 N5 Admin & IT Database Task 2.c

Переглядів 939Рік тому

You need to insert data into a database table and delete rows. You then need to sort alphabetically on 2 fields.

15:28

2022 N5 Admin & IT Spreadsheet Task 1.a

Переглядів 3 тис.Рік тому

The first task asks you to complete a costing sheet that includes an IF Statement and link to a summary sheet.

4:52

2022 N5 Admin & IT Spreadsheet Task 1.b

Переглядів 1,2 тис.Рік тому

The second part of the first question, you need to complete the summary sheet by linking to another worksheet.

1:25

2022 H Admin & IT Assignment Intro

Переглядів 397Рік тому

A wee introduction to the 2022 Higher Admin & IT Assignment

7:07

2022 N5 Admin & IT Database Task 2.b

Переглядів 1 тис.Рік тому

This task needs you to do a query and then a database report.

12:49

2022 Higher Admin & IT SS Task

Переглядів 905Рік тому

This tasks has a V & H LookUp and link to a summary sheet with % changes.

2022 Higher Admin & IT DB Task (Part 1) - Query

12:26

2022 Higher Admin & IT DB Task (Part 1) - Query

Переглядів 1,6 тис.Рік тому

This is the 1st task in the assignment. There is a query with a calculated field and a report. This video shows how to do the query part of the question. There is another video showing you how to do the report.