As easy as 1-2-3, subtotalling in Excel saves time and avoids errors Image Source : Freeimages.com/t pace

Tips – Using Subtotalling in Excel

As a trainer I often come across people doing things the very long way round. For instance, a lady had a large list of sales items and personnel which she needed...
Acronyms Tip DaaS, DaaS, HPC

Tips – Cloud acronyms: DaaS, DaaS and HPC

The second set of acronyms shows that just because you think you know the answer you might not. The problem with *aaS acronyms is that companies are always making new ones...
The Red Arrows : image sauce - Unsplash.com/ Oliver Rowley

Two spreadsheets that need to come together? Consolidation might be the answer.

You may well be tasked with creating one spreadsheet that has data coming from two or more spreadsheets. This could be a daunting prospect if you do not know about “consolidation”....
Zero - Image Source: Pixabay.com

Typing numbers that start with a Zero in Excel

How frustrating is it when you type a telephone number or any number that needs to start with a zero in Excel and the result you get is a number without...
Section Breaks that work perfectly. - Image Source: FreeImages.com / Michelle Rau

Tips – Word Sections explained.

Many of you may not know that you can have sections in Word. You can have sections even on the same page which are called continuous sections. These help to design...
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...
When Automation works well for you. (Image Source: FreeImages.com /Zach Schroeder)

Tip – AutoFill explained in MS Excel

One of the most delightful features in Excel when you’re just starting out is the AutoFill feature. Have you been working hard in creating a formula that needs to be used...
Continuous section breaks makes documents easily read. - Image Source: FreeImages.com / Robert Linder

Tips – Same Page Section Breaks in Word

Last week you read about section breaks for whole pages to create different formatting and layouts of whole pages. This week we investigate the Same Page Section Break. N.B. This Tip is...
Space : image credit - unsplash.com/NASA

Finding the cell that contains just a space in Excel

I have many clients who have the same problem with importing data from other applications into Excel. All seems perfectly well until they start to analyse the data only to find...
Quick Access tools you like to use. - Source Image: FreeImages.com / Dorian Widling

Tip – Quick Access Toolbar in MS Office

Those of you who have used Microsoft products for a long time will remember the static toolbars that we loved. I’m not saying that I don’t love the new improved ribbons...

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...