There are 8 free training skills of how to use office suite for Functions and Formulas

How to convert date to text in Excel

How To Convert Date To Text In Excel-WPS Academy Excel stores and analyzes data of all types. Most of the data consists of dates. Dates are presented in numeric form in excel worksheet by default. Excel users can convert this kind of dates in text manually. This method is applicable for data consisting of limited amount of dates. If the data consists of multiple dates, then it becomes very arduous for excel users to convert it in text. Excel has solved this problem of the users by inst....

How to add month name from date in Excel formula

Excel has lately gained popularity as it enables the users to organize data in meaningful categories and due to its advance features. This article holds a collection of formulas and methods to get month names and its goal is to display month name from any given data. Sometimes, when working with date-related data, you may want to add month name in Excel to number or the number to month name, such as convert January to 1, in Excel, you can use formulas to quickly convert between month n....

How to convert text to rows in Excel?

How to convert Text to Rows in Excel-WPS Academy For analysis and report preparation, we occasionally need to extract data from a variety of files in a variety of formats. In such cases, we might need to convert portion of the cell's data to columns. There are several techniques in Excel to transform text to rows of data. Split a Text Cell into Two or More Rows in Excel With Excel's Text to Columns and Transpose Data functions, text in a single cell that is delimited by a cer....

How to count unique text values in Excel?

Improving accuracy when using spreadsheets is easy if you know unique values in given data. You will learn how to count unique values Excel in this blog.

How to add macros in Excel ribbon?

How to add macros in excel. In order to know how to add macros in excel, you first need to understand what macros are. A macro in excel is basically a series of instructions and once you create a macro, what excel will do is that it will execute those instructions step-by-step on the data that you have provided to excel. For example, we could have  a macro that instructs excel to take a number, add 3, multiply by 7, and return the modulus. Now, whenever we instruct excel to run that sp....

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....

Excel formula: how to add percentage in Excel (4 Easiest Ways)

You can compute percentages in Excel in a variety of ways. Excel may be used to determine the % of right answers on a test, discount prices using various percent assumptions, and calculate the percent change between two numbers, for example. In Excel, calculating a percentage is a simple two-step procedure. The percent formula is built in a cell once the cell is formatted to indicate the value is a percent. Format values as percentage in excel online, 2016 and 2019: 1. In Excel, you m....

How to flip first and last names in Excel (3 easiest ways)

Perfecting your Excel skills is essential to becoming a professional. Learning how to format data, create filters and complex formulas are just some of the things you need to know to become a true Excel pro. One of the most important things you can do for your skills is to find out which formulas in Excel return specific values. Sometimes while working with the name, we need to flip the first and the last one for different purposes When you're looking to add a new first and last name t....