Welcome to our free Introduction to Microsoft Excel tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2019 Training course.
In this lesson, you will learn how to enter data in Excel worksheets.
Microsoft Excel worksheets are made up of rows and columns. Rows are defined by numbers and columns are defined by letters. When you open Excel, cell A1 is automatically highlighted. Anything you type will show up in this cell. To enter text into a different cell, simply select the cell by clicking on it and then begin typing.
Before entering text, it is helpful to be aware of the three shapes your cursor will take and what each one means:
To enter text in Microsoft Excel:
Note that in addition to showing up in the cell, the text you are typing also shows up in the Formula Bar:
If you are entering a lot of text, it is sometimes easier to type directly into the formula bar. To do this, simply select the cell by clicking on it and then click in the Formula Bar and begin typing.
Flash Fill is similar to the AutoComplete feature. It looks for patterns in your data and shows a suggestion. As soon as it detects what you are attempting to do, it shows a recommended pattern.
In the following example, full names have been entered in Column A. In Column B, this is what happens when you begin entering just first names, pressing Enter after each:
You can also easily expand data across columns by hovering the cursor over the lower-right corner of the cell and when it turns into a thin black cross, dragging. This will copy the data to multiple columns.
You can add and delete cells when working with a worksheet:
To add a cell to a worksheet:
To delete a cell in a worksheet:
To add a hyperlink to a cell in Microsoft Excel:
You can insert WordArt in a worksheet in Excel 2013, 2016, and 2019.
To add WordArt:
When you are typing data into a list, Microsoft Excel will attempt to guess what you intend to type based on the data in the cells above the one in which you are typing. This feature has been improved in Excel 2019. The example below illustrates this. Only the letter "B" has been typed into cell A4. Excel is guessing that the user intends to type "Ball":
If the user does intend to enter "Ball", he or she can press Enter as soon as Excel has correctly guessed.
Things to be aware of regarding the AutoComplete feature:
Before the end of this course we will build a spreadsheet showing the quarterly profit & loss statement for a fictitious company called Dave's Lemonade Stand. This is the first of these exercises. The spreadsheet will ultimately look like the below:
In this exercise, you will enter income and expense categories in column A of a new worksheet.
In the next lesson we will cover formatting numbers to include commas, decimals, currency symbols and more, and formatting dates in various ways. In this lesson, however, we will simply enter dates and numbers in the most basic format, and use autofill to quickly add numbers that follow a pattern.
To enter numbers in Microsoft Excel:
Things to be aware of when entering numbers:
To enter dates in Microsoft Excel:
If your data follows a pattern, you can use the Fill Handle to quickly and easily add data to multiple rows and columns.
To use the Fill Handle:
Examples of scenarios in which it might be useful to use the Fill Handle include:
In this exercise, you will enter the four quarters of the year at the top of your worksheet and will enter projected quarterly numbers for the two income categories.