Finance & Accounting Online Course by Udemy, On Sale Here
How to create a Closing Balance Stock Sheet with Google Sheets (2020)
An excellent training about Accounting & Bookkeeping
Google Sheets Basics Course – For Absolute Beginners (2020)
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 Introduction2 How to Access Google Drive3 Explaining the My Drive Menu4 How to Name the Workbook Spread Sheet5 How to Identify Cells6 Creating Column Headings7 Formating to Bold Text8 Typing Date in the Correct Format9 Changing Date to Full format10 Auto Creating Future Dates for the Whole Month11 Changing Numeric Data to 2 Decimal Places12 Pre Staging 2 Decimal Places in all required Cells13 Calculating Total Sales14 Calculating Closing Balance15 Auto Creating Opening Balance16 Auto Prestaging Formulae to the rest of the future dates17 Correcting the Closing Balance Arithmetic Formula18 Filling in the rest of the Cells19 Copying and Populating Opening Balace formula to more cells20 Entering The rest of the data21 Copying and Pasting Cells22 Saving the File23 Coloring the background of Cells24 Deleting Rows25 Fixing the Opening Balance Problem26 Calculating Column Totals27 Creating Borders on Cells28 Creating a Second Sheet in a Workbook and Copying Entire Sheet to It29 Deleting Values from Cells in Second Spread Sheet30 Copying back deleted formula in Second Sheet31 Changing Date on Second Sheet32 Using Paste Special33 Entering the rest of the data34 Inviting other users to work on your Spread Sheet35 Downloading the Spread Sheet36 Received Invitation Email37 Creating a Chart38 Changing the Chart Type39 Downloading the Chart Image40 Inviting another User to Edit Spread Sheet in Detail41 Editing Spread Sheet as an Invited Guest42 Deleting Chart and Creating a New One as an Invited User43 Merging Cells and Typing a Heading for the Chart44 Original User Checking Changes made by Other User45 Outro
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.