tag:blogger.com,1999:blog-93123282012-05-20T09:14:43.697-07:00A blog for listing new Microsoft Excel tutorials.Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger18125This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site.tag:blogger.com,1999:blog-9312328.post-51635992830049197182011-03-30T14:33:00.003-07:002011-03-30T14:39:02.874-07:00

I recently had the chance to review the Excel tutorial offered by ExcelEverest.com. It is an amazing combination of text-based instruction, interactive exercises, and embedded videos that makes learning the basics of Excel fun. I'm going to write up a much more extensive review on my new Vertex42 blog, but thought I'd mention it really quickly here for now.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1tag:blogger.com,1999:blog-9312328.post-1155623890766458062006-08-14T23:22:00.000-07:002006-08-14T23:38:11.380-07:00

The first part of my new Excel 2007 Basics Tutorial is now online. I am interested in feedback because it is not a traditional online tutorial. I'm experimenting with using links to the online help system to serve as pointers to reference material. Like most tutorials, the principle is that you learn by doing, and part of that learning is getting familiar with where to go for help. The idea is to

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1136529550589579012006-01-05T23:36:00.000-07:002006-01-05T23:39:10.603-07:00

Have you ever distributed a workbook to many clients, only to find out that they are not enabling macros? Well in the linked video, I show you a relatively simple way to force your users to enable macros with only four lines of code.http://www.datapigtechnologies.com/flashfiles/forcemacros.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com2tag:blogger.com,1999:blog-9312328.post-1134143023146177512005-12-09T08:41:00.000-07:002005-12-09T08:43:43.166-07:00

I put this little utility together so that I could split my Excel datasets into separate Excel workbooks or separate tabs without cutting and pasting. For example, with this add-in, you can create a separate workbook for each Employee in your dataset or each City, or State...etc.Feel Free to Download this add-in and share it with othershttp://www.datapigtechnologies.com/dpeeinstall.htm

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com1tag:blogger.com,1999:blog-9312328.post-1129470763601197082005-10-16T06:52:00.000-07:002005-10-16T07:00:25.473-07:00

I read a blog a few days ago that hinted that Excel 12 will increase the number of undo actions to 100. That means that you will be able to undo 100 actions. In current versions of Excel the "undo stack" is limited to 16, so you can see this will be a big improvement.But for those of you who can't wait, I made a tutorial to show you how to increase the number of undo actions in Excel by

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1125727518278198642005-09-02T23:05:00.000-07:002005-09-02T23:05:18.310-07:00

Timelines have been created in Excel using drawing tools and stacked bar charts. This article, "How to Create a Timeline in Excel", demonstrates a new approach: using an XY chart, with error bars as leader lines. You can either create a timeline from scratch by following the tutorial, or download the ready-made Excel Timeline Template.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1122598350526739732005-07-28T17:48:00.000-07:002005-07-28T17:54:46.403-07:00

Some Excel users have the habit of giving their column headings the dual roles of label and data. For example, they'll call their columns January, February, March, etc. Unfortunaely, this causes a whole host of problems when trying to analyze the data. The video linked below will show you how to easily transpose these datasets to convert these month names into a single column called month. http:

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1119379280233426462005-06-21T11:39:00.000-07:002005-06-21T11:41:20.236-07:00

Here is a fun spreadsheet I created that does a few magic tricks. Can you figure out how they work?www.datapigtechnologies.com/downloads/magicspreadsheet.xls

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com1tag:blogger.com,1999:blog-9312328.post-1115091178756655962005-05-02T20:31:00.000-07:002005-05-02T20:34:38.313-07:00

You may of heard of dynamic ranges and even seen some in action. But do you know how they really work? This video will finally explain dynamic ranges.http://www.datapigtechnologies.com/flashfiles/dynamicranges.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com1tag:blogger.com,1999:blog-9312328.post-1115090786053601822005-05-02T20:18:00.000-07:002005-05-02T20:29:46.400-07:00

As of Excel 2003, there is no inherent functionality that allows you to sort by color. However, with an easy custom function, you can gain this functionality without breaking a sweat.Click on this link to see how: http://www.datapigtechnologies.com/flashfiles/SortonColor.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com70tag:blogger.com,1999:blog-9312328.post-1109263454954170942005-02-24T09:39:00.000-07:002005-02-24T09:44:14.956-07:00

This functionality is, in my opinion, underestimated and underutilized. Easy to set up and maintain, data validation can guide your users through data inputs, help avoid common errors, and keep your data clean. Watch the Video below to learn about Data Validation with Excel.http://www.datapigtechnologies.com/flashfiles/datavalidation.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1106548217142513802005-01-23T23:26:00.000-07:002005-01-23T23:30:17.143-07:00

Sending emails with Excel is easier than you think. Check out this tutorial that shows you how to use the SendMail method of Excel to create email functionality in your Excel spreadsheets. http://www.datapigtechnologies.com/flashfiles/excelsendemail.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com1tag:blogger.com,1999:blog-9312328.post-1102714154584542412004-12-10T14:25:00.000-07:002004-12-10T20:51:11.903-07:00

A new video on the basics of recording a macro has been added to DataPigTechnologies. This video covers the mechanics of recording a macro, the differences between recording with relative reference on vs off, and assigning a macro to a button. Follow the link to watch: http://www.datapigtechnologies.com/flashfiles/recordmacros.html

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1102395481373579812004-12-06T21:50:00.000-07:002004-12-06T21:58:01.373-07:00

Ever need to convert trailing minus signs in Excel? Well you can do it without code or a fancy Add-In. The below video tutorial will show you how to do it with a simple formula. http://www.datapigtechnologies.com/flashfiles/trailingminusproblem.html -M.Alexander

Mike Alexanderhttp://www.blogger.com/profile/02055618557455235559noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1102390525164470152004-12-06T20:35:00.000-07:002004-12-06T20:38:18.116-07:00

Michael Alexander of DataPigTechnologies.com has a created a site with a great set of online Excel video tutorials. Topics include pivot tables, charts, basic Excel concepts, and advanced Excel functions. I'm happy to announce that Michael has joined the Excel Tutorials team blog and we look forward to what he'll have to share in the future!

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1101968785874797142004-12-01T23:26:00.000-07:002004-12-01T23:29:22.973-07:00

This online guide provides an introduction to Monte Carlo simulation. It discusses the difference between deterministic and stochastic models, using two online interactive examples. A sales forecast model in Excel is used to demonstrate the basic steps of a Monte Carlo simulation for risk and uncertainty analysis. It shows how to: Generate random numbers Create histograms Calculate summary

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1101842017774900572004-11-30T12:13:00.000-07:002004-11-30T12:13:37.773-07:00

Download example spreadsheet problems for the Microsoft Excel solver add in, including how to solve a system of non-linear implicit equations. Learn how to use Excel solver in a VBA macro.

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com0tag:blogger.com,1999:blog-9312328.post-1101335744443267752004-11-24T15:26:00.000-07:002004-11-26T15:23:20.696-07:00

The purpose of this web log is to provide a method for reporting new Microsoft Excel tutorials having to do with a variety of subjects. I often come across sites that have a great tutorial or two, but I don't always have the time to add links to my website. This blog will serve as a way to quickly get the word out about new Excel tutorials as they are created, or as they are discovered. The

Jon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.com1