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). that'll get you well on your way to 'Excel Guru Status' giving you not only the Microsoft Office training (including Excel, Word and Outlook video tutorials) and.

Author:REGINALD KAPLUN
Language:English, Spanish, Indonesian
Country:Grenada
Genre:Health & Fitness
Pages:194
Published (Last):15.10.2015
ISBN:513-5-37121-490-6
Distribution:Free* [*Registration Required]
Uploaded by: OLIMPIA

72754 downloads 178767 Views 34.43MB PDF Size Report


Free Excel Tutorial Pdf

Are you looking for Excel examples? Are you looking for clear explanations that help you master many Excel features quickly and easily? Then this section is for. CFI's Excel Book is free and available for anyone to download as a pdf. Learn about the most important Excel shortcuts and functions to succeed in your career!. Here you will get the material for computer IT and Excel related courses and tutorials. The materials for which you will get the PDF, DOC, PPT, RAR and ZIP files.

Summary Why Learn Excel? Analysts, consultants, marketing professionals, bankers, and accountants all use Excel on a consistent basis. You might even find that other random professionals like graphic designers and engineers are working away with the powerful formulas and charts that come with Excel. Seeing as how Excel is so prominent in the workforce, it pays to learn all about it and put that experience on your resume. Developing your Excel skills using online resources could improve your employment prospects without the need to spend a lot of money on college courses. Learning Excel might even improve your job opportunities if you lack educational experience. Upon completing the right training, you automatically make yourself more valuable in the modern day workforce.

No matter you are a beginner or want advanced information on any of these Excel topics, you can visit this Excel topic for complete knowledge.

Moreover, all the material is free to download from this website. Home Office Excel. Excel tutorials in PDF. Microsoft Excel Part 3: Advanced Advanced Description: Microsoft Excel Part 2: Intermediate Intermediate Description: Microsoft Excel Part 1: Introduction Beginner Description: Select Adjacent Columns, Rows, or Cells When you want to select columns, rows, or cells that are next to each other, begin by selecting the first one.

Then, hold down your mouse button and drag through the rest. You will see them highlight as they are selected. Release the mouse button when you finish.

Another way to do this is to select the first one, hold down your Shift key, and then select the last one. If you do this with cells, you can select an entire group across and down. Select Scattered Columns, Rows, or Cells If you would like to select columns, rows, or cells that are not adjacent, start by clicking the first one.

Then, hold down the Ctrl key and continue clicking the ones you want. Release the Ctrl key when you finish. Insert or Delete a Column, Row, or Cell You can easily add or get rid of a column or row that you no longer need. Again, put your mouse over the letter or number, but instead of left-clicking your mouse, right-click. In the context menu that appears, select either Insert or Delete.

Popular Topics

You can also simply hide and unhide columns or rows How to Hide or Unhide Columns and Rows in Excel How to Hide or Unhide Columns and Rows in Excel If you're dealing with a data-heavy spreadsheet, sometimes it's helpful to hide or unhide rows and columns to better see the information you need to analyze.

Read More by selecting Hide or Unhide from the context menu. You can insert or delete a cell the same way as a column or row. However, with either option, you will receive a pop-up alert asking how you would like to shift the cells, row, or column. Just choose an option and click OK. Move a Column, Row, or Cell If you decide to move a column, row, or cell to a different spot in your spreadsheet, you can do it but must be careful.

First, select the column, row, or cell as described above.

300 Examples

Put your mouse over one of the edges of it so that the four-sided arrow appears. Then, drag it by holding down your mouse button to its new location and release. What you must be cautious of is if you release the column, row, or cell over the top of one that already contains data. If this happens, a pop-up box will appear asking if you are sure you want to replace the data.

So, if you do this in error, click Cancel and it will go back to its original spot. Adjusting the Size of a Column or Row You may want all or some of the columns or rows on your spreadsheet to be a specific size regardless of the data they hold. Adjusting the width or height is simple and can be done in two different ways. First, you select and right-click the column or row. In the context menu choose either Column Width or Row Height, depending on which one you want to change. In the pop-up window that appears, you will see the current width or height.

Replace it with the number you want and click OK. Another way to adjust the size of a column How to Manage Columns in Excel How to Manage Columns in Excel Do you need to add, move, hide, or change columns in a complex spreadsheet?

Don't panic.

We'll show you basic Excel column operations to organize your data. 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.

Adjusting the Size to Fit Your Data 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. Basic Formatting Excel offers a variety of ways to format your spreadsheets, from basic to advanced. Fonts, Shading, and Colors 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. Select the top row. Click the arrow next to the Fill Color and pick a color. Click the arrow next to the Font Color and pick a color. 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.

Online Microsoft Excel Classes | Start Learning for Free | Skillshare

Dates, Currency, and Decimals 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. Dates 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. Select the column, row, or cell where you will enter the date. 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.

Method One Select the column, row, or cell where you will enter the currency. Under Number on your ribbon, click the arrow in the General Select Currency from the dropdown box. Method Two The second method allows you to choose the type of currency you would like.

Select the column, row, or cell where you will enter the currency. Under Number on your ribbon, click the arrow next to the Currency Select the type of currency you wish to apply.

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. Decimals You can use the decimal formatting to adjust your currency or simple numbers. You can apply this formatting with these two steps. Select the column, row, or cell where you will enter the number.

Under Number on your ribbon, click either the Increase Decimal or Decrease Decimal button depending on your current numbering format. Additional Number Formats 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. 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.

300 Examples

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. 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.