1577 results for how do i learn excel for free
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1577 results for how do i learn excel for free
How to make a simple lottery through the RANDBETWEEN Function?
02:02How to make a simple lottery through the RANDBETWEEN Function?
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....
Set Allow Users to Edit Ranges in a protected sheet
02:04Set Allow Users to Edit Ranges in a protected sheet
As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....
Page setup and print-out for spreadsheets
02:07Page setup and print-out for spreadsheets
WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....
Superscript and subscript in WPS Presentation
01:32Superscript and subscript in WPS Presentation
In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....
Elementary arithmetic functions in WPS Spreadsheet
02:50Elementary arithmetic functions in WPS Spreadsheet
Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....
How to convert PDF to Excel using OCR online for free
How to convert PDF to excel using OCR Keyword: PDF to excel OCR. Do you know how to convert OCR PDF to Excel using WPS Office's OCR feature? When using Word or Excel in WPS Office, optical character recognition, or OCR, is a technology that can extract text from photographs. Being able to understand the text of an image is helpful when it has a lot of words. The OCR capability has three main applications. The WPS Office makes use of the OCR function to recognize characters using A....
How to convert word/excel/ppt to pdf for free in WPS Office
Welcome to WPS Official Academy! Are you looking for free pdf converter with powerful functions? That's it! WPS Office is a perfect choice for you to convert word/excel/ppt to pdf files for free. After reading this quick tutorial, you are able to quickly perform conversions between word/excel/ppt and pdf. lSimple steps to convert word/excel/ppt to pdf for free in WPS Office1. Open the word/excel/ppt documents you want to convert in WPS Office.2. Go to the Tools tab, and click Expor....
How to use the paste special function
02:11How to use the paste special function
Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....