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.

Office for Android Tablets – Preview

This is a key step by Microsoft, preview versions of the big three from the Office suite are available for Android Tablets. Not final versions, but worth exploring. So far I have installed them on my old Nexus 7 (with KitKat). I’ve done a few basic tasks in Word, but haven’t checked them out in full (report next week)

If you want to try them out use the links below to get to the Google Play Store

When you get to the Google play store search also for  OneDrive and OneNote (There is even OneNote for Android Wear!)

If you are on any other device you are already catered for MS Office for most devices

So why is this a big deal?

As Office 365 and SharePoint online start to get some traction, users will want to work with content in the field. Android tablets are a cost effective way for business to provide a handy, but functional tool. While there are third party apps for working with Office files, I found this a mixed success and the lack of these apps is what lead me to moving to a windows tablet (and the cost of basic windows tablets becoming competitive).

So when the final apps are released, companies can give staff a good android tablet and use Office 365 (and bank the money they saved vs buying i-Pads).

Steven

Excel Charts – Small and Large values on the same axis

This is a question that came up recently. My first thought was add a secondary axis, but in this case the small and large values were in the same series. I thought there might be something available as a third party add-in for Excel.

Solutions to Try

I did find an answer by Jon Peltier which looks good and gives step by step detail, but also appears to be a lot of work. This article provides links to alternative approaches at tushar-mehta.com and andypope.info – which has a zipped example to look at. If you are seriously  into graphs you should visit Jon Peltier’s blog. Continue reading “Excel Charts – Small and Large values on the same axis”