Learn Design & Programming

microsoft office excel
, , , , , ,

How To Identifying Duplicate Values in Microsoft Office Excel Part 1

From time to time, you may need to identify duplicate values with a list in Excel. Modern versions, including Excel 2007, 2010, 2013 and later, provide this capability with just a few mouse clicks. For good measure, I'll also describe…
microsoft office excel
, , , , , ,

How to Create Dynamic Cascading List Boxes In Excel

You may know how to create cascading validation drop down list in Excel. However, how to create dynamic cascading list boxes in Excel? This article introduces a VBA method to get it down. As below screenshot shown, you need to create a parent…
microsoft office excel
, , , , , ,

How To Extract first letter of each word from sentence in Excel

Supposing you have a list of countries’ name in your worksheet, and now, you need to extract the first letter of each word in the cell as following screenshots shown. Normally, there is no direct feature to pick up the first letter of each…
Linux-Distributions Distors
, ,

Understand Different Desktop Environments for Linux

In Linux, there are so many choices, and this includes the desktop environments and window managers. The most popular desktop environments in Linux are GNOME, Unity, Cinnamon, MATE, KDE, Xfce, and LXDE. All of them offer sophisticated…
microsoft office excel
, , , , , ,

How to quickly add dollar sign ($) in formulas in Office Excel

In Excel, you put dollar signs in a cell reference to keep it fixed when you copy a formula around.  It's laborious having to type dollar signs into a cell reference, but fortunately there's a keyboard shortcut you can use instead! Start…
microsoft office excel
, , , , , , ,

How to quickly Concatenate Columns data in Office Excel

In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column. Common…
microsoft office excel
, , , , , , ,

How to quickly copy a Formula in Excel

There are many ways to copy a formula down a column in Excel, but by far the quickest is to simply double-click on the AutoFill Handle.  To do this: Select the cell containing the formula you want to copy. Hover the mouse cursor over…
microsoft office excel
, ,

Linux Command Line Tutorial: Manipulate Terminal with CD Commands

The most frequent tasks that you perform on your PC is creating, moving or deleting Files. Let's look at various options for File Management. To manage your files, you can either use Terminal (Command Line Interface - CLI) File manager…
microsoft office excel
, ,

Linux vs Windows: What's the Difference?

It's time to make the big switch from your Windows or Mac OS operating system. Mac OS uses a UNIX core. Your switch from Mac OS to Linux will be relatively smooth. It's the Windows users who will need some adjusting. In this tutorial will…
microsoft office excel
, ,

Download & Install Linux (Ubuntu) in Windows or standalone

Now that we know what Linux is, it is the time that to learn how we should install it on the computer and choose which Distribution we should use. Let us start by understanding what a Linux Distribution is. In this tutorial, we will learn…