Microsoft office excel 2010 tutorial for beginners free download.Results for “microsoft office 2010 tutorial”
Step 1: Data Entry.Free Excel Tutorial at GCFGlobal
The goal of these instructions is to familiarize the user with the basics of Excel We use a gradebook as an example to help the user visualize how different functions can be used. This tutorial will cover data entry, formatting, formulas and functions, and graphs.
Entering data into an Excel spreadsheet is a simple 3-step process: 1. Click on the cell where you want to insert data 2. Type the data in to the cell 3. As mentioned previously in Step 3, using the mouse is one option when you want to switch which cell you are working with. But when dealing with a larger amount of data or if you want to be as efficient as possible, manually using the mouse is not the best option.
Utilizing the keyboard will help speed нажмите чтобы узнать больше the process of data entry: 1. Press the ENTER key after entering your data to automatically move the active cell highlight down to the next cell in that column 2. Press the TAB key after entering your data to automatically more the active cell highlight over to the next cell in that row 3. Press any of the four arrow keys to move the active cell highlight to a cell in the direction of the arrow key pressed 4.
Microsoft office excel 2010 tutorial for beginners free download the ESC key to cancel the current data entry. There are two main types of data that people enter into Excel: Text and Numbers. You decide to увидеть больше an Excel spreadsheet to accomplish this. In cells A1-A16, enter the following text in order starting at the top of the column, moving downward: Student, Heather A.
In cells B1-B16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 1, 81, 55, 35, 87, 76, 78, 90, 67, 70, 92, 84, 80, 72, 81, and In cells C1-C16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 2, 88, 56, 48, 91, 78, 86, 91, 87, 76, 95, 87, 88, 74, 84, and In cells D1-D16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 3, 93, 57, 55, 93, 80, 94, 97, адрес, 79, 98, 92, microsoft office excel 2010 tutorial for beginners free download, 77, 88and Once all the data is entered, your spreadsheet should match the image above.
Formatting Data There are many different options in Microsoft Excel to format numbers, text, and the cells themselves. These instructions will cover some of the more basic and widely-used formatting options available: Changing the Font Font commands will allow you to change the style, size, or color of the text you wish to alter: Style 1.
Select the cells you wish to modify. Click the drop-down arrow next to the FONT command in the upper left corner of the screen 4. Size 1. Under the HOME tab at the top of the page, locate the drop-down arrow next to the font size command 3.
Click on the drop-down arrow 4. Scroll over the various font sizes and choose size Color 1. Microsoft office excel 2010 tutorial for beginners free download the cells you wish to modify -In this case, select cells A1-F1 again. Under the HOME tab at the top of the page, locate the drop-down arrow next to microsoft office excel 2010 tutorial for beginners free download font color command.
Scroll over the various font colors and click on the desired color. Horizontal 1. Select the cells you wish to modify -In this case, please select all cells. Select the cells you wish to modify 2. Click on the drop-down arrow and select the number format you want some frequently used examples include Currency, Time, Date, Percentage, Fraction, etc. Returning to our previous example from the instructions regarding data entry, follow these steps to further format the data and text you entered: 1.
Use your mouse to highlight all the cells containing text or number data 2. Make sure you click on the box you will see a checkmark appear stating that the table has headers 4.
Once you have a column of numbers, there are several different calculations you can do with these. Average and Sum 1. Type in Class Average in cell A17 and change the font color to red. Select the cell in which you want the average to appear. In this case, B17 3. Click and drag over the cells that you want to be averaged. In ссылка на страницу case, B2-B A moving border will appear around all the cells that are going to be averaged.
Repeat steps for columns C and D. Change font color of B17, C17, and D17 to red to match A Now you can go back and format the cells to make them currency or to round them to 2 decimal points.
Right click on the microsoft office excel 2010 tutorial for beginners free download that has the average in it, as averages typically have many decimal points. Click Format Cells On the left box, select Number 4. On the right side, make sure the box after Decimal Places: says 2.
In order to extend a formula over multiple cells, first type the formula in one cell. In microsoft office excel 2010 tutorial for beginners free download case, we will put the average in column E.
Click and drag to select cells B2 C2 and D2 3. The formula should have extended throughout all of column E to insert the average of each student and the class average. Select cells E2-E17 and format the cells so that they are rounded to 2 decimal places. Now we will use Excel to help show us which students have passed and which have failed. Select cell F2 2.
The formula should extend throughout column F to complete which students have passed or failed. Now we will use Conditional Formatting to visually highlight who has failed. Click and drag on cell F2 all the way to cell F16 2. Hit OK 5. Now all the Fail grades should be highlighted in red. Scatterplot Graph 1.
Highlight data and titles required. Select Scatter microsoft office excel 2010 tutorial for beginners free download the Charts section. Click scatterplot type needed 5. After the scatterplot нажмите чтобы перейти shows up, click on the graph and move it to desired place on the spreadsheet.
Line Graph 1. Data from Test 1, Test 2, and Test 3 for each student should be highlighted. Select Line from the Charts section.
Click which line graph type is needed 5. After the line graph shows up, click on the graph and move it to desired place on the spreadsheet. Bar Graph 1. Select Bar from the Charts section. Click which bar graph type needed. How to Add Titles: 1. Select a graph by clicking on it. Click on the Layout tab. Click on the Chart Title box. Select which type of title is needed.
A text box should appear above the selected graph. Fill in text box with your title -In this case, type in Class Grades as the title. Axis Titles: 1.
Click on Axis Titles box -In this case, the bar graph will be used. A text box should appear next to the Y or X axis of the selected graph 4. Fill in text box with your title -In this case, the title for the X axis will be Gradeand the title for the Y axis will be Class Average. When using Charts or Graphs in Excel, swapping the X and Y axis can drastically change the appearance of the graphs.
The following steps explain how to swap the data : 1. Select which graph you wish to alter. Click on the Design tab. The graph design should change, and the Student Names should now be in the Y-axis, and Test 1, Test 2 and Test 3 should now be along the X-axis. Question 1 year ago жмите Introduction. I am updating my Microsoft Office skills. This is a lovely tutorial! Thank you!
Microsoft office excel 2010 tutorial for beginners free download.Free Office Tutorials at GCFGlobal
Test your Excel skills with the free Excel Quiz. Understanding and using the different views in Excel can make your work much easier.
Knowing how to use the mouse, keyboard and Go To features as well as how to select columns, rows and multiple cells makes using Excel much easier and can save you a lot of time.
Learn how the tabs are organized into groups, how to open the group dialog box and how to hide the ribbon. Learn how to add, delete and change the position of the buttons you use the most. Using the copying and pasting functions in Excel will not only save you time from having to re-enter data repeatedly, it may also ensure more accurate data entry and less frustration.
You can do the same with dates and numbers using the fill handle and Auto Fill feature. You can even create your own list.
This is a great time saver. This includes changing the appearance of the data including the font, font color, text alignment, merging cells, wrapping text and using the fit to cell feature. You can copy formatting by using the Format Painter. A good place to start is with getting to know how cell references work. Copying formulas using the fill handle saves a lot of time. So does knowing how to change the formula to its actual value.
This is done by formatting numbers for currency, percentage, dates, and fractions including decimal places and negative numbers. Understanding functions, how Excel organizes functions, and creating functions using the Function dialog box takes Excel beyond basic math.
Formatting is the key. This includes changing the appearance of the worksheet including inserting and deleting columns and rows, changing column widths and row heights, cell color and borders and how to add Headers, Footers and page numbers. Split the worksheet to see two different parts at the same time using the Split Screen function. It can be helpful to name cells and cell ranges rather than referring to a cell by its address.
Switching rows and columns gives you another view of your data. Like using a sticky note, inserting comments can help explain your data. Another security issue is when other viewers or users of the worksheet inadvertently or intentionally change formulas or data without your knowledge and thus compromise the integrity of the data.
You could have a worksheet for each month, or each location, or each person. You need to know how to add and delete worksheets, format multiple worksheets at the same time, insert data into multiple worksheets and calculate formulas across worksheets. How to create a bar or pie chart. Knowing how to format charts using the Design, Layout and Format tabs to change colors, labels and scale makes you an Excel Chart Wizard!
Then you can change margins, paper size and layout, page breaks and column widths and print the cell borders andcolumn headings at the top of each page to make it easy to read. There are modifications you can make to print an Excel worksheet either on one page or at least with all of the columns on one page.
How to create and edit macros is easy and makes you an Excel pro. You need tools that allow you to organize your data according to specific criteria, for example, alphabetically sort surnames or apply specific filters to a worksheet to only display data that meets specific filter criteria.
The sort and filter tools in Excel allow you to organize and manipulate your data quickly and easily. Use the concatenate function to combine words and even numbers that are contained across different columns into one cell. The converse function of concatenate is the Text to Columns function which allows you to separate text across different columns.
Excel even has a built-in function to remove duplicate values to ensure your data is free from repeat entries. You can apply different formatting to a cell or cells that meet your specific conditions i. Outline tools such as Group and Subtotal give you quick results when looking for answers in your data.
A What-if analysis lets you see how those changes will affect the outcome of the formula. Use Solver, data tables, and Goal Seek to test multiple values and see how the results change. Data analysis tools ensure that values are entered in the same format where specified throughout your worksheet.
Sometimes you need to change the case of words to upper or lower case or remove extra spaces or characters. Doing this manually can take up a lot of time and can lead to data entry errors. Formulas allow you to perform the above functions in record time. Data Forms allow you to find data, view entries, add and delete data to a worksheet with a user-friendly form. You can insert images and shapes, background colors and use SmartArt to make a worksheet in Excel visually more appealing.
Excel for Beginners to Advanced Excel Training. Do the Tutorial then Test yourself! We’ve added a fun 30 second Excel Shortcuts Video tutorial. If you like it we will add more Sharpen your Excel skills with this Excel test and Excel tutorial. MS Excel spreadsheets are not only great for financial workbooks and budgets, it can also be used for creating calendars and schedules, fitness tracker, invoices, to do lists, weight loss tracker, vehicle service logs, address lists and much more.
What is Excel? How to use Excel – What is Microsoft Excel? What can Microsoft Excel be used for? What are the benefits of using Microsoft Excel to perform the above functions? What MS Excel Training is best for you?
What Version of Excel are you using? Find out how to find out! More from TestsTestsTests. More Microsoft Excel 1. What is Microsoft Excel? QUIZ 4. What version of Excel are you using? Free Excel Templates – get organized 1. TEST 2.