How to Get Started with Google Voice

Scenario: Your students don’t check their emails. Or, they are new to Blackboard Learn and have not figured out how to send course emails.  They do check their phones and texts. Dilemma: You don’t want to share your personal phone number with the students, but do want a way to reach out. Solution: Google Voice. It lets you text from a different number but yet receive their replies to your phone.

How To Create Your Knockout Online Portfolio

According to a recent Forbes article, 56 percent of all hiring managers are more impressed by a candidate’s online portfolio than any other personal branding tool. However, only 7 percent of job seekers have created an online portfolio.

This workshop and presentation will show you 3 steps to creating a knockout online portfolio:

1) Make your LinkedIn Profile 100% complete
2) Add content to SlideShare
3) Start a blog

And more!

Excel: use FORMULATEXT() to add notes to formulas



If you use Excel in your teaching, it is sometimes useful to spell out the formulas used in a cell. I found a neat way to show how you can accomplish it. The trick is use the FORMULATEXT() function. Here is how to do it.

  1. Go to cell E67.
  2. Go to the ribbon and click on FORMULAS. Then Function Library › Lookup & Reference. In the Reference field of the Function Dialog, point to cell B67 then click OK.
  3. In cell E67, the actual formula is displayed.

Bonus tip: Use the N function to add additional notes. You can do so by just adding +N plus the comment following the formula in the original cell (B67). So in B67, it looks like:

=T.DIST.RT(B65,B61)+N(“RT stands for ‘right tail”)

Then in E67, the actual formula and your comment are displayed. Use the N function to insert your comments at the end of the formulas.