Course curriculum

  • 1

    01 - Introduction To The Course

    • Welcome To Your Spreadsheets Course

    • Why It's Good To Know Spreadsheets

    • Before You Start

  • 2

    02 - The Anatomy Of A Spreadsheet

    • Your First Spreadsheet With Google Sheets

    • The Hierarchy Of A Spreadsheet

    • Real Life Examples Of Hierarchy

  • 3

    03 - Data Basics

    • Different Data Types

    • How To Insert Data

    • Basic Editing Operations

    • How To Change Data

  • 4

    04 - Formatting Basics

    • How To Resize Cells

    • How To Use Text Wrapping

    • How To Align Content

    • Basic Text Formatting

    • How To Format Numbers

  • 5

    05 - Working With Larger Datasets

    • How To Import CSV

    • How To Split Text Into Columns

    • How To Resize Columns And Rows

    • How To Delete And Insert Columns And Rows

    • Cleaning Up The Data

    • Adding New Data To Existing Table

  • 6

    06 - Navigating And Organizing Data

    • How To Move Around With Keyboard

    • How To Freeze Rows And Columns

    • Grouping VS Hiding

    • How To Use Filters

    • Using Automatic Calculations

    • How To Sort Tables

  • 7

    07 - Using Formulas

    • Relative VS Absolute References

    • Your First Formula

    • Using SUM Function

    • Calculating Adjusted Word Counts

    • Using Text Function

    • Using VLOOKUP Function

    • Finalizing The Total Budget

  • 8

    08 - Making It Pretty

    • Why Make Spreadsheets Pretty

    • On Contrast And Choosing Colors

    • Alternating Colors

    • Proper Alignment

    • Using Borders

  • 9

    09 - Keyboard Shortcut References

    • All Keyboard Shortcuts From The Course

  • 10

    It's A Wrap

    • How To Get Certified

For more information about the course, please visit our main site.