Microsoft have gathered a range of resources for Office 365 covering SharePoint, Office and Skype for Business as well as planning and end user adoption at http://fasttrack.office.com/. When you get there click about a bit, a lot of the “good stuff” is a couple of clicks down.
These resources are of use to you if you have recently moved to one of the many varieties of Office 365. I’ll be reviewing this in more detail myself next month as part of revamping my own SharePoint site.
Q. Can I total values in a table, e.g. one amount in a number field per row?
To cover a related question, this approach should work for check boxes in a table which gave been allocated values
Assuming you have a table with repeating rows in place
You then need to open the script editor panel via the Window menu.
Select the field that will act as the grand total – in my example, this is called Total.
In the Object panel set value to Calculated Read Only
Set Value to Calculated Read Only
In the Script Editor panel choose calculate
Set the Language to FormCalc
Then in the panel add the following code – Use your table name, row name and field name. Read [*] as saying “for each instance of the object” “This” refers to the currently selected object, in this case the grand total field.
Save and test
Q. Can I auto-number my rows?
Yes you can, but you will need to be comfortable with adding some code. Please read this very good article here “Numbering rows in a LiveCycle Designer table or repeating subform” which also has a sample file.
I’d like to do a video on this, but due to time limitations, I wont make promises I can’t keep.
A Ted talk to lighten your day: James Veitch: This is what happens when you reply to spam email. I usually recommend deeper technical or data oriented TED talks. This one is fun and good place to start with TED talks.
Always looking for new uses of OneNote and found two that I’d like to share with you.
Free eBook for teachers: “Liberating Genius: The First 20 Days” by Angela Maiers – which is an e-book using OneNote as its “host”. This has got me thinking about going beyond my current use of OneNote as a scrapbook for course resources to using it for courseware.
College prep planning resources and virtual event for students use OneNote as a resource to support an online session. Its aimed at american students going to college, but its worth Australian and other schools getting a copy to explore the approach.
As people may know I am currently doing the Data Analysis course via Duke University and Coursera. While I am my data kick I am keeping track of news of new and updated tools. And so I have two bits of news:
Microsoft has released an update for Power BI desktop and also a universal app (to suit Windows tablets, phones and PCs). I will explore these tools further after I have complete the current module of the data analysis course.
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:
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:
- Use strong passwords
- Switch on two factor authentication
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.
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.
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!
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
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 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.