While selecting text using mouse, Ms Word sometimes selects more than you need. This is one of the annoying feature of Ms Word and is one of the most searched in superuser. Steps to stop word from selecting more Navigate Files > Options to open Ms Word options window Click Advance Uncheck the box against “When selecting, automatically select entire word” in “Editing options” group Result After the above setting,… Read More »How to stop Ms Word from selecting more than you need
Ever wondered how to align text left and right on same line in Ms Word. The trick is to use tab spacing and is explained in following steps. Setting up tab space to align text left and right align on same line in Word 1: Make sure the “Ruler” is visible. Navigate to View Tab and check the box against “Ruler” to display ruler. 2: Change “Left Tab” to “Right… Read More »How to align text left and right on same line in Ms Word
The programming logic for finding the smallest number is easy. However, what if you want to find the second smallest number? This blog covers two different ways to find the second smallest number in the list by using Python. Method 1 (simple but inefficient): By sorting array The first program is the standalone program, where the user is asked to populated the list during run time. Then sort the list… Read More »Finding the Second Smallest Number in Array Using Python
Pi (π or Π) is one of the most commonly types Greek alphabets in Ms Word. Of the four different ways to type Pi symbol in Word, Math Autocorrect is my favourite. Apart from being the fastest of all, it has the easy to remember keyboard shortcut. Ms Word Pi shortcut Type \pi and hit spacebar to get lower case of Greek letter pi (π). Similarly, to get upper case… Read More »Ms Word shortcut for Pi (π or Π) symbol
Table of contents, page number, list of figures/tables/equations, figure/table/equation number and cross reference are some common example of fields. Sometimes you need to update all fields in Ms Word rather than updating each one by one. There are a couple of ways to do it. However, each method has its limitations and doesn’t update each type of field. This blog describes the correct procedure that ensure every field are updated… Read More »How to update all fields in Ms Word for Windows & MacOS
There are three different ways to type degree symbol in Mac. Place the cursor at the location where you need degree symbol and use any of the following methods. Three ways to type degree symbol in Mac Method 1: Emoji and Symbols (commonly used method) Navigate Edit > Emoji & Symbols to open symbol and emoji search window. Alternatively, you can also use “Control + Command + Space” keyboard shortcut.… Read More »How to Type Degree Symbol in Mac
The CREATE TABLE statement is used to creating a table in the provided schema. If a schema name is given, then the table will be create in the specified schema. Otherwise it will create in the current schema. The tables cannot have the same name as any existing data type in the same schema because CREATE TABLE statement automatically creates a data type that represents the composite type corresponding to one… Read More »Creating Tables in PostgreSQL
Many of the Microsoft Word document formats requires header only on the first page. There are different methods to achieve it. Some method includes insertion of section break in the first page as an additional step while other simply involves ticking a check box. Here we will cover the latter one which is simple and faster. Steps to Insert Header Only on First Page The following method works in Word… Read More »How to Insert Header Only on First Page of Ms Word document
For inserting a new field in an existing table, use the ALTER statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. To add a new column to an existing table, use the ADD COLUMN statement. Syntax Specify the name of the table that you want to add a new column to after the ALTER TABLE keyword and then specify the name of the new column with its data type and… Read More »Adding one or more Column in Existing Table in PostgreSQL
PostgreSQL is one of the popular object-relational database management system (ORDBMS). It was developed at the Computer Science Department at the University of California. PostgreSQL is easy to set up and install. It offers support for SQL and NoSQL. It has a great community which happy to serve you when you are facing issues while using PostgreSQL. Data Science has evolved, and while many data scientists still work with CSV files… Read More »PostgreSQL : DBMS of the Year