Free Excel and Quickbooks Online Workshop Series for BMCC Students

The Accounting Department’s free Microsoft Excel and QuickBooks workshop is designed to provide BMCC 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. For more information, kindly Email Professor Clive Nair at the email below. Your Access code will be provided upon registration.

Registration: Contact Professor Clive Nair at cnair@bmcc.cuny.edu or (917) 817-9607.

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

Excel Workshop Series

May 30  | 6-9 p.m.
Level 1 – Creating Worksheets, Formatting and Charting Data

June 1 | 6-9 p.m.
Level 2 – Using Excel Functions and Formulas, and Creating Tables

June 6 | 6-9 p.m.
Level 3 – Analyzing Data Tools and Special Features

June 8 | 6-9 p.m.
Level 4 – Learning Advanced Topics Using Excel Workbook

QuickBooks (QBO) Workshop  Series

June 13 | 6-9 p.m.
Understanding basic accounting functions using the QB software platform.

1. Overview of the QBO homepage and menu system
2. Reviewing basic financial statements.
3. Cash basis vs accrual basis accounting.
4. Understanding basic general journal entries.
5. Setting closing dates to protect accounting records.

June 15 | 6-9 p.m.
Invoicing and Processing Customer Payments

1. Creating and sending invoices
2. Processing and receiving payments
3. Understanding the “making deposits” process.
4. Compiling and sending customer statements

June 20 | 6-9 p.m.
Recording Expenses & Payments

1. Entering and paying bills
2. Processing expenses and bills using QBO.
3. Writing checks and entering bills.
4. Running and customizing expense & vendor reports
5. Budgeting cash payments

June 22 | 6-9 p.m.
Inventory

1.  Generating product invoices
2. Creating purchase orders “receiving/invoicing” process.
3. Stock control
4. Managing supplier payments.

June 27 | 6-9 p.m.
Month End and Year End Close Process

1. Preparing and processing month end and year end procedures.
2. Preparing bank reconciliations using the QBO Platform
3. Reviewing financial statements and journals

June 29 | 6-9 p.m.
Exam Preparation

1. Review Sample Exams
2. Question and Answer Session

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

• + Google Calendar
• + iCal Export