It’s 2017: Learn New Ways To Get Organized In Your Job Search

Start off the new year by getting your job search organized! This workshop will show you how to create a job application journal in Google Docs, keep track of your interview appointments in Google Calendar, spice up your online presence, and create a more modern resume in Microsoft Word.

Organizing Outlook Email

Organizing Outlook Email

You will learn:
Organizing Email
Finding Messages
Email Tips in Outlook

Covers Microsoft Outlook 2010, 2013, 2016. The demo will be with Outlook 2013.

Content Level: Beginner

Windows 10 and Office 2016



I spent the last weekend setting up a new computer. I finally decided to ditch my 5-year old laptop and get a new machine. I ended up with an All-in-One computer, since I don’t need to really move around my laptop anymore because I do my mobile computing on my iPhone.

Along with my machine came Windows 10. I waited until now to give it a try. My rule of thumb is that, when it comes to Windows and Office versions, wait a year before I start using them. The rule came in handy as Windows 10 just received the “Anniversary” update and so I was able to update to that version without jeopardizing breaking any existing settings. So far, I really like it. I do think it’s better than Windows 8.1, but there is a lot new to learn. I hope to write about it more. One thing I no longer need is to find a replacement for the Start menu. That’s what I did when I upgraded to Windows 8.1, but as of now, I really like the new menu.

I also upgraded to Office 2016 (not 365). I took a quick look to see what’s new. Aside from a slightly-new interface, I don’t see anything significant. You may want to check out what’s new in 2016 before you think about purchasing the new version.

Let the fun begin!

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.


Math AutoCorrect symbols in Microsoft Word


If you are a math teacher, you know the pain of entering math symbols in Microsoft Word. There is an easy way to enter hundreds of math symbols by enabling Word’s AutoCorrect feature. Here are the steps:

  1. Go to File menu.
  2. Go to Options.
  3. Click on Proofing.
  4. You see the AutoCorrect Options button. Click it.
  5. Then check the option “Use Math AutoCorrect rules outside of math regions to enable these shortcuts everywhere.”
  6. If you have the “Replace text as you type” option enabled, you will be able to now use any of the shortcuts built-in to insert mathematical symbols as you type in Word.

For example, to insert an angel symbol angle, you will type in


and you will see the symbol on your screen.This is faster than finding the symbol on the internet and using the good ol’ copy and paste or using the ALT codes.

Additionally, you can add your own symbol if you don’t see the one you needs. You just type in some text in the Replace box and a symbol in the With field.

2 Free Microsoft Office Add-ins to Boost Your Productivity


As a teacher, I use Microsoft Office applications for various purposes. If I can use shortcuts to save me a few seconds here and there, they add up. Microsoft add-ins are a great way to save time.

The add-ins plugs into Office and provide additional features not found in the default installation. You usually access them via the added Ribbon tab. There are two add-ins I use on a regular basis.

One is the popular ASAP Utilties. It adds over 300 features and shortcuts.  For example, one function coverts unrecognized numbers (?text) to actual numbers.

This add-in is free for home and student users and works with Excel 2000 (!) and above.

The second add-in is the Office Tabs. This adds tabbed editing and browsing of the open documents (workbooks and presentations). One downside to Office 2013 is that it does not supported tabbed view. That means when you open multiple workbooks in Excel, for example, they each show up in a different taskbar button at the bottom of the screen. Windows sometimes consolidates all the buttons as one button so you have to manually hover over the consolidated button and find the workbook you need to switch over. Install this add-in and managing multiple open workbooks because a breeze. Other features include saving all open files with one click, renaming files, and closing documents. Take a look at the web site for more features.


Collect Text From Multiple Points in Microsoft Word with Spike


Microsoft Word is perhaps the most used office application. However, many people use about 10% of its features. It is probably not glamorous to talk about hacking Word, but it is a powerful editor. One shortcoming with Windows is that its built-in clipboard only retain the most recent copy/paste data. When editing a document though, there are many times you wish to collect a bunch of texts and paste all somewhere else. That’s where Spike comes in (only available on 2010 or earlier versions). Follow the steps below.

  1. Highlight the text you want to copy and press CTRL-F3. The information is in the Spike.
  2. Continue with CTRL-F3 until you gathered all your text.
  3. To paste the collected text into a new location or another document, press CTRL-SHIFT-F3. The Spike will now be empty.

The bad news is this features seems to be removed from Word 2013 but plenty of people still use Word 2010, so I hope this tip helps.

Microsoft Office Just Got A Little More Productive


I am a fan of Google Drive. I find it useful for many occasions when I teach. Google recently introduced the Google Drive plug-in for Microsoft Office that integrates GDrive with Word, Excel, and PowerPoint (2007 or above). I was able to save to GDrive with the help with Google Drive for Windows, but not with the plug-in, I am able to save directly to GDrive. It would be handy if I only want to save a file to GDrive but do not need a local copy.

Also, if you are a user of Office 365, IFTTT launched the Office 365 Channels. For example, this Recipe sends an email when you receive a refund in Square. I find that IFTTT takes a little getting used to, but once you figure it out, there are many automated tasks you can let it handle. Great news for a lazy (err, efficient) worker like me.