You may list your data in Microsoft Excel, but you may decide to sort your data or one column to fit your needed and analysis. Today, we are going to show you how to sort column data in Excel? You can sort your Excel data on one column or multiple columns. You can sort in ascending or ..
Have you wounder How to Change Chart Type in Excel? In today Microsoft Excel tutorial, we are going to show you How to Change Chart Type in Excel You can easily change to a different type of chart at any time. 1. Select the chart. 2. On the Design tab, in the Type group, click ..
In today’s Excel tutorial, we are going to show you How to create Charts in Excel. A simple chart in Excel can say more than a sheet full of numbers. As you’ll see, creating charts is very easy. Create a Chart To create a line chart, execute the following steps. 1. Select the range A1:D7. Advertisement 2. On the ..
Today tutorial, we are going to show you how to create Pivot Tables in Excel? Pivot tables are one of Excel‘s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country. ..
If you are working with a large set of data in Microsoft Excel, you may get confused and would like to locate/find particular data. It is going to be hard to go along all the columns and raws. One easy way to find it is by using the Find and Select data in Microsoft Excel. ..
Templates are very important for people who are using Microsoft Excel. They can save you time and effort instead of building a new one. In today’s Microsoft Excel tutorial, we are going to show you How to create Templates in Microsoft Excel? Instead of creating an Excel workbook from scratch, you can create a workbook based on ..
If you are working a lot with Microsoft Excel, you may need to know What are the top Keyboard Shortcuts in Microsoft Excel? because they save you time. Today, we are going to present to you some of the top Keyboard Shortcuts in Microsoft Excel Keyboard shortcuts allow you to do things with your keyboard instead ..
Logical Functions such as if, and, or, and not are very important to build your Microsoft excel worksheet. They help in creating budgets and analysis. Today, we are going to show you How to add Logical Functions in Microsoft Excel? Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If ..
In this Excel tutorial, we are going to show you How to Move or copy cells and cell contents in Excel Use Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes from the cells. For example, copy the resulting value of a formula without copying the formula, or copy only the formula. ..
In this post, we will show how to Insert and delete rows and columns to organize your worksheet better in Excel. Insert or delete a column in Excel Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns. Alternatively, right-click the top of the column, and then select Insert or Delete. Insert or delete a row in ..