Posts

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…

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…

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…

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…

How to Activate Two-Factor-Authentication in Google and GMail
When you forget or lose your password, services will often email you to confirm your identity and reset it. This makes email the golden key to all of your other online accounts. If your email password is compromised with no second layer of authentication…

Complete list of Keyboard Shortcuts for Microsoft Office Powerpoint
Using Microsoft Office Powerpoint for making presentation is great but very tedious sometimes if you don't find anything that you want in Ribbon.When we present something in Office Powerpoint, it's really good if we don't use mouse. With…

Quickly Select a Range in the Workbook in Office Excel
There are two options to select a range of cells quickly:Either you can Select the first cell, press Shift, select another cell and then click the mouse or Select the first cell, type the address of the last cell in the Name box, and then…

Customize the Quick Access Toolbar in Office Excel
The small buttons at the top-left side of the Excel screen are known collectively as the Quick Access Toolbar. By default, the Quick Access Toolbar contains three commands: Save, Undo, and Redo. If you click the drop-down selection arrow next…

Understanding Contextual Tabs in Office Excel
Contextual tabs are special types of tabs that appear only when a particular object is selected, such as a chart or a shape. These contextual tabs contain commands specific to whatever object you are currently working on.For example, after…

Familiarizing with the Ribbon Menu and Tabs in Office Excel
Like any other application, Excel has a basic workspace called the user interface. A user interface is the combination of screens, menus, and icons you use to interact with an application. In Excel, the user interface is primarily composed…