How to create magnifying glass effect in PowerPoint?

How to create magnifying glass effect in PowerPoint?Sometimes we need to highlight a specific area in our presentation pictures. Then we can create the magnifying glass effect in our slides.Now let’s explore the techniques step by step.1. Create a duplicate of the original picture with the shortcut key Ctrl+D. Then select the duplicate picture and click the Picture Tools tab. Then click Crop drop-down button and choose an oval shape preferably. 2.Next, narrow the cropped area as you wi....

The WEEKDAY Function in EXCEL

· Description:Weekday Function can return a number from 1 to 7 identifying the day of the week of a date. In today’s tutorial, we will also learn how to combine WEEKDAY with nested IF&OR function. · Syntax:(Serial_number, Return_type) · Arguments:Serial_number: The number that represents a date.Return_type: You can enter a number here: 1: Returns a number from 1 to 7, meaning start from Sunday and end at Saturday. It’s the default if omitted.2: Returns a number from 1 to 7, meaning st....

How to convert a word document to a PDF?

PDF is a file format used to present documents in a manner independent of application software, hardware and operating systems, so that all parties see the same contents. Sometimes we need to convert a word document to a PDF and WPS Office helps you perform the conversion conveniently.Here are the steps.lOption 11. Open the word document you want to convert to a PDF in WPS Office. Head to the Tools tab and click on the Export to PDF button. 2. Then, in the pop-up dialog, complete relev....

How to change color of PowerPoint slide?

1. Click Design > the Background drop-down button. You can select one color from the Gradient Fill area. Tips: Recommended Gradients for premium users only. 2. You can also click Background in the drop-down button to get a Object Formatting pane. We can set Solid fill or Gradient fill. Here we take Gradient fill as an example.3. Click Color Schemes on the toolbar to choose a set of colors(optional). Then set the Gradient Style, Color, Position, Transparency and Brightness in the pane....

The VALUE function: Convert text to number in Excel

In daily work, we often come across text formats that represent numbers. So how can we convert text to number? There are two methods. · Option 11. Click the Formulas tab > Insert Function to pop-up a dialog.2. Input “VALUE” in the text box and then select the desired cell in the new dialog. Then click OK.3. Drag the cell to fill the formula into the rest of the cells.Tips: This method is suitable for situations where multiple data needs to be processed. · Option 2WPS Spreadsheets iden....

Conditional formatting in Excel--Top/bottom Rules

We can use conditional formatting to mark specific contents quickly according to a certain rule. In this tutorial, we are going to talk about Top/Bottom Rules. There are multiple rules for selection, namely, Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, Above Average and Below Average. We take Above Average as an example. Here is a sales table of different branches. Now we want to highlight the data that is above average. Here are the steps. Open your Excel document, and click t....

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.

How to insert a table in WPS Writer

After we use WPS Writer to open the document, first click the Insert tab, and then click the Table button. Here, we can find different ways to insert a table in WPS Writer. 1. We can directly select the row and column in the popup box, and then insert them into the document. 2. We can also insert a table by clicking Insert Table, then input the number of columns and rows according to our needs. Then click OK. 3. Or we can just click Draw Table and hold down the left mouse button to dra....