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