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