Hide/Unhide the Columns or Rows in Excel
Hiding the rows or columns in Excel is just the matter of right clicking on the column letter or row number and pressing the Hide option in the menu.
Demos and Full Guide
Excel Filter Introduction
Thanks to Excel built-in functionality, you may filter data and return only desired rows or columns by certain criteria.
Demos and Full Guide
Moving Columns and Rows in Excel
In simple terms, moving the rows and columns in Excel is just the matter of copy and paste or pressing the short keys Ctrl + X and Ctrl + P, that you might already used too while working in Excel, MS Word or other programs.
Demos and Full Guide
Freezing Columns in Excel
In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.
Demos and Full Guide
2 Ways to On/Off Scroll Lock for Excel
If you suddenly start seeing navigating from cell to cell is stopped while pressing the arrow keys and rather navigating in the worksheet then your scroll lock is ON.
Demos and Full Guide
Protecting Cells in MS Excel
In this tutorial, you will learn how to password protect a cell, multiple cells, a row and multiple rows in MS Excel.
Demos and Full Guide
How to freeze panes in Excel?
Freezing the rows or columns while working in a long workbook can be really useful. For example, the top row contains the headers of the workbook and while entering data or analyzing it
Demos and Full Guide
What is Excel MOD function?
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
Demos and Full GuideThe Kotlin map collection
The map is an interface and a collection in Kotlin. Maps are used to hold the pairs of objects in the form of key/value.
Demos and Full GuideWhat is Kotlin lambda?
In Kotlin, you may define and use the lambda and anonymous function, that is called “function literals”.
Demos and Full Guide
What is list in Kotlin?
A list is a generic collection of elements. Kotlin has three Collections while List is one of those. The other two collections are Set and Map.
Demos and Full GuideWriting Kotlin Hello World program
The Kotlin code below simply displays the “Hello World” on the screen and this is followed by explaining code lines in that program:
Demos and Full Guide
How Kotlin while loop works?
In Kotlin, the while works just like in Java. So, if your background is Java then you already know how it works. For beginners, the while loops execute a block of code until the given condition is True.
Demos and Full Guide
What is an array in Kotlin?
The array class represents an array in Kotlin. Array class has get and set functions. The items in array are called elements.
Demos and Full Guide
How Kotlin if works?
Kotlin if is an expression that returns a value. This is different if compared with the other languages where if acts as a statement. As, it acts as an expression in Kotlin, so there is no ternary operators (condition ? then : else).
Demos and Full Guide