Saturday, December 5, 2020

Calculating number of workdays between two dates where weekends are not Saturday and Sunday

0
A recent tip of mine showed how to calculate the number of working days there are between two dates. Also where there are bank holidays involved. Today I shall investigate the...

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

0
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.com / Ana J

Counting work days without Bank holidays and personal days in Excel.

0
Carrying on from my previous tip on how to count days between two dates that are just week days. We need to investigate adding in personal days and bank holidays. If...
holiday - image credit: pixabay/Stephanie Laubscher

How to count only week days in Excel

0
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....
Space : image credit - unsplash.com/NASA

Finding the cell that contains just a space in Excel

0
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...
Finding Nemo: Image Credit - pexels.com / Tom Fisk

Using Animation in PowerPoint Presentations

0
Hands up those of you who go to presentations and take notes on the design of the presentation. What works and what doesn’t? I guess most of you have not raised...
Linking ; Image credit -Unsplash.com/bryson-hammer

Linking spreadsheets in Excel 19

0
A while ago I wrote a tip on how to consolidate two or more spreadsheets together. It occurred to me that maybe some of you were not aware of the simple...
Columns - image credit / unsplash.com/Héctor J.Rivas

Change and keep column settings in Explorer 10

0
You would be amazed how many times I get asked this question. “How do I keep the settings of particular columns in Explorer for any future folders I create as a...
size matters : image credit - Pixabay.com/NjoyHarmony

Determine what size the window of your app will be the next time you...

0
We all use more than one application at any time. Usually they open in full screen. This is not always what we want. Many of my students these days are lucky...
Chameleon : image credit - unsplash.com/erwan_hesry

How to make a cell change colour of the background whilst typing in new...

0
In my training course the other day a student asked me how they could make Excel change the background of a cell when they typed in a new word. The simplest...

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