How To Move from Evernote to OneNote

image

Image from https://www.onenote.com/import-evernote-to-onenote

I have used OneNote for a long time.  However, because it was easier to link in Evernote, I kept some important stuff in Evernote since I could access it from my iPad or from my Samsung phone. 

Microsoft has been making it very easy for us to switch everything to OneNote because OneNote is now so accessible from any device.  I wanted to see how easy.

Using the Microsoft OneNote Import Tool

I downloaded the importer, and I let it chug.

It immediately found my Evernote – but just the one. I have two Evernote accounts so I thought it might find both of them.

image

Image from import tool

As I continued, I received the message below telling me how the content will be organized.

image

Image from import tool – Evernote to OneNote

The import to OneNote happens quite quickly.

image

Image from the import tool – how the content from Evernote is moving.

When the import was complete, I did get the SUCCESS message below.  (I love this!)

image

Image from the import saying that I am successful

However, it actually took about twenty minutes for all my notes to import. 

I downloaded the Android App for OneNote while I was doing the move between Evernote and OneNote.  I was surprised that all of the notebooks were up on my phone before they were fully imported according to my desktop.  It did put each of my folders into different notebooks which is a bit confusing at first. 

If you switch to OneNote from Evernote, let me know how it goes for you.

Cheers!

Microsoft offers free Windows Server 2016 licenses to VMware switchers

image

The title above is also the HEADLINE for Mary Jo Foley’s blog of August 25 … you can see her blog here http://www.zdnet.com/article/microsoft-offers-free-windows-server-2016-licenses-to-vmware-switchers/?ftag=TRE624278d&bhid=24421659496900511552450458228080

This is great news for Microsoft Partners and clients that wish to set up data centers.  Here is the feature differentiation comparison from the article.

Check it out to see if this will make a difference to your organization.

winserver2016datacenterstandard.jpg

You Can Use Power BI To Analyze the Top Movies from IMDb And Other Lessons

image

Graphic from https://www.youtube.com/watch?v=ByIUx-HmQbw&list=PL1N57mwBHtN2q1WbU5O29rrn_A0lkVv9p&index=3

 

I think learning should be fun! And, for me, Microsoft made a lesson on learning how to do queries in Microsoft Power BI a lot of fun by using the query on the IMDB database.  I love movies and I use the IMDb database often so I enjoyed the way the lesson categorizes movies.

Want to learn how to start using the Power BI tool?  Well, you can either start by going to the Learn page at the Power BI website at https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-0-0-what-is-power-bi/

Or, you you can go directly to the Power BI Desktop videos, and watch the short movies that also appear on YouTube.  The IMDb example is at https://www.youtube.com/watch?v=ByIUx-HmQbw.

For folks that work with Dynamics GP 2016, these short learning sequences are a great way to discover the ease of creating Power BI reports from a data source.

Enjoy!

Microsoft Power BI Updates in July 2016

 

image

Graphic from https://powerbi.microsoft.com

 

Microsoft announced the following updates for Power BI for July.  The announcement comes from Filip Karadzic,  Senior Program Manager, from the blog announcements page at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary/.

REPORT VIEW:
  • Predefined table styles
  • ShapeMap can use custom maps
DATA CONNECTIVITY:
  • New Data Connectors:
    • Amazon Redshift (Import + DirectQuery) (Preview)
    • Impala (Import) (Preview)
  • Improvements to existing data connectors:
    • Support for specifying a Command Timeout via the UX
    • CSV/Text – Support for Fixed-Width delimited files
    • SAP BW connector improvements:
QUERY EDITING IMPROVEMENTS:
  • Ability to use R scripts in Query Editor
  • Query Parameters – List Query output as “allowed values” for a parameter
  • Ability to overwrite existing user-defined functions

What is Microsoft’s Power BI and How Does It Work?

image

Graphics from https://powerbi.microsoft.com/en-us/

 

What is Microsoft Power BI

“What is Power BI?”   Microsoft defines it as

“Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.

Where Can I Get More Information on Microsoft Power BI?

Microsoft has created a web site for Power BI at https://powerbi.microsoft.com/.  You can find out everything you need to know about the product at this site.

You can also stay updated with all the new features by checking the Microsoft Power BI Blog at https://powerbi.microsoft.com/en-us/blog/.

 

Why Do I Need To Know About Power BI?

Power BI integration to Dynamics GP is a new feature in Dynamics GP 2016.  The big question that all GP users have is about the benefit of Power BI.  The benefit is that users can now connect data to the HOME page, and produce reports and dashboards similar to the way reports and dashboards can be built in SSRS reports.

 

Prerequisites for GP Users To Use Power BI

– You have access to Power BI and at least one report is available.

– You are able to log in to the Power BI site and view a report.

– You are creating your own Power BI reports\charts.

– You are using the GP 2016 desktop client.

Here Is A List of Helpful Excel HOW TO Articles

image Graphic from news.techgenie.com 

I love it when people take the time to write up step-by-step HOW TO articles or blogs.  And, I like Excel HOW TO articles because it is an easy way to give a tutorial to a client when I need them to create/fix/organize data for loading into an ERP system. 

Recently, I have found quite a few key Excel HOW TO procedures.  As I like to keep things where I can easily find them, I am putting them on my blog so that others have the list, too.

Here we go.

1. Copy a formula in Excel    http://www.wikihow.com/Copy-Formulas-in-Excel

2. Excel Data Validation for Dates  (This is awesome!) http://www.contextures.com/exceldatavalidationdates.html#download

3. How to find duplicates in Excel and numbers (uses conditionals and COUNTIF)  http://www.makeuseof.com/tag/find-duplicates-excel-numbers/

4. All about Pivot Tables http://www.excel-easy.com/data-analysis/pivot-tables.html or at https://fiveminutelessons.com/learn-microsoft-excel/how-create-pivot-table-excel

5. Eleven advanced Excel tricks – Vlookup, Index match,  3D Sum, $ sign, Ampersand symbol, arrays, goal seek, pivot tables, http://www.businessinsider.com/excel-tricks-vlookup-index-match-pivot-tables-array-2013-5#-1

6. How to split data from one column to two http://smallbusiness.chron.com/split-excel-data-two-columns-54661.html or https://www.ablebits.com/office-addins-blog/2014/02/27/split-cells-excel/

7. Link data in two workbooks https://www.youtube.com/watch?v=-foPogO3QNE

8. General Excel training from Microsoft https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-US&ad=US