youtube tutorial excel

Excel2003 Introductory Animation Tutorial 58, edit macros in Excel tables. Demo Animation Operation Steps If you are familiar with the language of the VBA program, you can edit the macro directly in Excel is more convenient, the macro code is also simpler. Go to the Visual Basic Editor window by executing the tools → macros →visual basic Editor command

Excel2003 Getting Started animation tutorial 54, add-ins in Excel. Demo Animation Operation Steps First save the Add-in document to the appropriate folder, and then load it in Excel. Execute the Tools add-in command, open the Add-Ins dialog box, click the Browse button, open the Browse dialog box, select the macro that you want to load, and then confir

Excel2003 Introductory Animation tutorial 47, Excel Watch window. Demo Animation Operation Steps We sometimes need to see the values in different cells in multiple worksheets in Excel at the same time, and you can view them in a supervised window. Select the appropriate cell, right-click, and select the Add Watch command on the shortcut menu that pops

EXCEL2003 Introductory Animation tutorial 64, Excel replaces characters in formulas. Demo Animation Operation Steps Although Excel is not word processing software, its replacement function is still very powerful, not only to replace the characters in the cell, but also to replace the characters in the formula. For example, we need to replace the letter

Excel2003 Introductory Animation Tutorial 39, insert hyperlink in the table. Demo Animation Operation Steps You can also add hyperlinks in your Web pages in Excel: Select the cell that is the linked object (such as G5), perform the insert → hyperlink command, open the Insert Hyperlink dialog box, select the existing file or Web page option on the left, and then press the Drop-down button to the ri

of dataIRow row = sheet. CreateRow (r + 1);Row. Createcell (0). Setcellvalue ((int) dt. rows[r]["Id"]);Row. Createcell (1). Setcellvalue (dt. rows[r]["Name"]. ToString ());Row. Createcell (2). Setcellvalue (dt. rows[r]["Remarks"]. ToString ());}SqlDataReader reader = sqlhelper.executereader (SQL);if (reader. HasRows)//{Create a workbookIworkbook workbook = new Hssfworkbook ();Create a worksheetIsheet sheet = workbook. Createsheet ("Dbtoexcel");int rowIndex = 0;while (reader. Read ())// {A row i