This course teaches you how to use Google Sheets to create a Closing Balance Stock Sheet. This course will introduce you to opening spreadsheet files, entering data, formatting data, editing, creating charts, saving, sharing and downloading the document from Google Sheets Cloud Platform with full compatibility with Microsoft Excel 365 and below. You will also be shown how to color cells, copy, paste, cut commands, and many other essential items that you will need to create a Closing Balance Stock Sheet with Google Sheets.

Course Content:

1 Introduction
2 How to Access Google Drive
3 Explaining the My Drive Menu
4 How to Name the Workbook Spread Sheet
5 How to Identify Cells
6 Creating Column Headings
7 Formating to Bold Text
8 Typing Date in the Correct Format
9 Changing Date to Full format
10 Auto Creating Future Dates for the Whole Month
11 Changing Numeric Data to 2 Decimal Places
12 Pre Staging 2 Decimal Places in all required Cells
13 Calculating Total Sales
14 Calculating Closing Balance
15 Auto Creating Opening Balance
16 Auto Prestaging Formulae to the rest of the future dates
17 Correcting the Closing Balance Arithmetic Formula
18 Filling in the rest of the Cells
19 Copying and Populating Opening Balace formula to more cells
20 Entering The rest of the data
21 Copying and Pasting Cells
22 Saving the File
23 Coloring the background of Cells
24 Deleting Rows
25 Fixing the Opening Balance Problem
26 Calculating Column Totals
27 Creating Borders on Cells
28 Creating a Second Sheet in a Workbook and Copying Entire Sheet to It
29 Deleting Values from Cells in Second Spread Sheet
30 Copying back deleted formula in Second Sheet
31 Changing Date on Second Sheet
32 Using Paste Special
33 Entering the rest of the data
34 Inviting other users to work on your Spread Sheet
35 Downloading the Spread Sheet
36 Received Invitation Email
37 Creating a Chart
38 Changing the Chart Type
39 Downloading the Chart Image
40 Inviting another User to Edit Spread Sheet in Detail
41 Editing Spread Sheet as an Invited Guest
42 Deleting Chart and Creating a New One as an Invited User
43 Merging Cells and Typing a Heading for the Chart
44 Original User Checking Changes made by Other User
45 Outro