QuasarConf 2022
Had a great opportunity to share how I’m using Quasar Framework to develop engineering toolsRead More →
From Wikipedia:
https://en.wikipedia.org/wiki/Software_engineering
Software engineering is an engineering approach on a software development of systematic application.
Engineering techniques are used to inform the software development process which involves the definition, implementation, assessment, measurement, management, change, and improvement of the software life cycle process itself. It heavily uses software configuration management which is about systematically controlling changes to the configuration, and maintaining the integrity and traceability of the configuration and code throughout the system life cycle. Modern processes use software versioning.
Had a great opportunity to share how I’m using Quasar Framework to develop engineering toolsRead More →
Table is a general abstraction of a Table object for the .NET environment. Table is a simple project I created to be used as part of larger projects. It allows you to quickly add an abstraction to use data tables and related functionality. How to use Table Check the GitHubRead More →
Create an Excel lookup formula that searches a table using criteria from various columns. It mimics the functionality of the native VLOOKUP() formula using a combination of the INDEX() and MATCH() function. Ingredients Microsoft Excel The Need There is no doubt that one of the most useful and often used Excel functionsRead More →
Short Description Create a simple Excel function that returns the name of the Worksheet where that cell is. Ingredients Microsoft Excel The Need When working with Excel Workbooks that contain multiple Worksheets, you might need to get the name of the each Worksheet in formulas. For example, I have aRead More →
Short Description Add a Custom Tab to the Office Ribbon with controls to trigger your code functions. Ingredients Microsoft Office Custom UI Editor for Microsoft Office The Need When building custom functionality or macros in a Excel or Word, you might want to provide the user with a User InterfaceRead More →
Short Description Create an Excel Add-in that allows you to add Application Settings functionality on any Workbook. Store and retrieve setting names and values on a centralised location and accessible anywhere from your VBA modules and classes. Ingredients Microsoft Excel The Need Sometimes when you are creating an Excel tool or application,Read More →
Short Description Perform searches in Excel rows or columns and extract data in any direction from the found reference. The final form of this recipe is: Searching a column and returning a value in another column =INDEX(<Column to extract value from>,MATCH(<Value of criteria used for looking>,<Column to be searched forRead More →
Copyright © 2023 Engineers Tools