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,...
Tips – How to use Flash fill in Excel
Over the past 25 years I have constantly been asked how to easily extract single words out of multiple words in a cell in Excel. This is normally because people receive...
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...
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...
What is and how to use the Outline View in MS Word
When you first go into Word the default view is Print Layout. This shows you the size of the paper, margins and an indication of the font and size of text...
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...
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...
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...
Tip – Drawing Tables in Word
I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells...
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....
LATEST NEWS
Can Pyramid Analytics soar with new funding?
Pyramid Analytics has announced a $25 million growth equity funding round led by Jerusalem Venture Partners (JVP). The funding comes five years after its...
Cartesi launches Layer-2 Linux infrastructure for developing blockchain DApps
Cartesi has provided what it says is the first ever dApp infrastructure which runs an operating system (OS) on top of blockchains. It launched...
WSO2 adds passwordless authentication
WSO2 has added Passwordless Authentication with FIDO2 in the latest version of its WSO2 Identity Server 5.10.0. What this means is that WSO2 is...
Asana launches Do not Disturb for home workers
Asana has announced the a new Do Not Disturb feature for its work management tool. The feature is targeted at workers who are now...
James Hambro & Partners selects InvestCloud for digital transformation
Independent wealth management group James Hambro & Partners (JH&P) has selected global FinTech firm InvestCloud to support its digital transformation. The company expects the...
Open Application Network partners with Bloq for blockchain infrastructure
Bloq has announced it will provide infrastructure continuity for the Open Application Network (OAN). It is picking up from where one of OAN's existing...
Ginp banking malware tricks users with Coronavirus Finder
The Ginp banking trojan has new functionality according to security company Kaspersky. It is taking advantage of people's concerns over COVID-19 with a "Coronavirus...
Accelo improves visibility of task progress
Accelo continues to develop its product and has released several updates to support users.
Most of the new feature improvements and bug fixes are not...
SAP Ariba extends supply chain capabilities
There were two key announcements during the virtual SAP Ariba Live ‘event’ last week. Goldman Sachs is to offer global payments on the Ariba...
Professional Services still buoyant on 2020 revenues
BigTime Software has published the results of a survey into the impact of COVID-19 on North American professional services business. The results were drawn...
SAP Ariba Live goes virtual and Discovery becomes free
SAP Ariba Live, scheduled for Las Vegas in mid-March, went virtual as COVID-19 continued its depredations of the global event and travel industry. Rather...
RPA and AI are most effective when a human is involved
Just before Covid-19 caused the mass cancellation of conferences, Enterprise Times visited Appian to meet with Matt Calkins, CEO and other senior members of...
VirusBlockchain – for community and workplace monitoring
The Public Health Blockchain Consortium (PHBConsortium.org) has announced the release of a monitoring blockchain (VirusBlockChain) for the systematic, continued and anonymous verification of communities...
NutriBullet blames RiskIQ for delayed breach response
NutriBullet was hit by a malware attack in February that continued for over a month. Two days ago, RiskIQ published a blog showing that...
