Excel has a number of features, and the following are some of the main learning points: #excel technique**i. Basic operations**1. Workbooks and sheet management - new, save, open the workbook. Learn about different file formats (e. G... Xlsx,. Xls, etc.) and their respective characteristics. - inserting, deleting, renaming, moving and copying sheets. Learn how to quickly switch and manage multiple sheets in a workbook. - adjusting the row height and column width of the sheet to suit different data requirements. Cell operations - the method of selection of cells, including individual cells, continuous areas, and discrete areas. - input and editing of cell data, such as input specifications for different types of data, such as text, numbers, dates, etc., and methods of modifying and deleting data. - cell format settings, including numerical formats (e. G., values, currencies, dates, percentages, etc.), font formats, borders and bottomlines, to glorify tables and enhance the readability of data. **ii
**
Fast filling
- enter sequence data, such as digital sequences, date series, etc., using automatic filling。
- improve data entry efficiency through intelligent filling (e. G. Autofilling other cells according to the pattern of available data)。
2. Data validation
- sets the data validity rules to limit the type, range, etc. Of data entered in the cell to prevent the input of incorrect data。
- custom data validation rules, such as setting down a drop-down list for users to choose input content。
3. Finding and replacement
- quickly find the location of specific data in the sheet。
- batch replacement of specific data and more efficient data revision。
**iii. Formulas and functions**
1. Formula base
- understands the composition of the formula, including operators (e. G., arithmetic operators, comparative operators, text connectors, etc.), cell references, etc。
- masters the distinction between relative references, absolute references and hybrid references and uses the scenes to correctly refer to cells when copying formulas。
Common functions
- mathematic functions: sum (summation), average (average), max (maximum value), min (minimum value), etc., for basic mathematical calculations。
- statistical functions: count (count), countif (conditional count), sumif (conditional sum), etc., for statistical purposes。
- text functions: e. G. Left (take left characters), right (take right characters), mid (take intermediate characters), concatenate (text connections), etc., for text data processing。
- date function: date (construction date), year (year taken), month (month taken), day (date taken), etc., to process date data。
Data visualization**
1. Conditional format
- automatically set cell formats according to specific conditions, such as highlighting data larger than a value, setting different colours for duplicate data, etc., making data easier to analyse。
- use visual tools such as data bars, colour steps and icon sets to visualize data size relationships。
Chart production
- select the appropriate chart type, such as a column chart, a line chart, a pie chart, etc., to show the relationship between data trends, proportions, etc。
- edit chart elements, such as titles, coordinates, data labels, etc., to enable the chart to convey information more clearly。
- format charts as required, such as setting colours, fonts, etc., and glorifying charts。
** v. Data management**
1. Order
- aligning data in ascending or descending order by single or multiple columns in order to quickly organize the data。
2. Screening
- simple filtering to filter out data that meet the requirements by setting conditions。
- advanced screening, with complex screening conditions, such as multiple combination filters。
3. Disaggregated summary
- classification of data according to specific fields and aggregation of data such as sum, average, etc。
Data analysis tools**
1. Data lens tables
- creation of data lens tables to quickly aggregate and analyse large amounts of data。
- adjusting the layout and field settings of the data lens table to meet different analytical needs。
- dynamic screening using the sniper function of the data perceived table。
2. Simulation analysis
- a single variable solves the value of a variable in a formula that meets certain conditions。
- programme manager, which can create and manage multiple different scenarios for comparative analysis。
In summary, excel's six aspects of basic operations, data input and editing, formulae and functions, data visualization, data management and data analysis tools present key learning elements. Basic operations cover workbook and sheet management and cell operations; data input and editing include rapid filling, data validation and search and replacement; formulae and functions are divided into formulae bases and introductions to commonly used functions; data visualization is conditional format and chart production; data management includes sorting, filtering and grouping aggregations; data analysis tools are data lens tables and simulations. This comprehensive coverage covers the more important features of excel and facilitates systematic user learning of excel。
