Finding and Replacing Data
When you work with Excel, sometimes you have to deal with very large amounts of data. As a result, finding a particular value…
Category: training
Filling Cells with Color and Pattern in Excel
Besides text formatting, you can also highlight particular cells by changing their background type. In Excel, you can fill cells with color, gradient, and pattern….
How Excel Stores Date and Time
If you want to use date and time efficiently in Excel, you first have to learn how Excel stores these values. At first,…
Merging Text with Numbers in Excel
When you have data in multiple columns, you may want to merge them so the data will occupy only one column. Example: In…
Backstage View
The backstage view is a place where you can perform operations on the file. The backstage view was first introduced in Excel 2010 and is…
AutoFill in Excel
AutoFill is a very useful Excel feature. It allows you to create entire columns or rows of data that are based on the…
Trendlines in Excel
One of the easiest methods for guessing a general trend in your data is to add a trendline to a chart. The Trendline…
Number Formatting
If a cell is not formatted to a particular type, Excel will read that value and try to guess what format should it…
Relative, Absolute and Mixed Cell References in Excel
When you open an Excel spreadsheet, the first thing you see are cells. You can enter a value into a cell, or use…
Selecting Rows and Columns
In the previous lesson, I presented a few ways to select cells and ranges. This time, I will show you a few methods…