在线一本码道高清

Back to top
Position: Home > Download Center > Computer Tutorials > Newspapers and Magazines > Excel Master Shortcut
Excel master shortcut pdf scan full version

Software Description

Excel master shortcut pdf This electronic textbook is the most practical excel tutorial book I have seen. The function of excel is not limited to tables, functions, and statistics. If you have mastered all the functions and skills of excel, you can achieve it in both office and painting! Not much introduction here, everyone can come to the green resource network to download excel master shortcuts e-book learning experience!
Excel master shortcut pdf scan introduction introduction
"Excel Shortcuts for Excel Masters" is a step-by-step introduction to the rich and powerful functions of Excel from shallow to deep. The book has 7 chapters, which explain data manipulation and processing, data analysis, formulas and functions, chart making, Macro is integrated with VBA, Excel and Access. Each chapter has a large number of cases. When explaining the operation methods and techniques, detailed step diagrams are used. Some of the contents are also equipped with operation process demonstration animations. The sample files and animations are shared on Tencent Weiyun for readers to download. The appendix is attached with Excel specifications and restrictions and Excel's common shortcut keys for easy reference at any time.
"Excel Shortcuts for Excel Masters" is suitable for Excel users at all levels. It is a golden key for Excel novices to enter the gate of Excel. For those who have some experience, it is a ladder for further improvement. A large number of examples in the book are suitable for readers to use in daily work. Follow the author's WeChat public account and Tencent's Weibo, communicate directly with the author, and continue to improve.
Excel master shortcut pdf scan directory description
Chapter 1 Data Operation and Processing 1
The first trick is the maximum number of rows and columns that can be loaded in different versions of Excel 2
2nd trick to convert different versions of Excel 2
The magic trick of shortcut 3
The fourth trick how to do the same operation on multiple worksheets-create a workgroup 7
No. 5 Techniques for entering special data such as ID number, score, index with superscript 7
Sixth trick how to add Pinyin to Chinese characters in Excel 8
7th trick for entering equal and proportional series 9
The eighth trick how to turn a row of data into a column of data or a column of data into a row of data10
The 9th batch conversion between text and digital format11
The tenth batch to reduce the data in multiple rows and columns by 10,000 times—the magic of selective paste13
The 11th stroke conditional format 13
The 12th trick to set the range of data entry for the cell-data validity (data verification) 22
13th trick Do you know what day of the week you were born? —Excel's wonderful custom cell format 24
Show and hide the 14th stroke sheet label 30
Show and hide the 15th stroke worksheet 30
The 16th trick how to hide the Excel worksheet in depth 31
Step 17 How to enter blank spaces in batches after canceling merged cells 33
18th trick how to insert a check mark (.) And a cross mark (.) In Excel 34
Chapter 19: How to Add Bullets to Excel Cells 35
Tip 20: How to insert a blank row at the bottom of each row in the Excel table 36
Trick 21 How to select multiple charts or graphic objects at once in Excel 38
The 22nd trick how to divide multiple lines in a cell into multiple cells 40
Trick 23 Copy and paste a table with a line break in Word into a row in Excel 42
The 24th trick how to quickly turn multiple columns of data into one column of data 44
The twenty-fifth trick Excel file save display information can not be deleted through the "Document Inspector" 45
Twenty-sixth trick Excel sharing conflict when saving a file, cannot save to "file name.xls0" 48
The 27th stroke form is copied from Excel to Word. Small logos such as "top of form" and "bottom of form" appear 48
The 28th trick Excel open CSV file is garbled solution 51
29th Excel File Tips For "Weight Loss" 52
Trick 30: Lesser-known camera feature in Excel 54
The 31st trick Excel file has many pages, how to print the header row of each page 57
Chapter 32 Protection of Excel Worksheets and Workbooks 58
Chapter 2 Data Analysis 63
The 33rd trick in Excel how to separate Chinese and English in a field into 2 fields-column 64
The 34th trick Excel text data how to keep the format after the column and the consistency before the column 65
The 35th trick how to change the conventional number format to the date format-a versatile sub-66
36th move to delete duplicates 66
37th trick how to fix the first row and column at the same time-freeze pane 67
The 38th trick to sort as you want 67
39th best way to hide data-create a group 69
The 40th allowance report can be freely retracted-classified summary 70
41st trick: easy-to-use screening like "point and shoot" 71
The 42nd trick to sifting through the complex conditions Excel advanced filtering skills 72
Chapter 43: Pivot Table Application 76
The 44th trick summarizes worksheet data with multiple fields in the same field—powerful merge calculation 80
Chapter 3 Formulas and Functions 83
The 45th move, the third move, the three tables concept (parameter table, source data table, summary table) 84
46th formula type (common formula, array formula, named formula) 85
47. One tricky point: reference types (relative, absolute, mixed) 86
48th trick why only formulas are not displayed in Excel cells 87
49th Sum Function and Tip 88
The 50th trick how to enter the sum formula 89 in batches
The 51st trick function is not necessarily the best way to solve a problem90
The 52nd trick Count, Counta, Average, Max, Min, Large, Small and other commonly used functions 91
53th trick Math functions like Int, Round, Roundup, Rounddown, Abs 91
The 54th measure is the most frequently occurring value—Mode Function 92
55th Product of Multiple Values—Product Function 93
56th Sum of Multiple Products—Sumproduct Function 94
57th Subcategory Summary-Subtotal Function 95
58th trick to meet certain conditions count and sum — Countif, Sumif 96
59th trick multi-conditional statistical functions (Countifs, Sumifs, Averageifs) 99
The 60th trick how to calculate the median of a given value-Median function 102
The 61st trick how to randomly enter batch data-Rand function 103
Rank 62-Rank Function 103
The 63rd trick is not the usual way, Excel generates a unique random integer 104
64th trick logical functions If and Iferror 105
The 65th trick how to extract the date of birth, area code, gender based on the ID card number 106
66th trick to remove spaces in batches-Trim function 108
67th letter case conversion-Lower, Upper, Proper functions 108
The 68th trick to convert the value to the specified number format-Text function 109
The 69th trick how to determine whether the 2 strings are exactly the same-Exact function 110
70th trick to merge multiple strings-Concatenate function 110
71st trick to merge multiple texts-Phonetic function 110
72nd trick how to find the position of a string-Find and Findb functions 111
73rd trick to find the second string starting position number in the first one-Search and
Searchb function 112
74th trick how to separate name and phone number in Excel 113
75th trick text string replacement—Substitute function 115
76th trick text string specified replacement-Replace function 115
77th trick Vlookkup function basic usage, multi-column search, multi-conditional search, fuzzy search 116
78th Recruiting Perfect Match-Index Function and Match Function 118
The 79th trick Excel lookup function results in multiple records 120
The 80th trick Vlookup function finds 13 easy mistakes and solutions 124
81st trick Select the specified value from multiple lists—Choose function 129
The 82nd trick is mainly used for fuzzy lookup function-Lookup function 130
How to extract the contents of the last column of non-empty cells in the 83rd trick—Lookup function 131
The 84th method uses the specified reference as the reference system, and obtains a new reference with a given offset—Offset function 132
The 85th trick how to avoid # N / A and other error values in the formula—Excel IS class function introduction 133
86th move date and time functions Today, Now, Year, Month, Pay 136
The 87th move is the 20th working day from a certain day—Workday function 136
How many working days have the 88th recruited employee worked? Networkdays function 137
The 89th trick is the day of the week—Weekday function 138
The 90th trick is the day of the week—Weeknum function 138
The 91st trick returns the serial number of a specific date-Date function 138
Chapter 92 How to Count the Years, Months, and Days Between Two Dates—Datedif Function 139
How to convert lowercase numbers to uppercase
The 94th trick how to convert full-width characters to half-width characters — Asc function 140
The 95th trick to calculate the monthly repayment amount of the loan-PMT function 141
Chapter 4 Chart Making 145
Basic Theoretical Knowledge of 96th Chart Making 146
The 97th stroke of the basic chart production, column, bar, line, pie, scatter, etc.149
Rule 98 Add Reference Line to Excel Bar Chart 158
The 99th trick Excel double-axis production method 162
The 100th trick of Excel composite pie chart (including secondary relationship composite pie chart) making skills 164
101st move Excel budget and performance comparison chart (thermometer bar chart) production 172
The 102nd stroke of the multi-axis coordinate chart 177
The 103rd trick matrix percentage chart 181
The 104th trick to compare left and right bar chart making step 182
Chapter 105 How to Modify the Legend Series Order of an Excel Chart 186
106th trick how to put 3 bar charts in one chart 187
107th move maximum and minimum value in line chart 189
The 108th trick to make Excel dynamic charts with the offset function 190
Chapter 109 Use the Choose Function to Make an Excel Dynamic Pie Chart 192
The 110th trick Excel data labeling utility 193
111th Annual Report Chart 194
Chapter 112 How to Make a Quadrant Scatter Plot with Excel and Fill the Quadrant with Different Colors 198
Chapter 5 Macros and VBA 207
What does the 113th trick macro in Excel mean

Software screenshot

Category Navigation
Popular downloads
  • ETPDF converter official version

    ETPDF converter official version

    download now
  • Extreme Whale Downloader 2018 Official Free Edition

    Extreme Whale Downloader 2018 Official Free Edition

    download now
  • wps office 2016 official download free full version

    wps office 2016 official download free full version

    download now
  • LeTeam game box 2018 official free version

    LeTeam game box 2018 official free version

    download now
  • Tencent computer housekeeper official download 2017 official version

    Tencent computer housekeeper official download 2017 official version

    download now
  • QQ browser official download 2016 computer version

    QQ browser official download 2016 computer version

    download now
  • uc browser computer version 2017 official pc version

    uc browser computer version 2017 official pc version

    download now
  • Baidu Guardian 2017 official latest version

    Baidu Guardian 2017 official latest version

    download now
  • Baidu antivirus software 2016 official free version

    Baidu antivirus software 2016 official free version

    download now
Change batch Recommended mobile games
Ranking in this category