Counting work days without Bank holidays and personal days in Excel.
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...
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....
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...
Using Animation in PowerPoint Presentations
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 spreadsheets in Excel 19
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...
Change and keep column settings in Explorer 10
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...
Determine what size the window of your app will be the next time you...
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...
How to make a cell change colour of the background whilst typing in new...
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...
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,...
Do you need a date to automatically, or not, update in Excel?
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
Keeper searches Dark Web for password breaches
Keeper Security has released BreachWatch, a utility which searches the Dark Web for login credentials exposed through a public breach. BreachWatch is available as...
Salesforce makes email marketing smarter with new Einstein AI innovations
Salesforce has announced new Einstein AI innovations for Marketing Cloud. The enhancements will enable brands to increase customer engagement with relevant and timely email...
Accelo expenses module is generally available
Accelo has completed the work on its expenses module but has yet to launch the new release. Accelo believes that its module should stop...
Blocksyte + Caroli introduce blockchain traceability for olive oil
Blocksyte, a blockchain supply chain application company focused on the food industry supply chain, and Caroli, a producer of high-quality, extra virgin olive oil...
SafeBreach warns of critical vulnerability in PC-Doctor
SafeBreach has released details of a vulnerability in PC-Doctor, a support tool used by several PC vendors including Dell. The software allows end users...
How SNIA is using Open Source to speed up storage standards
Developing a storage standard has always been a long, arduous and contentious process. It is the same for most standards.
However, with the speed that...
What to make of Facebook’s Libra?
On June 18th Facebook 'announced Calibra and Libra (though they will not be available until 2020). This is either a momentous event or an...
New but familiar player in Service Desk Software – SolarWinds
Following a slew of acquisitions, SolarWinds has launched a Service Desk solution. Solarwinds is a brand familiar to IT leaders with a wide range...
Microsoft, SalesForce and the Ethereum Foundation join Hyperledger
Hyperledger, an open source collaborative effort created to advance blockchain, has announced a diverse line-up of eight new members, including the Ethereum Foundation, Microsoft,...
Reports highlight future of Jobs in the digital age
Zigurat Innovation & Technology Business School and consultancy Setesca, have published a report "Future of Jobs in the Digital Era." The report highlights the...
Kaminario launches new Storage as a Service Offerings
Kaminario, a cloud storage software company, announced three new offerings and a unified licensing framework. The announcement is aligned to the company’s vision of...
Ripple partners with MoneyGram
Ripple, a provider of blockchain for global payments, entered into what it calls "a strategic partnership with MoneyGram". The latter is one of the...
TCS teams with SAP to transform surgical kit ecosystem
Tata Consultancy Services (TCS) is partnering with SAP to launch an Intelligent Field Inventory Management (iFIM) solution. Powered by SAP Leonardo, this leverages IoT...
FDA program to evaluate blockchain to protect pharmaceutical integrity
The US Food and Drug Administration (FDA) has selected IBM, KPMG, Merck and Walmart for inclusion in a program which will support the U.S....
