training Archives | Page 6 of 8

Windows and Office Clipboard

Windows Clipboard The Windows Clipboard is a place where the most recently cut or copied value is stored. This can be a value…

A chart is a graphical representation of data. They are an integral part of spreadsheets and were present in spreadsheets even before the…

You can perform such arithmetic operations as addition or subtraction not only on numbers but also on dates. In this lesson, I will show…

Quick Access Toolbar was created to give users easy access to frequently used options and features. It is located above the ribbon, and…

The AutoSum feature is used to sum the values of columns or rows with a single click. When you use it, Excel tries to guess which cells…

A data type is like a wardrobe for your data—it defines how your computer interprets and interacts with information. Just as you wouldn’t wear a…

VBE (which stands for Visual Basic Editor) is a separate application, integrated with Excel. Here, you can write or edit your macros. In…

If you want to enter information inside a cell, first you need to click the cell to make it active. You can use…

In the previous lessons, you’ve learned how to merge data. In this lesson, you’ll learn quite the opposite. I will show you how…

Besides changing the color, size and font type, you can highlight text in Excel in several different ways. For example, using: bold (Ctrl +…