Excel 2010 dummies free download

Excel returns you to your Book1 workbook file that you leave excel 2010 dummies free download for the next exercise. You can also create the new workbook and close the Available Templates panel in the Backstage Excel 2010 dummies free download by double-clicking the desired template icon. Moving Around the Workbook The key to doing both data entry and data editing in any spreadsheet is selecting the cell or cells you want to fill or modify. Doing this cell selection almost always entails moving the cell cursor or pointer to another part of the current worksheet.

Move the cell pointer to cell C13 using just the down arrow and left arrow keys. Move the cell pointer to cell A1 using the Name Box. One of quickest ways to do this is by entering the reference of the cell you want to go to in the Name Box. You can also use any of the following techniques to scroll to new parts of the current worksheet: After scrolling to a new part of the worksheet in view, you still have to select a cell by clicking in it to set the cursor in it.

The commands that appear on each tab are then further divided into Groups, containing related command buttons. Also, many of these groups contain a Dialog Box Launcher button that appears in the lower-right corner of the Group. Clicking this button opens a dialog box of further options related to the particular Group. Selecting Commands from the Ribbon In Exerciseyou get practice selecting commands from the Ribbon. Make sure that Excel is running and an empty Sheet1 worksheet is active on your computer monitor.

You may have to scroll down the list of command options in the Choose Commands From list box in order to select and add the Draw Borders, Form, and the different Speak Cells command options to the Quick Access toolbar. Next, you want to modify the order in which the command buttons appear on your customized Quick Access toolbar so that they appear in this order arranged in four groups: Click the New command option in the Customize Quick Access Toolbar list box to select it and then click the Move Up button the one with the black triangle pointing upward until New is the first command in this list four times.

Getting Familiar with the Excel Interface such as saving and printing. Before you attempt the exercises in this chapter, you may want to play the Using the Excel Ribbon and Backstage. This video demonstrates selecting commands from the File menu as well as on the Ribbon and Quick Access toolbar. Opening the Backstage View and Selecting Its Menu Commands In this exercise, you get familiar with the new Excel Backstage View and the commands on its File menu as you practice opening the Backstage View and selecting some of its menu commands.

Click the File menu at the top of the menu, immediately above the Save option. Doing this selects the Options command in the Backstage View, which in turn, opens the Excel Options dialog box in the regular worksheet view.

For details on the CD-ROM and how to use its files, see the About the CD appendix. Icons Used in This Book Icons are sprinkled throughout the text of this workbook in high hopes that they draw your attention to particular features. Some of the icons are of the heads-up type, whereas others are more informational in nature: This icon indicates the start of a question and answer section in the workbook.

What is the primary function of the Quick Access toolbar? To enable you to quickly select Excel excel 2010 dummies free download that you use all the time without having to open the File menu or use the Ribbon commands. To group related Excel commands together and give you quick and easy access to these commands. Selecting Commands on the File Menu in the Backstage View Clicking the File menu, the green tab-looking thingy at the far left of the Ribbon, opens the Excel Backstage View with a menu of excel 2010 dummies free download that appears down the left side.

Now customize the name of a clipboard to store your clips. Visibility Others can see my Clipboard.

When you switch to the Backstage View when a workbook file is open for editing, Excel selects the Info option at the top of the menu instead, displaying excel 2010 dummies free download panel with a thumbnail of the current worksheet and a list of properties describing aspects of the file. Click the Info option on the menu. Note that an Information about Book1 panel now appears attached to the immediate right of the Info option and that all of the suboptions, Save through Close above Info, are indented as a group see Figure Now, highlight and click the Save As command to select it.

Excel opens the Rename dialog box where you can replace the generic New Group name with your own descriptive name. Replace New Group by typing Data Form in Display Name text box and then selecting OK. Data Form Custom now excel 2010 dummies free download as the sole group on the Misc custom tab in the Main Tabs list box.

Dedication To all my teachers, mentors, and guides who challenged me to learn more, do more, and give more. I am ever grateful. This time, preliminary thanks are in order to Andy Cummings and Katie Feltman for giving me this opportunity to write in this wonderful workbook format. Thanks to Michael Weber for his thorough text review and great suggestions for improving and clarifying excel 2010 dummies free download of the more lengthy workbook exercises.

You can keep your great finds in clipboards organized around topics. Excel 2010 dummies free download Explore Search You. Excel workbook for dummies [dr. Show related SlideShares at end. Full Name Comment goes here. Are you sure you want to Yes No. Embeds 0 No embeds. No notes for slide. Excel lets you design forms, interact with corporate databases, interpret and present sales figures, and perform dozens of other excel 2010 dummies free download. The exercises in this workbook let you practice the techniques and learn by doing.

Adding a custom tab to the Excel Ribbon Excel enables you to customize the Ribbon by creating a custom tab to which you can then add your own groups of commands.

Introduction Excel is the most sophisticated spreadsheet program available in the world of personal computing. For millions of users the world over, Excel is also their number-one forms designer, their interface to the corporate database, as well as their premier charting program. About This Book As its name suggests, Excel Workbook For Dummies is designed to give you the kind of hands-on experience with all the major aspects of the program you need to start using the program for business or home with a certain degree of confidence and efficiency.

This time, the cell cursor stops in cell AB18 rather than XFD18 because AB18 is now occupied. Both entries in cells A18 and AB18 are deleted and the cell cursor is back in the home cell, A1.

You can also color-code a sheet tab by right-clicking it, clicking Tab Color on the shortcut menu, and then selecting the color square on the pop-up palette. Of course, you must know how to move between the sheets in order to be able to add excel 2010 dummies free download edit data in them. You can also display more tabs by reducing the width of the horizontal scroll bar by dragging to the right the split bar that appears when you position the mouse pointer on the vertical bar at the beginning of the scroll bar.

Most of the time when selecting multiple cells in a worksheet, you select a discrete block of cells of so many rows high and so many columns wide. Such a block is known as a cell range in the parlance of spreadsheet software. A cell range is most often described by the reference of its first and last cell that is, the cell in the upper-left corner and the lower-right corner of its block, respectively.

Excel closes the Backstage View and creates a new workbook file in the regular Worksheet View, indicated by Book2 in the program title bar. Note the excel 2010 dummies free download of Book1 and Book2 program icons on the Windows taskbar.

For other comments, please contact our Customer Care Department within the U. Some of the people who helped bring this book to market include the following: Acquisitions, Editorial, and Media Development Project Editor: Linda Morris Acquisitions Editor: Katie Feltman Copy Editor: Linda Morris Technical Editor: Joyce Nielsen Editorial Manager: Jodi Jensen Media Development Project Manager: Laura Moss-Hollister Media Development Assistant Project Manager: Jenny Swisher Media Development Associate Producer: Josh Frank Editorial Assistant: Lynsey Stanford Layout and Graphics: Jacqui Brownstein, Rebecca Denoncour Indexer: Infodex Indexing Services, Inc.

Moving the Cell Cursor to Unseen Parts of a Worksheet In Exerciseyou get practice moving the cell cursor to cells in the same worksheet that are not currently displayed on your screen. Move the cell cursor to cell C with the Name Box on the Formula Bar.

The final version of your customized Quick Access toolbar now appears once again above the Ribbon to the immediate right of the File menu. The Excel Options dia- log box with the Quick Access Toolbar option selected. The top part of the Excel display screen with the custom Misc tab and the customized Quick Access Toolbar. As a result of doing the exercises in this chapter, you will have practice in launching Excel, moving around a new spreadsheet, the many aspects of doing data entry, and, most importantly, saving your work.

This dialog box contains all the options for changing the Excel program and worksheet options. These options are divided into categories General through Trust Center.

If necessary, launch Excel excel 2010 dummies free download, in the program title bar, note that Book1 is the current workbook file.

Move the cell cursor to cell J10 on Sheet2. If used in a formula on another worksheet, this cell reference is indicated as Sheet2! Select cell M21 on Sheet3. When you move the cell cursor to a cell, you, in essence, select that cell. If you were to refer to this cell in a formula on another worksheet, this cell would be designated as Sheet3!

The chapters excel 2010 dummies free download exercises in Part I form the core skills on which all spreadsheet users rely. These skills run the gamut from navigating the commands on the tabs of the Excel Ribbon and on the File menu in the Backstage View, customizing the Quick Access toolbar and Excel Ribbon, and performing basic data entry, all the way to more complex data editing, with cell formatting and worksheet printing in between.

That being said, it is still to your benefit to complete all the exercises within a particular chapter, if not in a single work session, at least in a short time period. The exercises in this part are truly fundamental and are meant to give you a strong foundation in the basic features that all Excel users need to excel 2010 dummies free download. Please keep in mind that I designed the exercises in this workbook to work with my Excel companion books, Excel For Dummies and Excel All-In-One Excel 2010 dummies free download Dummies Wiley.

For some of the printing exercises, you will benefit from having a printer installed on your system although you can complete most of their steps and get the gist of the lessons without actually printing the sample worksheets. This workbook is designed exclusively for users of Microsoft Office Excel As such, all the practice material utilizes features such as the Ribbon command structure, Live Preview, and style galleries that were newly introduced in Excel The sample Workbook files are all saved in the Microsoft Office XML file format.

Click Budgets under Office. Excel displays a preview of this template and its name in the preview pane on the right. Click the Download button excel 2010 dummies free download press Enter. Excel downloads a copy of the Event Budget template while at the same time closing the Available Templates panel in the Excel 2010 dummies free download View.

Notice what happens to Book2 when you close Book1. Leave Book2 open for the next exercise. To switch back to Book2, click the Book2 icon or thumbnail on the taskbar so that Sheet1 of Book2 is selected.

Excel opens the Save As dialog box in the regular worksheet view where you can modify the name, location, and type of Excel workbook file before saving a copy of it. Press the Esc Escape key on your excel 2010 dummies free download to close the Save As dialog box. This time, small letters appear on each command in the Backstage View menu. These are the access keys that you can type to select a menu option rather than clicking its name or button.

To facilitate this crossover usage, I have, wherever possible, used the same example files in the exercises of this workbook as you see illustrated and explained excel 2010 dummies free download length in these references. Whatever you do next and wherever you go in this workbook, just be sure that you enjoy yourself!

Practice launching Excel by double-clicking the Excel program shortcut on the Windows desktop and then exiting the program. Then launch Excel again, this time by clicking the Excel button on the Windows taskbar. You can leave Excel running for Exercise Opening a New Workbook Each time you launch Excel using any method other than double-clicking an Excel workbook file icona new workbook containing three blank worksheets opens. You can build your new spreadsheet in excel 2010 dummies free download workbook, using any of its sheet pages.

As soon as you drop the icon on the Windows Taskbar or Quick Launch toolbar, Windows pastes a copy of the Excel program shortcut on the toolbar. You can then launch Excel by clicking this Excel button excel 2010 dummies free download the Windows taskbar.

Entering the Spreadsheet Data Exercise Open a New Workbook File from an Installed Template File In Exerciseyou open a new workbook from the Personal Monthly Budget template installed with Excel This time, you will select a home budgeting template to use in creating your new workbook file.

Moving to a different sheet in the workbook Each new workbook you start uses the general Excel Worksheet template that automatically includes three blank worksheets that you can fill with data. Each sheet in a workbook is automatically given the next available excel 2010 dummies free download name, such as Sheet1, Sheet2, and the like, but you can easily replace these generic names with something descriptive: Double-click the tab you want to rename, type the new sheet name, and press Enter.

For that reason, as well as to excel 2010 dummies free download you get comfortable with unfamiliar Ribbon commands, you will work with the Ribbon expanded at all times in all remaining exercises in this workbook. The Ribbon now remains fully displayed at all times as you select any of its tabs and command buttons without ever obscuring any part of the worksheet display.

Click Start on the Windows taskbar and then type exc in the Search box before you excel 2010 dummies free download Microsoft Excel at the top of the Start menu. Excel adds a program shortcut icon called Microsoft Excel to the desktop. You can then launch Excel by double-clicking this program shortcut on the Windows desktop. Drag the Microsoft Excel program shortcut icon to the Quick Launch toolbar and then drop this icon on to the bar some place in between its displayed buttons.

Use the same technique to move the Open command button up until it appears between the New and the Save button. Use the Move Down button to move the Undo and Redo buttons so that they now appear in the same order below the Quick Print and Print Preview and Print buttons. Getting Familiar with the Excel Interface The command buttons for your customized version of the Quick Access toolbar now appear in the correct order in the Customize Quick Access Toolbar list box in the Excel Options dialog box.

F20, for a six-row and five-column cell range whose first cell is B15 and last cell is F Materials and Textures Cookbook, Third Edition - Sample Chapter. Using power query to tell your story form your facebook data. Financial Modelling Best Practice in MS Excel www. Ms Excel Training in Ambala! Excel Excellence Microsoft Excel training that "sticks": Como identificar fuentes confiables en internet. Start clipping No thanks. You just clipped your first slide! Clipping is a handy way to collect important slides you want to go back to later.

If you want to start work on a spreadsheet in another workbook, click the New command button on your customized version of the Quick Access toolbar assuming that you performed Exercise in Chapter 1. Entering the Spreadsheet Data When Excel opens a blank workbook, the new workbook follows the Blank Workbook template which controls the formatting applied to all its blank cells.

Click the Formulas tab to displays its commands. Note that the commands on the Formulas tab are divided into four Groups: Function Library, Defined Names, Formula Auditing, and Calculation. Press the Alt key. Note the access-key letters that now appear on the File menu, Quick Access toolbar options, and the Ribbon tabs.

Practice Moving the Cell Cursor to Different Sheets of the Same Workbook In Exerciseyou get practice moving the cell cursor to specific cells in different worksheets of the workbook named Excel 2010 dummies free download, which should be open in Excel.

Click the Add button. Excel inserts a separator between the Print Preview and Print and Undo command options in the Customize Quick Access Toolbar list box. Use this same technique excel 2010 dummies free download add a Separator between the Redo and AutoFormat command excel 2010 dummies free download and the Form and Speak Cells command options in the Customize Quick Access Excel 2010 dummies free download list box.

Chapter 6 introduces you to formula-making just as Chapter 7 introduces you to the all-important topic of formula copying. Working with Graphics This part takes you into the graphical aspects of Excel, the most important of which is its rich and versatile charting capabilities covered in Chapter Managing and Securing Data This part is concerned with the management and security of the vast amounts of data that you accumulate in your worksheets.

As soon as you have these skills under your belt, you are well on your way to mastering Excel. The File menu contains all the File commands. Also, in place of the many toolbars in the pre-Excel versions, Excel offers a single toolbar called the Quick Access toolbar. The exercises in this first chapter are designed to get you familiar with the Excel interface. As a result of doing these exercises, you should be comfortable with all aspects of the display screen and the command structure and ready to do all the rest of the exercises in this book.

Click the drop-down button on the Choose Commands From drop-down list box and then click the Commands Not in the Ribbon option on its drop-down menu. The Choose Command From list box now contains only command buttons that are not found on the various tabs of the Excel Ribbon.

When you first create a custom tab, it contains only a single, generic New Group Custom into which to add your commands. You can, however, add other groups to the custom tab using the New Group command button as well as give these groups their own descriptive names using the Rename command button. Creating Spreadsheets Exercise Adding Commands to a Custom Tab In Exerciseyou get practice adding commands to the custom tab you added to the Ribbon in Exercise Before you start this exercise, make sure that the Excel Options dialog box is still open with a Misc Custom tab appearing in the Main Tabs list box between View and Developer.

Sometimes, it also involves activating a different worksheet in the workbook file. Excel gives you plenty of choices in techniques for moving the cell cursor, some of which use the mouse and others of which are keyboard-driven. Moving the Cell Cursor in a Displayed Area of the Worksheet For Exercisemake sure Sheet1 of the blank workbook, Book1, is active before you start practicing moving the cell cursor to different cells in the displayed area using the mouse, arrow keys, and Name Box: Move the cell pointer to cell F9 with the mouse.

Note the names of the different parts of the display screen before you perform Exercise Creating Spreadsheets Figure The Excel program window as it appears immedi- ately after launching the program. Worksheet areaFile menuName box Formula bar RibbonQuick Access toolbar Zoom excel 2010 dummies free download View buttons Status bar Sheet tabs Q. What are the primary functions of the commands located on the File menu in the Excel Backstage View? To open, close, save, print, and share your Excel workbook files as well as to modify the Excel program options.

Move the cell cursor directly to cell A1 the Home cell in a single operation. Hold down the Shift key to scroll quickly through columns and rows by dragging the scroll box in the horizontal or vertical scroll bar. After scrolling into view the region with the cell you want to select, you still need to click in the cell to select it. Use the Ctrl key in combination with any of the four arrow keys to jump from occupied cell to occupied cell in a particular direction. Moving the Cell Cursor Using the Ctrl and Arrow Keys In Exerciseyou get practice moving the cell pointer around a blank worksheet and between data entries with the Ctrl key and the arrow keys in Sheet1 of Book1.

Leave the Book1 workbook with the renamed tab open for the next exercise. Selecting Cell Ranges When entering, editing, or formatting a single cell, all you have to do is move the cell cursor to it as you practiced in the earlier excel 2010 dummies free download. You can also enter the same data as well as do the same type of editing and formatting in a bunch of cells at one time, but to do so, you must first select the cells where all this is going to happen.

Getting Familiar with the Excel Interface Selecting Commands from the Ribbon The Excel Ribbon contains the bulk of all the commands that you use in creating, editing, formatting, and sharing your spreadsheets, charts, and data lists. As shown in Figurenormally the Ribbon is divided into seven tabs: Home, Insert, Page Layout, Formulas, Data, Review, and View.

Click the Advanced button in the left pane to display all the Advanced options in the right pane. Next, scroll down to the Display Options for This Worksheet section and click the Show Page Breaks check box to remove its check mark before you click the OK command button to close the dialog box. Note excel 2010 dummies free download deselecting the Show Page Breaks option in the Excel Options dialog box removes all the dashed page break lines from the Sheet1 worksheet. The Excel Backstage View when the Info menu option is selected.

You can use either method to switch between open Excel workbook files. Excel closes Book2 and returns you to Book1. Note that the program would have prompted you to save changes to Book2 before closing it if you had made any data entries in the first worksheet of this workbook. Leave the Book1 workbook open for the next exercise.

Excel 2010 dummies free download template is a particular type of Excel file designed to automatically generate new workbooks that use both its data and formatting. Excel template files use the filename extension. Switch back to Book1 notice the change in the Excel program title bar and then close the workbook.

Excel adds the Quick Print button to the Quick Access toolbar that you can click to send the current worksheet to the printer. Use the same technique to add the New, Open, and Print Preview and Print command buttons to the Quick Access toolbar on your own. Using command options that appear in the Excel Options dialog box, you can add buttons for any of the commands that appear on the various tabs of the Ribbon as well as some Excel commands that remain completely unavailable until you add them to the Quick Access toolbar.

After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

The Excel Options dialog box with the Customize Ribbon option selected. Adding commands to groups on your custom tab After you add a custom tab to the Excel Ribbon, you can then start adding the commands you want to appear on this tab. Just as with the standard Ribbon tabs, the commands you add on your own custom tab are arranged in groups.

Your customized Quick Access toolbar now contains four groups excel 2010 dummies free download command buttons created by the three Separator options that appear after the Print Preview and Print command option, Redo command option, and the Form command option. Click OK to close the Excel Options dialog box. Check the buttons on your customized toolbar against those shown in the toolbar in Figure On the Quick Access toolbar, click the Customize Quick Access Toolbar button followed by the Excel 2010 dummies free download Above the Ribbon option on its menu.

The title case is used to make these names stand out from the rest of the text. Often, however, especially in the case of dialog box options, Microsoft does not always follow this convention, preferring to capitalize only the first letter of the option name. To complete most of the exercises in this workbook, you only need to have Microsoft Excel installed on a computer running a version of Microsoft Windows XP, Windows 7, or Windows Vista.

Excel opens the Available Templates panel in the Excel Backstage View. Click the Blank Workbook icon followed by clicking the Create button or press Enter.

Click the Minimize the Ribbon button the one with the caret symbol to the immediate left of the help button with the question mark icon. Excel immediately minimizes the Ribbon to display only the seven tab names and the Minimize the Ribbon button changes to the Expand the Ribbon button indi- cated by the caret symbol pointing downward. Click Data on excel 2010 dummies free download minimized Ribbon.

Launching Excel Excel is only one of the primary application programs included as part of Microsoft Office In order to be proficient in its use, you need to be familiar with all the various ways of launching the program. How many ways are there to start Excel ? You should be familiar with all these methods: Can I have Excel launch automatically each time I start my computer? Copy the Microsoft Excel option to the Startup submenu on the All Programs menu by holding down the Ctrl key as you drag this option from the Microsoft Office menu to the Startup menu.

Publishing and Editorial for Technology Dummies Richard Swadley, Vice President and Executive Group Publisher Andy Cummings, Vice President and Publisher Mary Bednarek, Executive Acquisitions Director Mary C. Contents at a Glance Introduction Getting Familiar with the Excel Interface Entering the Spreadsheet Data Using Formulas and Functions Copying and Correcting Formulas Creating Date and Time Formulas Financial Formulas and Functions Using Common Statistical Functions Text Formulas and Functions Adding Graphics to Spreadsheets Managing and Securing Data Building and Maintaining Data Lists Macros and Visual Basic for Applications Using the Visual Basic Editor The Part of Tens Top Ten Features in Excel Top Ten Tips for Using Excel Like a Pro Comparing Worksheets Side by Side Table of Contents Introduction Getting Familiar with the Excel Interface.

In excel 2010 dummies free download a case, I suggest that you get your hands on a copy of my Excel Workbook For Dummies Wiley. Instead, pick up a copy of the original Excel Workbook For Dummies Wiley. That edition covers the same material, exercises, and Excel features as this workbook following the classic command structure. Moreover, its sample files are saved in the classic workbook file format that your version of Excel can open. How This Book Is Organized This workbook is organized into seven Parts, the first six of which contain the chapters with exercises you perform to become proficient in the use of particular Excel commands and features.

The options on this pull-down menu enable you to quickly customize the command buttons on this toolbar. In addition, you can change the placement of the toolbar by moving it down so that it appears immediately below the Ribbon and above the Formula bar. Quickly Customizing the Quick Access Toolbar In Exerciseyou get practice excel 2010 dummies free download the contents and position of the Quick Access toolbar using options that appear on the Customize Quick Access Toolbar menu.

This icon indicates a hint that can help you perform a particular step in the exercise. This icon indicates a tidbit that, if retained, can make your work somewhat easier in Excel. This icon indicates a tidbit that is excel 2010 dummies free download to the topic being discussed and is, therefore, worth putting under your hat. This icon indicates a bit of trickery in the topic that, if ignored, can lead to some sort of trouble in your spreadsheet.

Excel expands the Ribbon to display all of the Excel 2010 dummies free download tab command buttons. Click anywhere in the worksheet area excel 2010 dummies free download minimize the Ribbon once again. The only problem with this minimized Ribbon arrangement is that the temporarily expanded Ribbon covers the first three rows of the worksheet. This makes it very difficult to work with data at the top of the worksheet.

Click the OK button to close the Excel Options dialog box. The custom Misc tab you just created now appears excel 2010 dummies free download the end of the Excel Ribbon. The Misc tab is selected, displaying its sole Form button in the single Data Form group. Click the Home tab to select it. Selecting Commands on the Quick Access Toolbar When you first start working with Excelthe Quick Access toolbar contains only the following three simple command buttons: Getting Familiar with the Excel Interface Customizing the Quick Access toolbar In addition to the three default command buttons, the Quick Access toolbar contains a Customize Quick Access Toolbar button the one with the line above a downward pointing triangle that, when clicked, opens a pull-down menu.

Type c excel 2010 dummies free download the Name Box and then press the Enter key. Move the cell cursor to cell CA using the horizontal scroll bar. Hold down the Shift key as you drag the scroll box in the horizontal scroll bar to the right until column CA appears and then click cell CA to put the cell cursor in it. Move the cell cursor to cell CA using the vertical scroll bar. Hold down the Shift key and drag the scroll box in the vertical scroll bar down until row appears and then click cell CA to put the cursor in it.

Excel displays the Customize the Ribbon panel in the Excel Options dialog box. This panel is divided into two list boxes: Popular Commands on the left side and Main Tabs on the right side see Figure Click the View tab check box in the Main Tabs list box to select it and then click the New Tab button. Getting Familiar with the Excel Interface Excel inserts a generic New Tab Custom with a generic New Group Custom right below it.

Greg recently received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion. Everyone is glad that Excel 2010 dummies free download was finally able to get out of school before he retired.

In the Worksheet View, the program inserts a copy of the budget template as a new workbook automatically named EventBudget1 in the Excel program title bar. This template is all set for you to start editing its values. Close the EventBudget1 workbook file.

Identifying the Parts of the Excel Display Screen Before you can start using Excelyou have to be familiar with its display screen. Figure shows you the Excel display screen as it first excel 2010 dummies free download when you launch the program.

This custom tab and group appear between the View tab and the Developer tab in the Main Tabs list box. Click New Tab Custom in the Main Tabs list box to select it and then click the Rename command button. Excel opens the Rename dialog box where you can replace the generic New Tab display name with a descriptive name. Replace New Tab by typing Misc for Miscellaneous in excel 2010 dummies free download Display Name text box and then select OK. Misc Custom now appears in the Main Tabs list box sandwiched between View and Developer.