Book 1. Workbook Recovery 2. Workbook Check 3. Modify Connection 4. Copy Macros 5. Change...
Book 1. Workbook Recovery 2. Workbook Check 3. Modify Connection 4. Copy Macros 5. Change Linked Workbook 6. External Link Options 7. Image Title 8. Array Type Functions 9. Date Functions 1 10. Date Functions 2 11. Date Functions 3 12. Date Functions 4 13. Date Functions 5 14. Date Functions 6 15. Lookup Functions 16. TrendLine 17. Pivot Table 18. Pivot Table Grouping 19. Relationships 20. Hierarchies 21. Protect Sheet 22. Protect Workbook 23. Save as... 24. Application settings Book 1. Workbook Recoveryrecover the unsaved workbook apply to the Book workbook save it in the Desktop\IL-ates\Excel folder name Book 2. Workbook Checkcheck the workbook for hidden metadata or personal information apply to the Book workbook delete Comments and Annotations 3. Modify Connectionchange the connected table of the existing connection apply to the Book workbook to the videoclub Customers connection change the table to Rents export the connection file using the name Rents in the folder Desktop\IL-ates\Files 4. Copy Macroscopy the macros from the book apply to the Book workbook copy the macros from the open workbook TEST4U_new.xlsm to the Book workbook 5. Change Linked Workbookchange the linked workbook from Book1 to Book2 apply to the Book workbook it is found in folder Desktop\IL-ates\Excel 6. External Link Optionschange the Save external links option apply to the Book workbook disable the Save external links values option 7. Image Titleadd a title to the image apply to the Book workbook sheet: Sheet3 title: Logo 8. Array Type Functionsinsert the Transpose function apply to the Book workbook sheet: Sheet2 from cell range: Α1:G2 to cell range: I1:J7 9. Date Functions 1use the proper date function apply to the Book workbook sheet: Sheet3 to the cell Ι6 to show the number of the day of the week (Sunday=1, Monday=2,...) which corresponds to the date in cell Α6 10. Date F...Want more? Then download our TEST4U demo from https://www.test4u.eu/en/demo TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did. TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees. More on https://www.test4u.eu/en/demo
Book 1. Workbook Recovery 2. Workbook Check 3. Modify Connection 4. Copy Macros 5. Change Linked Workbook 6. External Link Options 7. Image Title 8. Array Type Functions 9. Date Functions 1 10. Date Functions 2 11. Date Functions 3 12. Date Functions 4 13. Date Functions 5 14. Date Functions 6 15. Lookup Functions 16. TrendLine 17. Pivot Table 18. Pivot Table Grouping 19. Relationships 20. Hierarchies 21. Protect Sheet 22. Protect Workbook 23. Save as... 24. Application settings Book 1. Workbook Recoveryrecover the unsaved workbook apply to the Book workbook save it in the Desktop\IL-ates\Excel folder name Book 2. Workbook Checkcheck the workbook for hidden metadata or personal information apply to the Book workbook delete Comments and Annotations 3. Modify Connectionchange the connected table of the existing connection apply to the Book workbook to the videoclub Customers connection change the table to Rents export the connection file using the name Rents in the folder Desktop\IL-ates\Files 4. Copy Macroscopy the macros from the book apply to the Book workbook copy the macros from the open workbook TEST4U_new.xlsm to the Book workbook 5. Change Linked Workbookchange the linked workbook from Book1 to Book2 apply to the Book workbook it is found in folder Desktop\IL-ates\Excel 6. External Link Optionschange the Save external links option apply to the Book workbook disable the Save external links values option 7. Image Titleadd a title to the image apply to the Book workbook sheet: Sheet3 title: Logo 8. Array Type Functionsinsert the Transpose function apply to the Book workbook sheet: Sheet2 from cell range: Α1:G2 to cell range: I1:J7 9. Date Functions 1use the proper date function apply to the Book workbook sheet: Sheet3 to the cell Ι6 to show the number of the day of the week (Sunday=1, Monday=2,...) which corresponds to the date in cell Α6 10. Date F...Want more? Then download our TEST4U demo from https://www.test4u.eu/en/demo TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did. TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees. More on https://www.test4u.eu/en/demo