Microsoft Excel Step by Step: Frye, Curtis: : Books.microsoft excel step by step pdf free download
Looking for:
Excel video training - Customers who viewed this item also viewed |
- Download Microsoft Excel Step By Step PDF Book | Find Popular Books
Why does the sits not allow you to download. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question 0. Report abuse.
Details required :. Cancel Submit. Hi ChristineMcHale1! Jen :. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Choose where you want to search below Search Search the Community. PDF The popular standard, which reproduces the look and layout of the printed page. This eBook requires no passwords or activation to read.
We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. About eBook formats. Step-by-step, full-color guide to learning Microsoft Excel Easy lessons for essential tasks Big full-color visuals Skill-building practice files.
I have some excel experience so I was able to tolerate it but I wouldn't recommend the e-book to students who are impatient and have short attention spans. I bought this because my work requires me to use Excel.
Before my job I had never used Excel. I hoped the book would help me learn how to use Excel, but it is not put in a good, systematic order. It's a new book.
Not much to write about. I got what I paid for. This book is used a lot by me and the office staff for reference! See all reviews. Top reviews from other countries.
It is only useful for people who have 0 knowledge of both computer and Excel. And it does not provide any deeper knowledge of Excel.
Waste of my money! Bought kindle version, wish I could return for a refund. Report abuse. This one is to be avoided. This is a really badly written book which does not help to learn new skills. It reads like a computer manual. You are much better off looking at Microsoft Office Tutorials website. I only bought this one because I enjoyed Visio book from the same series. I wish I could return it.
I got this to help me prepare spreadsheets, always used excel but never had proper training, need to be more interactive for a new job.
I bought this based on the reviews. Rookie error. This book is NOT for beginners. It is too complex and too American. You absolutely need significant prior knowledge of excel.
Your recently viewed items and featured recommendations. Back to top. Get to Know Us. Make Money with Us.
Amazon Payment Products. Let Us Help You. My Excel includes Content Update Program. Microsoft Excel Step by Step.
Microsoft excel 2016 step by step free -
- Microsoft excel 2016 step by step free
When not writing, Curt is a popular conference speaker, corporate entertainer, and professional improvisational comedian with ComedySportz Portland. Enhance your purchase. Now in full color! The quick way to learn Microsoft Excel ! This is learning made easy. Get more done quickly with Excel Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step.
Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need.
Previous page. Print length. Microsoft Press. Publication date. See all details. Next page. Frequently bought together. Total price:. To see our price, add these items to your cart. One of these items is dispatched sooner than the other.
Show details Hide details. Choose items to buy together. This item: Microsoft Excel Step by Step. Usually dispatched in 6 to 10 days. Microsoft Word Step By Step.
In stock. Customers who viewed this item also viewed. Page 1 of 1 Start over Page 1 of 1. Lokesh Lalwani. Winston Wayne. Lambert Joan. Advance Excel Training Guide. Ritu Arora. Prof Satish Jain. Wayne L. KB Articles: KB Windows 10, Windows 7, Windows 8, Windows 8. Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts. Select Language:.
Microsoft has released an update for Microsoft Excel Bit Edition. Rather than adding controls to an existing ribbon tab, you can create a custom tab and then add groups and commands to it. You can export your ribbon customizations to a file that can be used to apply those changes to another Excel installation.
And, as with the Quick Access Toolbar, you can always reset the ribbon to its original state. The ribbon is designed to use space efficiently, but you can hide it and other user interface elements such as the formula bar and row and column headings if you want to increase the amount of space available inside the app window.
To display a ribbon tab 1. In the Excel Options dialog box, click Customize Ribbon. Select the check box next to the tab you want to appear on the ribbon 4.
To hide a ribbon tab 1. To reorder ribbon elements 1. In the tab list on the right side of the dialog box, click the element you want to move. Click the Move Up button the upward-pointing triangle on the far right to move the button or group higher in the list and to the left on the ribbon tab.
Or Click the Move Down button the downward-pointing triangle on the far right to move the button or group lower in the list and to the right on the ribbon tab. To create a custom ribbon tab 1.
To create a custom group on a ribbon tab 1. On the Customize Ribbon page of the Excel Options dialog box, click the ribbon tab where you want to create the custom group. Click New Group. To add a button to the ribbon 1.
On the Customize Ribbon page of the Excel Options dialog box, click the ribbon tab or group to which you want to add a button. Tip The tool tabs are the contextual tabs that appear when you work with workbook elements such as shapes, images, or PivotTables. Click the command to add to the ribbon. To rename a ribbon element 1. Click Rename. In the Rename dialog box, enter a new name for the ribbon element. To remove an element from the ribbon 1. On the Customize Ribbon page of the Excel Options dialog box, click the ribbon tab or group you want to remove.
To export your ribbon customizations to a file 1. To import ribbon customizations from a file 1. Import ribbon settings saved from another Office installation 2.
In the File Open dialog box, click the configuration file. Click Open. To reset the ribbon to its original configuration 1.
In the dialog box that appears, click Yes. To hide or unhide the ribbon 1. To hide or unhide the formula bar 1. On the View tab, in the Show group, select or clear the Formula Bar check box. To hide or unhide the row and column headings 1. In the Show group, select or clear the Headings check box. To hide or unhide gridlines 1. In the Show group, select or clear the Gridlines check box. Skills review In this chapter, you learned how to: Explore the editions of Excel Become familiar with new features in Excel Create workbooks Modify workbooks Modify worksheets Merge and unmerge cells Customize the Excel app window.
You can save the results of the tasks in the same folder. Create workbooks Open the CreateWorkbooks workbook in Excel, and then perform the following tasks: 1. Close the CreateWorkbooks file, and then create a new, blank workbook. Save the new workbook as Exceptions Add a tag to the Category property called performance. Create a custom property called Performance, leave the value of the Type field as Text, and assign the new property the value Exceptions.
Save your work. Modify workbooks Open the ModifyWorkbooks workbook in Excel, and then perform the following tasks: 1. Create a new worksheet named Rename the Sheet1 worksheet to and change its tab color to green.
Delete the ScratchPad worksheet. Copy the worksheet to a new workbook, and then save the new workbook under the name Archive In the ModifyWorkbooks, workbook, hide the worksheet. Modify worksheets Open the ModifyWorksheets workbook in Excel, and then perform the following tasks: 1.
On the May 12 worksheet, insert a new column A and a new row 1. After you insert the new row 1, click the Insert Options action button, and then click Clear Formatting.
Hide column E. On the May 13 worksheet, delete cell B6, shifting the remaining cells up. Click cell C6, and then insert a cell, shifting the other cells down. Enter the value in the new cell C6. Select cells EF13 and move them to cells BC Merge and unmerge cells Open the MergeCells workbook in Excel, and then perform the following tasks: 1.
Merge cells B2:D2. Merge and center cells B3:F3. Merge the cell range B5:E8 by using Merge Across. Unmerge cell B2. Add the Spelling button to the Quick Access Toolbar. Move the Review ribbon tab so it is positioned between the Insert and Page Layout tabs. Create a new ribbon tab named My Commands. Rename the New Group Custom group to Formatting. In the list on the left side of the dialog box, display the Main Tabs.
From the buttons on the Home tab, add the Styles group to the My Commands ribbon tab you created earlier. Again using the buttons available on the Home tab, add the Number group to the Formatting group on your custom ribbon tab.
Save your ribbon changes and click the My Commands tab on the ribbon. Work with data and Excel tables. In this chapter Enter and revise data Manage data by using Flash Fill Move data within a workbook Find and replace data Correct and expand upon data Define Excel tables. With Excel , you can visualize and present information effectively by using charts, graphics, and formatting, but the data is the most important part of any workbook.
Excel provides a wide variety of tools you can use to enter and manage worksheet data effectively. For example, you can organize your data into Excel tables so that you can store and analyze your data quickly and efficiently. Also, you can enter a data series quickly; repeat one or more values; and control how Excel formats cells, columns, and rows that you move from one part of a worksheet to another; all with a minimum of effort. With Excel, you can check the spelling of worksheet text, look up alternative words by using the thesaurus, and translate words to foreign languages.
This chapter guides you through procedures related to entering and revising Excel data, moving data within a workbook, finding and replacing existing data, using proofing and reference tools to enhance your data, and organizing your data by using Excel tables.
Enter and revise data After you create a workbook, you can begin entering data. The simplest way to enter data is to click a cell and type a value. Store important business data in your worksheets. Tip To cancel data entry and return a cell to its previous state, press Esc. With AutoFill, you enter the first element in a recognized series, and then drag the fill handle in the lower-right corner of the cell until the series extends far enough to accommodate your data.
By using a similar tool, FillSeries, you can enter two values in a series and use the fill handle to extend the series in your worksheet. You do have some control over how Excel extends the values in a series when you drag the fill handle. If you drag the fill handle up or to the left , Excel extends the series to include previous values. Another way to control how Excel extends a data series is by holding down the Ctrl key while you drag the fill handle.
If you select a cell that contains the value January and then drag the fill handle down, Excel extends the series by placing February in the next cell, March in the cell after that, and so on. If you hold down the Ctrl key while you drag the fill handle, however, Excel repeats the value January in each cell you add to the series. Tip Experiment with how the fill handle extends your series and how pressing the Ctrl key changes that behavior.
Using the fill handle can save you a lot of time entering data. To turn on AutoComplete, display the Backstage view, and then click Options. In the Excel Options dialog box, display the Advanced page. Another handy feature in Excel is the AutoFill Options button that appears next to data you add to a worksheet by using the fill handle. Use AutoFill options to control how the fill handle affects your data Clicking the AutoFill Options button displays a menu of actions Excel can take regarding the cells affected by your fill operation.
The options on the menu are summarized in the following table. To enter values into a cell 1. Click the cell into which you want to enter the value. Type the value by using the keyboard. Press Enter to enter the value and move one cell down. Or Press Tab to enter the value and move one cell to the right. To extend a series of values by using the fill handle 1. Select the cells that contain the series values.
Drag the fill handle to cover the cells where you want the new values to appear. To enter a value into multiple cells at the same time 1. Select the cells into which you want to enter the value. Enter the value. To enter cell data by using AutoComplete 1. Start entering a value into a cell.
Use the arrow keys or the mouse to highlight a suggested AutoComplete value. Press Tab. To enter cell data by picking from a list 1. Right-click the cell below a list of data.
Click Pick From Drop-down List. Click the value you want to enter. To control AutoFill options 1. Create an AutoFill sequence. Click the AutoFill options button. Click the option you want to apply. Manage data by using Flash Fill When you manage data in Excel, you will often find that you want to combine values from several cells into a single value. Note that not every contact has a middle initial. You could combine the names manually or by creating a formula, but Flash Fill can figure out the pattern if you give it a few examples.
Flash Fill suggests values if it detects a pattern in your data Note that Flash Fill did not include the middle initials in any row due to the lack of an initial in some of the rows. If you click in the FullName cell next to a row that contains an Initial value and edit the name as you would like it to appear, Flash Fill recognizes the new pattern for this subset of the data and offers to fill in the values. You can press Enter to accept the values Flash Fill suggests.
Edit a Flash Fill value to add data to the pattern Flash Fill also lets you fix errors in your data. If you enter a zero-leading number into such a cell, Excel removes the zero. Use Flash Fill to correct common data-entry issues To fix this error, you would select the cells that contain the postal codes and format the cells as text. Then, in the blank cell next to the first postal code that should have a leading zero, enter the postal code as it should appear, and press Enter.
When you start entering the postal code into the second cell, Flash Fill offers to change the data by adding a zero to every value in the list.
Flash Fill can overgeneralize the rule it applies to your data The logic behind Flash Fill guessed that you wanted to add a zero to every postal code, but this change is incorrect for any value that should start with a number other than zero.
When you do, Flash Fill updates its logic to suggest the correct values. To enter data by using Flash Fill 1. In the cell directly below the first cell into which you entered data, start entering a new value for the row. Press Enter to accept the suggested values. To correct a Flash Fill entry 1.
Create a series of Flash Fill values in a worksheet. Edit a cell that contains an incorrect Flash Fill value that so it contains the correct value. Move data within a workbook You can move to a specific cell in lots of ways, but the most direct method is to start by clicking the cell with the contents you want to move. The cell you click will be outlined in black, and its contents, if any, will appear in the formula bar.
When a cell is outlined, it is the active cell, meaning that you can modify its contents. You use a similar method to select multiple cells referred to as a cell range. After you select the cell or cells you want to work with, you can cut, copy, delete, or change the format of the contents of the cell or cells.
Important When you select a group of cells, the first cell you click is designated as the active cell. For example, you might need to move a column of price data one column to the right to make room for a column of headings that indicate to which category a set of numbers belongs.
Clicking a column header highlights every cell in that column so that you can copy or cut the column and paste it elsewhere in the workbook. View live previews of your pasted data If you point to one icon in the Paste gallery and then point to another icon without clicking, Excel will update the preview to reflect the new option.
After you click an icon to complete the paste operation, Excel displays the Paste Options button next to the pasted cells. Click OK to close the dialog box and save your setting. After cutting or copying data to the Clipboard, you can access additional paste options from the Paste gallery and from the Paste Special dialog box. Use the Paste Special dialog box for uncommon paste operations In the Paste Special dialog box, you can specify the aspect of the Clipboard contents you want to paste, restricting the pasted data to values, formats, comments, or one of several other options.
You can perform mathematical operations involving the cut or copied data and the existing data in the cells you paste the content into, and you can transpose data— change rows to columns and columns to rows—when you paste it.
To select a cell or cell range 1. Click the first cell you want to select, and then drag to highlight the other cells you want to select. To select disconnected groups of cells 1. Select a cell range.
Hold down the Ctrl key and select subsequent groups of cells. To move a cell range 1. Point to the edge of the selection. Move a cell range by dragging its border 3. Drag the range to its new location. Tip If you move the cell range to cover cells that already contain values, Excel displays a message box asking if you want to replace the existing data.
To select one or more rows 1. The rows do not need to be adjacent to the first row. To select one or more columns 1. The columns do not need to be adjacent to the first column.
To copy a cell range 1. Select the cell range you want to copy. On the Home tab of the ribbon, in the Clipboard group, click Copy. To cut a cell range 1.
Select the cell range you want to cut. In the Clipboard group, click Cut. Cut or copy a cell range. Click the cell in the upper-left corner of the range where you want the pasted range to appear. In the Clipboard group, click Paste. To paste a cell range by using paste options 1.
Copy a cell range. In the Clipboard group, click the Paste arrow not the button. Click the icon representing the paste operation you want to use. To display a preview of a cell range you want to paste 1.
Click the Paste arrow not the button. Point to the paste operation for which you want to see a preview. To paste a cell range by using the Paste Special dialog box controls 1. Click the Paste arrow not the button , and then click Paste Special. Select the options you want for the paste operation.
You can locate specific data in an Excel worksheet by using the Find And Replace dialog box, which has two tabs one named Find, the other named Replace that you can use to search for cells that contain particular values. Using the controls on the Find tab identifies cells that contain the data you specify; by using the controls on the Replace tab, you can substitute one value for another.
Tip By default, Excel looks in formulas, not cell values. To change that option, in the Look In drop-down list, click Values.
The following table summarizes the elements of the Find And Replace dialog box. Click the cell. Double-click the cell. To find the next occurrence of a value in a worksheet 1. In the Find what box, enter the value you want to find. Click Find Next. To find all instances of a value in a worksheet 1. Click Find All. To replace a value with another value 1. In the Find what box, enter the value you want to change.
In the Replace with box, enter the value you want to replace the value from the Find what box. Click the Replace button to replace the next occurrence of the value. Or Click the Replace All button to replace all occurrences of the value. Set your Find or Replace values. Click Options. Select the Match entire cell contents check box. Complete the find or replace operation.
To require Find or Replace to match cell contents, including uppercase and lowercase letters 1. Select the Match case check box. To find or replace formats 1. Finish your find or replace operation. Correct and expand upon data After you enter your data, you should take the time to check and correct it.
You can then edit the word directly, pick the proper word from the list of suggestions, or have the spelling checker ignore the misspelling. You can also use the spelling checker to add new words to a custom dictionary so that Excel will recognize them later, saving you time by not requiring you to identify the words as correct every time they occur in your worksheets. You can even change your mind again if you decide you want to restore your change.
Excel includes a new capability called Smart Lookup, which lets you find information relating to a highlighted word or phrase by using the Bing search engine. Excel displays the Insights task pane, which has two tabs: Explore and Define.
The Explore tab displays search results from Wikipedia and other web resources. Get suggestions for alternative words by using the thesaurus Finally, if you want to translate a word from one language to another, you can do so by selecting the cell that contains the value you want to translate and clicking the Translate button on the Review tab. Important Excel displays a message box indicating that the information will be sent over the web to a third-party translation service. Click Yes to agree.
Translate words to other languages. The translated sentence might not capture your exact meaning. To undo or redo an action 1. To check spelling in a worksheet 1. Click Spelling. Repeat step 2 until you have checked spelling for the entire worksheet. Click Close. Tip Excel starts checking spelling with the active cell. To add a word to the main dictionary 1. When the word you want to add appears in the Not in Dictionary box, click Add to Dictionary.
Finish checking spelling and click Close. To change the dictionary used to check spelling 1. Click the the arrow next to the Dictionary language box, and click the dictionary you want to use. To look up word alternatives by using the thesaurus 1. Select the cell that contains the word for which you want to find alternatives. In the Proofing group, click Thesaurus.
Use the tools in the Thesaurus task pane to find alternative words. On the title bar of the Thesaurus task pane, click the Close button to close the task pane. To research a word by using Smart Lookup 1. Select the cell that contains the word you want to research.
In the Insights group, click the Smart Lookup button. On the Explore tab of the Insights task pane, use the resources in the Explore with Wikipedia and other web resources lists.
Or On the Define tab of the task pane, look up definitions of the selected word. On the title bar of the Insights task pane, click the Close button to close the task pane. To translate a word from one language to another 1. Click the cell that contains the word you want to translate. In the Language group, click Translate.
If necessary, click Yes to send the text over the Internet. Review the results. Click the Close button to close the task pane. Excel provides those capabilities, and more, through Excel tables. Tip Sorting, filtering, and summarizing data are all covered elsewhere in this book. Excel can also create an Excel table from an existing cell range as long as the range has no blank rows or columns within the data and there is no extraneous data in cells immediately below or next to the list.
Entering values into a cell below or to the right of an Excel table adds a row or column to the Excel table. After you enter the value and move out of the cell, the AutoCorrect Options action button appears.
You can resize an Excel table manually by using your mouse. Excel tables often contain data you can summarize by calculating a sum or average, or by finding the maximum or minimum value in a column.
To summarize one or more columns of data, you can add a total row to your Excel table. An Excel table with a total row When you add the total row, Excel creates a formula that summarizes the values in the rightmost Excel table column.
You can change the summary function by picking a new one from the partial list displayed in the Excel table or by selecting a function from the full set.
Much as it does when you create a new worksheet, Excel gives your Excel tables generic names such as Table1 and Table2. Changing an Excel table name might not seem important, but it helps make formulas that summarize Excel table data much easier to understand. You should make a habit of renaming your Excel tables so you can recognize the data they contain.
If for any reason you want to convert your Excel table back to a normal range of cells, you can do so quickly. To create an Excel table 1. Click a cell in the list of data you want to make into an Excel table. On the Home tab, in the Styles group, click Format as Table. Click the style you want to apply to the table.
Verify that the cell range is correct. If necessary, select or clear the My table has headers check box, and then click OK. To create an Excel table with default formatting 1. Click a cell in the range that you want to make into an Excel table. To add a column or row to an Excel table 1. Click a cell in the row below or the column to the right of the Excel table. Enter the data and press Enter.
To expand or contract an Excel table 1. Click any cell in the Excel table. Point to the lower-right corner of the Excel table. To add a total row to an Excel table 1. To change the calculation used in a total row cell 1. Click any Total row cell that contains a calculation. Select a summary function. To rename an Excel table 1. On the Design tool tab, in the Properties group, enter a new name for the Excel table in the Table Name box.
On the Design tool tab, in the Tools group, click Convert to Range. In the confirmation dialog box that appears, click Yes. Skills review In this chapter, you learned how to: Enter and revise data Manage data by using Flash Fill Move data within a workbook Find and replace data Correct and expand upon data Define Excel tables. Enter and revise data Open the EnterData workbook in Excel, and then perform the following tasks: 1.
Use the fill handle to copy the value from cell B3, Fabrikam, to cells B4:B7. In cell C8, enter February. Edit the value in cell D3 to include the middle initial found in cell C3, and press Enter.
Click the Addresses sheet tab. In cell F2, enter and press Enter. In cell F3, enter 0 and then press Enter to accept the Flash Fill suggestions. Edit the value in cell F4 to read Move data within a workbook Open the MoveData workbook in Excel, and then perform the following tasks: 1.
On the Count worksheet, copy the values in cells B2:D2. Display the Sales worksheet, preview what the data would look like if pasted as values only, and paste the contents you just copied into cells B2:D2. On the Sales worksheet, cut column I and paste it into the space currently occupied by column E.
Find and replace data Open the FindValues workbook in Excel, and then perform the following tasks: 1. On the Time Summary worksheet, find the cell that contains the value On the Time Summary worksheet, find the cell with contents formatted as italic type. Click the Customer Summary sheet tab.
Replace all instances of the value Contoso with the value Northwind Traders. Correct and expand upon data Open the ResearchItems workbook in Excel, and then perform the following tasks: 1. Check spelling in the file and accept the suggested changes for shipped and within. Ignore the suggestion for TwoDay. Add the word ThreeDay to the main dictionary. Use the Thesaurus to find alternate words for the word Overnight in cell B6, then translate the same word to French.
Click cell B2 and use Smart Lookup to find more information about the word level. Create an Excel table from the list of data on the Sort Times worksheet. Add a Total row to the Excel table, and then change the summary function to Average. Rename the Excel table to SortTimes. Perform calculations on data. In this chapter Name groups of data Create formulas to calculate values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations.
Excel workbooks give you a handy place to store and organize your data, but you can also do a lot more with your data in Excel. One important task you can perform is to calculate totals for the values in a series of related cells. You can also use Excel to discover other information about the data you select, such as the maximum or minimum value in a group of cells. Regardless of your needs, Excel gives you the ability to find the information you want.
And if you make an error, you can find the cause and correct it quickly. Excel makes it easy to reference several cells at the same time, so that you can define your calculations quickly. For example, you can create a worksheet in which columns of cells contain data summarizing the number of packages handled during a specific time period and each row represents a region. Worksheets often contain logical groups of data Instead of specifying the cells individually every time you want to use the data they contain, you can define those cells as a range also called a named range.
For example, you can group the hourly packages handled in the Northeast region into a group called NortheastVolume. For example, if your data appears in worksheet cells B4:I12 and the values in column B are the row labels, you can make each row its own named range.
Manage named ranges in the Name Manager dialog box. Tip If your workbook contains a lot of named ranges, you can click the Filter button in the Name Manager dialog box and select a criterion to limit the names displayed in the dialog box. To create a named range 1. Select the cells you want to include in the named range.
Comments
Post a Comment