Companies Home Search Profile

Google Sheets - Advanced

Focused View

Intellezy Trainers

2:19:57

111 View
  • 1 - Google-Sheets-L2-Exercise-Projects-1579100146.zip
  • 1 - Introduction.mp4
    01:03
  • 2 - Importing Data.mp4
    02:21
  • 3 - Linking Sheets.mp4
    03:20
  • 4 - Linking to Another Spreadsheet.mp4
    04:36
  • 5 - Protecting Sheets and Ranges.mp4
    03:06
  • 6 - Working with Versions.mp4
    02:16
  • 7 - Reviewing Accessibility Settings.mp4
    01:32
  • 8 - What are Range Names.mp4
    02:17
  • 9 - Creating Range Names.mp4
    02:12
  • 10 - Using Range Names in Formulas.mp4
    02:09
  • 11 - Understanding Logical Functions.mp4
    02:25
  • 12 - Using Logical Statements.mp4
    03:27
  • 13 - Using AND and OR Functions.mp4
    03:46
  • 14 - Working with Nested IF Statements.mp4
    05:20
  • 15 - Using SUMIF AVERAGEIF COUNTIF and More.mp4
    04:10
  • 16 - Using the IFERROR Function.mp4
    02:53
  • 17 - Understanding Lookup Functions.mp4
    02:40
  • 18 - Using VLOOKUP.mp4
    07:25
  • 19 - Using HLOOKUP.mp4
    02:02
  • 20 - Using INDEX and MATCH.mp4
    07:21
  • 21 - Comparing Two Lists with VLOOKUP and IFERROR.mp4
    02:50
  • 22 - Using CONCAT CONCATENATE and TEXTJOIN.mp4
    03:35
  • 23 - Splitting Text to Columns.mp4
    01:31
  • 24 - Using LEFT RIGHT and MID Functions.mp4
    02:27
  • 25 - Using UPPER LOWER and PROPER Functions.mp4
    03:29
  • 26 - Using the LEN Function.mp4
    01:53
  • 27 - Removing Duplicates and Trimming White Space.mp4
    02:39
  • 28 - Understanding Date Functions.mp4
    01:57
  • 29 - Using TODAY NOW and DAY Functions.mp4
    03:47
  • 30 - Calculating YEARFRAC and NETWORKDAYS.mp4
    03:27
  • 31 - Using Data Validation.mp4
    07:01
  • 32 - Adding Conditional Formatting.mp4
    05:12
  • 33 - Grouping and Ungrouping Data.mp4
    02:11
  • 34 - What is a PivotTable.mp4
    02:22
  • 35 - Creating a PivotTable.mp4
    03:24
  • 36 - Working with PivotTables.mp4
    02:04
  • 37 - Creating a Chart from a PivotTable.mp4
    02:58
  • 38 - Filter Charts and Tables with Slicers.mp4
    04:58
  • 39 - What are Macros.mp4
    01:33
  • 40 - Creating a Macro.mp4
    03:14
  • 41 - Working with Scripts.mp4
    02:21
  • 42 - Creating a Form.mp4
    03:46
  • 43 - Working with Forms.mp4
    02:34
  • 44 - Sending a Form.mp4
    01:21
  • 45 - Course Recap.mp4
    01:02
  • Description


    Learn the advanced fundamentals of Google Sheets

    What You'll Learn?


    • How to Use Logical Statements
    • Lookup Functions
    • Date & Text Functions
    • How to Link SpreadSheets and Sheet Files
    • Work with Range Names
    • Create Pivot Tables
    • Work with Macros and Scripts
    • Conditional Formatting
    • Inserting Graphics
    • Creating Forms

    Who is this for?


  • Anyone who wishes to learn the advanced functions of Google Sheets.
  • More details


    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.

    With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

    Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.


    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 [email protected] with proof of completion of the course to obtain your certificate.


    Who this course is for:

    • Anyone who wishes to learn the advanced functions of Google Sheets.

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Intellezy Trainers
    Intellezy Trainers
    Instructor's Courses
    Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 45
    • duration 2:19:57
    • English subtitles has
    • Release Date 2023/01/23

    Courses related to Google Sheets