Office 365 Tools for Lawyers and Legal Professionals

Broadening the base of potential Office 365/SharePoint Online users is the Legal Matters Center for Office 365. I attended an early session on this at the Ignite conference in Chicago.

Resources can be found at:

How do I protect my Social Media accounts?

Strong Passwords and Two Factor Authentication on Social Media

This brief post is in response to a Facebook conversation I saw regarding local community leaders and public figures having problems with attempts to access their social media accounts.

I’d like to recommend two steps:

  1. Use strong passwords
  2. Switch on two factor authentication

Strong Passwords

Go to https://www.grc.com/ppp.HTM which is Steve Gibson’s Perfect Paper Passwords. Make sure you set the length of the password/pass-code you need – default is 4 you should use 10-12 (or more).

This will give you three pages of passwords you can use for all your accounts. Cross them off the list as you use them. Use a different password for each account.

This avoids people inadvertently using patterns or reusing passwords. You must use a different password for each account, to protect yourself if a service provider has a security breach and hasn’t encrypted passwords. You don’t want one breach providing the keys to all your online services.

Two Factor Authentication

Two factor authentication involves adding a factor when logging on to a service as well as your password. This can be a code via text message that is only good for a few minutes, a fingerprint or retina scan. At the current time the text message to your mobile is the most common approach.You then enter the code you have been sent. The code expires after a few minutes – so it is a one time code good for one use only.

For those of you with a historical leanings, one time codes date back to World War Two where flammable one time pads were used to co-ordinate forward air support.

To enable two factor authentication in your social media services look for settings option in your social media service. Then look for security settings. You are looking for the option where you are sent a code on your mobile phone when logging on (or in some cases where logging on a device other than your main device). It could be listed as login verification or authentication. You will then be taken through a test process that will text you a code and validate it.

Google+, LinkedIn, Twitter and Facebook all have options for two factor authentication. Your service may also have options to let you know about log in attempts from unknown devices.

Still Concerned

If you are feeling insecure check here https://haveibeenpwned.com/ to see if your accounts may have been exposed in data breaches – use your email addresses you use with online accounts.

 

Business Metrics for Data-Driven Companies

Successfully completed “Business Metrics for Data-Driven Companies” by Duke University on Coursera. First step in a five step process. The main purpose was to get an understanding of data analysis and what Data Analysts do, because I get many of them on my Advanced Excel and Excel Power Pivot courses.

I am glad I did it, learned a lot that I can use in my own business. I’d recommend it!

Why is PowerPivot not in all Versions of Excel?

Not all versions of Excel are created equal. For Excel 2013 and Excel 2016, many common versions of the the Office suite do not support PowerPivot. The linked article clearly outlines the situation for Excel 2016 (thank you to PowerPivotPro and Rob Collie).

In my view this is a pointless attempt at supporting the deluxe versions of the Office suite. It is going to cause confusion when preparing for Excel PowerPivot courses, and also for small business users who may have Office 365 Business Premium via an Office 365 subscription.

PowerPivot is not just for big corporate users. I can see small and medium businesses who want to be competitive and responsive in the current economic climate finding these tools essential. It is also going to be a key addition to the range of courses I offer!

Like me they will end up either buying a stand alone Excel licence or (in Australia) navigating the Telstra/Microsoft labyrinth to see if they can upgrade a of subscription or two to the required level. I will probably have to get standalone licences as there appears from exploring Telstra’s online interface that there is no option to upgrade further on my current Office 365 level. As a very small business I also don’t enjoy buying additional licences that duplicate something I already pay for.

A frustrating and expensive situation that will impact on the take up of a very useful tool.

Your thoughts and comments welcomed

Steven

PowerPivot Reference Card

This card is an excellent reference for PowerPivot users. Its also free and available Giving Back: “Steal” this Reference Card!

The host web site http://www.powerpivotpro.com/ is also worth bookmarking!

 

Boagworld on Intranets

Boagworld Podcast  features Gerry McGovern in this weeks podcast. While its not about SharePoint – covering Intranet effectiveness, end user adoption and getting management buy in/support are very effectively addressed. People involved in SharePoint sites and roll-outs would benefit from listening to this. You will find Podcast and transcript here.

I picked up a couple of good ideas – include starting with solving a management problem e.g. streamlining an approval process to get manager buy in.

400 YouTube subscribers!

WooHoo!!!!

Just reached 400 Subscribers on my YouTube Channel!!

Thank you all for your support.

More content coming next week.

Steven

Business Metrics for Data-Driven Companies

Signed up for “Business Metrics for Data-Driven Companies” the first course of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization. Enjoyed the Microsoft edX course I did recently, so I thought I’d do more.

Thought it was a fit and should help with the questions I get from Business Analysts on Excel and SharePoint Courses.

Microsoft: DAT206x Excel for Data Analysis and Visualization

Successfully completed (97%) the edX course: Microsoft: DAT206x Excel for Data Analysis and Visualization!

Learned a lot and filled in some gaps in my knowledge especially with Power Query and Power BI. I’d recommend it, keep an eye out for it! Looking forward to my certificate.

Now I am keen to learn more – looking at Excel to MySQL: Analytic Techniques for Business Specialization which is a series of courses and a project. Have to get enrolled by Nov 9 for the first course.

 

Ben Wellington: How we found the worst place to park in New York City — using big data

This is an excellent Ted talk about open data, gives practical examples and raises the need for consistent standards for data provided by Government.

There is a follow on discussion needed here about government making data public and in a form where the public can explore it and draw their own conclusions and effectively debate and discuss government plans and proposals.

If you follow this talk back to Ted, you will find a whole set of Data related talks, I recommend the one by Amy Webb.

 

Add data to you Power Pivot using Power Query in 25 minutes

Lesson Two

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.

This process is useful if you need to periodically add new data e.g. monthly.

Give me 28 minutes to introduce you to Power Pivot

Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot

Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates

Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint