Found 667 related files. Current in page 11
Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style.
Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks. Three types of basic data In a spreadsheet there are three basic types of data that can be entered. • • • labels - (text with no numerical value) constants - (just a number -- constant value) formulas* - (a mathematical equation used to calculate) data types examples descriptions LABEL Name or Wage or Days anything that is just text CONSTANT 5 or 3.75 or -7.4 any number FORMULA =5+3 or = 8*5+3 math equation *ALL formulas MUST begin with an equal sign (=). Page 4 of 19 Operands Operator Name How to type the sign Alternative + Addition Hold down the shift key and press the Plus sign (+) located next to the backspace Press the Plus sign (+) located on the Num Lock keypad section. – Subtraction Press the dash (hyphen “- Press the Minus sign (-) “) key located next to the located on the Num Lock number zero. keypad section. * Multiplication Hold down the shift key Press the asterisk (*) key and press the number 8 on the Num Lock keypad key – the asterisk (*) / Division Press the forward slash (/) Press the forward slash (/) located under the question key on the Num Lock mark (?) keypad
Essential Fundamentals of EXCEL 2010 What is Excel? Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis. Excel is a spreadsheet program that allows you to store, organize, and analyze information. . A panel that contains the command buttons and icons, organized into a set of tabs. For example: Home tab, Insert tab, Page Layout tab etc. The entire block that stretches from the upper-left side to the upper-right side of the application is called the Ribbon. The Ribbon is a unique interface component that comprises several task-specific commands grouped under various commands. The Ribbon provides the ability to identify desired functions and to perform both simple and advanced operations without having to navigate extensively.
The Fundamentals • The File tab menu and Backstage view contain commands for working with a program’s files, such as Open, Save, Close, New, and Print. • To Create a New Workbook: Click the File tab and select New, and click Create, or press + . • To Open a Workbook: Click the File tab and select Open, or press + . • To Save a Workbook: Click the Save button on the Quick Access Toolbar, or press + . • To Preview and Print a Workbook: Click the File tab and select Print, or press + . • To Undo: Click the Undo button on the Quick Access Toolbar, or press + . • To Redo or Repeat: Click the Redo button on the Quick Access Toolbar, or press + . • To Close a Workbook: Click the Close button, or press + . • To Get Help: Press to open the Help window. Type your question and press . • Cell addresses: Cells are referenced by addresses made from their column letter and row number, such as cell A1, A2, B1, B2, etc. You can find the address of a cell by looking at the Name Box. • To Select a Cell: Click a cell or use the keyboard arrow keys to select it. • To Select a Cell Range: Click and drag to select a range of cells. Or, press and hold down the key while using the to move the mouse pointer to the last cell of the range.
Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007. We will show you how to use and modify the Ribbon and the Quick Access Toolbar, and how to create new workbooks and open existing ones. After this lesson, you will be ready to get started on your first workbook. Getting to Know Excel 2010 The Excel 2010 interface is very similar to Excel 2007. There have been some changes that we will review later in this lesson, but if you are new to Excel, first take some time to learn how to navigate an Excel workbook. Video: Navigating Excel 2010 Watch the video (3:04). Need help? The Excel Interface Click the buttons in the interactive below for an overview of how to navigate through an Excel workbook. ©1998-2013 Goodwill Community Foundation, Inc. All rights reserved.
Microsoft® Excel® 2010 delivers rich, new and enhanced features to the world’s most popular productivity suite. Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions. With new data analysis and visualization tools, along with managed self-service business intelligence technologies, you can create effective business or information insights that track and highlight important data trends and communicate your results through high-quality charts and graphs. You can also easily share your insights with others through Microsoft SharePoint® 2010 or your Windows Live™ account. Work better together by working simultaneously with others online and accomplish your most important tasks faster. Your information is never far away as you can access your files from almost anywhere—from your PC, a Web browser, or smartphone.1 With Excel 2010 you can work when and where you want. Whether you’re producing financial reports, managing personal expenses, collaborating with a team on school or work projects—even if your workbooks exceed a million rows—Excel 2010 makes it easier to get what you need done more quickly, with more flexibility, and with better results. Welcome to Excel 2010—our most powerful and intuitive version yet.
Excel provides many ways to repeat information in many cells throughout a worksheet. The most convenient way to repeat information in contiguous cells is by using the Fill command. If the first cell contains a formula, the formula will be repeated in the additional cells. If the first cell contains text, the text will be repeated in the additional cells. You can allow Excel to automatically fill in the information for you, or you may choose to create custom patterns of information. NOTE: If Excel recognizes a pattern in the information you entered, the additional cells will contain the next item in the pattern. For example, if the first cell contains the day Sunday, Excel will fill the following cells with Monday, Tuesday, etc. Other examples include filling months of the year and hours of the day. Filling Cells: Ribbon Option (This option copies (repeats) the information from one cell to another.) 1. Type the information (cell contents or formula) in the first cell of the group 2. Starting with the cell containing the contents to be copied, select the group of cells to be filled 3. From the Ribbon, select the Home command tab 4. In the Editing group, click Fill ...
How To Use VLOOKUP in Excel 2010 This short tutorial uses Excel 2010 and sample file to show you a working example of the VLOOKUP function. Article reference: http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel Excel sample file: http://static.timeatlas.com/tutorials/VLOOKUP_Example.xls Video reference: http://www.timeatlas.com/news/projects/vlookup_demo Last Revised: May 20, 2012 1. Download the Excel VLOOKUP sample file shown in the More VLOOKUP References section Note: For this tutorial, we will be deleting information on this sheet and recreating the VLOOKUP formula. How To Use VLOOKUP in Excel 2010 - 1 Please v isit www.timeatlas.com f or more tips and tutorials. 2. Open the sample file you downloaded from above in Excel. The workbook will have 2 sheets at the bottom: Voters and Party Codes. The first sheet is a listing of registered voters and the second contains names of political parties. 3. Delete the cell entries for D2:D7 because we will be rebuilding the formula. Note: You can keep the column header "Politcal Party". How To Use VLOOKUP in Excel 2010 - 2 Please v isit www.timeatlas.com f or more tips and tutorials. 4. Place your cursor in cell D2. Click the Formulas tab and select Insert Function. How To Use VLOOKUP in Excel 2010 - 3 Please v isit www.timeatlas.com f or more tips and tutorials. 5. In the Search for a function: text box type "vlookup" and click the Go button. How To Use VLOOKUP in Excel 2010 - 4 Please v isit www.timeatlas.com f or more tips and tutorials. 6. Highlight VLOOKUP and click OK. How To Use VLOOKUP in Excel 2010 - 5 Please v isit www.timeatlas.com f or more tips and tutorials.
Note: Some third party utilities, macros and add-ins can overwrite native shortcut keys, in which case they will not work. Formatting shortcuts Bold Italic Underline Format Box Clear cell Outline border Remove border Insert a comment CTRL + B CTRL + I CTRL + U CTRL + 1 ALT + H + E + A SHIFT + CTRL + & SHIFT + CTRL + _ SHIFT + F2 Copy Paste Paste Special Cut Repeat Undo Delete selected cells CTRL + C CTRL + V ALT H + V + S (ALT + E + S still works) CTRL + X CTRL + Y CTRL + Z CTRL + Minus sign Workbook navigation shortcuts Toggle Excel workbooks CTRL + TAB Split Screen ALT + W + S (F6 to jump from pane to pane) Freeze pane ALT + W + F New workbook CTRL + N Print CTRL + P Open workbook CTRL + O (CTRL + F12) Save workbook CTRL + S Activate menu bar ALT or F10 Min / Restore Ribbon CTRL + F1 Print preview ALT + F + W + V (CTRL F2) Close window CTRL + W (CTRL + F4) Close program ALT + F4 Other useful shortcuts Excel Options Recalculate all workbooks Display a drop-down list Display “Insert Function” box Display “Name” box Enter array formula Auditing shortcuts Trace immediate precedents Trace immediate dependents Remove tracing arrows Evaluate formula Track changes Zoom to selection Go to precedent cells Go to dependent cells Go back to original cell “Go to” ALT + F + T F9 ALT + up/down arrow keys ALT + I + F (SHIFT F3) CTRL F3 SHIFT + CTRL + Enter ALT + M + P ALT + M + D ALT + M + A + A ALT + M + V ALT + R + G ALT + W + G CTRL + [ CTRL + ] F5 + Enter F5 Tab navigation Move/ Copy a tab Change tab name Moving to left/right tabs New tab ALT + H + O + M ALT + H + O + R CTRL + Pg Up/Down SHIFT + F11 Row / column shortcuts Select column Select row Delete row(s) / column(s) Add row(s) / column(s) Group / ungroup rows and columns Fit column width CTRL + Space Shift + Space CTRL + 'minus sign' CTRL + SHIFT + 'plus sign' SHIFT + ALT + left / right arrow key ALT + H + O + I Data editing shortcuts Select All Fill Down Fill right Find Replace CTRL + A CTRL + D CTRL + R CTRL + F CTRL + H Edit cells Start a formula Insert AutoSum formula...
Microsoft Excel 2010 looks very different from Excel 2003, so we created this guide to help you minimize the learning curve. Read on to learn key parts of the new interface, discover free Excel 2010 training, find features such as Print Preview or the Options dialog box, understand how to exchange workbook files with people who don’t yet have Excel 2010, and find out how to enable add-ins or get access to macros and other advanced features. Ribbon Groups Quick Access Toolbar Ribbon Tabs Commands shown here are always visible. You can add your favorite commands to this toolbar. Click any tab on the ribbon to display its buttons and commands. Each ribbon tab contains groups, and each group contains a set of related commands. Here, the Number group on the Home tab contains commands for displaying numbers as currency, percentages, and so on. Backstage View Hide the Ribbon Click the File tab to enter Backstage view, where you can open, save, print, and manage your Excel files. Need more space on your screen? Click this icon or press CTRL+F1 to hide or show the ribbon. Dialog Box Launchers Contextual Ribbon Tabs Some tabs appear on the ribbon only when you need them. For example, if you insert or select a chart, you’ll see Chart Tools, which includes three extra tabs — Design, Layout, and Format. If you see a dialog box launcher icon ( ) next to any ribbon group label, click it to open a dialog box with more options for that group. Zoom In or Out Click these buttons to display the current worksheet in Normal, Page Layout, or Page Break Preview view. To exit Backstage view, click any ribbon tab. Switch Between Views Click the 100% zoom button to select a zoom level, or drag the zoom slider to the right or left side. © 2010 by Microsoft Corporation. All rights reserved.