Accounting Course Online

Shawn sends in today’s question. The spreadsheet has billing data to audit. For each record, there is a location, a start date, and an end date. Shawn wants to find any records where the same date and location is double-billed. A quick two-loop macro solves this problem. Episode 1017 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Duration : 0:5:46

Read the rest of this entry »

Technorati Tags: accounting, business, Excel, mrexcel, spreadsheets, technology, tutorial, vba

Part 3 of the accounting concepts/terminology that we didn’t have time to talk about in class.

Duration : 0:9:20

Read the rest of this entry »

Technorati Tags: accounting, neanderthal, taxation

In a recent charting challenge, Jerome Sullivan sent in an interesting chart where the budget and actual numbers were actually plotted on top of each other. Episode 444 shows the non-intuitive steps required to create this type of chart.

This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every workday to learn one of the 277 tips from the book!

Duration : 0:4:0

Read the rest of this entry »

Technorati Tags: accounting, business, charting, charts, Excel, mrexcel, spreadsheets, technology, tutorial

A tutorial on finding and editing transactions to correct errors made when using Peachtree accounting software. Helpful for students using Perdisco’s Peachtree accounting practice sets. For more tutorials, visit: perdisco.com/peachtree

Duration : 0:7:44

Read the rest of this entry »

Technorati Tags: accounting, correct, correcting, edit, editing, errors, find, finding, peachtree, perdisco, Practice, set, Transactions, tutorial

Learn how to use the chart of accounts in Intuit QuickBooks at www.teachUcomp.com. A clip from Mastering QuickBooks Made Easy v. 2009. http://www.teachucomp.com/tutormain.htm – the most comprehensive QuickBooks tutorial available. Visit us today!

Duration : 0:6:19

Read the rest of this entry »

Technorati Tags: "basic, 2004, 2005, 2006, 2007, 2008, 2009, account, accountants, accounting, accounts, Activity, adjust, adjusting, agencies, agency, apply, applying, around, Asset, Assets, backup, bank, bar, bars, between, Bill, Billing, bills, book, Books, budget, budgets, Calculator, capital, card, cash, cd, center, centers, change, changes, changing, charge, charges, chart, class, Classes, cleanup, close, closing, company, course, courses, Download, DVD, guide, how, how-to, intuit, learn, manual, online, Pro, Quick, quickbooks, software, training, tutorial, use, using, video