Accounting Course Online

Question from YouTube is how to average all the non-zero values in a range. In Episode 1030, Bill and Mike show several methods for solving the problem.

This blog is the video 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:37

Read the rest of this entry »

Technorati Tags: accounting, array, average, business, Excel, formula, mrexcel, spreadsheets, technology, tutorial

Learn how to modify a report in Sage Peachtree at www.teachUcomp.com. A clip from Mastering Peachtree Made Easy v. 2009. http://www.teachucomp.com/pttutormain.htm – the most comprehensive Peachtree tutorial available. Visit us today!

Duration : 0:5:41

Read the rest of this entry »

Technorati Tags: "sage, 2004, 2005, 2006, 2007, 2008, 2009, account, accounting, book, cd, class, Classes, course, courses, do, Download, drop, DVD, element, elements, employee, employees, environment, Equity, event, events, Excel, exempt, Expense, export, exporting, feature, file, files, Finance, financial, find, Fixed, form, forms, global, group, groups, guide, help, how, how-to, id, import, importing, index, internal, invoice, invoices, Invoicing, item, items, learn, manual, modify, modifying, online, peach, peachtree, report, reports", software, training, Tree", tutorial, video

Glenn has a series of line charts showing monthly data for 2009. Most charts work fine, but the total chart shows the line dropping to zero for future months. Episode 1004 shows how to solve this problem, then how to solve the problem from the solution to the original problem!

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:3:26

Read the rest of this entry »

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

How much ice cream will Sally sell on any given day? Todays Episode 624 tries to figure out a relationship between temperature, rain and ice cream sales.

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

Duration : 0:3:54

Read the rest of this entry »

Technorati Tags: accounting, business, charting, Excel, Forecasting", mrexcel, multiple regression, spreadsheets, technology, tutorial

Figure out the number of billable days between two dates. Episode 1018 looks at ways to count the number of days, number of workdays, or number of Monday-Wednesday-Friday dates between two dates.

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:34

Read the rest of this entry »

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