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 

 

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