Course curriculum

    1. Welcome to Data Gurus

    1. Google Sheet Vs. Excel

    2. Anatomy of a spreadsheet: structure, navigation, and selecting cells

    3. Anatomy of a spreadsheet: renaming sheets and an overview of menu options

    4. Anatomy of a spreadsheet: enabling classic short cuts and inserting rows and columns

    5. Data Types: text, currencies, and decimals

    6. Text to Columns

      FREE PREVIEW

    7. Data Types: dates

    1. Anatomy of a Function

    2. Formula Reference - Fixed Vs Variable

    1. COUNT, COUNTA, COUNTUNIQUE

    2. Filter and Sort

    3. SUM, AVERAGE, MEDIAN, MODE, MAX, MIN

    4. Multiplication, DATEDIF

    5. BEDMAS / BODMAS

    1. TRIM, Upper Case, Lower Case, Title Case, and Pasting Values

    2. LEFT, SEARCH, MID, LENGTH, RIGHT

    3. CONCATENATE, CONCAT

    1. What You've Accomplished

About this course

  • 19 lessons
  • 3.5 hours of video content