Daily posts of Excel tips…and other stuff
Archive for the ‘General’ Category.
This week I made the switch from Firefox to Google Chrome. The latest stable release of Chrome supports “extensions” so all those pesky annoyances that kept me away from Chrome in the past can be fixed. My only complaint with Firefox is that I have to restart it a couple of times a [...]
Have you even attended a really good training session? What about it made it good?
I’d like to develop some training sessions. I get a lot out of preparing and presenting (and I hope the attendees get something too). Rather than developing training that looks like every other session I’ve attended, I thought it [...]
I’ve recently rebuilt my computer, which means I get to figure out all those little settings that I’m accustomed to. Since re-installing MZ Tools, the accelerator keys don’t work on any of the dialog boxes. Take the Add Procedure dialog, for instance
With this open, I click Alt+A and instead of actuating the Add [...]
In written correspondence, which is best:
dailydoseofexcel.com
DailyDoseofExcel.com
DailyDoseOfExcel.com
www.dailydoseofexcel.com
www.DailyDoseofExcel.com
www.DailyDoseOfExcel.com
http://dailydoseofexcel.com
http://DailyDoseofExcel.com
http://DailyDoseOfExcel.com
http://www.dailydoseofexcel.com
http://www.DailyDoseofExcel.com
http://www.DailyDoseOfExcel.com
I personally prefer #1, all lowercase and no unnecessary prefix. But I think I’m in the minority. One of the capitalized ones is probably easier to read, but I’m no sure about the “of”. Thoughts?
Top 10 Page Views in 2009
Post
Page Views
Creating CSV Files
33,947
Sumif Between Two Dates
19,336
Number Stored as Text
15,003
Writing to a Range Using VBA
12,165
Automating Internet Explorer
11,248
Progress Bar
11,212
Testing for Empty Cells
10,581
Pattern Matching
9,665
Calculated Fields in Pivot Tables
9,321
Maxif Minif Functions
8,162
Most Viewed 2009 Posts
Post
Page Views
Vlookup on Two Columns
6773
Vlookup
2695
Get the Path to My Documents in VBA
2258
Excel Sample Data
2230
Reading Xml Files in VBA
1710
Bingo
1673
Illegal Range Names
1576
Creating [...]
Hi all
I create a 2010 section on my Tip index page with the first pages about 2010.
http://www.rondebruin.nl/tips.htm
Load different RibbonX when opening file in Excel 2007 or 2010
Download to find the names of the Excel 2010 ControlIDs (819 kb)
Backstage view in Excel 2010
I not say they are good but this are my first examples that I [...]
MaryAnn asks an interesting question.
In column A there is text that may or may not contain the name of a US state. In column B there is a list of US states. In column C, we want the column A text without the state names. I think this would be a pretty [...]
J-Walk posted about Benford’s law and I thought I’d test it out. I found an Excel file with a lot of numbers, namely a price list. In a new workbook, I put the following code:
Sub MakeNumbers()
Dim wb As Workbook
Dim ws As Worksheet
Dim rCell As Range
[...]
