We assume you have Microsoft Office installed on your computer; if not, please check here to learn what Microsoft Office is and how to install it. Additionally, before starting the Microsoft Excel tutorial, it is advisable to go through the Microsoft Word tutorial. Check it out here; this tutorial covers the basics of many tools that are also used in other Microsoft Office programs and are considered standard. Simply put, if you know how to work in Microsoft Word, you already know some features that also work in Microsoft Excel.
If you've completed all of that, check out the previous first lesson on Microsoft Excel here, where you'll learn what Microsoft Excel is and how to start using it. Also, if something is unclear, please ask; leave a comment. Even a programmer might take some code from the Internet and add it to their project if it works; but they won't proceed with more code unless they understand why and how that code works. And be assured, they will ask the same question on dozens of websites and search the entire Internet until everything is fully clear. This is how you should think and learn. The rest is a matter of discipline and progressing step by step. And most importantly, follow the tutorial and do everything we do. This helps develop good habits and retain information longer.
In the previous lesson, you mastered how to start creating a table that resembled a To-Do List, where we listed things we wrote, did, and learned. In this second lesson, we will thoroughly explain the basic tools on the Home panel - Home tab and Ribbon toolbar. The first glance at this toolbar may seem familiar because it has many similarities with the toolbar in Microsoft Word. However, their purpose is the same: formatting and styling. Some of the tools, however, can only be used in Microsoft Excel, and you can be sure that these specific tools have exceptional purposes and are frequently used. Although we won't be able to practically apply all the tools and features available on the Home panel toolbar in this lesson, we will definitely start creating and working on a table by focusing on the most basic formatting, primarily of Cells in the table and the entire table itself.
Keep in mind that everything we do in the tutorial, you
should also do, because some of the tables you create now can be used in future
lessons to enhance them with better and more extensive features. Microsoft
Excel truly offers incredible things you can do with any complexity in terms of
calculations, tables, and charts. But also, things you might not expect.
Microsoft Excel helps you by automatically filling in some data you enter into
tables, whether the data is the same and needs to be repeated, or there is a
pattern by which it is entered into a column. So, it's best to move on to the
practical part so you can see for yourself how it all works.
Protecting Excel Files: How to Set a Password on a Workbook
Considering that in the last lesson we only limited ourselves to the beginning of work in Microsoft Excel; now we can start learning new things and build on what we have already learned. Unlike Microsoft Word, the use of which requires you to lock the document less often; when it comes to using Microsoft Excel; this is not really the case because most of the data processed in this office program is of a financial nature. Although the protection of a Microsoft Excel document at the level of this program is not enough, it definitely starts with preventing prying eyes into your finances. So first let's see how to lock or encrypt a Microsoft Excel document.
Start Microsoft Excel, click on Blank workbook; then on the button Save -> Browse -> Save As and in the same form; more precisely at its bottom; open the ComboBox named Tools and click the General Options… item on the drop-down menu. A small General Options dialog will open. See previous image. The first thing you can do is check the option Always create backup to automatically create a backup copy of the file before setting the password. This backup is useful if you forget your password or have problems accessing a file after setting a password. If the specified option is checked, Microsoft Excel will save a copy of the file without a password under the same name, but with the extension *.wbk.
This provides additional security, but at the same time
takes up more disk space due to the extra copy of the file. If you are sure of
your password and do not expect to forget it, you can leave this option
unchecked to reduce the file size. We will leave it unchecked. In the first
TextBox, write a simple password that is easy to remember and repeat it in the second.
Leave the Read-Only recommended option unchecked. If the user were to open a
file that indicates this option; but no password set; Microsoft Excel would
notify the user of the recommendation to open the file as read-only, but allow
them to open and modify it anyway.
If the user tried to save the changes, they would be prompted to save the file under a different name, so that the original file would remain read-only. This option is useful when you want to provide a certain level of protection, but also allow users to, if they wish, still make changes and save them under a different name. Press the OK button. Repeat the password, then repeat it again. Then find the directory microsoft_excel_tutorial and save in it a file called 02. Correct Data Entry into Tables. Now close the file and open it again. A Password dialog will appear, informing you that the file is protected and asking for a password.
Basics of Creating and Formatting Tables in Microsoft Excel
Before you create and start formatting data in a table, it is necessary to have an idea of what kind of table you are creating and what column names the table should have. Start with the heading in cell B2.
IQKoder - Virtual Programming School
Type the following column names in cells B3 through I3.
Student ID | First Name | Last Name | Email Address | Programming Language | Exam 1 | Exam 2 | Exam 3
Position the mouse properly on Headers - header for column names and stretch the columns to the right side enough to see all the names in full. Then enter the following names in the First Name and Last Name columns:
Dorian Gray
Brennan Jackson
Stacey Chan
Nicole Dudley
Jack Brock
Reed Cote
Ann Houston
Gavin Horne
Alden Kirby
Lisa Rosales
Fill in the Code column as follows, but pay attention to the quick filling. What it means? This means as soon as you start entering the following information:
DOGR
BRJA
STCH
…
Microsoft Excel will see the pattern by which you write the specified codes and will itself offer you to print the entire column or what we would call quick filling. When you are offered this, just press the Enter key and the entire column will be automatically printed for you. This is great because this way you save time and avoid making mistakes when entering data into the column. Also note that Microsoft Excel recognizes the format of your code and creates it itself. Now let's look at the next automation. In the Student ID column, enter the numbers 1 and 2 in B4 and B5. Select both cells, then notice that in the lower right corner of the selection marked with a green frame, you see a black mouse pointer in the shape of a + cross and with it extend the green selection frame from cell B4 all to B13. The entire column will fill itself with numbers from 1 to 10.
Then enter the following data into the table:
Programming Language Exam 1 Exam 2 Exam 3
C# 68 77 53
C# 89 93 92
C++ 93 93 94
Python 75 60 54
Java 88 81 80
Java 90 88 90
C++ 68 78 95
Python 90 96 96
C# 62 67 69
Python 82 68 79
Select the Programming Language column and in the toolbar, in the Alignment panel, click the Center button and thus center all the content of the specified column. If you managed to do all the tasks correctly, you got an imaginary table without formatting. Now that you have the data printed; you can focus on table formatting and aesthetics.
If you pay attention to the Ribbon, you will see that it is divided into seven groups of tools or, more accurately, panels:
- Clipboard – Tools for copying, cutting, and pasting selected text, cells, columns, rows, tables, etc.
- Font – Tools that allow you to change the font, its size, color, background color, etc. Pay attention to the drop-down menu button for Borders. With these options, you can draw and modify lines in tables you create.
- Alignment – Tools for aligning text in cells and tables. Note that, unlike in Microsoft Word, you also have vertical alignment options such as top, middle, and bottom within cells. You can even adjust the orientation and determine the direction in which your text flows within a cell.
- Number – Tools that help you format numbers in various ways, such as dates, percentages, currency, etc.
- Styles – Tools that allow you to apply ready-made styles to the entire table, experiment with styles at the cell level, or use conditional formatting for cells.
- Cells – Tools that let you insert, delete, and format cells.
- Editing – Tools that help you perform calculations in the table, such as summing values, automatically filling cells in various directions, deleting cell content at different levels (like clearing formats), sorting data, filtering, and tools that allow you to find and modify specific data in the table.
In this lesson, as a final task, we offer you to format an imaginary table you have already created to make it look exactly like the following image.
If you have succeeded in everything, congratulations; otherwise, if you have complications while doing this task, watch the following video.
Microsoft Excel - 2. Correct Data Entry and Formatting of Cells in the Table
No comments:
Post a Comment