How to learn to use excel for free

July 26, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

Many people are leery of WPS Excel since it's a complicated piece of software with a lot of feature hidden away below the surface. It's understandable why anything so complex would deter beginners, but the work is well worth it for such a potent piece of software. Here's how to quickly learn Excel. Excel may be quickly learned by segmenting the learning process into digestible steps. Excel cannot be learned in a day or a week, but if you set your mind to learning each process in turn, you will soon discover that you have a working comprehension of the programme.

Once you master these strategies, it won't take you long to feel at ease with Excel's foundational concepts. You're then close to finishing your WPS Excel training and turning into a true spreadsheet pro.

The basics of excel online, 2016 and 2019

The initial skills you'll need to learn in order to master Excel are listed below. Although they are often quite straightforward, it's crucial that you become comfortable with them before attempting more difficult activities.

 Doing simple math in excel

Start by entering the simplest math problems Excel will ever need to handle. 

1.The first thing to keep in mind when using methods like this is that Excel anticipates seeing an equals sign before any other symbols when given an issue to solve.

2.Your spreadsheet cell should show the value 20 when you enter =10+10 and hit Enter.

3.The operations of adding and subtracting are fairly self-explanatory, however you must substitute an asterisk (*) for the multiplication sign and a forward slash (/) for the division sign when performing these operations.

Using AutoSum in excel

This is a wonderful method to come up to speed with the fundamental use of Functions if you're new to Excel. 

1.First, enter any two integers in adjacent cells; either side by side or above and below is acceptable. 

2.Go to Home > AutoSum after selecting the cell that is directly beneath or to the right of those cells.

3.Press Enter to execute this, which will automatically insert an SUM formula into the chosen cell. Excel will add the two numbers and place the result in the designated cell; you may also select a different mathematical operation from the AutoSum dropdown menu.

Applying number formats in excel

1.Your spreadsheets are likely to contain many types of numbers as they become a little bit more complicated, including currency, dates, percentages, and more. It is definitely important preparing the data to type in order to make sure you can work with it.

2.Choose the numbers you want to format; you must format each sort of number individually. 

3.Find the selection that defaults to General in the Number column at the top of the screen.

From there, you can pick from a vast selection of various number forms. If you want more control, choose More number formats at the bottom of the list, where you can enter specifics like the desired currency or the amount of decimal places.

Note: This above written article is an attempt to show you how to use excel online, 2016 and 2019 in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.