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...