No circular references (when a formula or function references itsself) was one of the essentials in my Five Formulas and Functions Essentials post. Generally, if you have a circular reference, you’ll get an error message warning you about it. But the message doesn’t tell you where your circular reference is. And if you click Cancel on the [...]
Tag archives for function
Training Team Webinars
Here on the Training Team we’re increasing our online offerings by doing webinars. Over the last two weeks, we did an Intro to Excel Formulas and Functions webinar and an Excel Pivot Tables webinar. In future semesters these webinars will be offered to all students. Webinars will be recorded and posted online so they can be watched [...]
category: Excel, Self Support
Quickly Generate Text in Microsoft Word
Maybe you’re looking to test out some formatting, maybe your boss is walking by and you want to look busy, maybe it’s something else, but sometimes you just need some text on the page in a hurry. A couple of tricks in Microsoft Word can help you out. Generate Lorem Ipsum in Your Word Doc (Word 2007 [...]
category: Word
The TRANSPOSE Function in Excel – Flip Your Rows to Columns and Columns to Rows
Transposing Excel data means flipping your rows to columns and columns to rows. In the example above, I want my transposed data to update if I change one of the numbers in my original data. Transposing through pasting options, like in last week’s post, is not a good solution here, because my transposed data would not change if [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
