




Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
easy to learn formulae usage and structure of excel
Typology: Exercises
1 / 8
This page cannot be seen from the preview
Don't miss anything!
Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells. Ryan Blundell 1 Jun 2017
There are thousands of Excel tools at your disposal, so where should you start? Let's take a look at some of the basic formulas and advanced features of Microsoft Excel.
Before you attempt to hit the ground running, it's advisable to have a look at some of the basics to get you started.
The order and layout of a function and its arguments are known as the syntax. With Microsoft Excel, functions are built-in formulas which initiate the requested action on the information found in your worksheet. Formulas in Excel start with an equal sign (=), then continues with either a function name (SUM, COUNT, IF) or math operators and numbers. If we were to dissect this formula:
=COUNTIF(A1:E1, "Forecast")
We can break a formula down into the following parts:
When selecting a single cell in a worksheet, you can either use your mouse to click on the cell or use your arrow keys to navigate to it. To select specific cells, select the first cell and then hold down CTRL. Then select the other cells in question.
One of the most frequent uses of Excel is capturing numerical data. Whether it's financial, quantity tracking or grade/score records, you can use Excel to easily manage them, saving you time.
A small, two letter word can provide a lot of functionality to your data. If you were to use =SUMIF(A1:A10,">10,000"), you have now chosen to find the sum of the numbers in the same cells, but only taking into account values that are greater than 10,000.
While functions such as proper, upper and lower aren't going to solve mathematical problems, they do ensure that the text is displayed correctly.
Even with the most organized database, some information and insight are lost if not visually engaging for the reader. With 3D Maps, you can generate a three-dimensional presentation of your data that can have a much larger impact on the data than numbers alone. Imagine being able to visually see changes to data over time and by geographical location.
Before you can begin using 3D Maps, you should make sure that your data contains some sort of geographic information within your tables. The data could contain details as complex as longitudes and latitudes or as simple as a zip code or postal code.
You can use any presented drop-down arrow in the fields to ensure the data is matched correctly to the right geodata. 3D Maps then works to plot the data on the globe in the areas recorded in your workbook. From this point, you can then create a presentation that can be recorded as a video, or interactive navigation for viewers to delve into. We'll take an in-depth look at navigating Power Map in a future article.
If you are working with a large database in Excel that requires navigating, it could be difficult to keep track of the which category belongs to which column or row. With the ability to freeze panes, Excel users can lock specific rows or columns in place so that they remain visible while you scroll up and down or side to side through cells.
Pivot Tables are by far one of the most versatile ways to extract details from a large data set for further analysis. In a pivot table, data is sorted and summarized without necessarily having to input formulas to perform calculations.
This Excel function helps the user to locate and visualize data within a worksheet. Through predefined rules, you can use conditional formatting to identify values using manyy criteria. Excel also provides the means to create rules of your own.
Let's use an example to learn basic conditional formatting. You're taking inventory and have two columns of tracking numbers; one from your system records and another that was manually entered. You can use conditional formatting the check the data.
This will then highlight any recorded tracking number that hasn't been scanned while also potentially highlighting tracking numbers scanned by not in the system.
Again, this is but a few options that can be found in Microsoft Excel. It goes beyond creating a simple table of data. The numerical applications are complex in nature but will be simple to use over time. What does your work day with Excel look like? Do you excel at Excel? Let us know!