Looking at ranges can be fun - source image: freeImages.com / Tamlyn Rhodes

Tips – using range lookup in the Vlookup function in Excel.

In my last tip, Using Vlookup in ExceI, I explained how to create a Vlookup function. I only showed you how to use the first three lines of this function and...
numbers - Image Source: Pixabay Free Images

How to create Multi-level Numbering in Word

Numbering in Word is a bit of a nightmare at times and if you need multi-level numbering this could cause you much stress if you rely on the mouse alone. Using...
Cheetahs Source Image: Unsplash.com/ Roberta Doyle

Shortcut keys in Excel for Data, Functions and Formula Bar (5 of 8)

This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar. I have highlighted for you some that I find very useful...
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....
landscapes-in-nederlands : Image Source - Freeimages.com/ Daniel Hanai

Repeated Header rows in a Word Table

Microsoft Word is a great place to create a table for lists and the like. Sometimes my students have such long lists that they flow over to the next page and...
champagne

Tips – Fill Series in Excel Spreadsheets

In an earlier tip I explained how to use the Autofill feature in Excel. It is a wonderful time saving tool. Now I will explain the Fill Series feature where numbers and dates...
Indentations - Image source: Pixabay.com

Indentation explained for MS Word

When you create a word document the default settings for a paragraph are to have a left aligning paragraph and no indentation for the second and subsequent lines within that paragraph. I...
Validation : Image Source - Pixabay.com /Jackmac34

Setting up validation rules in an Excel Spreadsheet

When you have a file with data that has been updated by several people, do you find that the data is not quite what you need? Some fields could hold hold inconsistent...
Exit - Image Source : pixabay.com

Exit from an application in Windows.

Do you get thoroughly frustrated when you have worked hard all day and then you need to spend what seems like half an hour closing and saving files you have used...
Feet -Image Source: unsplash.com / ben-weber

The use of footers in PowerPoint

Do you look closely at the slides of a presentation during a meeting? You need to! This will help you create even better presentations yourself. Each presentation you sit through is...

LATEST NEWS

Visa B2B Connect

Visa B2B Connect launches for global crossborder payments

Visa has launched globally its Visa B2B Connect (VB2BC) network. This offers financial institutions the ability to process high-value corporate cross-border payments and covers...
Icertis with logo

Icertis, with Microsoft, expands its Blockchain Framework

Icertis, a provider of enterprise contract management in the cloud, is collaborating with Microsoft to expand the Icertis Blockchain Framework to create a more...
Linux Foundation Logo

Accord Project to develop open source framework for smart legal contracts

The Linux Foundation has launched the Accord Project, under the auspices of the Linux Foundation. The Accord Project is a nonprofit which will build...
Tableau survey shows lack of analytics skills

Salesforce doubles down against SAP with Tableau acquisition

Salesforce has signed a definitive agreement to acquire Tableau for $15.7 million. The announcement comes a few months after SAP paid $8 billion for...
Network API Image credit Pixabay/Geralt

WSO2 API Manager adds Ping API security platform

WSO2 and Ping Indentity have partnered to integrate their two products. The open source WS02 API Manager can now integrate with the PingIntelligence API...
Sky Republic Logo

Atlas – an enterprise blockchain platform to improve B2B

Sky Republic, an enterprise blockchain company founded by B2B software veterans, has launched Atlas, a smart contract platform built to synchronize B2B ecosystems. With...
(Image credit/Pixabay/Geralt)

Industry wants 5G, but barriers remain according to Capgemini report

Industrial companies are embracing 5G connectivity as a primary enabler of digital transformation and plan to implement the technology within two years. This is...
Solve.Care

Solve.Care launches blockchain network for diabetes patients

Solve.Care is partnering with Boehringer Ingelheim, the big pharma company, to launch a global healthcare platform using blockchain technology for the administration, coordination and...
Arc tools

ARK Deployer : create a blockchain in simple steps

ARK, a blockchain technology vendor (with no connection to ArcNet), has launched ARK Deployer. This is a free tool which enables users quickly and...

TRON plans blockchain addition to BitTorrent File System Protocol

TRON, a blockchain platform, has announced its plan to incorporate decentralised storage (as another blockchain solution) into the BitTorrent ecosystem. This represents another step...
Risks to OT increased through lack of skills 

Risks to OT increased through lack of skills

An online poll conducted by NTT Security claims that risks to Operational Technology (OT) are increased due to a lack of skills and visibility....
DIF

ArcBlock joins the Decentralized Identity Foundation

ArcBlock has officially joined the Decentralized Identity Foundation (DIF). This is a consortium formed to create and promote an ecosystem where decentralised identities use...

Need to change the data in a cell from lots of characters to just...

My students come to me with all sorts of questions. One that seems to come up every so often is how to easily change...
wine cellar

Wine comes to blockchain via TATTOO

Blockchain Wine Pte Ltd (BWPL) has selected EY to provide services to build a blockchain solution - TATTOO - leveraging EY's OpsChain Solution. BWPL...