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
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
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.
Borough of Manhattan Community College
The City University of New York
199 Chambers Street
New York, NY 10007
Directions
(212) 220-8000
Directory
Information for:
Students
Faculty & Staff
Alumni
