8 results for excel courses for beginners free
- All Tutorials
- Video Tutorials
- Quick Tutorials
More features in Document Encryption02:14
More features in Document Encryption
Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....
Text direction in WPS Presentation02:34
Text direction in WPS Presentation
When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....
Quickly fill cells with multiple methods04:07
Quickly fill cells with multiple methods
As for beginners, they usually enter data manually when they first use Spreadsheet. It is time-consuming and also easy to cause mistakes. So today we are going to learn a few tips to help you quickly fill in the data in the worksheet.· Fill contents down into the tableTake this table as an example, select the area that needs to be filled, first click the Home tab, then click the Fill button-and then select Fill down. (Notes: The shortcut key is Ctrl+D.) · Fill contents right into the t....
Look up data quickly with LOOKUP function04:23
Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
How to convert Excel to PDF02:50
How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
How to export a document to PDF?
1. Option 1: Click Export to PDF icon at the top left as below. Option 2: Click Menu → Export to PDF. 2. After setting as you need, click Export to PDF. 3. When the output is complete, you can use WPS Office to open the PDF file. Tips: PDF to Word/Excel/PPT: free of chargePDF to Word/Excel/PPT: only for membership For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
Insert an elegant table quickly in Excel
Sometime we may need to insert a table in Excel. Here are the steps.1. Open an Excel document, click the Insert > Table.2. In the pop-up dialog, you can select the cell range where you want to create a table. You can also check My table has headers according to individual needs. 3. You can also change its style in the toolbar. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
Unique Features in File Collect03:21
Unique Features in File Collect
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. In the workplace, collecting all kinds of documents is frequently needed. At this time, a file folder is always wanted to collect what we need by sending a sharing link to others At present, such a function is not available in other office software on the market. Fortunately, WPS launched the File Collect feature for a more efficient office experience. ....