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!
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.
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.
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.
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.
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
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
- MS Word for Android Tablet Preview
- MS Excel for Android Tablet Preview
- MS PowerPoint for Android Tablet Preview
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).
My Excel Pivot Tables series from my YouTube Channel – are now gathered together in a convenient Playlist.
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
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..
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