Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • microsoft office courses for beginners

      216 results for microsoft office courses for beginners

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      216 results for microsoft office courses for beginners

      More features in Picture to Text

      More features in Picture to Text

      01:55

      More features in Picture to Text

      WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users. WPS Presentation and Microsoft Office both can convert pictures to text. Today we will analyze their differences. Microsoft PowerPoint itself does not support OCR function. If you want to realize Picture to Text, you need to open another app-OneNote.Copy the picture to OneNote, right-click the image to select Copy Text from Picture. Fin....

      Presentation 48 views
      Unique features in Eye Protection Mode

      Unique features in Eye Protection Mode

      01:37

      Unique features in Eye Protection Mode

      WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Long-time staring at the screen when using office software can cause eye irritation. At this point, we can relieve tired eyes by adjusting the theme or colour of the document. Eye Protection Mode is not available in Microsoft Office yet. But we can adjust the theme colour to relieve eye strain.Click File, then get into the Options inter....

      Writer 82 views
      More features in Web search function

      More features in Web search function

      01:08

      More features in Web search function

      Today I will tell you the differences in the web search function between Microsoft Word and WPS Writer. When we use Microsoft Word to edit a document, we usually copy the content and open a browser to search for it if we encounter content that we do not understand. And when you use WPS Writer, you can skip this step. WPS Office has a built-in Google search engine in WPS Writer, so you only need to select the text you want to query and then click the Search button in the lower right cor....

      Writer 36 views
      The SUMPRODUCT function for quick calculation of total sales

      The SUMPRODUCT function for quick calculation of total sales

      01:44

      The SUMPRODUCT function for quick calculation of total sales

      When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

      Spreadsheet 714 views
      How to apply accounting number format in WPS Spreadsheet

      How to apply accounting number format in WPS Spreadsheet

      00:56

      How to apply accounting number format in WPS Spreadsheet

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

      Spreadsheet 155 views
      How to set the header row across pages

      How to set the header row across pages

      00:50

      How to set the header row across pages

      When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

      Writer 148 views
      TEXT formula in WPS Spreadsheet

      TEXT formula in WPS Spreadsheet

      03:09

      TEXT formula in WPS Spreadsheet

      The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

      Spreadsheet 1,560 views
      Using Tab stop to make a slide catalog

      Using Tab stop to make a slide catalog

      01:07

      Using Tab stop to make a slide catalog

      When making a slide catalog, we need to typeset the text to make the page look neater. Beginners will use the space bar to align the text one by one, but this is more troublesome. Is there any other way to quickly align the pages? First we need to click the View tab above, and then check Ruler. The ruler above the slide helps us determine the length of the Tab stop. Click the Menu drop-down button, and click Format, finally click Paragraph. In the Paragraph dialog box, click the Tabs b....

      Presentation 378 views
      Prev 123...2627 Next
      WPS Academy