Software - Google: Google Sheets: Advanced

Content
2 modules
Difficulty
Advanced
Rating
Course Length
135 mins
Instructor
Pantry of Knowledge

Description

This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms. This course has an assessment which may be required for a certificate to be generated.

This course aligns with the CAP Body of Knowledge and should be approved for 2.25 recertification points under the Technology and Information Distribution content area.
Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Objectives

  • Use logical statements
  • Use lookup functions
  • Link spreadsheets and sheet files
  • Work with range names
  • Work with macros and scripts
  • Use conditional formatting
  • Insert graphics
  • Create forms

Certificate

By completing/passing this course, you will attain the certificate POK Software Skills Certificate

Learning Credits

CEU
2.25

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Software - Google: Google Sheets: Advanced
{{ vm.helper.t('courses.scorm') }}
2.
Software - Google: Google Sheets: Advanced Survey
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty