holiday - image credit: pixabay.com / Ana J

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...
holiday - image credit: pixabay/Stephanie Laubscher

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

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

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 ; Image credit -Unsplash.com/bryson-hammer

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...
Columns - image credit / unsplash.com/Héctor J.Rivas

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...
size matters : image credit - Pixabay.com/NjoyHarmony

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...
Chameleon : image credit - unsplash.com/erwan_hesry

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...
Big_Ben: Image credit - unsplash.com/michael Jin

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,...
Dates : Image Credit Unsplash.com

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

Excel-Killer : Image credits Image by Esa Riutta from Pixabay and Image by Clker-Free-Vector-Images from Pixabay

Has Brookson found an Excel killer?

At Alteryx Inspire, Enterprise Times spoke to Brian Millrine, Group Strategy Director at Brookson and Andrew Bate, Advanced analytics manager at Brookson. Brookson offers...
smart city

Quant Network and Constellation Network announce Smart Cities partnership

Constellation Network (Constellation) - a software, big data and blockchain company - is integrating its secure communications protocol with Quant Network's (Quant’s) Overledger. The...
Giving Appian partners guidance on solution building and architecture (Image Credit: Ian Murphy)

What guidance do Appian partners get on solution building and architecture?

At Appian Europe, Enterprise Times caught up with Sathya Srinivasan to talk about how he is growing the Appian partner ecosystem. Srinivasan is Vice...
(Image credi

Report highlights Asia Pacific digital transformation market

Research and Markets has published a new report titled: "Digital Transformation Asia Pacific: 5G, Artificial Intelligence, Internet of Things, and Smart Cities in APAC...
Wallet

Crypto.com security assessed by Kudelski Security

Crypto.com, a payments and cryptocurrency platform, has completed an external security assessment which, it claims, proves its ongoing commitment to security in the cryptocurrency...
Appian Europe foces on the future of low-code (Image Credit: Appian)

Low-code will rule the world

Over the next decade, low-code will rule the world. That, at least, is the position taken by Appian CEO Matt Calkins during his keynote...
Appian Europe 2019 (Image Credit: Appian)

Why low-code and the Appian Platform?

At Appian Europe 2019, Enterprise Times talked with Siter Ali, Area Vice President for Solutions Consulting, EMEA and APAC at Appian. The Appian platform...
Druva unveils new protections for AWS workloads (Image Credit: Druva)

Druva extends protection for AWS workloads

Druva has announced new capabilities to protect customer workloads running in Amazon Web Services (AWS). It is delivering three new capabilities that extend its...
(Image credit/Pixabay/ Werner Moser)

Umbraco launches Heartcore “headless” CMS

Umbraco has launched Umbraco Heartcore, a software-as-a-service (SaaS) "headless" content management system (CMS). The platform supports the structuring and sharing content across multiple platforms,...
Sugarcane

KPMG Origins launches in AP as blockchain track and trace platform

KPMG has launched KPMG Origins in Australia, China and Japan. KPMG Origins is a blockchain-based ‘track and trace’ platform to support multiple industries -...
military jet barrier Image by skeeze from Pixabay

Druva breaks $100 ARR barrier

As 2019 draws to a close Druva has revealed it has now passed $100 million in annual recurring revenue and is continuing to grow....
O2 Image credit Image by jeffwallis from Pixabay

Appian low-code platform gets an update

At Appian Europe, held at the Intercontinental O2, the company has released the latest version of its low-code platform. The release delivers performance enhancements,...
Light Tunnel -Imagecredit Pixabay/Pexels

PwC powers up KYC with Fenergo

PwC will leverage Fenergo’s cloud-based Client Lifecycle Management (CLM) solution to improve its existing Know Your Customer (KYC) and Anti Money Laundering processes. The...
Dean Stocker, CEO and Chairman on stage at Alteryx Inspire (c) 2019 S Brooks

What can the Chief Data Officer achieve in an organisation

Alteryx talk about the Chief Data Officer and its evolution to the Chief Transformation Officer. It is a subject that Enterprise Times spoke to...