Kasper Langmann , Co-founder of Spreadsheeto. Pro tip: Ribbon sections In addition to tabs, the Ribbon also has some smaller sections. As we saw, workbooks can contain multiple sheets. You can also reorder the sheets in your workbook by dragging them to a new location. Just click into a blank cell and start typing. Go ahead, try it! Type your name, birthday, and your favorite number into some blank cells.
Try copying and pasting the data from the example spreadsheet into another column. You can also copy data from other programs into Excel. Try copying this list of numbers and pasting it into your sheet: 17 24 9 00 3 Running basic calculations in Excel is easy. When you hit Enter, Excel evaluates your equation and displays the result, 7. Performing subtraction, multiplication, and division is just as easy. You should get 82, the sum of the numbers in cells A1 and B1.
Now, change one of the numbers in A1 or B1 and watch what happens:. Many formulas take sets of numbers and give you information about them. The resulting number, 0. There are also functions that work on text. How did this happen? Then Excel will help you get the right numbers in the right places:. The easiest way to share your spreadsheets is via OneDrive.
Want more? Want a complete step-by-step blueprint? So, what happens when you need to revert or refer to the previous version of the workbook? An option you can try is Microsoft Spreadsheet Compare. Microsoft Spreadsheet Compare makes it easy for users to compare two versions of an Excel file.
The tool then highlights the differences between the two files making it easy to spot changes. The tool can be accessed from the Microsoft Office Tools program group. For the comparison to work, it is necessary to have different versions of the spreadsheet. The tool then analyzes the files and highlights the differences using certain criteria. To analyze different versions of a workbook, you have to import both workbooks in the Spreadsheet Compare tool. Here's how to do so:.
Step 3: Within the Compare Files dialog box, select the File icon beside the Compare older file option. Select the Excel file in File Explorer and click on Open. Step 6: You can streamline what the Spreadsheet Compare tool analyzes by either ticking or unticking the checkboxes at the bottom left of the tool.
For example, in this worksheet, you could choose "food" and "calories," which would show a table and graph of how many calories are in each type of food. That's convenient but doesn't offer a lot of additional insight compared to the original data.
But deselect food and instead correlate calories to the category of food — now you can see how each category compares in total calories, because the pivot table and chart sum the calories of all the items within each category and display the results. This is an insight that's not easy to see when looking at the worksheet in its original form. Your workbook can be saved to your computer or the cloud.
You can find the AutoSave control at the top left of the Excel window — swiped it to the right to autosave, or to the left to disable this feature.
To save the workbook, click the "File" tab and then choose "Save As" from the File pane. Choose a location and click "Save. You can also print a worksheet from the File tab as well. In the File pane, choose "Print" and select what you want to print in the Settings section. For example, you can print just a certain part of a spreadsheet or print everything in the workbook.
In recent years, Microsoft has eliminated its standalone Office products like Word, Excel, and PowerPoint, and Excel is available exclusively as a part of a Microsoft subscription. There are several plans available, including Microsoft Personal , Microsoft Family , as well as several versions of Microsoft Business , and Microsoft Enterprise.
Each of these generally come with the full suite of Office apps and OneDrive cloud storage, though they vary by price and which specific features are included. For you. World globe An icon of the world globe, indicating different international options. Get the Insider App.
Click here to learn more. A leading-edge research firm focused on digital transformation. Good Subscriber Account active since Shortcuts. Account icon An icon in the shape of a person's head and shoulders. It often indicates a user profile. Log out. Smart Home. Social Media. More Button Icon Circle with three vertical dots.
It indicates a way to see more nav menu items inside the site menu by triggering the side menu to open and close. Dave Johnson. Dave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life. Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft.
As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Insider Inc. Deal icon An icon in the shape of a lightning bolt.
0コメント