![]() The drop down menu will give you a wide array of number formatting, while the most used functions have dedicated symbols. At the top of your screen check out the “Number” area. Stop typing that dollar sign! Excel can do that for you! It can also do things like convert decimals to percentages, round your decimals and add commas. ![]() Much like formulas, if you change any data in your document the charts will update with little effort from you. Here they’ve turned the data into a bar graph. Image courtesy of: Once the data has been entered, you select the type of chart you want to create. In the example below the user is comparing the sightings of various animals in various months. With a little organization, you can create a chart without much effort. If you’ve ever wanted to achieve a professional looking chart to convince your parents the statistical benefits of you acquiring the new iPhone, you should turn to Excel. So if you find out dinner actually cost $300 not $30, you’ll know who to shake down in your family for more money at the end of the trip. The best part about formulas is that the answer will automatically update if you change the data in the cells. The user clicks in cell A3 and inputs the equation in the formula field. Below is an example of how easy formulas are to use. You can do everything from simple addition to statistical calculations. Formulas are a fundamental resource to use in Excel. If you’ve ever used Excel to keep track of expenses and you’re doing the math in your head, you’re doing it wrong. By using sheets, you save yourself from having multiple Excel documents that you can easily lose track of. Each tab can represent an aspect of the trip: food expenses, itinerary, receipts. Say you’re using Excel to plan a family vacation. You can organize different information that pertains to the same topic. If you look in the bottom of an Excel document, you’ll notice little tabs that say Sheet 1, 2, 3, etc. ![]() The second of our Microsoft Office for Dummies series features Excel. This series will run you through the basics of how to create successful Microsoft Office documents that may help you land your dream job. You can download all three programs at no cost, which includes the latest software updates so you’ll always have access to the newest features. Let’s take a moment to discover some basic features that many of us may not know about.Ĭal Poly Pomona (CPP) students are lucky enough to have access to Office 365 for free! Log in to your CPP email and click Office 365 or navigate here. It can be an extremely powerful tool that can help you both personally and professionally. Unless you’re an accounting major, you probably don’t have much experience with Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |