At most one email a week. Unfollow anytime with one click.
Transcript
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Show transcript
Introduction
This is the final result we will create, a neat weekly shopping list, complete with title, number, item name, quantity, unit, and unit price. From here, we will learn the basics of Excel that will be used in all future projects. Let's start! Hello, welcome to the Excel for beginners tutorial, getting to know Excel from scratch. We will learn about the Excel screen parts, how to enter data, how to adjust column width, up to saving the file. No experience is needed at all.
Step 1: Recognize the Excel screen parts
This is an empty Excel workbook. Let's get to know its parts one by one. At the top, there is a ribbon, where all commands are located, grouped into tabs such as Home, Insert, and Data. Below it is the Name Box, which shows the address of the Excel cell currently selected, and next to it is the Formula Bar, where we can view and edit the Excel content. The worksheet contains columns labeled with letters and rows labeled with numbers. Below it is the Sheet Tabs, and at the very bottom is the Status Bar along with the Zoom control.
Step 2: Cells, rows, and columns
The intersection of one column and one row is called a cell in Excel. Each cell has an address. The cell in column A, first row is addressed as A1. Click on cell A1, then observe the Name Box. Now click on cell C5, its address is C5. To select an entire column, click on the letter above it. And to select an entire row, click on the number to the left of it.
Step 3: Typing the title and table header
Now we start entering data. We move to cell A1 via the Name Box, then type the title, 'Weekly Shopping List', and press Enter. On the third row, we create the table header. Type 'Number', press Tab to move to the right, then type 'Item Name', 'Quantity', 'Unit', and 'Unit Price'. Tab moves to the right, whereas Enter moves down.
Step 4: Filling in the item data
Next, fill in the item data. Type the number 1, tab, item name, tab, quantity, tab, unit, tab, and price, then enter. After pressing enter, Excel automatically returns to the first column in the next row. Text is left-aligned, and numbers are automatically right-aligned. That is how Excel differentiates between text and numbers. Continue until 8 items.
Step 5: Widening the column
Look, there is an item name that is cut off because the column is too narrow. We will widen it. Select columns from letter B to letter E to choose 4 columns, then double-click the boundary line to the right of letter B. Excel will adjust the width of all selected columns to fit their content. Another way is to drag the boundary line to the right or left.
Step 6: Editing, deleting, and undoing cell content
If you make a mistake, fixing it is easy. Click the Excel cell you want to change, then press F2 to enter edit mode. We delete the last number with backspace, type 6, then press enter, so the quantity of rice becomes 6. To delete the content of Excel, select the Excel cell and press delete. And if you want to undo, press Ctrl Z, Ctrl Z is the most commonly used undo function.
Step 7: Inserting a new row
What if an item is missed? We will insert a new row. Click the row number where the new item will appear, press Ctrl Shift Plus, and an empty row appears. Type the missed item, for example, salt, 1 pack, with a price of Rp3.000. Then we will type the serial number again from 1 to 9. Now we will rename the worksheet.
Step 8: Renaming the worksheet
Double-click the sheet tab 1 at the bottom, then type belanja and press enter. A clear sheet name makes a file with many sheets easy to understand.
Step 9: Saving the file
Finally, we will save our work. Press F12 to open the Save As dialog box. Type the location and file name, then press Enter. The Excel file has an XLSX extension. After it is saved, the file name appears at the top. Get used to pressing Ctrl + S regularly to prevent losing your work.
Done! You now know the basics of Excel
Done. We have now learned about the different parts of the Excel screen, entering data, expanding columns, editing cell content, inserting rows, and saving the file. Thank you for watching. See you in other tutorial series. Want to become proficient in Excel for work and business? Cerdas Inovasi Digital offers Excel and Office courses, template creation services, reports, and dashboards in Excel, as well as sells the practice files of this tutorial. Contact us via WhatsApp or visit cerdasinovasidigital.com Thank you for watching. See you in other tutorial series.
Ask the class material
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
My notes
Notes are saved with the current video time and are only visible to you.
Questions & answers
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.
Your instructor
Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
53 video classes1,279 episodes
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
