Many people find learning Excel a bit tricky at first. It looks like a big spreadsheet with many buttons, and it’s easy to feel lost. But don’t worry, this tutorial on excel is here to help.
We will go through it step by step so you can start using it with confidence. Get ready to learn the basics without any fuss.
Key Takeaways
- You will learn how to open and save Excel files.
- Understand how to enter and edit data in cells.
- Discover how to use basic formulas for calculations.
- Learn to format cells to make your data look good.
- Understand how to sort and filter data for easier analysis.
Getting Started With Excel
This section will cover the very first things you need to know about Microsoft Excel. We will begin by learning how to open the program and how to save your work so you do not lose anything. It is like learning to turn on a computer and save a document.
Once you know these basic steps, you can start putting information into Excel.
Opening Excel
When you want to start using Excel, the first step is to open the program. You can usually find it by clicking the Start button on your computer. Then, look for Microsoft Excel in the list of programs.
Click on it, and the program will open.
You will then see a screen with different options. For a new start, choose ‘Blank workbook’. This gives you a fresh sheet to work on.
Saving Your Work
Saving your Excel file is very important. You do not want to do a lot of work and then lose it all. To save, go to the ‘File’ tab at the top of the screen.
Then click on ‘Save As’.
You will be asked where you want to save your file. Choose a folder on your computer. Then, give your file a name that makes sense.
For example, you could name it ‘My First Spreadsheet’. Finally, click the ‘Save’ button.
It is good practice to save your work often. Try saving every few minutes as you work. This way, if something unexpected happens, you will not lose much progress.
The Excel Interface
When you open Excel, you see a grid of boxes. These boxes are called cells. Each cell has an address, like A1 or B5.
This helps you know where your information is. At the very top, you see tabs like ‘File’, ‘Home’, and ‘Insert’. These tabs have many tools you can use.
Below the tabs is the formula bar. This bar shows what is inside the selected cell. You can also type or edit information directly in the formula bar.
The ribbon is the area below the tabs that shows different commands. It changes depending on which tab you select.
Entering and Editing Data
Now that you know how to open and save, let’s learn how to put information into Excel. This is the core of using spreadsheets. You can type numbers, text, or dates into the cells.
Editing is just as easy. You can change what you have typed or delete it.
Typing in Cells
To type in a cell, first click on it. You will see a blinking line appear in the cell. Start typing what you want.
For example, you could type your name in cell A1. If you want to put a number in cell B1, click on B1 and type the number.
After typing, press the Enter key or click on another cell. This confirms what you have typed. If you want to move to the next cell to the right, press the Tab key.
Editing Cell Contents
If you make a mistake or want to change something in a cell, it is simple to edit. Double-click the cell you want to change. The blinking line will appear, and you can make your edits.
Press Enter when you are done.
Another way to edit is to click on the cell and then click in the formula bar at the top of the screen. You can also use the arrow keys on your keyboard to move the cursor within the cell.
To delete the content of a cell, click on the cell and press the Delete key on your keyboard. You can also select multiple cells and press Delete to clear them all.
Data Types
Excel can handle different types of data. These include text (like names or descriptions), numbers (like sales figures or quantities), dates, and times. Excel tries to guess the type of data you are entering.
This helps it format and use the data correctly.
For example, if you type “Hello”, Excel knows it’s text. If you type “123”, it knows it’s a number. If you type “1/1/2024”, it recognizes it as a date.
Sometimes, Excel might misinterpret your data. You can fix this by formatting the cell.
Understanding data types is important for calculations. You can only do math with numbers. If Excel thinks a number is text, you might have trouble using it in formulas.
Using Basic Formulas
Formulas are what make Excel powerful. They allow you to do calculations automatically. Instead of doing math by hand, Excel can do it for you.
This saves time and reduces errors. We will start with the most common formulas.
What is a Formula?
A formula in Excel is an instruction to perform a calculation. All formulas start with an equals sign (=). This tells Excel that you are entering a formula, not just text or a number.
After the equals sign, you tell Excel what to do.
Formulas can involve simple math operations like addition (+), subtraction (-), multiplication (*), and division (/). They can also use cell addresses and other functions.
Simple Addition
Let’s say you have numbers in cells A1 and B1, and you want to add them in cell C1. You would click on cell C1. Then, type =A1+B1 and press Enter.
Excel will show the sum of the numbers in A1 and B1 in cell C1.
You can also add multiple cells together. To add A1, B1, and C1 in cell D1, you would type =A1+B1+C1 and press Enter.
Using the SUM Function
A very handy function for adding is SUM. It is useful when you have many numbers to add. To add numbers in cells A1 through A10, you can type =SUM(A1:A10) in the cell where you want the total.
The part in the parentheses (A1:A10) is called the range. It means all cells from A1 to A10. Using SUM is much faster than typing =A1+A2+A3.
and so on.
Subtraction, Multiplication, and Division
You can use other math symbols in formulas too. For subtraction, use a hyphen (-). For example, =A1-B1 will subtract the value in B1 from the value in A1.
For multiplication, use an asterisk (). So, =A1B1 will multiply the values in A1 and B1. For division, use a forward slash (/).
For example, =A1/B1 will divide A1 by B1.
When using formulas with cell references, if you change the numbers in the original cells (A1 or B1 in our examples), the result in the formula cell (C1 or D1) will update automatically. This is a major benefit of using Excel.
Order of Operations
Excel follows the standard order of operations (PEMDAS/BODMAS). This means it will do calculations inside parentheses first, then exponents, then multiplication and division (from left to right), and finally addition and subtraction (from left to right).
For example, the formula =(A1+B1)C1 will first add A1 and B1, and then multiply the result by C1. The formula =A1+B1C1 will multiply B1 by C1 first, and then add A1 to that result.
Formatting Your Data
Making your data look good makes it easier to read and understand. Formatting includes changing colors, fonts, and the way numbers are shown. Good formatting can highlight important information.
Changing Fonts and Colors
You can make text bold, italic, or change its color. Select the cell or cells you want to format. On the ‘Home’ tab, in the ‘Font’ group, you will find options for bold (B), italic (I), and underline (U).
There are also buttons to change the font color and the fill color of the cell.
Changing the font type or size can also improve readability. Look for the font name and size dropdown menus on the ‘Home’ tab.
Number Formatting
Numbers can be shown in many ways. For example, you might want to show a number as currency (e.g., $10.00) or as a percentage (e.g., 50%). Select the cells with numbers.
On the ‘Home’ tab, in the ‘Number’ group, you can choose different formats.
Click the dropdown arrow next to ‘General’. You can pick ‘Currency’, ‘Accounting’, ‘Percentage’, ‘Fraction’, ‘Scientific’, or ‘Text’. For dates, you can choose from various date formats.
Aligning Text
Text within a cell can be aligned to the left, center, or right. It can also be aligned to the top, middle, or bottom of the cell. Select the cells.
On the ‘Home’ tab, in the ‘Alignment’ group, you will see these options.
For example, if you have a long title, you might want to center it across several columns. To do this, select the columns, then click ‘Merge & Center’ in the ‘Alignment’ group. This combines the columns into one large cell and centers the text.
Borders and Shading
Borders can help separate data visually. You can add borders to individual cells or to a group of cells. Select the cells.
On the ‘Home’ tab, in the ‘Font’ group, find the ‘Borders’ button. Click the dropdown arrow to choose different border styles.
Cell shading adds color to the background of a cell. This can be used to highlight headings or important data. Select the cells and use the ‘Fill Color’ option, which looks like a paint bucket.
Sorting and Filtering Data
Once you have a lot of data, it can be hard to find what you are looking for. Sorting arranges your data in a specific order, like alphabetically or by number. Filtering shows only the data that meets certain conditions.
Sorting Your Data
Let’s say you have a list of names and you want to sort them alphabetically. First, select the column that contains the names. Then, go to the ‘Data’ tab.
In the ‘Sort & Filter’ group, click the ‘A to Z’ button for ascending order or ‘Z to A’ for descending order.
If your data has headings, make sure to check the box that says ‘My data has headers’. This will prevent Excel from sorting your headings along with the data. You can sort by multiple columns.
For example, you might sort a sales report by region first, then by sales amount within each region.
Filtering Your Data
Filtering lets you see only specific rows of data. For example, if you have a list of sales, you can filter it to show only sales from a particular city or sales above a certain amount.
To filter, select your data range, including the headers. Go to the ‘Data’ tab and click the ‘Filter’ button. Dropdown arrows will appear in your header cells.
Click on an arrow. A menu will pop up showing all the unique items in that column.
You can then select which items you want to see. For example, if you click the arrow in the ‘City’ column, you can uncheck ‘Select All’ and then check only ‘New York’ to see sales from New York.
Using Filter Options
The filter menus offer more advanced options. You can filter by text, numbers, or dates. For numbers, you can filter for values greater than, less than, or between certain numbers.
For dates, you can filter by specific dates, ranges, or even by month or year.
When you apply a filter, the row numbers on the left side will change color, and some rows will be hidden. Excel is still holding onto that data, it’s just not showing it to you right now. To remove a filter, go back to the ‘Data’ tab and click ‘Clear’ in the ‘Sort & Filter’ group.
Real-Life Examples
Learning a tutorial on excel is practical for many situations. Here are a few examples of how people use Excel every day.
Budgeting at Home
Sarah wants to keep track of her household expenses. She creates a simple Excel sheet. In one column, she lists the date of the expense.
In another, she writes a description (like ‘Groceries’ or ‘Electricity Bill’). In a third column, she enters the amount spent.
She uses the SUM formula to add up all her expenses for the month. She also sets up a budget column to compare her spending against her planned budget. If she spends more than planned in a category, the cell turns red using conditional formatting.
This helps her see where she can save money.
Sarah finds that using Excel makes her much more aware of her spending habits. She can easily see where her money is going and make better financial decisions.
Tracking Sales for a Small Business
Mark runs a small online store. He uses Excel to track his sales. Each row represents a sale, with columns for the date, product sold, customer name, and sale amount.
He uses filters to see his top-selling products or to find sales from a specific customer. He also uses formulas to calculate his total monthly revenue and profit. This helps him understand which products are most popular and how his business is performing.
By sorting his sales data by date, Mark can easily generate monthly sales reports. He can also see trends over time, like seasonal peaks in sales. This information helps him plan inventory and marketing efforts more effectively.
Managing a Project Schedule
A project manager, Jane, uses Excel to create a project timeline. She lists all the tasks for a project in one column. Other columns show the start date, end date, and duration for each task.
She uses formulas to calculate dependencies between tasks. For instance, if Task B cannot start until Task A is finished, she sets up the dates accordingly. This ensures the project stays on track.
She might also add columns for the person responsible for each task and its status (e.g., ‘Not Started’, ‘In Progress’, ‘Completed’).
Jane finds that Excel allows her to visualize the project timeline clearly. She can easily spot potential bottlenecks or tasks that are falling behind schedule. This enables her to proactively manage the project and deliver it on time.
Common Myths Debunked
Myth 1 Excel Is Only For Accountants
Many people think Excel is just for finance professionals. In reality, anyone can use Excel for a wide range of tasks. From planning a party to managing a personal budget, Excel’s features make organizing information simple.
Its flexibility means it’s useful in almost any field or for personal use.
Myth 2 Excel Is Too Complicated To Learn
While Excel has many advanced features, the basics are very easy to pick up. As this tutorial on excel shows, simple tasks like entering data and basic calculations require just a few clicks. You can learn what you need gradually, starting with the most common functions.
Myth 3 You Need Expensive Software
Microsoft Excel is part of the Microsoft Office suite, which is a paid product. However, there are free alternatives like Google Sheets or LibreOffice Calc that offer similar functionalities. These can be used for most of the tasks covered in this tutorial.
Myth 4 Formulas Are Hard To Write
While some complex formulas can be challenging, most basic formulas are very straightforward. Using cell references like A1+B1 makes them easy to understand. Excel also has built-in functions that do complex calculations with just a few clicks, like the SUM function.
Frequently Asked Questions
Question: How do I create a new Excel file?
Answer: To create a new Excel file, open Excel and select ‘Blank workbook’ from the startup screen.
Question: Can I undo a mistake in Excel?
Answer: Yes, you can undo a mistake by clicking the undo arrow at the top of the screen or pressing Ctrl+Z (Cmd+Z on Mac).
Question: What does the equals sign at the start of a formula mean?
Answer: The equals sign tells Excel that you are entering a formula to perform a calculation.
Question: How can I make my numbers show as dollars?
Answer: Select the cells, go to the ‘Home’ tab, and choose ‘Currency’ from the Number format dropdown.
Question: What is the difference between sorting and filtering?
Answer: Sorting rearranges your entire list based on a chosen order, while filtering hides rows that do not meet your criteria.
Conclusion
Learning a tutorial on excel helps you organize and analyze data easily. You can now open files, enter and change information, and use basic formulas for calculations. You also know how to make your data look better with formatting and how to sort and filter it.
Start practicing these skills, and you will become more comfortable with Excel quickly.
