» Printing a Range of Pages
11 hours ago by ExcelTips Daily Nuggets from allen@sharonparq.com
If your worksheet, when printed, requires more than a single page to print, you may want to only print a range of the possible pages. Here's how to specify exactly which pages you want printed. Read this ExcelTip: Printing a Range of Pages Microsoft Excel Tips - Learn Excel Faster!

» The Switch Function (VBA and UDF)
20 hours ago by Newton Excel Bach, not (just) an Excel Blog from dougaj4
Switch is a VBA function that operates in a similar way to the Select Case statement.  The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading →

» LatPilePY 1.03
1 day ago by Newton Excel Bach, not (just) an Excel Blog from dougaj4
The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves.  The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.

» Five most popular posts on the Excel blog in 2011
1 day ago by Excel Blog from Emily Warn
It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them on Office.com, or you can download Quick Reference Cards from our blog and pin them to your corkboard. There are ...

» Random Numbers in a Range
1 day ago by ExcelTips Daily Nuggets from allen@sharonparq.com
Excel provides several different functions that you can use to generate random numbers. One of the most useful is the RANDBETWEEN function, which allows you to generate a random number between a lower and upper boundary that you specify. Read this ExcelTip: Random Numbers in a Range Microsoft Excel Tips - Learn Excel Faster!

» Select Meaningful Axis Scales
1 day ago by Peltier Tech Blog from Jon Peltier
Last week, in You Have 1 New Notification On Klout!, I used social media metrics site Klout to illustrate how choice of axis scales can exaggerate or wash out the variation in a data set. Today I’ll pick on another social media metrics site, Topsy, to show how to pick meaningful axis tick spacing parameters. A [...]

» Excel Dev Con Live Blogging
2 days ago by Daily Dose of Excel from Dick Kusleika
Ross is live blogging the Excel Dev Conference in the UK. It’s already after lunch over there, but if you’re interested, check it out.

» Excel Mashup #1
2 days ago by Daily Dose of Excel from Tushar Mehta
Recently, Microsoft introduced a way to create a “mashup” using Excel. Fellow MVP, Jan Karel, put together a tutorial on how he created his first mashup. It helped me understand the basics, which are also well explained by Microsoft itself. In my case, for a long, long time I have wanted to draw any graph [...]

» Counting with Two Criteria
2 days ago by ExcelTips Daily Nuggets from allen@sharonparq.com
When you use Excel as a simple database program to store individual records, you may have a need to count the records which meet two criteria. There are a number of ways you can determine the desired count, as described in this tip. Read this ExcelTip: Counting with Two Criteria Microsoft Excel Tips - Learn Excel Faster!

» The Hawkesbury River Bridge at North Richmond, NSW
2 days ago by Newton Excel Bach, not (just) an Excel Blog from dougaj4
The bridge over the Hawkesbury River near North Richmond, North-West of Sydney, is one of the first reinforced concrete structures in Australia.  At the time of its construction it was the largest reinforced concrete bridge in the country, and it … Continue reading →

See all the latest posts on the Blog Toplist!