Home / DeveloperSection / Articles / Tips to Learn Excel: The Basics

Tips to Learn Excel: The Basics

Naomi Morriston998 27-Jul-2019

Excel is a program that lots of individuals are wary of -- it is a complicated piece of software, with a great deal of performance hiding away beneath the surface. It's easy to see why novices are put off by something really complex, but this effective piece of software is well worth the effort.

The important thing is breaking up the learning process down into manageable parts. It's not possible to learn Excel in a day or a week, but if you put your mind to understanding human procedures one by one, you will soon realize that you have a working knowledge of the program.

Make your way through these techniques, and it will not be long until you are familiar with the fundamentals of Excel. From that point, you are well on your way to becoming a legitimate spreadsheet master.

The Fundamentals

They're largely very straightforward, but it's crucial that you're familiar with them before you begin attempting more elaborate tasks.

To start, begin with the most elementary math problems you'll ever have to feed into Excel. The first thing to consider about techniques such as this is that Excel expects to find an equals sign first when you are giving it an issue to work out.

Adding and subtracting is rather self-explanatory, but you will have to use an asterisk (*) instead of a multiplication sign and a forward slash (/) instead of a division sign.

If you are just getting started with Excel, this is a superb way to get up to speed with the simple use of Functions. Next, pick the cell directly to the right or under those cells and browse to Home > AutoSum.

Excel will add the two numbers together and deliver the result in the designated cell -- using the AutoSum dropdown, you can pick different mathematical functions, also.

Once your spreadsheets start getting just a little bit more complicated, they are liable to contain unique kinds of numbers; money, dates, percentages, and much more. To be sure that you can work with this information, it is well worth formatting it to sort.

Pick the numbers you wish to format -- you will need to do every different kind one at a time. Search for the Amount segment at the top of the display, and find the dropdown that defaults to General.

From there you can select from a wholesome collection of different number formats. If you're looking for more control, pick More variety formats in the bottom of the listing, and you will have the ability to specify details such as the quantity of decimal places to use, or your favorite currency.

Presenting your information as a table lets you do more with the info accessible, and it's quite easy to prepare. To begin, pick the entirety of the data set you are trying to convert into a table -- such as headings -- and then click on the Quick Evaluation shortcut which will appear at the bottom left corner of your choice.

You will notice some immediate differences to the way the data appears, and there are a number of changes to how it could be manipulated, also.

You can create a chart or a chart in much the same manner that you would produce a table but you will need to think about how you wish to present that data beforehand. Excel can provide you a few pointers, but it is essential to know about what you want the graph to attain. With that in mind, lay out your information and choose the entire item, just as you did when creating a table. I have a table with all of my doorbell camera footage organized by date and time.

As soon as you've mastered basic arithmetic in Excel, it is sensible to begin experimenting with Functions. You'll discover a wide range of unique Functions to carry out various processes, and all are somewhat different -- nonetheless, working with simpler examples can allow you to become acquainted with fundamental practices which carry over.

Hover over one of the alternatives to have a preview of how it will look, or choose More to get additional control over the final product.

Advanced Techniques

Sooner or later, you will likely need to take your Excel use to another level. The fantastic news is that many facets of the software's performance are linked in some way or another, meaning that learning one strategy will probably reap rewards elsewhere later on.

Using Functions Immediately

Let's begin by using one of the most fundamental Functions included in Excel, SUM. We can use this operation to add up a set of characters without doing the legwork ourselves.

As you can see above, I've got five numbers that I want to add together, so I have entered my Function from the cell directly below the list -- note which you may do this task anywhere in your spreadsheet, since you'll tell the program exactly which cells it is searching for. It's possible to create a working example by typing in =SUM(E1:E5), but there are different means to relay this control, also.

You may want to enter from the term SUM and start the brackets, then pick the cells manually. You can do that by holding down Control key and clicking individual cells dragging over multiple cells functions too. As an alternative, you can type in individual cell references separated by one comma if they are not sequential.

The advantage of using cell references in Works as opposed to integers is that your results will upgrade based on the contents of these cells. Once your spreadsheet projects start to get more complicated, this will surely come in useful.

In recent years, Excel has become a powerful tool for creating dashboards in addition to conventional spreadsheets. Developing a dashboard in Excel can reap excellent benefits, but can also have plenty of effort depending upon your requirements -- however, conditional formatting may add a part of the dashboard experience to a standard spreadsheet, and is quite simple to set up.

Adding a Trendline to a ChartFor these purposes, we will use conditional formatting to help provide a visual shorthand for a number of information, so choose something that's worth having the ability to assess at-a-glance if you are going to try out this one. Select that information, and browse to Home > Conditional Formatting.

You'll find a terrific wealth of different formatting choices. We're taking a look at percentages, so a data bar makes sense -- however, color scales and icon sets are also used quite effectively in appropriate conditions.

Bear in mind that you could control aspects of this process by clicking More Rules from the dropdown menu. If your formatting is not supplying enough differentiation to be instantly clear, consider tweaking the rules somewhat.

Anyone can create a graph with Excel -- the key to becoming a specialist is being aware of all of the many tools the program offers to make a graph that suits your brief perfectly. A trendline is among many components that you may have to bring together to accomplish that task.

This is an addition which you will make to a graph once it has been built, so make one as a test or use something that's already been prepared. Once it is in place, you want to click on the graph, then click on the Chart Components shortcut that is exhibited by a plus sign icon. It is possible to add a trendline immediately by checking the box beside it, or you may click on the arrow to the right to get more detailed alternatives.

The vital element here is to understand what you are trying to illustrate. A trendline is not a fantastic improvement in many situations, so it is crucial that you think of the data that you are trying to present, and think about whether you are adding something rewarding to your graph, or simply introducing more clutter which distracts from the point being made.

Microsoft's Office Support website is home to a bevy of clearly presented tutorials on everything from high-level usage to the easiest tasks you may want to perform.

Alternatively, Excel Functions offers a terrific reference point, whether you are a complete beginner or a seasoned veteran. Needless to say, Excel will give you a hand with tooltips as you attempt input a Function, but it is great to have such a comprehensive resource to hand, should you wind up in a bind.

You can find out how to use the software to get the maximum from your household , see classic video games entirely inside the app, or perhaps take your data analysis to the next level by learning how to use Power BI in conjuction with Excel.

Updated 08-Aug-2019
Bio: Hello! My name is Naomi, I salt margaritas not sidwalks! ASU Graduate (Go Sun Devils!!) in human sexuality. Currently living in Louisiana working as a expert in writing. I am currently working on composing my own book. Love life, be kind, be YOU!

Leave Comment


Liked By