Google Sheets MasterClass

 

Course Outline:

• Introduction to google sheets

• Cells, Columns & Rows

• Enter Data

• Format number

• Adjust column widths & row heights

• Move columns & rows

• Insert columns & rows

• Hide columns & rows

• Freeze columns & rows

• Conditional formatting

• Column stats

• Addition, Subtraction, Multiplication & Division

• Functions

• SUM function

• Relative & absolute references

• VLOOKUP function

• Multiple worksheets

• Sort & filter

• Filter views

• Charts

• Pivot tables

• Create a new form

• Share & collaborate with others

• Publish, email & print