[Welfare is coming] 30 Excel tips to share (with viewing link)

↑↑↑Follow the WeChat public account "ZKEDU_HR" of "Chinese Academy of Sciences " to view more course details and HR information introduction.

This article takes about 8 minutes to read

In the process of using Excel, because many users do not have a good grasp of the functions provided by the software, they often spend a lot of effort to get the desired results. In fact, Excel itself has many skills, as long as you master them, you can get twice the result with half the effort.

This course shares 30 powerful Excel tips, and conducts practical analysis of frequently used functions and skills to help students efficiently solve problems in using Excel and improve office efficiency.

class

Procedure

Big

Tsuna

0 1

How to quickly navigate to the ends of the worksheet

0 2

How to quickly create new worksheets with specified names in batches

How to maximize the display interface of the worksheet

0 4

How to manage huge tables

0 5

How to implement intelligent choices

0 6

How to quickly locate the location of the target data

0 7

How to quickly batch fill ordered sequences

Customize common ordered sequences

0 9

Format worksheets in bulk

How to delete blank lines

1 1

How to find where a formula or function is located

How to quickly unify borders and font formatting

How to align both ends of a person's name with unequal number of characters

How to quickly call a specified worksheet in a workbook with multiple worksheets

How to easily cross-transpose row or column positions

How to set the indent effect of cells

How to quickly insert a row or column

Please specify the date format quickly

How to combine a column of data into one cell

How to move sheets between different workbooks

twenty two

How to remove duplicates

twenty three

Check for duplicate data

twenty four

How to see the contents of a workbook without opening a workbook in a folder

How to adjust the height of rows and columns in centimeters

How to increase line height between multiple lines of text within a cell

Bulk insert blank lines after related content

How to batch open or close multiple workbooks

How to switch between multiple open workbooks

How to quickly move the position of a worksheet in the current workbook

speak

division

between

Shaw

horse success

Senior lecturer of office with equal emphasis on theory and practice, expert in solving common software failure cases in Office, typesetting more than 100 IPO documents, 5 years of full-time office teaching experience in schools, 4 years of full-time first-line typesetting experience in companies, 3 years of internal training experience in enterprises, lecturer Workplace white-collar office series courses, wps series courses, etc.

He has served major domestic securities companies, typesetting documents of more than 200 large state-owned enterprises, private enterprises, banks, law firms and government agencies that have been listed, quasi-listed, or to be listed, and has conducted in-house training for office companies for many units.

class

Procedure

letter

interest

Course fee

watch for free

way of participation

The first step
is to scan the following QR code and follow the subscription account of
Chinese Science Court