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
, ,

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…
microsoft office excel
, ,

Grouping or Ungrouping Sheets in Office Excel

Grouping and Ungrouping sheets in excel is a way to perform a task quickly in one sheet & it will automatically update in the selected sheets. It saves time & eliminates any error if you want the graphical objects to be in the same position…
microsoft office excel
, ,

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…
microsoft office excel
, ,

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…
microsoft office excel
, ,

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…
microsoft office excel
, ,

Understanding Workbooks and Worksheets in Excel

An Excel file, often referred to as a workbook, contains one or more spreadsheets, or worksheets. Each box in the worksheet area is referred to as a cell. Each cell has a cell address, which is composed of a column reference and a row…
microsoft office excel
, , ,

What is INSERT Tab and it's uses in Office Excel

We use Insert tab to insert the picture, charts, filter, hyperlink etc. We use this option to insert the objects in Excel. To open the insert tab, press shortcut keys Alt+N. Insert tab contains 10 (ten) groups: Tables Apps…