Office 365 Bookings App – Lesson Two

Give me twelve minutes and we will explore Office 365 Bookings from the client perspective. See the emails the process generates. Continue reading “Office 365 Bookings App – Lesson Two”

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

 

Sharing Information vs Knowledge is Power

Watching the Ted Talk: “Stanley McChrystal: The military case for sharing knowledge” started me thinking about the issues he discusses for the perspective of SharePoint trainer, a trainer and an ex public servant.

A major of theme of this talk is that “the organisation will benefit from ready access to information“.  The burned out leftie in me would extend this to “Society will benefit from ready access to information“. But for the moment lets think organisation.

One of the major potential advantages of SharePoint is to allow exchange of information across silos. For this to happen, site owners and admins need to think about permissions in terms of the organisation not just the unit or  silo they are in. If read access to content is based on the silo and reflect management structure not need or community of interest, then no benefits are gained from collaboration. Wheels are reinvented, mistakes are repeated, solutions and troubleshooting tips are not exchanged.

There are a lot of business cultural assumptions to overcome in sharing. I often get comments that as a trainer I am “giving away all my secrets” or that my YouTube channel is “giving it away for free”. In the modern world however, my secrets are not just mine. Microsoft and Adobe and third parties invest a great deal of effort in distributing information about how to use their products in every medium possible. So my “secrets” can be easily found.  This sharing by these firms makes “Knowledge is Power” obsolete and has a business benefit -Support has a cost – so organisations will use software and other tools with support resources widely available.

I can concentrate on massaging this information to give you context and value but secret it is not. Sharing what I learn also has other values for my little business.

There are other issues raised by this talk, this is just one angle.

 

Matthew Carter: My life in typefaces

If I had the time I’d be a font geek. One of the Create Cloud features I enjoy most is the access to fonts.

Well, maybe I am a font geek after all. I enjoyed this talk by the man who designed Verdana.

In this Ted Talk, Michael Carter talks about the design of fonts to both achieve a purpose and address the limits of the available technology (eg for phone books or early PC screens).

Train-A-Scope YouTube Channel Theme for 2014

Welcome

I am Steven Knight and my business is computer training.

I train in SharePoint, Acrobat, Captivate and Office for leading training providers around Australia

This year I am following a theme for most of my YouTube channel content.

That theme is forms.

Why Forms?

End users are increasing looking for tools to enable them to

  • Collect data from internal or external clients efficiently
  • Export that data to Excel
  • That requires no coding
  • And are Low or no cost

I will still have content on other topics with forms being the ongoing theme. Continue reading “Train-A-Scope YouTube Channel Theme for 2014”

As work gets more complex, 6 rules to simplify

Having spent much of my working life working in or for large organisations, and having seen informal processes develop to get around blockages and conflict and the curse of the “silo”, I post this TED talk. I think the theory is good, but I can see large organisations having massive cultural barriers preventing it.