Saturday, December 5, 2020
Big_Ben: Image credit - unsplash.com/michael Jin

Using dates that automatically update in Excel

0
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,...
Dates : Image Credit Unsplash.com

Do you need a date to automatically, or not, update in Excel?

0
There are a few ways to input dates into a spreadsheet. One, you can type the date you require in the format you like. Two, you can type a formula that...
key-MasterTux : image source - pixabay.com/MasterTux

Create a Shortcut key for the strikethrough effect in Word

0
I had a student approach me the other day who asked if there were shortcut keys to change a highlighted word into bold or underlined or even italic. And could you...
Consolidation - image source: Unsplash.com/maddi-bazzocco

When two files have almost the same headings and need to be combined.

0
In my last tip I wrote about how to combine, or consolidate, two or more spreadsheets that had the same layout and headings. These needed to be combined in an all-inclusive...
The Red Arrows : image sauce - Unsplash.com/ Oliver Rowley

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

0
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”....
Peaceful : image source- Unsplash.com/federico-bottos

These mysterious non-printing characters. What are they?

0
Do you get a word document sent to you that looks badly laid out with things not sitting quite where they should be. When you try to correct them or add...
railway-bridge : image sauce - pixabay.com/Karen282

All things Page Break in Word

0
Microsoft Word is a word processor that creates the documents you require in a text format. The length of each page is governed by the size of paper you have chosen...
Windows - image source: unsplash.com/nathan-fertig

Dual screen for the price and space of one.

0
I do sometimes wish that every person in a company goes through a proper introduction to their PC on the induction course when then first join the company and then every...
Image source: Unsplash.com/clem-onojeghuo

Frustrated with selecting large areas in a spreadsheet?

0
I often hear from my students that they take a long and frustrating time to select the information they need in large spreadsheets. They use the mouse to click hold and...
sheepdog : image source- Pixabay.com/marybettinibank

Need just a few characters from a long string in an excel spreadsheet?

0
My students come to me with all sorts of questions. The one that seems to come up every so often is how to easily change the length of a piece of...

LATEST NEWS

(image credit/Pixabay/Gerd Altmann)

Salesforce unveils Einstein Automate

0
Salesforce has unveiled Einstein Automate – an end-to-end workflow automation solution that empowers people and businesses to be more productive. Einstein Automate delivers automation...
Crayon continues expansion with acquisition of Sensa (Image Credit: Jonatan Pie on Unsplash)

Crayon continues expansion with acquisition of Sensa

0
Crayon has announced its agreement to purchase Managed Services company Sensa. The deal will cost Crayon ISK 3.25bn (£18.93 million). The purchase price will...
Salesforce Hyperforce (c) 2020 Salesforce

Salesforce goes public with Hyperforce

0
Salesforce is to make its platform available on “major” public clouds. The new architecture is called Salesforce Hyperforce. All Salesforce applications are available in...
(Image credit/pexels/pixabay)

Research finds only 37% of organisations have the skills and technology to keep pace...

0
MuleSoft has announced the findings of The State of Business and IT Innovation report. The company commissioned the global survey of 1,739 line of...
The Access Group acquires career site Abintegro Image credit Gerd Altman Pixbay/gerslt

Abintegro joins The Access Group People division

0
The Access Group is to acquire Abintegro Limited. Headquartered in London, Abintegro provides customers with an easy to use career solution that helps improve...
Salesforce Results (Image credit pixabay/Geralt) https://pixabay.com/en/result-galaxy-earth-world-globe-2153619/

Salesforce hits triple of Slack, Results and Dreamforce

0
While the big announcement was its acquisition of Slack, Salesforce also issued yet another strong set of results for Q3 2020. Later today Marc...
Salesforce + Slack (c) Salesforce 2020

Salesforce takes up Slack for $27.7 billion

0
Salesforce finally confirmed the rumours as it announced that it had reached an agreement to buy Slack for a total value of $27.7 billion....
Finmail

Finmail Mailbox for sending digital currency by email

0
Securechain, a Copenhagen-based fintech products and digital payment solutions startup has launched Finmail Mailbox. Finmail Mailbox integrates both email and a digital currency payment...
(Image credit/Pexels/ThisIsEngineeering)

Uswitch report reveals the world’s biggest data breaches

0
A new report by Uswitch has revealed which countries have been the worst hit by data breaches. The report also highlights the worst cases...
Cyber researchers uncover end-to-end cyber-biological attack (Image Credit: National Cancer Institute on Unsplash)

Cyber researchers uncover end-to-end cyber-biological attack

0
An end-to-end cyber-biological attack has been uncovered by cyber researchers at the Ben-Gurion University of the Negev. Using malware, a cybercriminal could use change...
SMB's cyber reliance damaged by lack of IT expertise (Image Credit: AltumCode on Unsplash)

SMB’s cyber reliance damaged by lack of IT expertise

0
A lack of IT expertise is damaging the cyber resilience of SMB’s. Worryingly, around 25% of small businesses are spending less on cyber resilience....
SMEs failing security assessments by not protecting home networks (Image Credit: Luis Ricardo Rivera from Pixabay)

SMEs failing security assessments by not protecting home networks

0
SMEs are at risk of failing security assessments by not protecting the home networks of their employees. That claims from cybersecurity and IT Managed...
Blockchain Catch-up

Charles Brett’s Blockchain Catch-up Week 46 (to w/e 27th November)

0
This is a Charles Brett's start-of-the-week Enterprise Times ‘blockchain catch-up’ for Week 46. Necessarily it is idiosyncratic and selective. It is not intended to be...
UK Police forces using cloud for data storage (Image Credit: kingschurchinternational on Unsplash)

UK police forces using cloud for data storage

0
47% of UK police forces currently use a hybrid-cloud model to access and store data. The details emerged from a survey of UK police...