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...
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,...
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...
LATEST NEWS
State of California formalises interest in blockchain
California Government Operations Agency Secretary Marybel Batjer has selected Camille Crittenden, Executive Director of the Center for Information Technology Research in the Interest of...
Duplication in PowerPoint
How many times do you create a pretty box or object in PowerPoint and need to have exactly the same again and again and...
Standard Chartered executes Letter of Credit on Voltron blockchain
Standard Chartered Bank has announced the successful execution of a pilot transaction for PTT Group (PTT International Trading Pte Ltd) and IRPC Public Company...
Considerations when selecting a PSA solution
Enterprise Times sat down with Kevin Roberts, Product Evangelist at Kimble Applications. Roberts joined Kimble recently having spent several years at a competitor. The...
It’s time for software delivery to be a core business process
As Jenkins turns 15, Enterprise Times caught up with Sacha Labourey, CEO, Cloudbees at Jenkins World / DevOps World to talk about the companies...
Advanced obtains funds for growth
Advanced has announced that Vista Equity partners has sold a share of Advanced to BC Partners. Vista acquired Advanced in 2015 for £750 million....
NTT Security does threat intelligence deal with Europol
NTT Security has signed a Memorandum of Understanding (MoU) with Europol's European Cybercrime Centre (EC3). The deal sees the two organisations share threat intelligence....
Finboot secures Repsol investment after blockchain PoC
Finboot will supply Repsol with its blockchain technology solution BlockLabs after a successful blockchain Proof of Concept (PoC) conducted with the Spanish energy company....
Threat hunting, attribution and identifying what motives threat actors
Jaime Blasco is the AVP Product Development at Alien Labs, part of AT&T Cybersecurity. At Black Hat 2019, Jaime sat down with Enterprise Times...
IBM and Tata Communications join Hedera Governing Council
Hedera Hashgraph, a distributed ledger platform for enterprises, has announced that IBM and Tata Communications have joined the Hedera Governing Council. The Council -...
Deltek to acquire construction accounting vendor ComputerEase
Deltek has further strengthened its grip of the construction software industry with an agreement to acquire ComputerEase. The deal will see Deltek add over...
How does Glasswing Ventures choose the right start-ups?
Every day seems to bring more cybersecurity and AI start-ups. At Black Hat 2019, there were lots of companies claiming how their AI could...
MexiCar, a vehicle application storing tamper-proof data on blockchain
DeepCloud AI is developing MexiCar, a blockchain- and AI-powered platform to store, secure and track ownership and vehicle registration information. The platform will integrate...
Salesforce to buy ClickSoftware
Salesforce is planning to buy ClickSoftware, a management solutions service provider. ClickSoftware enables companies to schedule and optimise field service work. Salesforce Field Service...
