Explore

Google Sheets Basics Course - For Absolute Beginners (2020)

1.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

How to create a Closing Balance Stock Sheet with Google Sheets (2020)

Description

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

Requirements

Requirements
Computer with Internet Access and Web Browser Installed

Recommended for you

HTML5 + CSS3 + Bootstrap: The Beginner Web Design Course

Quickly learn HTML5 and CSS3 + Bootstrap - the basics of Web Development - to design your own responsive websites. *** NEW HTML5 and CSS3 COURSE ON UDEMY! ***...

Save Course

The Result-Oriented Web Developer Course - BOOTCAMP 2020

Full Stack Web Development Bootcamp. HTML, CSS, Javascript, etc ! 9 Major Projects. Complete. Full Stack Web Development Hello! Welcome to the Result-Oriented Web Developer Course - BOOTCAMP 2020....

Save Course

JavaScript for Kids: Code Your Own Games and Apps Age 8 & Up

Brand new (2020) coding course for kids ages 8 and up, build your own interactive games and apps in JavaScript! ★★★★★ Join over 40,000 students from 163 countries learning to code from Dr....

Save Course