2020. 2. 10. 11:16ㆍ카테고리 없음
Excel 2019 is a powerful tool, but it can be intimidating for new users who don't know where to start or how to proceed beyond the most basic tasks. In this course, Curt Frye provides training on all the essential tasks in the Mac version of this robust spreadsheet program. Learn how to manipulate workbook and cell data, use functions and formulas, and print worksheets. Curt also acquaints you with some more advanced techniques, including how to create a variety of charts, work with external data and objects, and create PivotTables. Instructor. Curt Frye is a freelance course developer and writer.
He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show. By: Garrick Chow course.
Problems are reported rendering Excel worksheets, causing text to display as backwards or upside-down. STATUS: WORKAROUND This occurs on a Mac with macOS High Sierra beta and Excel 2016 for Mac Insider's Fast update.
5h 21m 38s. 2,638 viewers. Course Transcript - Instructor When you start using Excel, the most basic skills you need are creating, opening, and saving workbooks. In this movie, I will demonstrate how to perform those tasks and control how Excel opens, creates, and saves your files. My sample file in the inquiries report workbook. And you can find it in the chapter two folder of your exercise files collection. Open those files so you would have something to look at.
But if you're in Excel, and you want to open a workbook, you can do that by pressing Command + O. Doing so displays the open dialogue box. And you can navigate within this dialogue box to find the file that you want to open. I'm currently set to the chapter 2 folder. If I want to change that, I can click the folder controls arrow and go up to exercise files. And there I see the entire exercise files archive.
If I want to look in chapter one, I can double click chapter one. And I see the files that I have available there. Any file that I want to open, I can click and then click open. In this case, I'll just stay with the one I had before. So I will click cancel. If you want to create a new workbook, you can do that by pressing Command + N. I'll go ahead and do that.
And I get a new workbook. And you can see that the zoom level is set to 100. So everything looks a little bit smaller in the body of the worksheet. Unless you change the setting, which I show you how to do elsewhere in the course, a new workbook will have a single worksheet in it.
If you want to close the workbook, press Command + W. In this case, I hadn't made any changes, so Excel did not ask if I wanted to save my work.
If I had made any changes, I would get an indicator asking if I wanted to do so. If you want to save your work, you can press Command + S, and that will save the file in the current location with the current name.
If you want to change the file's name, or location, or both, you can press Command + Shift + S. So I'll press Command + Shift + S.
And that gives me the save as dialogue box. And from here, I can type in the new name. I can also indicate where I want to save the file. So if I click the where controls arrow, I see that I can go to my disc. I can change to documents, downloads, other places. And I can also change the file format. Those are the basics of saving as.
In this case, I'll just click cancel to close out the operation. Excel gives you a great deal of control over how you open, save, and create workbooks. The keyboard shortcuts that I show you are the quickest way to perform the operations that I've described. But if you want, you can also go to the file menu and find those options there.
Practice while you learn with exercise files. Watch this course anytime, anywhere.
Course Contents. Introduction Introduction. 1. Getting Started with Excel 1. Getting Started with Excel.
2. Managing Workbooks 2. Managing Workbooks. 3. Working with Worksheets, Cells, and Cell Data 3. Working with Worksheets, Cells, and Cell Data.
4. Sorting, Filtering, and Managing Worksheets 4. Sorting, Filtering, and Managing Worksheets. 5. Summarizing Data Using Formulas and Functions 5. Summarizing Data Using Formulas and Functions.
6. Formatting Worksheet Elements 6. Formatting Worksheet Elements.
7. Working with Charts 7. Working with Charts. 8. Working with External Data and Objects 8. Working with External Data and Objects.
9. Exploring PivotTables 9.
Exploring PivotTables. 10. Reviewing and Sharing Spreadsheets 10. Reviewing and Sharing Spreadsheets.
Conclusion Conclusion.
I have a situation where we have two workbooks which populate a third work book. Our users tend to put data in the cells in the wrong location and accidently delete formulas.
Problems Saved A Workbook In Excel For Mac 2011
So I have gone through and locked and unlocked cells and ranges of cells. Then I protected the sheets.
But now when i copy the spreadsheets to a new location and try to relink them (Change Source) I get an error message saying that the workbooks can't be found or the data is encrypted. Any thoughts on how to get around this. Microsoft Excel 2000 A link is a formula that gets data from a cell in another workbook. When you open a workbook that contains links (a linking workbook), Microsoft Excel reads in the latest data from the source workbook or workbooks (updates the links). Use links when you want to maintain information in a single workbook, but also use the information in other workbooks.
For example, if your product prices change frequently, you might keep a master price list. Other workbooks that use the price data in calculations, such as purchase orders, inventory valuations, or sales estimates, can create links to the price list workbook so calculations always use current prices. When prices change, you only have to enter the new prices in one place. When you create a link, Excel creates a formula that includes the name of the source workbook in brackets , followed by the worksheet name, an exclamation point, and the cell reference. Create links between workbooks 1.Open both workbooks.
2.In the source workbook, select the cells you want to link to and click the Copy button. 3.Switch to the destination workbook and click the upper left cell of the range where you want the links. 4.On the Edit menu, click Paste Special, and then click Paste Link. You can also create a link starting from the linking workbook. Type an equal sign in a cell, switch to the source workbook, click the cell you want to link to, and then press ENTER. You can copy and autofill linking formulas as you do other Excel formulas.
Putting together a set of linked workbooks Before you make extensive use of links, it's a good idea to do some planning. Here are some tips for creating links.
Make links easy to track?? There's no automatic way to find all the cells in a workbook that contain links. You might want to use a particular format or border style for cells containing links, or otherwise document where the links are, so that as your set of linked workbooks grows and gains complexity you'll be able to maintain it efficiently. Turn on automatic calculation?? Source workbooks that you link to should have automatic calculation turned on (this is the default). To turn automatic calculation on, click Options on the Tools menu, click the Calculation tab, and click Automatic under Calculation.
Avoid circular links?? Circular links, where two workbooks contain links to each other, can make both workbooks slow to open and update. Consider where you'll store linked workbooks?? If you're using links to share data on your network, consider where the source and linking workbooks will be stored. Source workbooks stored on a network share are available to other network users, who can store their linking workbooks either on the network or on their own hard disks. Source workbooks on your hard disk, however, are only available to you, so if you put linking workbooks on a network share, other users won't be able to update links to source workbooks on your system.
Network drive letters in links When you click a cell containing a link and the source workbook is closed, you'll see the full path to the source workbook. The path uses the drive letter you have mapped to the share. The links continue to work correctly for other users who map different drive letters to the same share. You can edit linking formulas to use UNC names, such as myserver myshare, instead of drive letters. UNC names can make links easier to update when several people will use a linking workbook, because Excel can update links that use UNC names even if users don't have a drive letter mapped to the network share.
For example, you can change ='G: Prices'!B5 to =' myserver myshare Prices'!B5 However, using UNC names can also reduce calculation speed, especially if your workbooks use calculation-intensive features such as the Solver add-in program. File names and paths in links Windows has a 255-character limitation on paths, which also limits the length of the paths you can use when you create links. You'll need to consider path length in naming files and setting up folder names and structures. In addition, if a workbook file name is longer than 122 characters, you can create links to the workbook but you can't change the links once created.
Avoid characters from the Excel linking syntax in file names and worksheet names. You can't create links to workbooks and worksheets with names that include the characters ! Linking to cells containing large amounts of data Links can only return the first 255 characters in a cell.
If you want to link to large amounts of data, first distribute it among several cells on the source worksheet. If you're linking to a cell with contents that will grow as you maintain the source workbook, keep the 255-character limit in mind. Links in shared workbooks You can create links to or from shared workbooks, but if one user creates links in a shared workbook while other users have the workbook open, when other users save they may see a #REF! Error instead of the linked data. You can avoid this problem by creating all the links before you share the workbook, or at a time when other users aren't working on it.
Linking to password protected workbooks Assigning a protection password to a source worksheet or workbook does not prevent users of linking workbooks who don't know the password from updating the links. If you want users to have to enter a password to update links, save the source workbook file with a password to open (click Save As on the File menu, click General Options on the Tools menu).
Removing links to other workbooks If you no longer need a link to information in another workbook, or want to undo a link you just created, you can simply break the link. When you break a link to a another source, all formulas that use that source are automatically converted to their current value. Because the action cannot be undone, it's a good idea to save a version of your worksheet before you remove links. For more information, see Break links.
Hope this helps you. Please post back if you have anymore problems or questions.