NSCVCE
  • Computing Courses
  • Sign In
Select Page

Spreadsheets – Excel

by nsc-admin | Dec 7, 2024

This Excel Tutorial is for any level and covers the fundamentals of how to create and work with Excel Spreadsheets..

Categories: VCE Unit 1 & 2

Introduction to Excel

1 of 11 FREE
Spreadsheets and Excel – an introduction
Lesson 1 of 11 within section Introduction to Excel.
0
2 of 11 FREE
The Excel Interface and formatting
Lesson 2 of 11 within section Introduction to Excel.
0
3 of 11 FREE
Data Types in Excel
Lesson 3 of 11 within section Introduction to Excel.
0
4 of 11 FREE
Boolean data and conditionals
Lesson 4 of 11 within section Introduction to Excel.
0
5 of 11 FREE
Conditional Formatting
Lesson 5 of 11 within section Introduction to Excel.
0
6 of 11 FREE
Excel Formulas
Lesson 6 of 11 within section Introduction to Excel.
0
7 of 11 FREE
Visualising Data in Excel
Lesson 7 of 11 within section Introduction to Excel.
0
8 of 11 FREE
Working with Pivot Tables in Excel
Lesson 8 of 11 within section Introduction to Excel.
0
9 of 11 FREE
Practice Exercises
Lesson 9 of 11 within section Introduction to Excel.
0
10 of 11 FREE
VLOOKUP function
Lesson 10 of 11 within section Introduction to Excel.
0
11 of 11 FREE
Merge Tables in Excel
Lesson 11 of 11 within section Introduction to Excel.
0

Course Progress

Key Knowledge

  • Introduction to Excel
    • Spreadsheets and Excel – an introduction
    • The Excel Interface and formatting
    • Data Types in Excel
    • Boolean data and conditionals
    • Conditional Formatting
    • Excel Formulas
    • Visualising Data in Excel
    • Working with Pivot Tables in Excel
    • Practice Exercises
    • VLOOKUP function
    • Merge Tables in Excel
  • Facebook
  • X
  • Instagram
  • RSS
Site by DWNS - Hosted by iPresence.