Lesson #6: Advanced Spreadsheet - VLOOKUP using True - (for approximate matches)

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session we will continue with the Session Functions worksheet and use the Vertical Lookup (VLOOKUP) function to similarly to the IF function used in the previous video to search a the first column of a table for a value then return the result from a column specified. In this scenario it will be used to see which letter grade is to be applied to a students exam mark based on an approximate match of the numeric mark in the key table. Stay tuned and enjoy...Like, Subscribe and Share the content.

Відео

Lesson #5: Advanced Spreadsheet - The Nested IF Function

Переглядів 36 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session we will continue with the Session Functions worksheet and combine the IF( ) function to created a longer more advanced NESTED IF( ) function to test a single cell against multiple conditions, many times, then apply a result when the IF condition evaluates to be True or when if is False. In this sce...

Lesson #4: Advanced Spreadsheet - the IF Function

Переглядів 266 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session we will continue with the Session Functions worksheet to perform 8 given tasks. You will do more calculations using the COUNTIF( ) function, then the IF( ) function will be introduced to display text based on whether the comparison of values in a cell is true or false. Additionally the IF( ) functi...

Lesson #3: More Functions in Spreadsheet - Calculating with Functions (2)

Переглядів 156 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session we will continue with the Session Functions worksheet to perform 8 given tasks. These include inserting rows/columns, adjusting rows/columns height/width, applying currency formatting to values and bordering cells. We will also focus on the MAX( ), MIN( ), COUNT( ), COUNTA( ) and COUNTIF( ) functio...

Lesson #2: Spreadsheet Basics - Calculating with Functions (1)

Переглядів 126 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session you will learn how to manipulate the Spreadsheet program, and start using Functions such as the Sum( ) and Average( ) functions, as you continue with the previous worksheet from video Lesson #1. Stay tuned and enjoy...Like, Subscribe and Share the content.

Lesson #1: Spreadsheet Basics - Calculating with Formulas

Переглядів 306 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session you will learn how to manipulate the Spreadsheet program, understand the terms previously mentioned in the introduction video, enter data and perform calculations using simple formulas entered by the user. Stay tuned and enjoy...Like, Subscribe and Share the content.

Introduction to Spreadsheet

Переглядів 236 днів тому

CXC CSEC Information Technology - Introduction to Spreadsheet with Kevin Johnson. In this session you will be introduced to Spreadsheet terminologies and concepts. Although Microsoft Excel is used, the terminologies and most of the procedures may be applied to Google Sheets and other Spreadsheet program.