by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Cloud Services Artiles
What is cloud computing? Cloud computing delivers IT resources like compute power, storage, databases, virtual machines, and more through a web-based platform. Public cloud platforms like AWS own and maintain the costly hardware, such as servers and data centers,...
by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Trends
The following list in no particular order are the Artificial Intelligence (AI) trends you need to watch out for in 2020. 1. Robotic Process Automation (RPA) Robotic Process Automation (RPA) is a simple AI technology, but also one of the most disruptive. Imagine...
by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Have you wanted to compare two different spreadsheets in MS Excel to figure whether or not the data in them is different, or alternatively, whether there are any duplicate rows? Manually going through the entire list of data is a herculean task. Fortunately, MS Excel...
by dayo ade | Mar 3, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Microsoft Excel is extremely versatile and this leads to it being the most popular spreadsheet software in the industry today. This widespread use of Excel is more often than not likely to lead to situations where you want to find the difference between certain...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Mysql Database Articles
The data type of a column defines what value the column can hold: integer, character, money, date and time, binary, and so on. SQL data types can be broadly divided into following categories. Numeric data types such as int, tinyint, bigint, float, real etc.Date and...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Project Management Tutorials and Articles
Oracle Primavera P6 EPPM Version 19 is out with some exciting new features and below we did a list of all the latest update. Allow multiple users to access a PortfolioImprovements to the Project Statistics Portlet: You can group and sort the data and view all levels...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
There are multiple ways to accomplish everything in Excel. But sometimes, the quickest way is not the most obvious way. I just retired from the seminar circuit, but I present here four of the most painful customer stories. Each of these are from real people who ran...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
The highly anticipated XLOOKUP function in Excel is available generally for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel. XLOOKUP helps users find...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Microsoft Excel Articles
Every financial analyst or accountant spends more time in Excel than they may care to admit. Based on years and years of experience, we have compiled the most important and advanced Excel formulas that every world-class financial analyst and accountant...
by dayo ade | Feb 27, 2020 | Articles and Short Tutorials, Dynamo Articles
In this blog post, I’ll continue the subject I started a few weeks ago. In Part 1 I covered how structural engineers and detailers can automate reinforcement designs with Dynamo in the example of straight rebars around window and door openings. Let’s extend...