| Excel Tutorials |
A blog for listing new Microsoft Excel tutorials.
|
- New Excel 2007 Tutorial
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
- Forcing Users to Enable Macros
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
- Excel Explosion
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
- Increasing the number of Undo Actions in Excel
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
- How to Create a Timeline in Excel
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.
- Transposing an Entire Dataset at Once
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:
- Excel Magic Tricks
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
- Dynamic Ranges Finally Explained
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
- Sort by Color?
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
- Data Validation: Underestimated and Underutilized
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
|
