homeHome contactContact portfolioPortfolio musicMusic videoVideo historyHistory calendarCalendar rssLinks rssRSS


.. I used to be indecisive, but now I'm not so sure... ..

Overlay Charts – 444 – Learn Excel from MrExcel Podcast

June 11th, 2009 learn accounting   No Comments

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

Importing Fixed Width Files – 458 – Learn Excel from MrExcel Podcast

June 9th, 2009 learn accounting   No Comments

In our continuing look at importing text files, todays netcast discussed how to import fixed width files into Excel. Watch to learn why choosing the text column type will cause your formulas to never work. Episode 458 provides the details.

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:4:40

Read the rest of this entry »

Technorati Tags: , , , , , , ,

Quickbooks Training: Record and Use Vendor Deposit

June 9th, 2009 accounting training   No Comments

This tutorial is from our hands-on practice excercise series: Record and Use Vendor Deposit.

Duration : 0:4:19

Read the rest of this entry »

Technorati Tags: , , , , , , , ,

Quickbooks Training: Add Payroll & Compensation Details

June 7th, 2009 training accounting   No Comments

http://www.QuickbooksTrainingDVD.com

This tutorial is from our hands-on practice excercise series: Mastering Quickbooks Level 1.

http://www.QuickbooksTrainingDVD.com

Duration : 0:5:31

Read the rest of this entry »

Technorati Tags: , , , , , ,

Dueling: Average Non-Zeroes -1030- Learn Excel from MrExcel

June 7th, 2009 learn accounting   1 Comment

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