Loading Events

Free Excel and Quickbooks Online Workshop Series for BMCC Students

May 28 at 6:00 pm - 9:00 pm
| Zoom

May 28 – June 27, 6:00–9:00 p.m. | Zoom

Workshop in computer lab

The Accounting Department’s free Microsoft Excel and QuickBooks workshop is designed to provide students with exposure to a variety of Excel applications and QuickBooks Online expertise. Students will learn to organize and sort various data and information. The workshops will be designed to prepare students for real world applications and to better prepare them for Excel and QBO certifications. Please Email Professor Clive Nair at the email below for detailed instructions. Access code will be provided upon registration.

Registration: Prof. Clive Nair
cnair@bmcc.cuny.edu
Fiterman Hall, Room 630G
(917) 817-9607

Zoom Link to Workshop:
https://bmcc-cuny.zoom.us/j/86213148020?pwd=aGg1QS95UHFqZmRDaWxSN1cvR2wwdz09


Excel Workshop

May 28 | 6:00 – 9:00 p.m.
Level 1 – Creating a Worksheet, Format and Charting Data

May 30 | 6:00 – 9:00 p.m.
Level 2 – Using Functions, Formulas, Creating Tables

June 4 | 6:00 – 9:00 p.m.
Level 3 – Analyzing Data Tools and Special Feature

June 6 | 6:00 – 9:00 p.m.
Level 4 – Advance topics Using Excel Workbook


QuickBooks Online Workshop

June 11 | 6:00 – 9:00 p.m.
Understanding Accounting basics through the eyes of the software platform
1. Overview of the homepage and menu system
2. Review financial statements.
3. Understand Cash vs. Accrual accounting. What’s the difference and which should you use?
4. Understand and know when to use general journal entries.
5. Set a closing date to protect your accounting records.

June 13 | 6:00 – 9:00 p.m.
Invoicing and Processing Payments from Customers
1. Create and send invoices and sales receipts.
2. Learn how to Receive Payments for Invoices
3. Understand the Making Deposits process.
4. Compile and send Customer Statements

June 18 | 6:00 – 9:00 p.m.
Expenses & Payments
1. Entering and Paying Bills
2. Understanding the difference in processing expenses and bills in QBO
3. Understand the difference between Writing Checks vs. entering bills
4. Run and customize expense & vendor reports to get deeper insights about how and where you’re spending money.

June 20 | 6:00 – 9:00 p.m.
Inventory
1. Generate Product Invoices
2. Create Purchase orders and learn the receiving and invoicing process.
3. Learn about Stock Control
4. Manage Supplier payments.

June 25 | 6:00 – 9:00 p.m.
Month End and Year End Close Process
1. Prepare and process Month End/Year End Routines
2. Conduct Bank reconciliations on the QBO Platform
3. Review Financial Statements and Journals

June 27 | 6:00 – 9:00 p.m.
Exam Preparations
1. Review Sample Exams
2. Q&A

If you have any questions, contact Contact Professor Clive Nair at cnair@bmcc.cuny.edu or (917) 817-9607.


Details
Date:
May 28
Time:
6:00 PM - 9:00 PM
Open to:
BMCC Students Only