Sunday, September 20, 2020
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...
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...

LATEST NEWS

(Image credit/Pixabay/ Steve Buissinne)

Rapyd launches European card acquiring platform

0
Rapyd, a global fintech and "Finance as a service" company announced a major expansion of its European card acquiring platform. The company has added...
BCG DeFi

Crypto.com and BCG Platinion’s report on DeFi

0
Crypto.com and BCG (Boston Consulting Group) Platinion have released a report on Decentralized Finance (DeFi), an area they see as being where growth is...
Girl Graduate Image by fredy martinez enamorado from Pixabay

monday.com to graduate partner channel

1
monday.com, the fast-growing work management platform is strengthening investment in its partner ecosystem. The company has made a series of announcements including the appointment...
Success Talent gap job Image by Igor Link from Pixabay

New Salesforce initiative targets talent gap

0
Salesforce has launched the Salesforce Talent Alliance. The alliance aims to help increase the number of skilled Salesforce workers in the ecosystem. The target?...
Mastercard

Mastercard launches testing CDBC platform for central banking

0
Mastercard has launched a proprietary virtual testing environment for central banks to evaluate CBDC use cases. The platform enables the simulation of issuance, distribution...
Another Zerologon bug exploit code published (Image Credit: Darwin Laganzon from Pixabay)

Another Zerologon bug exploit code published

0
On Monday, The Cybersecurity and Infrastructure Agency (CISA) warned that it has seen publicly available code for CVE-2020-1472. Called Zerologon and discovered by Tom...
TAG

TAG completes DLT pilot for digital advertising

0
The Trustworthy Accountability Group (TAG) has completed a 12 month cross-industry pilot programme to evaluate the feasibility and potential benefits of Distributed Ledger Technology...
(Image credit/Pixabay/Gerd Altmann)

Digital Rivers unveils new products and initiatives

0
Digital River has pushed it biggest product release to date, and declared continued growth in partnerships and new customers. The company has also announced...
Remote Control Pulseway for macOS devices

Pulseway adds remote control for Apple Macs

0
Pulseway now supports remote control for macOS devices. It extends the capability of the remote control for Windows solution that Pulseway launched last year....
Remote workers, smart home devices and apps are a risk to corporate data (Image Credit: Anrita1705 from Pixabay)

Remote workers, smart home devices and apps are a risk to corporate data

0
“Smart home devices and their apps represent a major weak link in the corporate cybersecurity chain as the lines between work and home life...
Business man cogs, image credit pixabay/Geralt

Changepoint partially lifts curtain on Services Automation 2020

0
Changepoint has unveiled more updates to Changepoint Services Automation (SA) 2020, previously Changepoint PSA. In a recent blog, it revealed the next phase of...
46,000 US Veterans have their data compromised (Image Credit: US DoD)

46,000 US Veterans have their data compromised

0
The US Department of Veterans Affairs (VA) Financial Services Center (FSC) has written to 46,000 veterans. It is warning them that their names and...
Tech Mahindra

Tech Mahindra to offer solutions built on Amazon Managed Blockchain Services

0
Tech Mahindra, which already is part of the AWS Partner Network, is to team up with Amazon Web Services (AWS) to build solutions based...
Healthcare firms get funds to improve cyber security (Image Credit: PublicDomainPictures from Pixabay)

Healthcare firms get funds to improve cybersecurity

0
Healthcare companies in the UK can now access government funds to improve the cybersecurity of their products. Digital Infrastructure Minister, Matt Warman, has announced...