456 results for ms office advanced course
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
456 results for ms office advanced course
A Guide to Using “Advanced Filtering Mode” on WPS Office
A Guide to Using “Advanced Filtering Mode” WPS Office allows you to create, edit, and share spreadsheets easily. One of the many amazing things you can access in “Spreadsheets” of WPS Office is Advanced Filtering Mode. Using this mode allows you to: Create custom criteria for filtering data. Limit the entries that appear for specific criteria. See specified results according to your data filtration needs. In this short guide, we will show how you can use Advanced Filtering Mode easily ....
More features in Document Encryption
02:14More 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....
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 ....
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 change the page orientation
00:48How to change the page orientation
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....
Skillfully use Conditional Formatting to highlight performance
01:21Skillfully use Conditional Formatting to highlight performance
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....
Data Format-Scientific Notation
02:03Data Format-Scientific Notation
In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.You can use the following methods:When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the numb....
How to use OCR in PDF
02:12How to use OCR in PDF
Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....