BASIC EXCEL TUTORIAL PDF
Microsoft Excel , Microsoft Excel (Windows). Microsoft Excel . Cell Basics. to use another file type, such as a PDF or Excel workbook. Microsoft Excel is one of the most popular spreadsheet applications that helps you To begin Microsoft Excel, Go to Applications > Microsoft Excel (Figure 1). Excel is a spreadsheet program in the Microsoft Office system. You can use Today's class will focus on Microsoft Excel , but many of the topics are applicable to the . We will learn some of the shortcuts in the next few pages, but it's also.
|Language:||English, Spanish, Portuguese|
|Genre:||Science & Research|
|ePub File Size:||27.43 MB|
|PDF File Size:||17.50 MB|
|Distribution:||Free* [*Registration Required]|
Excel Tutorial in PDF - A beginner's tutorial for Microsoft Excel to learn basic to advance concepts step by step including open workbooks, format. Specifically you will learn about the following topics. • Understanding the basic concepts of a spreadsheet, including: • the idea of templates. • cells, rows and. Are you looking for clear explanations that help you master many Excel features quickly and easily? Then this Want to learn much more about Excel? Basics .
Example, here is a table with some made up sales figures.
Select cell range A1:D24 2. Drag Item to column labels 2. Drag Price to Values 3. Drag Company name to row labels No what happened to the pivot table? You can now analyze the data more easily.
Try rearranging the fields in the pivotTable Field List and explore!
You can also use dates or categories or whatever. Click Minimum color and pick a blue color. Click Maximum color and pick a red color.
Conditional formatting — formula You can use a formula to determine which cells to format. Now conditional formatting becomes really powerful! Example, here is a list. Are there any duplicates? Not that easy to identify, but wait! Select the data 2. Read More or row is to first select it. Move your mouse to the border until you see a two-sided arrow appear.
Then, hold down your mouse button and drag until you reach the size you want.
If you would rather have each column and row sized to accommodate your data, you can do this in a just a few clicks. First, select the entire spreadsheet by clicking the triangle in the upper left corner between the A and the 1. Then, move your mouse between two columns until you see the two-sided arrow and double-click.
Next, do the same for the rows. You will notice both columns and rows of the spreadsheet adjust to fit the data in your cells. It will automatically adjust for the cell with the longest amount of data. Excel offers a variety of ways to format your spreadsheets, from basic to advanced. No matter what you decide to use Excel for, basic formatting of columns, rows, and cells can help you view your data easily.
For instance, you may use the first row of a spreadsheet to insert headers. Like in our example for a product sheet, you might use item number, product name, and price. To make that top row stand out better from a large amount of data beneath, you can format it easily. Select the row and then apply your formatting using options on the Home tab. Here, you may make the font bold, apply a fill shade, and color the font. Keep in mind that these instructions will apply to the entire first row.
If you only have a few columns, you can follow the steps further above to only select certain cells in that row and apply the formatting to them alone. If you are creating a tracking spreadsheet, automatic formatting for dates, currency, and decimals is convenient. And you can apply each of these formatting rules in just a few clicks from the Home tab.
You may have a Date column on your spreadsheet for many reasons. When you enter the data, when you make a download, or when an item is due are all just examples. Note that if you use the Long Date , which inserts words and numbers as shown below, you do not have to type it in manually.
If you have a spreadsheet for your budget, price list, or invoicing, then you can apply the currency format easily in two different ways. Whichever method you decide to use, any number that you enter into the applied columns, rows, or cells will automatically be formatted as that currency. You can use the decimal formatting to adjust your currency or simple numbers.
You can apply this formatting with these two steps. You will also notice under Number on your Home tab, many additional ways to format your numbers. As you progress with Excel, these may come in handy.
These options include times, fractions, percentages, and others. Plus, you can click the More number formats link at the bottom to see options like ZIP code, phone number, and custom choices. One of the best time-saving features in Excel is the AutoSum tool.
Excel Tutorials for Beginners
And if you are using Excel for a project like income and expenses or loan and debt management, you will appreciate the AutoSum feature. This uncomplicated formula tool can add, average, count numbers, or find the minimum or maximum for a column, row, or group of cells. By default, you should see the AutoSum button on your Home tab ribbon, all the way to the right. You can also access it from the Formulas tab.
If you just click the AutoSum button, it will automatically insert the sum function. But if you click the arrow for the button, you will see the other common formulas you can use mentioned above. Say that you have a column of numbers you would like to add.
First, click the cell where you would like the total to display. Next, click the AutoSum button. Excel will automatically detect the numbers you want to add. They will be highlighted and you can see the formula which may appear something like this: The equal sign indicates a formula.
SUM is the function. And C2: C7 are the cells that apply. If this looks correct for you, just hit your Enter key. The calculation will pop into the cell adding those numbers for you. The other options within AutoSum work similarly. Maybe you need to get the average of a group of cells. First, click the cell where you want the average to display.
Next, click the arrow for the AutoSum button. Again, Excel will automatically detect the numbers, highlight the cells, and provide the formula. Click the Enter key to insert the average. As we mentioned in the Basic Terms for Excel section, there are many formulas and functions that you can use. Some, like AutoSum, provide very simple and commonly-used calculations. Feel free to check them all out on the Formulas tab if you like to experiment.
One of the best ways to get started in Excel is to use a template.
Key Highlights of VBA Tutorial PDF are
And you will find a large variety of options both within Excel and on external sites. You will then see a number of featured templates you can use, categories you can pick from, and a search box if you want something specific.Enter Data in Excel Dos and Dont's of Entering Data in Excel covers best practices for data entry and shows you how to: Plan the worksheet Enter headings and data units Protect worksheet formulas Use cell references in formulas Sort data Build a Column Chart How to Use Charts and Graphs in Excel explains how to use bar graphs to show comparisons between items of data.
Stay informed by joining our newsletter! MS Word. Chandoo : Find intermediate information about conditional formatting and creating reports quickly. Beginning Microsoft Office Spring Project management is the application ofExcel first carries out the subtraction operation C2-C4 or , since it is surrounded by brackets and gets the result of