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?” 

PowerPoint tip for navigating graphics

by Carol Marion, Senior Media Designer

You just created a fantastic graphic illustrating the new workflow or process on a PowerPoint slide. Your client will love it! The presentation is tomorrow and you need to make updates. But now it’s hard to select parts of the graphic. Too many shapes in the way. 

PowerPoint has an easy way to see and select any object on a slide. Select any shape and go to the Drawing Tools Format ribbon. In the Arrange group, click on Selection Pane. In the pane, every text box and object is listed. Click on each object to select it. You can drag them up or down in the stacking order, or click the eye icon to hide the object while you work on another. You can even double-click on a listing to rename the object for easier identification. 

Now, go wow that client!

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.

 

http://money.cnn.com/2018/06/13/technology/microsoft-office-365-changes/index.html

 

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.

 

https://www.youtube.com/watch?v=Jp4GT_8WAVM

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:

Tips

  • 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:

https://ggia.berkeley.edu/practice/gratitude_journal#

https://www.huffingtonpost.com/lauren-jessen/gratitude-journal_b_7745854.html

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