CIW

ICTv3 Spreadsheet Essentials

Lessons
TestPrep
Get A Free Trial

About This Course

Skills You’ll Get

Download Course Outline

1

Modern Spreadsheets

  • 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
2

Charts and Printing

  • 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
3

Advanced Editing Techniques in Spreadsheets

  • 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

ICTv3 Spreadsheet Essentials

$ 284.19

Buy Now

Related Courses

All Course
scroll to top