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...
Create a Shortcut key for the strikethrough effect in Word
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...
When two files have almost the same headings and need to be combined.
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...
LATEST NEWS
Immense Solutions secures $4.6 million in funding
Intelligent mobility software provider, Immense Solutions, has raised US$4.6 million in a series A funding round. The funding round was led by Amadeus Capital...
Kai Waehner explains why you need Kafka
The Apache Kafka summit was held in London last week. Kafka was originally designed to solve the problem of high volume and throughput at...
Calastone’s blockchain-based DMI goes live
Calastone has gone live with its blockchain Distributed Market Infrastructure (DMI). The technology underpinning Calastone's network has migrated to a blockchain-enabled market infrastructure. This...
HPE buys Cray for $1.3 billion
Supercomputer stalwart, Cray Inc, has been bought by Hewlett Packard Enterprise (HPE). The offer of £35 per share values Cray at $1.3 billion and...
Alexis Richardson on why the CNCF is growing so fast
The Cloud Native Computing Foundation is holding its annual European conference in Barcelona this week. Alongside the CNCF conference is KubeCon, a project that...
FLETA testnet claims 15,000 TPS
FLETA, a Korean blockchain platform, is aiming to create a sustainable DApp ecosystem. It has announced the release of its beta testnet with its...
Marconi adds Diffie and launches its Mainnet for scaling complex networks
Marconi, creator of a networking and blockchain protocol using programmable packets, has launched its Mainnet platform. This multi-cloud application platform provides ways to build...
Calculating number of workdays between two dates where weekends are not Saturday and Sunday
A recent tip of mine showed how to calculate the number of working days there are between two dates. Also where there are bank...
VMware report says digital employee experience is linked with company growth
VMware Inc, shared results of a global survey of employees, human resources (HR) professionals, and information technology (IT) decision makers. The survey reviewed attitudes...
Hyperledger Iroha passes development milestone
Hyperledger Iroha has been certified as a production-ready Hyperledger platform. It claims to offer simple implementation, an advanced permission model and both privacy and...
Plug and Play opens supply chain/logistics accelerator in Northwest Arkansas
Plug and Play has plans to open a supply chain and logistics accelerator program in Northwest Arkansas. The new program will bring innovative startups...
Confluent Cloud get cloud native boost
At the Kafka Conference in London, Confluent announced several updates to its Confluent Cloud platform. These are all aimed at making the product cloud-native...
Topolytics wins $100,000 for WasteMap data platform
Topolytics has won first prize in the Google Cloud and SAP Circular Economy 2030 Contest for its WasteMap data analytics platform. The company beat...
Project Klaytn: blockchain applied for social good
Ground X, the blockchain unit of South Korean mobile platform Kakao, has successfully completed Project Klaytn, its first pilot. This leverages blockchain technology to...
