Intellezy’s Pay-Per-Use Model

Intellezy’s pay-per-use model is revolutionizing the way people access training. All of our 5000+ short-segment videos are available to you for only 10-cents a minute, with absolutely no strings attached. No minimum requirements, no subscriptions. Worried that you or others in your organization might go over budget? Set your desired monthly cap and we’ll make sure you never go over.

This competitive pricing doesn’t just include our videos. You also get access to exercise files, practice exams, bookmarking, notetaking, reporting, real time tracking of users, administrative capabilities, and more.

Yes, there is a bunch of free content out there. We know that. But your time is valuable. Why waste it wading through countless subpar videos when you know you can trust the high-quality training found in our studio-produced videos of industry professionals? And for only 10 cents a minute, you can keep within your budget.

Try our pay-per-use model today at www.intellezy.com. Or request free grouop trial access at https://www.intellezy.com/subscriptions/request_free_pilot.

 

Meet the Instructor: Heather Walsh

Favorite Application and Why:  Excel. Hands down. Maybe it’s because I am an English major and I want to exercise the logical part of my brain? Not sure. But I pride myself on the trove of Excel keyboard functions I have memorized, which allows me to really zoom around a spreadsheet.  

Favorite Excel Function:  Vlookup! It’s the best. I love it so much that I used to show it to classes at lunch break as a treat even if it wasn’t covered in the course.   

Favorite Keyboard Shortcut:  Ctrl + Z for undo. I use it all the time in my videos. If only there was a Ctrl + Z for life! 

Favorite Movie:  Godfather I and II are tied for first.   

Favorite Book:  Pride and Prejudice 

Favorite Restaurant:  Pepe’s pizza in New Haven. I grew up nearby and was lucky to have it many times! 

Which historical figure would you most want to meet and why:  Abraham Lincoln. I’d love to hear what the thinks of our modern world and current political landscape. 

Tell us something interesting about yourself:  I played rugby in college. I was a winger!  

Click here to see courses taught by Heather 

 

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

 

Why is This in My Inbox Again?

I don’t know if you’re like me, but I usually leave messages in my Inbox until I’ve resolved them.  This leads to an Inbox with several, ok dozens (sometimes hundreds), of read messages.  My favorite aerobic activity for many years was opening and losing messages I’d already read to remind myself why the message was still sitting in my Inbox!

When follow up flags were first introduced in Outlook, I thought this would solve my problem. While having a little red flag next to a message told me I needed to take action, it didn’t tell me what action needed to be taken.  So, there I was still opening and closing messages all day.  I got fed up with this counterproductive behavior several years ago and decided there HAD to be a better way, and BINGO, there was.

My solution does involve follow up flags, but it also involves customizing the fields in my Inbox.  Here’s what it looks like now:

In Outlook, you can customize the text for your follow up flags AND you can add a field to your Inbox headers allowing you to see that custom text!  Here’s how you do it:

Adding Customized Follow Up Flags

First, let’s start by learning how to add your own custom text to the follow up flags.

  1. Right click on the message to flag.
  2. Select Follow up, Custom…
  3. In the Flag to field, enter the custom text for the flag: 
  4. Adjust any other flag settings you like, and then click OK.

Adding the Follow Up Flag Field Header

Now, let’s see how we add the field that will make our custom follow up flag text visible.

  1. Right click on any field header at the top of your Inbox
  2. Select Field Chooser, and from the list that opens, find the Follow Up Flag label.                                                                                                              
  3. Drag the label from the dialog box up onto your Inbox header and drop it where you want it to appear.
  4. Click the red X in the corner of the list box to close it.
  5. If the area for the Follow Up Flag text is too narrow, simply place your mouse on the left or right edges of the label in the header and drag to widen.

You’re all set!  No more needlessly opening and closing messages to determine why they are still in your Inbox.  Hope you found this helpful.  Learn more tips like these in our amazing array of micro lesson videos too!