Tech Tips Flashcards
Data load for Pivot automatically in Excel
Have macro enabled in excel .xlsm
Create a table for the data set - this helps in tracking the addition/updation/deletion of data into the pivot
Create pivot for the dataset using the created table - for data consolidation
create a macro -alt+F11 to with worksheet selected- change event- thisworkbook.Refreshall- to have all the pivot and connections refreshed based on the changes to the worksheet
Node.js
Node.js is an open-source, cross-platform, JavaScript runtime environment that executes JavaScript code outside of a browser. Node.js lets developers use JavaScript to write command line tools and for server-side scripting—running scripts server-side to produce dynamic web page content before the page is sent to the user’s web browser. Consequently, Node.js represents a “JavaScript everywhere” paradigm,[6] unifying web-application development around a single programming language, rather than different languages for server- and client-side scripts.
Though .js is the standard filename extension for JavaScript code, the name “Node.js” doesn’t refer to a particular file in this context and is merely the name of the product. Node.js has an event-driven architecture capable of asynchronous I/O. These design choices aim to optimize throughput and scalability in web applications with many input/output operations, as well as for real-time Web applications (e.g., real-time communication programs and browser games).[7]
The Node.js distributed development project was previously governed by the Node.js Foundation,[8] and has now merged with the JS Foundation to form the OpenJS Foundation, which is facilitated by the Linux Foundation’s Collaborative Projects program.[9]
Corporate users of Node.js software include GoDaddy,[10] Groupon,[11] IBM,[12] LinkedIn,[13][14] Microsoft,[15][16] Netflix,[17] PayPal,[18][19] Rakuten, SAP,[20] Voxer,[21] Walmart,[22] and Yahoo!.[23]
npm
npm (originally short for Node Package Manager)[3] is a package manager for the JavaScript programming language. It is the default package manager for the JavaScript runtime environment Node.js. It consists of a command line client, also called npm, and an online database of public and paid-for private packages, called the npm registry. The registry is accessed via the client, and the available packages can be browsed and searched via the npm website. The package manager and the registry are managed by npm, Inc.
Compiling
Compile is the process of creating an executable program from code written in a compiled programming language. Compiling allows the computer to run and understand the program without the need of the programming software used to create it.
A compiler is a special program that processes statements written in a particular programming language and turns them into machine language or “code” that a computer’s processor uses. Typically, a programmer writes language statements in a language such as Pascal or C one line at a time using an editor.
Microsoft LTS
LTS releases include features and components that have been stabilized, requiring few updates over a longer support release lifetime. These releases are a good choice for hosting applications that you do not intend to update often.
Microsoft Current releases
Current releases include features and components that are new and may undergo future change based on feedback. These releases are a good choice for applications in active development, giving you access to the latest features and improvements. You need to upgrade to later .NET Core releases more often to stay in support.
Both types of releases receive critical fixes throughout their lifecycle, for security, reliability, or to add support for new operating system versions. You must stay up-to-date with the latest patches to qualify for support.
Microsoft Support for .NET Core
Microsoft Support for .NET Core
Every Microsoft product has a lifecycle, including .NET Core. The lifecycle begins when a product is released and ends when it’s no longer supported. Knowing key dates in this lifecycle helps you make informed decisions about when to upgrade or make other changes to your software. This product is governed by the Microsoft Modern Lifecycle.
This document describes the support lifecycle for: .NET Core, ASP.NET Core and EF Core.
The .NET Core OS Lifecycle Policy describes support for various operating systems.
.NET Core Releases
This table describes support type, supported patch version and end of support date for .NET Core releases.
Version Release Date Support Level Supported Patch Version End of Support
.NET Core 3.1 December 3, 2019 LTS 3.1.2 December 3, 2022
.NET Core 2.1 May 30, 2018 LTS 2.1.16 August 21, 2021
For previous versions, see here.
Release Types
Microsoft produces Long Term Support (LTS) and Current releases, which are defined as:
LTS releases are designed for long-term support. They included features and components that have been stabilized, requiring few updates over a longer support release lifetime. These releases are a good choice for hosting applications that you do not intend to update.
Current releases include new features that may undergo future change based on feedback. These releases are a good choice for applications in active development, giving you access to the latest features and improvements. You need to upgrade to later .NET Core releases more often to stay in support.
Both types of releases receive critical fixes throughout their lifecycle, for security, reliability, or to add support for new operating system versions. You must stay up-to-date with the latest patches to qualify for support.
Release Support Policies
.NET Core releases are supported according to the following policies.
Long Term Support (LTS) releases
LTS releases are supported for three years after the initial release.
Note: .NET Core 1.x was released under an earlier definition of LTS. See: .NET Core 1.x “shorter” LTS definition.
Current releases
Current releases are supported for three months after a subsequent Current or LTS release.
Maintenance releases
Maintenance releases are in the last stage of the lifecycle . During Maintenance, a release will receive security updates. The length of Maintenance time is 3 months for Current and 1 year for LTS.
End of support
End of support refers to the date when Microsoft no longer provides fixes, updates, or online technical assistance. As this date nears, make sure you have the latest available update* installed. Without Microsoft support, you will no longer receive security updates that can help protect your machine from harmful viruses, spyware, and other malicious software that can steal your personal information.
- Updates are cumulative, with each update built upon all of the updates that preceded it. A device needs to install the latest update to remain supported. Updates may include new features, fixes (security and/or non-security), or a combination of both. Not all features in an update will work on all devices. Update availability may vary, for example by country, region, network connectivity, or hardware capabilities (including, for example, free disk space).
Out of support .NET Core releases Version End of Support .NET Core 3.0 March 3, 2020 .NET Core 2.2 December 23, 2019 .NET Core 2.0 October 1, 2018 .NET Core 1.1 June 27, 2019 .NET Core 1.0 June 27, 2019
DMZ demilitarized zone
In computer security, a DMZ or demilitarized zone (sometimes referred to as a perimeter network or screened subnet) is a physical or logical subnetwork that contains and exposes an organization’s external-facing services to an untrusted, usually larger, network such as the Internet. The purpose of a DMZ is to add an additional layer of security to an organization’s local area network (LAN): an external network node can access only what is exposed in the DMZ, while the rest of the organization’s network is firewalled. The DMZ functions as a small, isolated network positioned between the Internet and the private network and, if its design is effective, allows the organization extra time to detect and address breaches before they would further penetrate into the internal networks.
The name is from the term “demilitarized zone”, an area between states in which military operations are not permitted.
Excel sql queries
https://chandoo.org/wp/sql-insert-update-statements-from-csv-files/
Excel drop down list
https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2
Excel Vlookup
https: //stackoverflow.com/questions/8295816/how-to-create-an-excel-dropdown-list-that-displays-text-with-a-numeric-hidden-va
https: //exceljet.net/excel-functions/excel-vlookup-function
https: //www.youtube.com/watch?v=iJ1MO2xx8wQ
https: //support.microsoft.com/en-us/office/how-to-correct-a-n-a-error-in-the-vlookup-function-e037d763-ffc3-4fae-a909-89c482d389b2
https://exceljet.net/formula/vlookup-if-blank-return-blank
Excel How to correct a #N/A error for Vlookup
https://support.microsoft.com/en-us/office/how-to-correct-a-n-a-error-a9708411-f82e-4e1b-8a7e-28c28311b993
vlook up looks at the first column
https://support.microsoft.com/en-us/office/how-to-correct-a-n-a-error-in-the-vlookup-function-e037d763-ffc3-4fae-a909-89c482d389b2
Select all the cells in a column and copy the formula in excel
Enter your desired formula into the 2nd row of the column you want to fill.
Make sure to use $ for any referenced cells where the row stays the same for all equations.
Select the cell containing the formula, and press Ctrl + Shift + Down.
This should select all cells in that column between the selected cell and the very bottom.
Then press Ctrl + D.
This should fill all the selected cells with the forumla you entered into the 2nd row’s cell.
Explaining the $ sign a little more.
Example: =VLOOKUP(A2,$B$2:$C$21,2)
Here the value for B2:C21 will be constant for all the cells.
