Training Courses

Data Journalism : Introduction

One Day Course


Data-driven journalism is the increasingly popular process of analysing and filtering data to find new stories or different angles on existing stories. This is a one day course that will teach journalists to how use the powerful data-analysis tools in Microsoft Excel to assess data from different sources and look for stories within the facts.

This course assumes a working knowledge of Excel, if you do not have that, we can run a tailored course for you. Please call to discuss this option. This is not a course that will teach you to write a story, if you wish to hone your writing skills, you should consider taking our Introduction to Feature Writing or Introduction to News Writing courses as well. To attend this course you need a working knowledge of Excel. You should be able to create and format your own spreadsheets and workbooks and create formulas. If you don't know Excel, we can run a tailored course for you. Please call to discuss this option.

Public Course Dates & Pricing

Course DatesLocationPriceStatus

  • Public Courses

    Small class sizes so you get the maximum amount of trainer time possible. You attend with delegates from other companies.

    A great, cost efficient way to learn, discounts are also available for group bookings.


    Discount Info
  • Private Courses

    One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

    We offer a free consultation service to help work out every detail and build the perfect course for you.

    From £545 + VAT

    Free Consultation

Course Outline

  • Introduction
    • What is Data Journalism?
    • Why is there such an increase in Data Journalism?
    • Examples of good Data Journalism
    • Merging technical knowledge and journalism

    Mission critical Excel skills
    • How to use Excel to find stories
    • Conditional formatting
    • IF and LOOKUP
    • Sorting
    • Auto-filtering data
    • Constructing a drop-down menu
    • Turning records into a table

    Pivot tables and journalism
    • Why journalists need pivot tables
    • Creating a pivot table
    • Auto-filtering data
    • Constructing a table
    • Moving fields around
    • Various ways of displaying values
    • Manoeuvring fields around the table
    • Creating different results and tables from the same spreadsheet
  • Finding data online
    •Turning online text into a spreadsheet
    •Finding data journalism sources online
    •Preparing third-party spreadsheets for your analysis
    •Recognising data entry errors and how to repair them
    •When to add your own data columns to a spreadsheet
    – and how to use them to analyse data

    Finding Stories in the Data
    •Asking the right questions
    •Analysing the data in different ways
    •Finding new story ideas
    •Looking for the hidden story

    Questions and answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel 5 working days before your course and there’s no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Value + Choice
Reputation + Feedback

  Our Clients

We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 4999 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed4999
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.7 / 10
  % Who Would Recommend Us99.7%

"Very efficient teaching, covered all topics that were mentioned. Food / refreshments were also great! "

"Great atmosphere with a knowledgeable and effective trainer. "

"Excellent trainer, very friendly and knowledgeable. It ended up being a one-to-one session, which I was nervous about at first, but he immediately put me at ease, built rapport, and generally did all the things he ended up teaching me about as key interviewing techniques! I would definitely recommend this course and Piers as a trainer."

"Great practical training on pivot tables - very clear and lots of unexpected resources like Twdocs"

"Excellent one-to-one tuition from Andrew! I found my training day really helpful and have learned a lot!"

"Course was very informative and useful. "

"Great facilities, really knowledgeable and engaging trainer."

"Providing a friendly and relaxed atmosphere, delivering relevant, useful and engaging information, and tailoring content to specific contexts."

"The whole training environment is excellent, very high quality facilities, friendly and helpful staff team, excellent and plentiful refreshments, friendly and approachable instructor. Very impressed."

"Friendly and relaxed enviroment"

"The content was well presented"

"Interesting and engaging course."

"Everything was really well explained and the one-to-one tuition was very valuable. "

"The training was tailored to my work, and I got opportunities to practice the skills I learnt. I also feel very encouraged to go out and perform what I've learnt"

"Really informative trainer, she was really good. the hummus was really tasty!!"

"Friendly approachable way of delivering specialist knowledge. Handy to have an expert insight into industry. "

"The course was very useful. "