CC Process

Content creation process – Excel Hints & Tips
created by Jacob

What is it?

We are creating useful (hopefully!) Excel Hints & Tips which are emailed weekly to a selection of our customers (and subscribed website visitors) and published on our blog as well.

Why are we doing this?

We are generating this content to really demonstrate to our market that we are knowledge experts on Excel (and MS Office) by providing them with useful content that they can benefit from and share with their connections. We know we do a great job on our training deliveries, but we need compelling content to raise the awareness of those who have NOT yet trained with us.

This method (along with many other marketing activities) will contribute towards giving us greater authority in our market/the web and we will all benefit from increased business.

Okay so how do we choose topics to write about?

This is very much an organic process, we want to know about big wins, “aha!” moments you have had with your delegates, we also review what existing topics on our site and the web are generating greater interest.

How do I contribute?

Our processes are at an embryonic stage, we are learning as we go, please be patient!

To start with, we will provide every contributor with a WordPress account (we use WordPress for our MS Office & Excel blogs). You will be able to create draft content (text & images/screenshots). Marketing (Jacob in this instance) can then review the content, edit and publish. The good thing about using WordPress is that we can collaborate on drafts before they go live.

A quick WordPress guide for you!

All we are after at this stage is for you to contribute as an Excel trainer, don’t worry about trying to write the content, choosing a title etc, that will be marketing’s remit. Just provide an introduction to the Excel Tip, what the benefits are, then take them through how to do it step by step…

Here are some published examples:

Use the following examples as a template with regards to layout/presentation.
https://www.stl-training.co.uk/b/blog/excel-training/share-files-excel/

https://www.stl-training.co.uk/b/blog/excel-training/how-to-split-a-stacked-chart-in-excel/

Basic guidelines:

  • Aim for an Excel hint that is version free (not version dependent, or if it is show a work around for other versions)
  • Consider the potential audience to be intro – Adv users, but pitch the level of difficulty more at introduction/intermediate level
  • Always ask yourself – Would I see value in using this Excel hint, would I show it off/share with my friends/colleagues?
  • When introducing the Excel hint, try and explain why it is useful (you may be able to draw on delegate interactions “aha” moments)

What are the timelines?

The most important thing is create this content in step with your training schedule but not feel under any artificial deadlines. If we can as a group aim to have one piece of content per week produced that would be great.

Next Excel Hints to create and publish (a mash-up of suggestions from Jens, Andrew and online research!) – This is first come first served, so use the “Leave a reply” form at the bottom of this post to notify everyone which items you can action (at least 2 from this list) , and when approximately you can do this by.

  1. Keyboard shortcuts, jump between tabs using CTRL + PGUP/PGDWN
    Let’s look at featuring a dozen or so shortcuts, with a quick description for each one.
  2. Pie chart – pull out a segment! Just click Pie Chart – then click segment to separate.
  3. Show formulas (button on the formulas tab in the formula auditing group)
  4. How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series (this is based on existing content, we just need to make it more user friendly with screenshots, reword it and not make version specific)
    https://www.stl-training.co.uk/article-2013-how-create-excel-2010-chart-show-both-number-and-percent-data-series.html
  5. Concatenate in Excel
  6. $ref & BODMAS
  7. Count & CountA, the difference. Again you can reference this article and make it more visual, also feel free to expand with any related functions etc…https://www.stl-training.co.uk/fg-17/what-is-difference-between-count-and-counta-in-excel.html
  8. Remove duplicates (and anything else related to this)
  9. Working with %
  10. sub-total feature: Data – subtotal
  11. Page breaks & printing – repeating headers on different Excel pages.
  12. Use Vlookup to compare lists.
  13. Arrange two worksheets from the same workbook side by side

UK government pays £5.5m penalty for not listening to Microsoft

UK Government pays £5.5m to Microsoft
£5.5m says UK government should have taken Microsoft seriously about XP

Imagine you’re at an important hospital appointment and you’re kept waiting because the scanner, which potentially cost £100K, needs a re-boot. And then you discover it’s driven by Windows XP which is no longer supported by Microsoft. That would be insane wouldn’t it?

Sadly not. It’s a true story and it’s probably just the tip of the iceberg across the NHS. Just how big a problem it is we don’t know because, as The Register discovered, the Department of Health doesn’t actually know the penetration of XP amongst its million PCs spread across GP surgeries, trusts, hospitals and other organisations. An estimate from healthcare specialists EHI Intelligence back in September 2013 put the penetration of NHS PCs running XP at 85%. Its survey suggests that NHS managers were keeping their fingers crossed that either Microsoft would change its mind or some sort of deal would be done. Fortunately for them, the government was able to finalise a deal with Microsoft for its public sector users – but only for a year, only for security updates for XP, Office 2003 and Exchange 2003 and at a cost of around £5.5m. As people are wont to ask in such situations, how many nurses could that have paid for?

For many bodies such as the Metropolitan Police and HM Revenue and Customs, migrating away from XP will be completed by the end of the year. But it’s all a bit late and reeks of panic. The government’s central purchasing agency, the Crown Commercial Service, is putting on a brave face and claiming that its deal with Microsoft is saving the government £20m by centralising negotiations – but why has it had to happen in the first place?

“We see it as a serious case of hiding behind the sofa and hoping it will all go away,” says Rich. “Windows XP was born 13 years ago – that makes it venerable in technology terms. It can’t last forever.”

Microsoft has been flagging up the end of life for years and offering assistance in moving on. Yet it seems to have come as a surprise to many that’s it’s been true to its word. “Either they thought that the sheer numbers of XP users still out there would be persuasive in getting XP’s life extended or it’s an example of poor management”, says Rich Talbot, Trainer at Best STL. The NHS story suggests the latter. “We can’t even sigh and say that this is what happens in large public bodies, because organisations in every commercial space from small to large have missed the deadline too,” adds Rich.

Best STL hears grumbles about the greedy face of business forcing businesses to spend money when they can least afford it. Is Microsoft being fair in withdrawing support? Let’s look at its arguments.

  • Security issues leading to compliance risks. Security is definitely one of the biggest issues facing organisations today and Microsoft claims that an ageing OS can’t be protected sufficiently well. If that’s true, it’s important. And if organisations continue to use an operating system without updating security they will suffer. It’s quite likely that there’s a huge amount of malware silently sitting on XP systems today waiting to be initiated by attackers to steal data and devastate businesses. Even if the worst doesn’t happen, failing to comply with ever-tightening financial regulations is asking for huge financial penalties and loss of face.
  • Lack of ISV and hardware manufacturers’ support. Microsoft quotes Gartner research on its web site, arguing that a growing number of ISVs won’t support XP with new versions of their software and that manufacturers won’t support XP on their new PCs. On the other hand, one of the reasons that organisations may be holding back from upgrading is that they don’t know if their current legacy applications will work on Windows 7 or 8 or Linux or something else. Where there are specialised applications like the driver for that scanner, this could well be true – but, as Rich says, it’s time that someone found out.
  • Greater productivity with newer versions of Windows and Office. “Yes, it’s possibly true but it’s a very general claim and depends on your needs,” comments Rich. “We can all recognise this as marketing puffery.”

Is there an alternative argument that Microsoft is being harsh on government and businesses in times of economic difficulty? “We don’t think so,” says Rich. “The global financial crisis began over six years ago. How long can we keep claiming poverty? In any case, if the likes of Microsoft stopped driving for profitability, where would be the development that we all really need?”

So here’s the quandary. Microsoft is insisting that there will be no help beyond this final year for anyone. That’s hardly surprising and managers really need to avoid the temptation to sign up for the year and then promptly hide their heads again. So what’s the bottom line? Says Rich “If you’re running any applications on XP that are business-critical you need to take action now because lack of security and compliance are a real threat. If you’re driving important apps – such as that scanner – with XP then while security might not be your priority, lack of day-to-day support that puts the equipment out of action could be.”

Are you concerned about upgrading to a new version of Windows – we can help with migration and training for individuals and organisations contact us for more information.