Visit and subscribe theCPAtube. Complete all HBL assignments on SLS & GC.

Week 5

Mastering MS-Excel & GoogleSheets

Welcome to Week 5

For this week, we will be focusing on GoogleSheets. The online equivalent of MS-Excel on the personal computers.

Both Googlesheet and MS-Excel are spreadsheet softwares.
GoogleSheet has become a very important spreadsheet software as it is online and allows for collaboration.
It is used in schools for organising data such as exam marks and class lists.
It is mostly used in businesses for financial management like budgeting, tracking inventory, planning dates.
Mastering this software will bring you a lifetime of benefits.

L3 : Wk 5 | Fri 24 Apr | Excel Functions Lesson Summary Quiz | Google Meet

Part 1: Google Meet Session for Excel Functions

Reference Helpfile

Check out the MS-Excel webpage on our welovecpa website

https://sites.google.com/view/learn-cpaonline/lessons/ms-office-skills/ms-excel-sst

....

0800 : Standby to receive Google

0805 : MeetUp Commences

Revision on

RANDBETWEEN
COUNT functions (COUNT, COUNTA, COUNTIF)
IF
TEXT functions (LEN, LEFT, MID)
DATE function (TODAY)
Calculating Percentages

0820 : Q&A | End of Session

...

Part 2 : Login to SLS

Complete 10 Questions MS-Excel Quiz on SLS
Additional time to complete Week 5 outstanding work

L2 : Wk 5 | Thu 23 Apr | Google Sheets PS 6-3 Schools Grades

Background

It is recommended that you complete PS 6-2 Overseas Trip, if you have not done so.
We are going to continue to use GoogleSheets.
We have learnt COUNTING functions (COUNT, COUNTA, COUNTIF)
We have learnt RANDBETWEEN (smallest, highest)
We have learnt Conditional Formatting
We are going to learn 3 new functions IF, LEN, LEFT, MID

...

Objectives

Revising Excel functions (COUNTIF, RANDBETWEEN, AVERAGE)
Using Google Sheets
Conditional Functions: IF
Text Functions: LEN, LEFT, MID
Sorting Ascending/Descending (Data/Sort)
Conditional Formatting
Sharing link & Submit

...

EXAMPLES

1. = LEN(OKAY) = 4

1. = LEN(APPLEPEN) = 8

1. = LEN(APPLE PEN) = 9 (Space is counted)

2. = LEFT("OKAY",1) = O

2. = LEFT("OKAY",2) = OK

3. = MID("OKAY",2,3) = KAY

3. = MID("OKAY",3,2) = AY

...

Reference Helpfile

Check out the MS-Excel webpage on our welovecpa website

https://sites.google.com/view/learn-cpaonline/lessons/ms-office-skills/ms-excel-sst

CPA Super Excel Examples

http://gg.gg/cpasuperexcel

...

Instructions

Go to this folder in your class Cloud folder. Click here

GoogleSheet : Class_Index_Name_Schools Grades

2. Open the GoogleSlides for detailed instructions on Making a Copy of the GoogleSheets.

// see example from previous lesson PS 6-2

3. Instructions & clues are included inside the Googlesheet itself.

4. Watch video tutorial for PS6-3 Schools Grades here.

5. Complete the Class_Index_Name_Schools Grades.

6. Submit your Shared link to "http://gg.gg/cpa-submissions-3T1"

...

ENJOY the LEARNING!

....

Other Support

Video tutorial will be up on TheCPAtube.

L1 : Wk 5 | Mon 20 Apr | Google Sheets PS 6-2 Overseas Trip

Background

We are going to use Google Sheets.

We are going to revisit this spreadsheet as a revision & also we are completing it directly online (without any downloads).

...

Objectives

Revising Excel functions (COUNT, COUNTA ,COUNTIF)
Using Google Sheets
Functions: COUNTA, COUNTIF, TODAY, RANDBETWEEN
Sorting & Conditional Formatting
Sharing link & Submit

...

Instructions

Go to this folder in your class Cloud folder. Click here
1. It should contain
  1. PS 6-2 Overseas Trip Googlesheet
  2. Google Slides Instructions "PS6-2 & Make A Copy"
  3. PS 6-2 Overseas Trip (Worksheet) GS.pdf
Open the GoogleSlides for detailed instructions on Making a Copy of the GoogleSheets.
Open the pdf file for instructions "PS 6-2 Overseas Trip (worksheet) GS.pdf"
Complete the PS 6-2 Overseas Trip Googlesheet
Submit your Shared link to "http://gg.gg/cpa-submissions-3T1"

Other Support

Video tutorial will be up on TheCPAtube.

Google Sites

Report abuse