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!

 

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

 

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 Pivot Tables and Conditional Formatting

My Excel Pivot Tables series from my YouTube Channel – are now gathered together in a convenient Playlist.

In Transition

Folks

My apologies for the lack of recent posts

I am currently in the process of transitioning back to being a fully freelance contract trainer, studying for my Certificate IV TAE and a SharePoint exam.  And I have been doing a few custom courses recently.

All of which doesn’t leave a lot of time for blog posts!

I have some posts planned including:

  • How to tell what version of SharePoint you have
  • Some video posts on  Pivot Tables and SharePoint/Office 365

Regards

Steven

Sunday Night Music – Pivot tables – the Musical!

Pivot Tables Make Everything Just Right

A class project featured on YouTube and Blogs.Office.Com singing the praises of Pivot Tables

Just watch and enjoy, or go through to YouTube -where you can expand the info section to see the words and sing along..

Too Many Different Cell Formats Error – Excel 2007/Excel 2010

This error can arise when you go to paste data at the end of a list or in a large spreadsheet where some of the following conditions apply:

SharePoint End User Assorted Questions

Sharing an accumulation of answers and resources covering recent questions I have been asked.

Which SharePoint books have you read and found useful?

I have both of the books below on my bookshelf at Safari Books Online. I have downloaded many chapters as pdf to my e-book reader.

SharePoint® 2010 How-To

  • By: Ishai Sagi
  • Publisher: Sams
  • Pub. Date: August 15, 2010
  • Print ISBN-10: 0-672-33335-X
  • Print ISBN-13: 978-0-672-33335-4
  • Web ISBN-10: 0-13-248748-9
  • Web ISBN-13: 978-0-13-248748-1
  • Pages in Print Edition: 400

Microsoft® SharePoint® 2010 Plain & Simple

  • By: Johnathan Lightfoot; Chris Beckett
  • Publisher: Microsoft Press
  • Pub. Date: November 1, 2010
  • Print ISBN-13: 978-0-7356-4228-7
  • Pages in Print Edition: 256

Continue reading “SharePoint End User Assorted Questions”