Extracting data in a flash :Image source - Pixabay -Nick Gessell nov 2016

Tips – How to use Flash fill in Excel

Over the past 25 years I have constantly been asked how to easily extract single words out of multiple words in a cell in Excel. This is normally because people receive...
Big_Ben: Image credit - unsplash.com/michael Jin

Using dates that automatically update in Excel

In a previous tip I showed you that you can input dates three different ways into a spreadsheet. One of them was the formula that allowed the result change every day,...
Looking at ranges can be fun - source image: freeImages.com / Tamlyn Rhodes

Tips – using range lookup in the Vlookup function in Excel.

In my last tip, Using Vlookup in ExceI, I explained how to create a Vlookup function. I only showed you how to use the first three lines of this function and...
Cheetahs Source Image: Unsplash.com/ Roberta Doyle

Shortcut keys in Excel for Data, Functions and Formula Bar (5 of 8)

This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar. I have highlighted for you some that I find very useful...
landscapes-in-nederlands : Image Source - Freeimages.com/ Daniel Hanai

Repeated Header rows in a Word Table

Microsoft Word is a great place to create a table for lists and the like. Sometimes my students have such long lists that they flow over to the next page and...
Indentations - Image source: Pixabay.com

Indentation explained for MS Word

When you create a word document the default settings for a paragraph are to have a left aligning paragraph and no indentation for the second and subsequent lines within that paragraph. I...
champagne

Tips – Fill Series in Excel Spreadsheets

In an earlier tip I explained how to use the Autofill feature in Excel. It is a wonderful time saving tool. Now I will explain the Fill Series feature where numbers and dates...

What is and how to use the Outline View in MS Word

When you first go into Word the default view is Print Layout. This shows you the size of the paper, margins and an indication of the font and size of text...
holiday - image credit: pixabay/Stephanie Laubscher

How to count only week days in Excel

My students are great at finding me new tips to write. This week I had one who wanted to count the number of days between two dates but without the weekends....
Table - Source Image: Pixabay

Tip – Drawing Tables in Word

  I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells...

LATEST NEWS

(image credit/Pixabay/Gerd Altmann)

Business failing to implement digital transformation projects says Mulesoft report

MuleSoft has announced the findings of the 2020 Connectivity Benchmark Report on the state of IT and digital transformation. The survey revealed 59% of...
(Image credit/Pixabay/ElasticComputeFarm)

Co-op UK and Digital Goodie expand partnership with deployment of headless commerce

Digital Goodie has expanded its partnership for the launch of Co-op's dedicated online grocery shop and home delivery service. Digital Goodie is the creator...
Pega sees IT and business uit infighting harming the CX (Image Credit: Pega sees IT and business uit infighting harming the CX)

Pega says IT vs Business is hurting the customer experience

Pega Research has released its latest report titled: The four false narratives of customer experience (registration required). It highlights how the internal battle between...
Telos Foundation

The Telos Foundation makes two moves – the BRI and Unbiased

The Telos Foundation is joining the Blockchain Research Institute (BRI) in an effort to further its mission to broaden blockchain adoption. Almost simultaneously it...
Hedera

Hedera Consensus Service (HCS) launched by Hedera Hashgraph

The Hedera Consensus Service (HCS) is open to developers on the Hedera mainnet. HCS has been in development at Hedera since mid-2019. it seeks...
(Image credit/Pixabay/mohamed Hassan)

5G IoT revenue to reach $8 Billion by 2025

A new study from Juniper Research found total operator-billed revenue from 5G IoT connections will reach $8 billion by 2024. This rises from $525...
Keeper gives LogRhythm access to password logs (Image Credit: Gerd Altmann from Pixabay )

LogRhythm signs up Keeper for password logs

LogRhythm has signed Keeper Security as a Technology Alliance Partner. The partnership means that LogRhythm will add Keeper's password event data into its SIEM...
Obviously AI (c) 2020

Predictions which are Obviously AI

Artificial Intelligence is often the domain of data scientists and organisations are finding it difficult to locate them. Now there seems to be an...
Unsigned firmware leaves users at risk (Image Credit: Sergio Stockfleth from Pixabay)

Unsigned firmware a bonanza for hackers

Enterprise security company Eclypsium is warning of the dangers from unsigned firmware inside devices from desktops to laptops. The details are contained in a...
Israeli soldiers fall for Hamas dating scam(Image Credit: Kat Nelson on Unsplash)

Hamas Android malware targets Israeli military

Israeli soldiers using Android devices have fallen victim to a malware attack by terror group Hamas. The Israeli army claims that it had now...
Facebook stuns Vienna court (Image Credit: C. Cossa)

Facebook makes outrageous statements in Vienna court

Last week Facebook, or to be more precise Cecilia Alvarez, EMEA Privacy Policy Director at Facebook, was answering questions under oath in the Vienna...
Handcash

HandCash introduces HandCash Connect – a Bitcoin development kit

Spanish BitCoin wallet provider, HandCash, has packaged the basic components it believes every BitCoin application developer needs - in just one toolkit. HandCash Connect's...
Cheshire Cat Image by tookapic from Pixabay

Can Qlik bring smile to Cheshire healthcare teams

In April 2020 four NHS Clinical Commissioning Groups will merge. As the units come together the work to leverage their combined data has already...
NTT joins Charter of Trust (Image Credit: Anemone123 from Pixabay )

NTT joins the Charter of Trust

NTT announced at the Munich Security Conference that it has joined the Charter of Trust (CoT). Created in 2018 by Siemens, the CoT is...