What Would Ed Do?

At Intellezy, we take pride in the solid Instructional Design of our content. It’s why we strive to work with some of the top trainers in the industry. We are a team of educators, and our focus is on creating quality short-segment videos that are going to help our students retain the information they learn.  

We recently received an email from a user describing how helpful an Excel course by Ed McCrae was, which is not unusual fan mail for us. However, what really got us excited was how the user stated their whole team is now asking themselves “What Would Ed Do?” when they are stumped in Excel.  The user’s team at this particular company made a connection with Ed as he was teaching because the learners could see his facial expressions, gestures, and voice because Ed never left the screen. He was with them throughout the whole duration of the course, just as a live instructor would be. Now, it begs the question would this have happened with a typical eLearning course with the screenshot and voiceover? Maybe… but I doubt it. Our brains are wired for face-to-face communication; the information flows better when you see the other person speaking because you see how they are conveying the information.  Video in general is booming, both in the marketing and education space, because our brains consume the information easier and faster than reading text. Additionally, our brains remember 95% of the information given in video compared to only 10% when the information is given in text.

As you know, there are thousands of eLearning courses to choose from, and we at Intellezy know your time is valuable. If you are in a corporate setting, we also know you have about 20 minutes of your work week to devote to training, so make it count. Choose training that will make a lasting impression and help you retain the information. Choose training that is up to date with your applications, and that provides projects and exercise files that mimic live situations. Choose Intellezy and soon you’ll be asking yourself, “What Would Ed Do?” 

Uncomplicate Your Nested IF Statements with the New IFS Function


If you’ve ever had to write a nested IF function in Excel, you know how complicated they can get. You might get to the end, nervously hit Enter, and see that the whole thing has failed because you forgot a few parentheses, or you missed a comma. Well, if you have Office 365 or Office 2019, you now have access to a ridiculously easy way to create nested IF statements. It’s called the IFS function. 

Excel doesn’t often debut new functions, but boy is this one a gamechanger. Just liked a nested IF, it tests if various conditions are true, and then returns a value accordingly. Here’s the syntax of the IFS function:

=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

You can test up to 127 conditions. That’s right, 127! But it’s always best practice not to have too many conditions, as it can be difficult to test and modify something that long. But hey, if you are so inclined, go for it.

The easiest way to learn how to use IFS function? Watch our video and see it in action:

You can find many more videos on the new features of Office 365 and Office 2019 at www.intellezy.com.

By Heather Walsh

Flash Fill Keyboard Shortcut

Flash Fill Keyboard Shortcut 

Flash Fill is one of the most popular new features in Excel 2013/2016. It will fill in cells for you automatically based on a pattern. So if you have first names in column A, and last names in column B, you can quickly fill column C with first and last names, or last names and then first names with a comma in between. Just supply the pattern for Excel, and it will do the rest. 

And there is a handy shortcut key for Flash Fill. Simply highlight the cells containing the pattern as well as the empty cells you would like filled, and then press Ctrl + E. It’s that easy! Excel will fill in the cells with Flash Fill. 

 To learn even more about Flash Fill and see it in action, click here: 

 You can find thousands more short-segment videos like this one at www.intellezy.com. Start your free trial today.