Merging Cells
Merging cells in Excel can be useful when you want to format the look of your worksheet. You can merge two or more…
Category: training
Worksheets in Excel
Difference between a worksheet and a workbook With Excel, you can achieve high efficiency with little effort. However, before you start working with…
Formula Bar in Excel
The formula bar is located between the ribbon and the workspace. When you click any cell in the worksheet, Excel will display contents…
Application Window in Excel
With Excel 2007 Microsoft introduced a revolutionary new look for the Office Suite applications. The major change was the Ribbon, which completely changed the way…
Excel Ribbon
The biggest change that has ever been done in the Office Suite user interface is the Ribbon. The first release of Excel that uses the…
Formatting Date and Time
You can format date and time in many different ways. Look at the following example to learn how to do it. Example 1:…
Start Screen in Excel
When you start Excel 365, the program displays the default startup screen, similar to the one displayed in the following image. The screen…
Naming Cells and Ranges in Excel
When you work with worksheets, you will often type cell addresses that reference to a particular cell or a range of cells (for…
Inserting Cells
Sooner or later you will need to insert additional cells between those that already contain data. Of course, you can move the contents…
Simple Fractions and Decimal Fractions in Excel
You can find two types of fractions in Excel: simple fractions (e.g. 4/5) and decimal fractions (e.g. 1.34). In this lesson, I will show you how to use them….