Category: Basic

0

Hide and Unhide Excel Worksheets from a Workbook

Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives as we have already discussed viewing...

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

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

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()”....