While I was teaching a class on Logical functions, a student asked if it was possible to make a logical function case sensitive. I was stumped. Fortunately, my boss found the answer while the class moved on to other skills. Hooray Ben!
Ben’s answer - the EXACT function. EXACT evaluates whether two text strings (numbers and [...]
Entries from October 2009
Case Sensitive Functions
June 23rd, 2009 · Filed under: Excel
Posted by Holly Green
Tags:
Spelling With AutoCorrect Options
June 17th, 2009 · Filed under: Excel · Office 2007 · Outlook · PowerPoint · Word
Posted by Holly Green
I couldn’t possibly count the number of times I’ve accidentally typed teh and watched as Word magically rearranged the letters to spell the. Nor can I count the number of times Word has made up for my inability to apply the i before e rule correctly. Word is constantly correcting words like receive for me without my [...]
Tags:
Recover a Corrupt Excel File
June 12th, 2009 · Filed under: Excel · Useful Web Sites
Posted by Jeff Hauger
Maybe you’ve had that one Excel workbook that you’ve used for years. It’s probably even traveled with you from one version of Excel to the next and even outlasted a desktop or two. But then one day the workbook with years worth of data won’t open. You click on it, nothing, you try to open [...]
Tags: · Excel
DreamSpark ~ FREE Design Software for Students
June 3rd, 2009 · Filed under: McCombs Tech Resources · Useful Web Sites
Posted by Jeff Hauger
As a student of the University of Texas at Austin, or for that matter if you are a high school or university level student anywhere, you can download full suites of design software from Microsoft for FREE!
Go to: www.dreamspark.com
The DreamSpark site offers Visual Studio 2008 Professional Edition, Expression Studio 2 for web designers, Robotics [...]
Tags:


