Move Cells, Rows and Columns in Excel

When you move or copy rows and columns, by default Excel moves or copies all data that they contain, including formulas and their resulting values, comments, cell formats, and hidden cells. When you copy cells that contain a formula, the relative cell references are not adjusted. Therefore, the contents of [...]

2022-07-05T00:27:17+05:30Categories: Miscellaneous|Tags: |

Adjust Row Height and Column Width in MS Excel

If you deal with long numbers, names or something that won’t generally fit into a standard cell, you can manually stretch the dimensions of that cell to fit. Microsoft Excel (MS Excel) also allows you to automatically adjust row height and column width. Modify Column Width To change column width [...]

2022-06-18T01:10:45+05:30Categories: Miscellaneous|Tags: |

Group and Ungroup Worksheets in Excel

When we are working with a set of identically structured worksheets, grouping them together can save you a lot of time. You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes made on one worksheet [...]

2022-06-12T16:56:11+05:30Categories: Miscellaneous|Tags: |

How to Use AutoFill in Excel

AutoFill feature in Excel helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence. AutoFill Sequences For Excel to know how to fill in the [...]

2022-06-07T23:28:04+05:30Categories: Miscellaneous|

MPEG MP4 Container Format

MPEG MP4 is a container format that allows video, audio and other related information to be bundled together in a single file. It is largely based on the QuickTime file format. It supports a wide range of codecs. Structure of MP4 Files ISO Base Media File Format (ISOBMFF, MPEG-4 Part [...]

2021-11-11T17:02:44+05:30Categories: Miscellaneous|Tags: |

What is Media Container ?

A single media signal is called Elementary Stream or just Stream. People usually mean the same thing when they refer to the Video Stream as Codec, Media or H.264 Stream. A media container format specification describing how different multimedia data elements (streams) and metadata coexist in files. Common container formats [...]

2021-11-10T13:04:37+05:30Categories: Miscellaneous|

Definition of Aspect Ratio

Aspect ratio is simply the ratio of an image’s width to its height. It is also know as display aspect ratio(DAR) or picture aspect ratio (PAR). If the ratio of an image is different than the ratio of your screen, you may not see the whole image. \begin{align*} Aspect\ Ratio [...]

2021-04-20T15:25:30+05:30Categories: Miscellaneous|

Improve Critical Thinking Skills

What Is Critical Thinking Critical thinking is careful goal-directed thinking. It is the process of actively and skillfully conceptualizing, applying, analyzing, synthesizing, and evaluating information to reach an answer or conclusion. A critical thinker can possess mindsets which could include: Ask relevant, clear questions with a precise and limited scope.Gather [...]

2020-05-02T18:41:09+05:30Categories: Miscellaneous|

Lookaround Assertion | Regular Expression

Introduction Lookahead and lookbehind, collectively called "lookaround", are zero-length assertions just like the start and end of line. Lookaround actually matches characters, but then gives up the match, returning only the result: match or no match. They do not consume characters in the string, but only assert whether a match [...]

2019-10-20T16:34:38+05:30Categories: Miscellaneous|Tags: |

Backreferences | Regular Expression

Introduction Backreferences match the same text as previously matched by a capturing group. Suppose you want to match a pair of opening and closing HTML tags, and the text in between. By putting the opening tag into a backreference, we can reuse the name of the tag for the closing [...]

2019-10-13T13:31:14+05:30Categories: Miscellaneous|Tags: |
Go to Top