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
Avast subsidiary harvested browsing data for sale
Antivirus vendor Avast has been accused of selling users personal data. The claim comes from an investigation carried out by news website VICE. The...
UAE could save US$3B with blockchain implementation
The UAE (United Arab Emirates) could save over US$3B (AEDirham 11B) by implementing advanced blockchain technologies. This is the claim of a joint white...
Jolocom and Bundesdruckerei e-government PoC
To demonstrate the potential for decentralising digital identity solutions in the context of IT infrastructure, researchers at Bundesdruckerei have tested a blockchain-based self-sovereign identity...
Retailers look to hybrid cloud as they search for flexibility
Nutanix, an enterprise cloud provider, has announced the retail industry findings of its second Enterprise Cloud Index Report. The report measures retailers’ plans for...
Going beyond CRM, talking technology, methodology and strategy
Enterprise sat down with Patrick Morrisey GM Revenue Optimization Business Unit and Nigel Cullington, VP Product Marketing at Upland Altify at Dreamforce. Cullington reveals...
Changepoint rises with bright future
Changepoint announced new branding last year and it has now revealed what it has been working on for the last eighteen months. In a...
Sage Foundation engages student on AI
Sage Foundation has launched its FutureMakers initiative in the US for the first time. It partnered with 3DE, a non-profit created by Junior Achievement...
EEA partners with Whiteblock to offer collaborative blockchain
The EEA (Enterprise Ethereum Alliance) is partnering with Whiteblock to provide a testing environment for the EEA global membership base (of which Whiteblock is...
IBM report: ‘shoppers will pay premium prices for sustainable, traceable brands’
IBM has released a study on global consumer trends which 'reveals' that the importance of brand purpose surpasses cost and convenience for today's shoppers....
The unsolved problem of poor utilisation
KeyedIn has highlighted recent research showing how poor utilisation rates are. The research, carried out by the Resource Management Institute (RMI), was co-sponsored by...
Kadena launches its hybrid blockchain
Kadena has launched its public blockchain which includes full transactions and the ability to write smart contracts. The latest functionality of the network completes...
WAV files risk to Windows 7 and beyond
WAV files have been blamed for infecting Windows 7 machines with cryptomining malware at a medical tech (MedTech) vendor. It infected over 50% of...
Ternio slashes minimum balance requirement on BlockCard
Ternio, the creator of BlockCard, has reduced the minimum balance requirement for all its BlockCard holders - by 90% (from US$100 to US$10). Ternio...
Food Trust for quality and origin of Terra Delyssa Extra Virgin Olive Oil
CHO, a Tunisian olive oil producer, will use IBM's Food Trust blockchain to create a provenance record that traces, via eight quality assurance checkpoints,...
