–

Generating Sentences

–

This video tutorial teaches you how to generate sentences using drop down lists and excel functions.

–

–

–

Next: Advanced Excel Tutorial

–

–

This Post Has 7 Comments

  1. Amy Joynt July 8, 2015 Reply

    Thanks for these videos… I’m having a difficult time in particular with the drop down list as I am using Microsoft Office 2011 which doesn’t seem as user friendly. Any suggestions?

    1. timothymcivor July 14, 2015 Reply

      Thanks Amy,
      Just to clarify, are you using a Mac or PC? Microsoft Word for Mac works differently, but if that’s the case I can help you through it.

      1. Amy Joynt July 25, 2015 Reply

        Mac

        1. timothymcivor July 31, 2015 Reply

          This video should be able to help you out: https://www.youtube.com/watch?v=quZ-GJOlmcc

          A little side note: I used to use my Mac for everything, but I noticed that Microsoft Word for Mac has more glitches and bugs compared to Microsoft Word for PC. That’s one of the main reasons I chose to do all these tutorial videos on a PC.

          1. Amy Joynt August 3, 2015

            Arg, that’s all I have for now. I agree though excel in Mac is not as good. Thanks, I’ll check out the video today.

  2. Lisa September 28, 2015 Reply

    Our district is pushing Google Docs and Google Sheets. Do you have a tutorial for these?! I would imagine there would be similar capabilities but function keys/shortcuts would be different. Any help with google would be fabulous!

    1. timothymcivor September 29, 2015 Reply

      Hi Lisa,
      That’s great that you’re using Google Docs and Google Sheets. I use it at my schools too, mostly for RTI purposes. You are correct that the functions in Excel are the same as the ones in Google Sheets, so any functions that you learn on Excel can be applied to Google Sheets. However, it’s a bit more limited in some ways. For example, you can’t link from Google Sheets to Microsoft Word. There are plenty of Youtube tutorials already posted on the basics of Google Docs and Google Sheets, but if you have questions about Google Docs specific to school psychology, I’d be happy to answer them.

Leave a Reply