![Build Your Skill](/img/default-banner.jpg)
- 70
- 68 379
Build Your Skill
Приєднався 22 чер 2020
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.
Переглядів: 420
Відео
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
Переглядів 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
Переглядів 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
Переглядів 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.
2023 Higher Admin & IT - SS Pivot Task
Переглядів 63710 місяців тому
A work through for the Pivot Table Spreadsheet task from the 2023 Assignment.
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
Переглядів 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.
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.
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.
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.
2022 H Admin & IT Assignment Intro
Переглядів 397Рік тому
A wee introduction to the 2022 Higher Admin & IT Assignment
2022 N5 Admin & IT Database Task 2.b
Переглядів 1 тис.Рік тому
This task needs you to do a query and then a database report.
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
Переглядів 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.
2022 N5 Admin & IT Spreadsheet Task 1 - Printing Requirements
Переглядів 688Рік тому
2022 N5 Admin & IT Spreadsheet Task 1 - Printing Requirements
2022 Higher Admin & IT SS (Tasks 6 & 7)
Переглядів 1,1 тис.Рік тому
2022 Higher Admin & IT SS (Tasks 6 & 7)
Excel - Introduction to V, H and X Lookups
Переглядів 151Рік тому
Excel - Introduction to V, H and X Lookups
Excel - Matching Transactions with a Pivot Table
Переглядів 1,1 тис.2 роки тому
Excel - Matching Transactions with a Pivot Table
Excel - How to incorporate a VLookUp into Conditional Formatting
Переглядів 1512 роки тому
Excel - How to incorporate a VLookUp into Conditional Formatting
Excel - How to Build Basic Interactive Dashboards
Переглядів 722 роки тому
Excel - How to Build Basic Interactive Dashboards
Excel - Combining 2 Function Argument Boxes (IF Statement & Rounddown)
Переглядів 1,9 тис.3 роки тому
Excel - Combining 2 Function Argument Boxes (IF Statement & Rounddown)
Guide to Excel and Word Packs for Beginners
Переглядів 1403 роки тому
Guide to Excel and Word Packs for Beginners
7. Excel 3D formulas and working between multiple sheets
Переглядів 4903 роки тому
7. Excel 3D formulas and working between multiple sheets