ICTv3-Spreadsheet

ICTv3 Spreadsheet Essentials

  • 3 Interactive Lessons and 29 topics mapped to the official exam objectives
  • 179 Practice Test Questions and 3 Full Length Tests

Beginner Self-paced · 1 year access

3Interactive Lessons
29Topics
179Practice Test Questions
26Videos
85Flashcards

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

3 Interactive Lessons · 29 topics
01 Modern Spreadsheets 11 topics
  • Points to Ponder
  • Purpose of Spreadsheets
  • Evolution of Spreadsheet Software
  • Basic Spreadsheet Software Features
  • Keyboard Shortcuts
  • Basic Spreadsheet Editing Techniques
  • Navigating multiple sheets
  • Lesson 1 Skills Section
  • Getting Started with Google Sheets
  • Getting Started with MS Excel
  • Case Study
02 Charts and Printing 9 topics
  • Points to Ponder
  • Tables in Spreadsheets
  • Creating Charts in Spreadsheets
  • Printing a Table and Chart
  • Modifying Charts in Spreadsheets
  • Lesson 2 Skills Section
  • Creating and Modifying Charts with Google Sheets
  • Creating and Modifying Charts with Excel
  • Case Study
03 Advanced Editing Techniques in Spreadsheets 9 topics
  • Points to Ponder
  • Formulas
  • Using Formulas in a Spreadsheet
  • Absolute vs Relative References
  • Conditional Formatting in Spreadsheets
  • Lesson 3 Skills Section
  • Advanced Editing with Google Sheets
  • Advanced Editing with MS Excel
  • Case Study

02 / FAQs

Questions before you start

Contact us ↗

Prepare for ICTv3 Spreadsheet Essentials

One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.

  • 1 year of full access
  • Certificate of completion
Try Free

No credit card required

scroll to top