How to input data into a table efficiently

Uploaded time: August 17, 2022 Difficulty Beginner

How to input data into a table efficiently

Key Points Catalogue

The key points of this lesson

In this lesson, we've learned the following key points.

1. How to use shortcut keys to improve the efficiency of table entry?

Ctrl+Arrow keys: to quickly jump to all sides of the table

Ctrl+Shift+Arrow keys: to select data according to the Arrow keys

Ctrl+Home: to jump to cell A1

Ctrl+End: to locate the bottom right cell of the used data area

Enter the cell address in the name box in the upper left corner of the worksheet, you can quickly jump to the current cell.

2. How to become proficient in using the fill function of WPS tables.

When editing a table, you can use the fill function if you need to enter the same data or data with a fixed pattern.

Select the cell area, and click the Home” tab > “Fill,” where you can choose to fill to the left, fill to the right, fill up and fill down. If you need to fill the same content in the adjacent cells, just select the command as needed.

When you enter a number or date in the cell, place the mouse in the small right corner of the cell. As the mouse becomes a cross shape, drag down or double-click it; besides you can automatically trigger the fill function of WPS Spreadsheets, which we call Fill Handle.

How to fill 1-10,000 in 5 seconds?  Why not try the Fill>Series function? By setting itsstop value and step value, you can fill it instantly.

Ctrl+E Flash Fill is very powerful, it can learn by the rules you set and apply them to the selected blank cells.

3. How to make a drop-down list to improve entry efficiency?

Select the cell area, click the Date tab > Insert Drop-Down list, and you can manually enter the options in the pop-up dialog box. After setting, we only need to click the cell to select the desired content in the drop-down list.

4. How to use the OCR function to enter information quickly?

The OCR function can extract text information from pictures and support a high degree of restoration of the typesetting layout.

Click the Tool tab>Picture to Text, there you can open the local picture or take screenshots directly from the desktop area of your computer. Three types of conversion methods are provided in the system, including Convert to Plain Text, Convert to Word, and Convert to Table

You'll Learn

The basics of WPS Spreadsheet.

The most commonly-used batch processing skills for increasing productivity.

Process large data in WPS Spreadsheet.

Master the popular PivotTables to create dynamic reports.

Nest dynamic formulas, including the IF, VLOOKUP, SUMIF, and MATCH functions to impress your leader.

Acquire skills in improving security, sharing, co-editing, and printing files.

Course Content

Start from beginners, from theory to practice, don't worry about learning

Basics of WPS Spreadsheet

6  lectures

3592  minutes

This chapter covers some basics about WPS Spreadsheet, including the interface and common format types. You will learn how to enter and process data, customize formats, and make a data table starting from 0.

How to make a table efficiently

6  lectures

3664  minutes

Filter, Search, locate and View are all the basics in a table. Do you really know how to use them? Knowing how they work can help you make tables quicker. This chapter covers the usage of "Text to Columns" and "Split and Merge." These two tools will boost your productivity by more than thrice.

Most commonly-used Formula Skills

5  lectures

3471  minutes

80% of beginners think that functions are too much for entry-level. They can't remember the syntaxes, make mistakes all the time, and make tables manually. A few key functions can solve most of the working issues. This chapter covers the statistical functions SUM and SUMIF; logical functions IF ,AND, OR; time function DATEIF and NETWORKDAYS; And the magical power of the VLOOKUP function.


2  lectures

1329  minutes

This chapter covers the basics of PivotTables and PivotCharts. You can immediately apply what you've learned to your work in real cases. You can also learn how to create and beautify the dynamic PivotTables, thus impressing your leader.

Data Visualization

6  lectures

3709  minutes

Charts have advantages in presenting data. This chapter covers the usages of conditional format, column charts, line charts, pie charts, combo charts, and sparklines. You can learn how to pick charts for various situations. There are also useful strategies to beautify your chart and make it more appealing.

Security and Painting

3  lectures

1896  minutes

This chapter focuses on three things: how to protect the security and privacy of sheets, how to share, collaborate and track changes in the table; how to solve typical printing issues at work.

You'll Get

  • 300+ Mins Videos
  • 100+ Real Cases
  • 40+ Practice Files


Seriously, it really helped me a lot. I used to be overwhelmed by the huge amount of data every day, but the spreadsheet has relieved me of the statistical burden!
WPS Office is completely beyond imagination and now I am highly dependent on it for my work, creating test papers, courseware, and slideshows ...... It covers almost everything.