691 results for use if then else in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to use Spell Check in Excel
· Change1. Click the Review tab and the Spell Check drop-down button, choose Spell Check.2. If there are errors in the content of our document, the Spell Check window will pop up. Then, we will see the misspelled words.3. Select the correct word in the Suggestions area, and click the Change button. In this way, we can correct this word.4. Or we can click the Change All button to correct the misspelling of all these words in Excel. · Ignore1. Click the Ignore Once button, then we can ig....
How to change the page orientation00:48
How 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....
More features in picture inserting01:53
More features in picture inserting
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....
How to use LEFT and RIGHT formulas together in excel
Are you ready to master how to use LEFT and RIGHT formulas together in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. · What is WPS Spreadsheet? WPS Spreadsheet is compatible with Microsoft Office Excel. As the world's leading developer of office software solutions, WPS Office provides free applications for individuals and businesses to improve productivity. · What is the LEFT and RIGHT function in WPS Spreadsheet? They both all....
How to insert document fonts00:45
How to insert document fonts
We often download some special fonts when beautifying documents.However, if the same font is not installed on other computers, it may not display correctly.So how can we solve this problem? Here are the steps to insert fonts into documents.Click Menu and then Options in the upper-left corner. On the left of the pop-up dialog, select General and Save and select Embed True Type on the Save interface, and click OK to save again. In this way, after we save the document locally and transfe....
More features in Picture to Text02:12
More features in Picture to Text
Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....
Different methods of using format painter02:12
Different methods of using format painter
When we use WPS Spreadsheet at work, if we want to quickly copy the formatting of a cell to another cell, we can use the Format Painter function in WPS Spreadsheet. Take this table as an example. We now want to copy and paste the formatting of cell A1 to cell D1. 1. Select cell A1.2. Click the Home tab first and then click the Format Painter button.3. Now select cell D1. There you can copy and paste the formatting of cell A1 to cell D1. But how can we use Format Painter to copy and pa....
How to link WPS Writer and Spreadsheet together02:26
How to link WPS Writer and Spreadsheet together
In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....