The ‘Microsoft Excel’ Archives
Posted July 17, 2019 by

How to Wrap your Text in Excel In Easy Steps [With Video and Images]

In this Tech Recipe, we will deal with everything there is to know about wrapping text in excel. We will discuss why this little gimmick is handy. Furthermore, we will outline a step by step process to help you format your disorderly text in a matter of seconds.

Category Microsoft Excel

Posted July 8, 2019 by

How to Insert a Checkmark in your Excel Worksheet

This tech-recipe will show you three different methods to insert a checkmark in your excel worksheet. In the end, we will also tell you which method will work best for you and why.

Category Microsoft Excel

Posted July 1, 2019 by

How to Remove Blank Rows in Excel Instantly [Easy Steps]

Blank spaces can give your Excel data worksheet a somewhat unprofessional look. Sometimes, they are an essential part of the formatting process. But in most cases, they are extravagant and unwanted. You might have them due to some miscalculations in executing Excel’s automatic shortcuts. Simply deleting cells won’t get the job done. You might lose […]

Category Microsoft Excel

Posted June 25, 2019 by

How to Make a Pie Chart in Excel — Everything You Need to Know

Pie chart is perhaps the most common method to represent data quantitatively. It shows how much of a certain category contributes to the overall population. It is also used to compare one value set from another, but only if the values are too large or too small. Close values are compared best by a bar […]

Category Microsoft Excel

Posted June 14, 2019 by

How to Shade Every Other Row in Excel (Easy Steps)

The stacks of white rows can dull your senses. Shading every other row in Excel can produce a wonderful contrast between these white rows and brighten your Excel experience.

Category Microsoft Excel

Posted June 4, 2019 by

How to Convert Your Excel Spreadsheets to Google Sheets

microsoft excel

Most people prefer working on the smooth interface of Google Sheets. It’s interactive and easily shareable with other users. Because of this users often feel the need to import their Excel files to Google Sheets and work on them there. In this tutorial, we will teach you how to convert your Excel spreadsheets to Google […]

Category Microsoft Excel

Posted May 27, 2019 by

How to Calculate CAGR in Excel (Compound Annual Growth Rate Formula)

To calculate CAGR in Excel, there’s no preset Excel function. However, there’s an easy method with which you can input a custom Excel formula and calculate it.

Category Microsoft Excel

Posted May 22, 2019 by

How to Calculate Percentage in Excel [ Shortcut for % Change]

You can calculate percentage in Excel through many different methods. Some involve formatting cells and use of complex formulae, while others do not. Our main focus will be on the latter.

Category Microsoft Excel

Posted May 21, 2019 by

How to Calculate Standard Deviation in Excel [STDEV.S Formula]

If you’re someone who has to deal with a lot of numbers on a daily basis, you must familiarize yourself with a large array of Excel formulae. To perform basic mathematical operations, such as addition, multiplication, subtraction and Standard deviation (SD), you must learn how these formulae work.

Category Microsoft Excel

Posted May 3, 2019 by

How to Freeze Panes in Excel — Lock Columns and Rows

Dealing with an enormous amount of data is hard in itself. Excessive scrolling and managing rows and columns is a frustrating ordeal, to say the least. However, learning how to freeze panes in Excel is one way of slicing this ordeal into a manageable difficulty.

Category Microsoft Excel

Posted May 1, 2019 by

How to Unmerge Cells in Excel — Three Easy Ways

A merged cell in Excel is formed as a result of coalescence between two cells references, for example, A1 and B1.

Category Microsoft Excel

Posted April 27, 2019 by

How to Lock Cells in Excel — Entire Worksheets and Individual Cells

To protect your data, formulae and other aspects of your excel spreadsheet, it’s essential to learn how to lock cells in Excel. You don’t want someone to tamper with your spreadsheets and make unwanted modifications.