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...
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...
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...
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....
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...
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...
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...
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 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...
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 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 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...
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...
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...
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...
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...
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 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...
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
An online poll conducted by NTT Security claims that risks to Operational Technology (OT) are increased due to a lack of skills and visibility....
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 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...
