Category: Basic

0

How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders in the worksheet. They are quite handy...

Operators, Precedence, Excel, Associativity 2

What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you can use them to build complex Excel formulas. Here...

0

15 Best Online Excel Training for Basic & Advanced Users with Certification

“Note: Are you a basic Excel user? Or an advanced level user? And searching for the best online Excel courses? And don’t want to spend the top dollars on the training? You’re at the...

Paste Special Command in Excel Image 1 0

What is and how to use paste special command in Excel

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across almost every Windows application. By pressing “Ctrl-V” or clicking “Paste”,...

Excel, Watch Window, Bank Data 0

Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important are the last row of the data containing, say, the daily sum of sales, or percentage of...

How to copy formula in Excel 0

How to copy formula in Excel

While you are working with Excel, you will have to copy formula frequently from one cell to other cells. Here is how you will do this: Select cell B4 and enter this formula “=RAND()”....

How to use Flash Fill in Excel 2013 0

How to use Flash Fill in Excel 2013

Flash Fill is one of most important features newly added in Excel 2013. Flash Fill technique can recognize pattern in a text and you can separate part of a text in a new column...

Understanding contextual tabs in Excel Ribbon 0

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kind of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual tabs contain commands related to objects that...

Mouse Conventions 1

Mouse Conventions

Some mouse related terms we shall use in the tutorials of Excel 2013. Mouse Pointer: When we move our mouse, a small graphic figure moves onscreen. The mouse pointer is generally an arrow but...