Tag : Excel tutorials

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

How to format numbers in Excel? What are Available number formats in Excel? n Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. To be able to do that, follow these simple steps: Select a cell or a cell range. On the Home tab, select Number from the ..

Read more