Pinterest Stumbleupon Whatsapp
Ads by Google

Excel is a program that many people are wary of — it’s a complex piece of software, with a lot of functionality hiding away beneath the surface. It’s easy to see why novices would be put off by something so complicated, but this powerful piece of software is well worth the effort.

The key is breaking the learning process down 27 Fantastic Learning Websites You Might Have Missed 27 Fantastic Learning Websites You Might Have Missed Many fantastic educational websites that fly under the radar. Thanks to the breadth of knowledge from these twenty seven sites, lifelong learning is a smoother journey. Read More into manageable components. It’s impossible to learn Excel in a day or a week, but if you set your mind to understanding individual processes one by one, you’ll soon find that you have a working knowledge of the software.

Make your way through these techniques, and it won’t be long before you’re comfortable with the fundamentals of Excel. From there, you’re well on your way to becoming a true spreadsheet master.

The Basics

Here are some of the first techniques you’ll need to master if you want to get to grips with Excel. They’re largely very simple, but it’s important that you’re familiar with them before you start attempting more complex tasks.

Doing Simple Math

To begin, start with the most basic math problems you will ever need to feed into Excel. The first thing to remember about techniques like this is that Excel expects to see an equals sign first when you’re giving it a problem to work out. Type in =10+10 into a cell in your spreadsheet and press enter; the cell should display the number 20.

simple sum

Ads by Google

Adding and subtracting is fairly self-explanatory, but you’ll need to use an asterisk (*) in place of a multiplication sign and a forward slash (/) in place of a division sign.

Using AutoSum

If you’re just getting started with Excel Need Help with Excel Formulas? 7 Resources to Consult Need Help with Excel Formulas? 7 Resources to Consult Excel is the spreadsheet gold standard. If you are required to use Excel and yet have to familiarize yourself with it, these resources will quickly introduce you to the basics and more. Read More , this is a great way to get up to speed with the basic use of Functions. First, enter any two numbers in cells that are next to one another — either side to side or above and below works fine. Next, select the cell directly to the right or below those cells and navigate to Home > AutoSum.


This will automatically populate the selected cell with a SUM formula, so press enter to execute it. Excel will add the two numbers together and deliver the result in the specified cell — by using the AutoSum dropdown, you can choose different mathematical functions, too.

Applying Number Formats

Once your spreadsheets start getting a little bit more complex, they’re liable to contain different types of numbers; currency, dates, percentages, and more. To make sure you can work with this data, it’s well worth formatting it to type.

Select the numbers you want to format — you’ll have to do each different type one at a time. Look for the Number section at the top of the screen, and find the dropdown that defaults to General.

format numbers

From there you can choose from a healthy list of different number formats. If you’re looking for more control, select More number formats from the bottom of the list, and you’ll be able to specify details like the amount of decimal places to use, or your preferred currency.

Creating a Table

Presenting your data as a table How To Use An Excel Pivot Table For Data Analysis How To Use An Excel Pivot Table For Data Analysis The pivot table is one of the single most powerful tools in the Excel 2013 repertoire. It is frequently used for large data analysis. Follow our step-by-step demonstration to learn all about it. Read More allows you to do much more with the information at hand, and it’s very easy to set up. To get started, select the entirety of the data set you’re looking to convert into a table — including headings — and click on the Quick Analysis shortcut that will appear at the bottom left corner of your selection.

quick analysis

Navigate to the Tables tab and select Table. You’ll notice some immediate differences to the way the data looks, and there are some changes to the way it can be manipulated, too.

table formatted

Use the arrow buttons in the table header cells to filter out particular points of data, or sort them one way or another.

Creating a Chart

You can make a chart or a graph 8 Types of Excel Charts & When You Should Use Them 8 Types of Excel Charts & When You Should Use Them Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Read More in much the same way that you would create a table — but you’ll need to consider how you want to present that data ahead of time. Excel can give you some pointers, but it’s important to be aware of what you want the chart to achieve. With that in mind, lay out your data and select the whole thing, just as you did when creating a table.

creating charts

Hover over one of the options to get a preview of how it will look, or select More for extra control over the finished product.

Advanced Techniques

Sooner or later, you will probably want to take your Excel usage to the next level. The good news is that many aspects of the software’s functionality are connected in some way or another, meaning that learning one technique will likely reap benefits elsewhere later on.

Using Functions Manually

Once you’ve mastered basic arithmetic in Excel, it’s wise to start experimenting with Functions. You’ll discover a huge variety of different Functions to carry out different procedures, and all are slightly different — however, working with simpler examples will help you become familiar with basic practices that carry over.

Let’s get started by using one of the most basic Functions 16 Excel Formulas that Will Help You Solve Real Life Problems 16 Excel Formulas that Will Help You Solve Real Life Problems The right tool is half the work. Excel can solve calculations and process data faster than you can find your calculator. We show you key Excel formulas and demonstrate how to use them. Read More included in Excel, SUM. We can use this functionality to add up a series of figures without doing the legwork ourselves.

using SUM

As you can see above, I have five numbers that I’d like to add together, so I’ve entered my Function in the cell directly below the list — note that you can execute this task anywhere on your spreadsheet, as you’ll tell the program exactly which cells it’s looking for. You can produce a working example by typing in =SUM(E1:E5), but there are other ways to relay this command, too.

You might want to enter in the word SUM and open the brackets, then select the cells manually. You can do this by holding down Control key and clicking individual cells — dragging over multiple cells works also. Alternatively, you can type in individual cell references separated by a single comma if they’re not sequential.

success SUM

The benefit of using cell references in Functions rather than integers is that your results will update based on the contents of those cells. Once your spreadsheet projects begin to get more complex, this will certainly come in useful.

Integrating Conditional Formatting

In recent years, Excel has grown into a powerful tool for creating dashboards Visualize Your Data & Make Your Spreadsheets User Friendly With An Excel Dashboard Visualize Your Data & Make Your Spreadsheets User Friendly With An Excel Dashboard Sometimes, a simple spreadsheet format isn't engaging enough to make your data accessible. A dashboard allows you to present your most important data in an easy-to-digest format. Read More as well as conventional spreadsheets. Creating a dashboard in Excel can reap great benefits, but can also take a lot of effort depending on your needs — however, conditional formatting can add an element of the dashboard experience to a standard spreadsheet, and is very easy to put in place.

For these purposes, we’ll use conditional formatting to help provide a visual shorthand for some data, so pick something that’s worth being able to assess at-a-glance if you’re going to try this one out. Select that data, and navigate to Home > Conditional Formatting.

conditional formatting

You’ll fine a great wealth of different formatting options. We’re looking at percentages, so a data bar makes sense — however, color scales and icon sets can also be used very effectively in appropriate circumstances.

formatting styles

Remember that you can control aspects of the process by clicking on More Rules in the dropdown menu. If your formatting isn’t providing enough differentiation to be immediately clear, consider tweaking the rules a bit.

Adding a Trendline to a Chart

Anyone can create a chart with Excel — the secret to becoming an expert is being aware of all the many tools the software offers to make a chart that fits your brief perfectly. A trendline is one of the many components that you might need to bring together to achieve that task.

This is an addition that you’ll make to a chart once it’s been built, so create one as a test or use something that’s already been prepared. Once it’s in place, you need to click on the chart, then click the Chart Elements shortcut that’s illustrated by a plus sign icon. You can add a trendline quickly by checking the box next to it, or you can click on the arrow to the right to access more detailed options.


The crucial element here is to know what you’re trying to illustrate. A trendline isn’t a good addition in many situations, so it’s vital that you think about the data that you’re trying to present, and consider whether you’re adding something worthwhile to your chart, or just introducing more clutter that distracts from the point being made.

Build Your Excel Skills

There’s always more to learn about Excel, but here are a few good places to start. Microsoft’s Office Support site is home to a bevy of clearly presented tutorials on everything from high-level usage to the simplest tasks you might want to carry out.

Alternatively, Excel Functions provides a great reference point, whether you’re an absolute beginner or a seasoned veteran. Of course, Excel will help you out with tooltips as you try input a Function, but it’s good to have such a comprehensive resource to hand, if you do end up in a bind.

Finally, there’s a host of great Excel tutorials to work your way through on MakeUseOf. You can learn how to use the software to get the most out of your family budget 7 Useful Excel Sheets to Instantly Improve Your Family's Budget 7 Useful Excel Sheets to Instantly Improve Your Family's Budget It's not always easy to set up a family budget, but these seven templates will give you the structure you need to get started. Read More , see classic video games recreated entirely within the program 6 Iconic Games Recreated in Microsoft Excel 6 Iconic Games Recreated in Microsoft Excel Microsoft Excel can now also help you procrastinate. Excel games like 2048 are a great way to relax between crunching numbers. And they might playfully get you curious about advanced Excel formulas. Read More , or even take your data analysis to the next level by learning to use Power BI in conjuction with Excel Microsoft Excel + Power BI = Data Analysis Bliss Microsoft Excel + Power BI = Data Analysis Bliss Need help turning your data into something useful? Microsoft's Power BI can visualize your data and create automated reports. We show you how to set up your first Power BI dashboard. Read More .

Do you have a question about your next steps to Excel mastery? Or are you a seasoned user looking to share your wisdom with the next generation? Join the conversation in the comments section below.

  1. Bob Duncan
    January 6, 2016 at 4:01 pm

    I am now retired, but have used Excel (and others before there was an Excel) for many, many years. In recent years I have discovered ASAP Utilities, which is an excellent add-on for Excel!
    I still use it for any and all types of charts - i.e. Phone Numbers, scoring chart for card games,
    deck layouts on cruise ships, etc.

Leave a Reply

Your email address will not be published. Required fields are marked *