After reading you can go to work completely, who dares not!?

1, AutoFilter 2, character replacement 3, table edit macro 4, import external Data 5, row and column quickly convert 6, run a macro in a table

7, add macro 8 in the table, text and letter of the column merged 9, plus multiple views 10, Set table Print Area 11, table chart

12, get the network data 13, table search function 14, table Insert Super Key 15, print the specified page 16, frozen row, column headings

17, call macro 18, use the Function Wizard to enter Formula 19, one time to open more than one table 20, lock and hide formula 21, shared worksheets

22, convert the formula to numeric 23, label color 24, set read-only password 25, prevent data duplication into 26, add header and footer

27, table Plus Unit 28, change save location 29, split window 30, protection work PO 31, call Macro 32, automatic fill sequence

33, set the data alignment 34, direct input function 35, character formatting 36, input data Drop-down list 37, correct input ID number

38, page background set 39, data input range control 41, data sorting operation 40, how to display according to conditions, 42, how to use advanced

43, data Format set 44, template save and call 45, Watch Window 46, row and column hidden operation 47, name information 48, worksheet encryption save 49, reference mode conversion 50, Chinese date format 51, worksheet move 52, worksheet copy 53, the subregion locks

54, row and column height set 55, uppercase number set 56, cell merge 57, add macro 58, table title Repeat Print 59, table border settings

60, center across the column 61, formula evaluation

　　　

Excel Tutorials

Rare Excel Tutorials Collection edition, simple and clear, package you learn

Photo Name: Auto Filter


Photo Name: Character substitution in Excel


Photo Name: Edit macros directly in Excel


Photo name: Importing external data in Excel


Photo Name: Fast transitions in Excel columns


Photo Name: Run macros in Excel


Photo name: Adding descriptive text to Excel


Photo Name: Data collation in Excel


Photo Name: Data merge in Excel


Photo Name: Add a common folder to Excel


Photo name: Adding multiple Views in Excel


Photo Name: Setting the print area in Excel


Photo Name: Record "Macros" in Excel


Photo Name: Creating a chart in Excel


Photo Name: Getting network data in Excel


Photo Name: Use Excel's "search function"


Photo Name: Insert hyperlink in Excel


Photo Name: Print the specified page in Excel


Photo Name: Freeze row and column headings in Excel


Photo name: Calling macros with a form


Photo Name: Enter a formula with the Excel function Wizard


Photo Name: Open multiple Excel files at once


Photo Name: Lock and hide Excel formulas


Photo Name: Shared Excel workbook


Photo Name: Convert Excel formula results to numeric values


Photo Name: Set Excel label color


Photo Name: Set Excel file read-only password


Photo Name: Prevent Excel data from repeating input


Photo Name: Add a header and footer to an Excel datasheet


Photo Name: Adding units to data in Excel



Photo Name: Split window


Photo Name: Securing Excel Workbooks


Photo Name: Button calls macros


Photo name: Excel custom Auto Fill sequence



Photo Name: direct input function in Excel


Photo Name: Excel character format settings


Photo Name: Excel custom input data Drop-down list


Photo Name: Excel enter ID number correctly


Photo Name: Excel page background settings


Photo Name: Excel data Entry Range control



Photo Name: How to display the Excel data table by condition


Photo Name: How to name information in Excel data table


Photo Name: How to take advantage of the Excel data table


Photo name: Excel data Format settings


Photo Name: Excel Built-in series bulk fill


Photo Name: Save and call Excel templates


Photo name: Excel Watch Window


Photo name: Rows and columns in Excel hidden operations


Photo Name: Excel Workbook encrypted Save


Photo Name: Excel formula reference mode conversion


Photo Name: input for special symbols in Excel


Photo Name: Excel Chinese date format


Photo Name: Excel worksheet move


Photo Name: copy of Excel worksheet


Photo Name: Excel area Lock


Photo Name: Excel Animation Tutorial: Loading macros


Photo Name: Excel table Grekon High setting


Photo Name: Excel uppercase number setting


Photo Name: merge of Excel cells


Photo Name: Excel Animation Tutorial: Saving Add-ins


Photo Name: Excel table header repeat print


Photo name: Excel table Border Settings


Photo Name: Excel header centered across columns


Photo Name: Excel "formula evaluation" feature