569,718 views
To master the design of attendance and absence files in Excel, you must watch this video • Very important and an untested method (Design a statement of... To master the design of employee payroll sheets in Excel, you must watch this video • The sheet is free - Design an employee payroll sheet... This video is very useful about the 25 most important websites on the Internet ???? I challenge you that it will change your life completely • ???????? Very useful websites that you will not imagine that they are available... ـــــ Follow us on Facebook / infology1 ــــ Follow us on Instagram / infologyyy Telegram channel link https://t.me/InfologyChannel Link to the group of scholarships and free courses / infology11 00:00 Introduction 01:02 Auto Sum 01:53 Random Numbers 02:55 Move Data 03:27 Justify Text 04:03 XLOOKUP 04:58 ALT + = 05:21 Skip Blanks 06:02 Filter() 06:28 Analyze Data 07:09 Auto Fill 07:41 Copy Sheet 08:26 Browse All Sheets 09:03 Remove Blanks 09:34 Quick Analysis Tool 10:20 AutoFill Column Width 10:53 Absolute Cell Reference 11:52 Paste Special Values 12:27 Drop Down List 13:19 Filter Function 14:04 Remove Duplicates 14:28 Flash Fill 15:00 Data Types 15:36 Transpose 16:07 Freeze Panes 16:43 Slicer Option 17:32 Conditional Formatting 18:19 If Function 19:19 SUMIFS Function 20:16 IFERROR 21:09 Filled Maps 21:49 PMT() Function 22:29 Advanced Select 23:02 Named Range Shortcut 23:35 Hide Cells 24:16 Count Blank 24:42 Goal Seek 25:50 ISBLANK 26:57 Convert() 27:35 Insert Multiple Rows & Columns 28:06 Status Bar Info 28:52 Choose Function 29:26 Unique Function 30:00 Proper Function 30:45 Mathematical Functions 31:29 Clear All Formatting 31:49 Insert Date 32:04 Insert Time 32:23 Show Functions 32:51 Merge Cells