Sometimes, you may need to enter a date or time for your excel records such as the collection data of your biological samples or your budget. Today, we are going to show you How to enter Date and Time Functions in Microsoft Excel? o enter a date in Excel, use the “/” or “-” characters. To enter a time, ..
Do you know How to Filter your data in Microsoft Excel? Today, we are going to show you How to Filter your data in Microsoft Excel? Filter your Excel data if you only want to display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On the Data tab, in ..
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 ..