# 2022.2| Best Pieces of Advice for grasping office skills in Feb.

March 22, 2022
1.5K Views
0

A free Office suite fully compatible with Microsoft Office

There are many reasons why you may be interested in using WPS Office. If you haven't found the answer, why not see what the most popular features are among users in February 2022?

· Insert special symbol in word

Can't believe this tutorial gets more than 4,000 hits. It's been less than a month, after all.

What makes the special symbols so special? Click the following link to get the answer:

How to insert special symbols

· Create your own PowerPoint theme (Slide Master)

Not to be outdone, this tutorial is also well done!

This tutorial tells how to edit slide master in WPS Presentation:

Everything you want to know about making your own PPT theme (like how to design the themes, colors, fonts and effects) can be found in the following link:

Create own PowerPoint theme (Slide Master)

· LEFT and RIGHT function

Function! How come the nightmare of excel novice becomes one of the top searches? Because people really need it, which may explain why human claim sugar is killing us yet cannot stop buying it.

Simply put, both the LEFT and RIGHT functions allow you to extract a given number of characters from a given text string.

Suppose we want to delete the first 5 and last 4 characters from i,e 12345Mary1234. Is it possible to get the result Mary?

And here is how they work:

How to use LEFT and RIGHT formulas together

· SUMPRODUCT Function in Excel

Aha! Another function hits the jackpot! SUMPRODUCT is the upgraded version of the SUM function, as it can multiply ranges together and returns the sum of products.

I bet to say that no store owner wants to miss the following tutorial:

SUMPRODUCT Function

·  Highlight every other row in Excel

When confronted with a spreadsheet containing large amounts of data in hundreds of rows and columns, it's easy to become perplexed when jumping from one place to another. No worry! There are always more solutions than problems. To learn how to make a table simpler to read and edit, please click the following tutorial:

This is a list of the top 5 most popular lessons in February 2022. Stay tuned for the following content!

In WPS free PowerPoint tutorial, learn how to use themes and background styles of presentations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more, and WPS Office can be downloaded free on Windows, PC, Mac, Linux, Android, and iOS devices.