Skip to main content
You are currently using guest access (
Log in
)
Title
Home
Home
Page path
Home
/
►
Courses
/
►
L1 L2 Cambridge Nationals in Information Technologies
/
►
LO5 To be able to Import and Manipulate Data to Develop a Solution to Meet an Identified Need using
Data Modelling with Spreadsheets :: Mini Website
LO5 :: To be able to import and manipulate data to develop a solution to meet an identified need
Totals and Rounding
Making Decisions
Handling Errors
Lookup Functions
Match and Index
Cell Referances
Handling Text
Dates and Times
Counting and Adding
Viewing Formulas
Validating Data
Conditional Formatting
Protecting Worksheets
Managing Data
Pivot Tables and Pivot Charts
What-If Analysis
Macros and Security
Totals and Rounding
SUMPRODUCT Function
Page
SUMPRODUCT
File
ROUND Function
Page
ROUNDUP Function
Page
ROUNDDOWN Function
Page
ROUNDING
File
Making Decisions
Logical (Boolean) Operators
Page
IF Function
Page
Top Scorer IF Function
File
Handling Errors
IFERROR
Page
IFERROR
File
Lookup Functions
VLOOKUP Function
Page
VLOOKUP
File
HLOOKUP Function
Page
HLOOKUP
File
Match and Index
MATCH Function
Page
MATCH
File
INDEX Function
Page
INDEX
File
Using INDEX and MATCH Together
Page
INDEX and Match
File
Cell Referances
INDIRECT Function
Page
INDIRECT
File
Handling Text
CONCATENATE Function
Page
TEXTJOIN
Page
LEFT Function
Page
RIGHT Function
Page
PROPER Function
Page
LOWER and UPPER Function
Page
Text Handling
File
Dates and Times
DATE Function
Page
TIME Function
Page
NOW Function
Page
Dates and Times
File
Counting and Adding
COUNTIF Function
Page
COUNTIF
File
SUMIF Function
Page
SUMIF
File
SUBTOTAL Function
Page
SUBTOTAL
File
Viewing Formulas
Showing Formulas
Page
Validating Data
Validating Data
Page
Validation List
File
Validation Hardcoded list
File
Validation Error Messages
Page
Validation Error Message
File
Validation Input Messages
Page
Validation Input Message
File
Other Validation Rules
Page
Other Validation Rules
File
Conditional Formatting
Conditional Formatting
Page
Clearing Conditional Formatting Rules
Page
Conditional Formatting
File
Conditional Formatting with Formulas
Page
SEARCH and FIND
File
Top and Bottom Conditional Formatting
Page
Top and Bottom
File
Protecting Worksheets
Protecting a Worksheet
Page
Locking Cells
Page
Cell Protection
File
Managing Data
Importing Data
Page
Exporting Spreadsheet Data
Page
External References
Page
Three Cities
Folder
Pivot Tables and Pivot Charts
Pivot Tables
Page
Sorting and Filtering Pivot Data
Page
PivotTables
File
Pivot Charts
Page
PivotCharts
File
Dynamic Charts
Page
Dynamic Charts
File
What-If Analysis
What-If Analysis
Page
What If
File
Scenario Summary
Page
Scenario Summary Report
File
Goal Seek
Page
Goal Seek
File
Macros and Security
Creating a Macro
Page
Creating Your Macro
Page
Adding a Command Button
Page
Password Protection
Page
