Exciting New Partnership Announcement for Intellezy & GO1

We are thrilled to announce we have teamed up with GO1 to help distribute Intellezy content globally. GO1 is an established leader in online learning and education, covering areas such as South Africa, Vietnam, Malaysia and The United Kingdom. Intellezy is an award-winning content provider delivering relevant content on Microsoft Office, Office 365, Adobe IT and Business Skills needs.

GO1 is your one-stop training solutions and eLearning resource. Giving the users the ability to curate content combined with choosing from an ongoing growing library of courses, GO1 has you covered.

Click here to learn more about how GO1 and Intellezy can benefit your organization!

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

Sorting Deleted Items by Date Deleted, Not Date Received

by Pam Conway, CLO and VP of Operations @ Intellezy

Recently, while working in my home office, my cat, Edgar, hopped up on my desk and promptly parked himself on my keyboard. Before I could dislodge him, his furry behind managed to delete a huge swath of messages in my Outlook Inbox. These weren’t all new messages, I quickly realized. Many were a few weeks old, left in my inbox as reminders to follow up. When I hurried over to my Deleted Items folder and remembered that it lists all messages in the order they were received, not the order in which they were deleted, I understood the magnitude of Edgar’s actions. I would need to recall the exact subject lines of each message deleted and then scroll through the deleted items folder in the hopes of finding them further back in the chronology. The problem? I couldn’t recall the specifics of a single message, only that I was missing at least a dozen or more.

What to do?! Well, luckily, I remembered my ability to customize the field headings in any folder and I was able to add a column that allowed me to sort the contents of my deleted items folder by when it was modified, which equated to the date it was deleted. Here’s how I did it:

1. In the deleted items folder, click the View tab and then click View Settings.

2. Next, click the Columns button.

3. Click the dropdown arrow for the Select available columns from list.

4. Select Date/Time fields.

5. Select Modified from the list and then click the Add button. The Modified column heading will be added to the list of column headings on the left. It will appear in the last position, which equates to the far right of the list of columns in the folder.

6. Use the Move Up button if you want the Modified column to appear in a different location.

7. Click OK in each of the two dialog boxes to return to the deleted items folder.

8. You will now see a Modified column header. Click the header to sort by this field. All recently deleted messages will now appear at the top of your deleted items!

The Ever-Changing Office 365 Suite

If you’ve ever used Office 365, you know that it changes quite frequently. One day you might log in and see that instead of going to the app launcher and clicking on Calendar to see you appointments for that day, suddenly it’s gone! Instead you have to go to Outlook now to get the calendar. 


And now more changes are coming. This article below from CNN details some of these forthcoming changes, such as an improved Outlook search function or changes to the Ribbon.




At Intellezy, we strive to keep our videos as up-to-date as possible on Office 365. We update our videos at a minimum every 6 months, and sooner than that if a big change rolls out.


Here’s an example of a new video we added to reflect a change in 365. OneNote Online added a feature called immersive reader, which allows you to have your text read aloud to you.



Learn Microsoft Azure at Intellezy

Microsoft Azure is one of the hottest technologies out there. If you haven’t heard of it yet, chances are you probably will soon. It’s a set of cloud services that Microsoft created for doing everything you need to do to work in the cloud: build, test, deploy, and manage applications and services.  

Intellezy has nine great Azure courses. And we are constantly updatint them to make sure you can keep up with the constantly changing 365 environment. Here’s a video from Azure Containers, of one of our new Azure courses: 

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


Using OneNote as a Gratitude Journal

“Enjoy the little things, for one day you may look back and realize they were the big things.” ―  Robert Brault

Gratitude journals are a wonderful exercise to help appreciate our lives.  Studies have shown that using a gratitude journal can decrease stress, allow focus on what is important, and gain new insight into what things are important to us.  An electronic alterative to pen and paper is Microsoft OneNote.

Why OneNote?

Pen and paper is a tried and true form of journaling.  OneNote gives you the advantage to have it on your desktop and on your mobile devices.  If you are like me and suffer from nomophobia (fear of being without my mobile phone, yikes!), you always have your mobile phone nearby.  This gives you the opportunity to add to your journal whenever you like.  Most importantly, your little brother/sister can’t sneak and read it (I’m looking at you John)!  Bonus, if you suffer from DHWS (doctor handwriting syndrome), OneNote gives you the advantage of clear notes. (My apologies to my first-grade teacher for my horrific hand writing).

See below for instructions on how to create your own gratitude journal using OneNote on a mobile phone.

Create the Notebook

I suggest creating a new notebook for each year.  This will help keep the year’s entries organized and easy to find.  This will also allow you to find older entries.

Create Sections for Each Month

Next, we can create sections inside of our new notebook, one for each month.

Create an Entry

Now it’s time to create an entry!  See the below for a sample:

Sample Entry:


  • Create a blank template of your entry. This can be copied to your Month section.
  • Tailor the entry to you; make it your own.
  • Don’t sweat if you don’t have three entries. One may be the loneliest number, but it is also an acceptable number to appreciate.
  • Don’t limit to three if you have more. Log all the wonderful things that you have experienced today!
  • Read old entries to remember all the good in your life. Use this as a reminder to reach out to people who were a part of your day.
  • Use your notes from the previous “What would have made today better?” to make today a better day.
  • Log the good things as they happen. This helps you appreciate those moments later.

Additional Resources:



Want to learn more about OneNote? Watch this video on adding sections and pages. Or visit us at Intellezy.com for thousands of short-segment videos like this.

By Jason Delph

DIY eBay Reports with Power BI

Attention eBay sellers! It doesn’t matter if you sell a few items here and there (like me), or if you are an ultra-super power seller with that awesome shooting star icon!  Power BI offers excellent options for report building and data analysis for sellers of all sizes.  If you are like me, you may do some basic bookkeeping with Excel, just to keep track of what you are selling. I don’t spend a whole lot of time on it, but rather I just want to see some numbers.  Needless to say, I am not accountant and my spreadsheets aren’t going to win any beauty contests.

After A Power BI Make-Over…

After importing my Excel data into Power BI, I was able to bring those numbers to life:

Power BI really helps visualize those boring spreadsheet numbers.  It allows you take apart your tables and view and analyze different areas of your sales.  I took it a step further and used CData’s ODBC Driver for eBay to connect to eBay as an ODBC data source.  This allows you to pull in real time data from eBay’s database about your account. Setting this up is a bit more complicated than simply extracting data from a spreadsheet, but it offers an in depth view of your eBay sales and listing trends.

Power BI is not limited to just eBay. It has incredible utility for any online seller, small business owner, or anyone who has a need to generate reports or analyze data.

If you are interested in the CData ODBC Driver for eBay, check it out here.

To learn even more about Power BI 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.   

By Ryan Scramlin


Co-Authoring: The Coolest Feature You’ve Never Heard Of 

Co-Authoring: The Coolest Feature You’ve Never Heard Of  

When you hear co-authoring, you might think of two people writing a novel together. Maybe a ghost writer with actual skills propping up a sub-par celebrity.  

When we talk about co-authoring in Office 365, what we mean is two or more people working on a Word document, Excel Spreadsheet, or PowerPoint presentation at the same time using the online version of the office app in Office 365. While they might be working on the next Great American Novel, more likely it’s going to be a budget, a report, or a marketing presentation.  

But why should you care about co-authoring? What’s the big deal about two people working on something at the same time? Is it really the best feature you’ve never heard of?  

To clarify, it’s not as if two people are working in their own little bubble on the document with no idea of what the other is doing. You don’t just independently do all of your work and then eventually see the other person’s changes and think, “well shoot if I knew Ellen was going to add that, I wouldn’t have wasted my time writing something so similar.”  

Instead,  you see changes happening in real time. In this screenshot below, you get a good idea of how changes appear as they happen. Once the document owner shares the document, you can all begin working on it together.   


You’ll see different colored flags for each person who is in the document and see those changes appear as that person types. That’s pretty amazing, if you think about it. You can have multiple people in different locations all collaborating at the same time and riffing off what the other is doing. See? The coolest feature you’ve never heard of.  

Now in order to co-author, the Word, Excel, PowerPoint, or OneNote file must be stored on SharePoint or OneDrive. This makes sense if you think about it. It would be too hard to sync changes if it were a file stored on your hard drive, but when a file is on SharePoint or OneDrive, it’s stored in the cloud. (See last week’s blog post for more on OneDrive.) That means everyone has to be connected to the Internet to use real-time coauthoring. And only docx., pptx., xlsx., or .one formats are supported, so don’t try to co-author your crusty old 2003 .doc file. It won’t work. For older Office files, just do a quick File: Save As and convert them to a newer format, and you’re good to go.  

Oh snap. Did your collaborator just mess something up big time in your document? No worries—you can use the fabulous feature called version history to revert back to a previous version. Just right-click on the file in OneDrive or SharePoint and choose Version history. Don’t you wish you had that in all aspects of your life? (I’ve always said I wish you could use my favorite shortcut Ctrl + Z, aka Undo, in real life.)  

So the next time you need to work with others on a file, and you have an Office 365 subscription, fire up your browser and give co-authoring a go. And maybe after you all finish those final pesky edits on the Quarterly Update slide deck, you can try your collective hand at the next Great Gatsby. Happy editing!  

To learn even more about co-authoring 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.   

By Heather Walsh 


Setting Out of Office in Office 365’s Outlook Web App

Going on vacation but forgot to set your Out of Office message before you left?

No worries. You can do it from any device with an Internet connection using the Outlook Web App in Office 365. Simply log in to Office 365 and click the gear icon in the upper-right corner. Type in Automatic and you’ll see Automatic Replies appear at the top of the list. Click on it.

Choose the “Send automatic replies” option and type your message. You have some other cool options there that you can select, like choosing the exact time to begin and end your automatic reply or declining meetings automatically during this period. Click OK at the top when finished.

That’s it! Enjoy your vacation.

Office 365 OneDrive: Can You Really Ditch Your Hard Drive 

You might have heard of OneDrive. Maybe your company has migrated to Office 365, and you can see that OneDrive is represented in one of those little tiles in the upper-left that you haven’t clicked on yet. If you haven’t, one thing you’ve probably heard of, because it’s so hard to avoid these days, is “the cloud.”   

How do they relate?  Well, OneDrive is Microsoft’s way to offer you storage in the cloud. This means that your documents and files are NOT stored on your local hard drive. Instead they are stored on Microsoft’s computers and servers somewhere else—you won’t really know where and you don’t need to know where. All you need to know is that you can access these files from any computer with an Internet connection. Being able to access your files from just about anywhere is a pretty powerful feature. And OneDrive allows you to share documents, which can help you collaborate easily with others and even co-author documents at the same time. 

So if you put your files in OneDrive, does this mean you can actually ditch your hard drive?  

You might think this option won’t work for you because you aren’t online all the time, but Microsoft anticipated this and enabled a sync function allowing you to essentially download all these documents locally to multiple computers. You can work during the day on your office PC, then work offline on your personal laptop on the train ride home, synching changes back to OneDrive when you are online again, and you’re good to go.  

Another thing to consider is backups. By now, just about everyone knows someone with this familiar tale of woe: pictures lost forever, or the 20-page report gone. Even if your organization is backing up your files, you might be working on a report at home on your local hard drive and can lose all your hard work there. And, though we hear these stories and wince in commiseration, some of us still aren’t taking the proper steps to backup our files. Here’s how OneDrive can come in.  

OneDrive is going to be way more stable than counting on your PC, or possibly even your company’s backup system, depending on how robust it is. Remember those friends who lost their pictures and reports? Most likely it was due to hard drive failure, or maybe theft or a power surge. Now, that’s not to say that Microsoft’s servers aren’t susceptible to these types of issues, but guess what? They don’t have one measly hard drive to store your files. They have a complex system of hard drives and servers and datacenters and redundant datacenters to make sure they don’t have to come to you with egg on their face saying: whoops, sorry we lost all of your files.  

While OneDrive is great, the truth is you shouldn’t count on it alone. You also should have another backup of your files somewhere else. That might be on an external USB hard drive, or your organizations network drive if you have one, or it might be back to where we started: on your PC’s hard drive.   

You also might not want to put sensitive documents on OneDrive. Although files are not shared with others by default and you must choose to enable this sharing feature, the truth is your files are on Microsoft’s infrastructure where might you want to keep these tax returns or torrid love letters instead?  

That external USB hard drive and …. your PC’s hard drive. Yeah. So….  

The moral of the story is while you might not be able to completely ditch your PC’s hard drive, you can use OneDrive to move away from making it a primary location for your documents and use it more as a supplement to cloud-based storage.  

To learn even more about OneDrive 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.  

 By Heather Walsh