- HOW TO USE MICROSOFT EXCEL 2010 FOR BEGINNERS HOW TO
- HOW TO USE MICROSOFT EXCEL 2010 FOR BEGINNERS FREE
HOW TO USE MICROSOFT EXCEL 2010 FOR BEGINNERS HOW TO
How to add Background Color automatically in Excelġ7. How to apply fonts, background colors, and borders in Excel 2010ġ6. How to Format numbers and dates in Excel 2010ġ5. How to work with times and dates in Excel 2010ġ4. How to Understand formulas and functions in Excelġ3. How to work with data using shortcuts in Excelġ2. How to Customize your display of Status Bar totals in Excelġ1. How to Customize the ribbon bar in Excelġ0. How to Find the commands you need and use Backstage view or the File tab in Excelĩ. How to Navigate through shortcuts in ExcelĨ. How to Create multiple custom Worksheet views in Excelħ. How to Change and Add an Excel WorksheetĤ. How to Create a worksheet and copy paste in Excelģ. How to work with Basic Features in ExcelĢ. Microsoft Excel is a powerful office calculation program which thousands use on a daily basis.Īre you a beginner or do you use it frequently but still have questions regarding a specific move/essential trick?Īs a matter of fact, the very best selection of tutorials are provided here.Īfter using our guide there won’t be left much you won’t be able to do self-confidently in Excel, since it’s been under research and development by an expert dev team.ġ. 3.) Click on the drop-down arrow 4.This audio guide will teach you in an interactive way to work easy and efficient with Excel 2010. 2.) Under the HOME tab at the top of the page, locate the drop-down arrow next to the font color command. Color 1.) Select the cells you wish to modify -In this case, select cells A1-F1 again. 2.) 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 12. Size 1.) Select the cells you wish to modify -In this case, please select cells A1-F1 (Column Headers). 2.) To change the font style of the cells as well as the row and column headers, click on the PAGE LAYOUT tab at the top of the page 3.) Click the drop-down arrow next to the FONT command in the upper left corner of the screen 4.) Scroll over the various fonts and choose “ Office Classic 2-Arial-Arial” *Note: to change the font of ONLY the cells and not the row and column headers, complete the same directions just given, only under the HOME tab at the top of the page. 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. Once all the data is entered, your spreadsheet should match the image above.įormatting Data There are many different options in Microsoft Excel to format numbers, text, and the cells themselves.
HOW TO USE MICROSOFT EXCEL 2010 FOR BEGINNERS FREE
*Note: Feel free to enter some of the data horizontally along the row, instead of vertically down the column, to get practice with the different keyboard functions.
Data for columns E and F will be entered later in the Formulas and Functions section. 5.) In cell E1, enter Final Grade, and in cell F1, enter Pass/Fail. 4.) 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, 90, 79, 98, 92, 89, 77, 88, and 61. 3.) 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 58. 1.) In cells A1-A16, enter the following text in order starting at the top of the column, moving downward: Student, Heather A., Ryan A., Jack C., Colleen D., Phil E., Sara F., Tom G., Paulene G., Tim H., Dan I., Brian K., Forrest L., Morgan M., Danielle N., Beatrice S., and Class Average 2.) 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 55. You decide to use an Excel spreadsheet to accomplish this. Scenario: Suppose you are a teacher who needs an effective way to organize your student’s grades on various assignments. For some practice with entering data, follow these next steps listed: *Note: By default, text data will be left-aligned within the cell and number data will be right-aligned. There are two main types of data that people enter into Excel: Text and Numbers.
0 kommentar(er)
