"Learning Excel in 30 Days - From Rookie to Data Analysis Master" is oriented to solving common problems in actual work and based on a large amount of practical work experience. It introduces commonly used and practical functions in Excel to help readers get rid of the ranks of "rookies" in 30 days. Chapter 1 introduces common simple but practical skills in Excel; Chapter 2 introduces the basic skills that must be practiced to learn Excel; Chapter 3 introduces cell data sorting, which can make the data more standardized by organizing messy data; Chapter 4 introduces wildcards and search and replace functions, and the combined use of these functions can batch process non-standard data; Chapter 5 introduces data security protection and rapid summary of multi-table data, protecting data security can reduce losses; summary can quickly integrate data into a table Chapter 6 introduces efficient data management. Using the correct method can improve the efficiency of data input and avoid entering wrong data; Chapter 7 introduces the necessary skills for efficient data analysis - functions, and details the use of commonly used functions to help readers solve problems encountered in office; Chapter 8 introduces the efficient data analysis tool - pivot tables. Proficiency in pivot tables can improve efficiency when processing large amounts of data; Chapter 9 introduces three real work cases in detail to consolidate the previous learning. The whole book is equipped with a 360-minute synchronous video explanation. Scan the QR code in the book to watch the teaching video. It truly allows readers to use their mobile phones to watch the operating steps and techniques, and to learn the master's ideas from the book.
