Wednesday, July 31, 2024

How To Download, Install And Activate Microsoft Office 2024 Preview Lega...


00:01 - Intro 00:31 - Uninstalling Previous Version Of Office 01:31 - Downloading Office Deployment Tool 02:27 - Creating Configuration File 04:19 - Installing Office From The Command Prompt 06:07 - Activating Office 2024 Preview

Sunday, July 28, 2024

Thursday, July 25, 2024

12 Excel Copy Paste Hacks - I Bet You Don't Know All!


00:00 Intro 00:29 Copy Paste Basics 01:32 Click and Drag 04:33 New Paste Values Shortcut 06:32 Paste Special Options 14:07 Paste Special Operations 15:44 Copy and Paste as a Dynamic Picture 19:50 Copy and Paste from Clipboard 23:22 Copy Formula Without Changing Cell References 25:00 Copy from the Cell Above 26:18 Copy Paste Non-Adjacent Cells 26:50 Make a Copy of Worksheet 27:57 Wiggle Trick 30:27 Copy Pasting in Pivot Tables 32:26 Copy and Paste Formatting in Charts

1- If we double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane.
2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.

25 Tips & Tricks to Make you an Excel WIZARD


⏱️ TIMESTAMPS 0:16 Adding a Dynamic Dropdown 4:53 Unpivotting Data 7:38 Add a Slicer to a Table 8:48 Text to Column 9:32 Transposing Data 10:07 Remove Duplicates 11:11 Duplicating a Window 11:59 The Watch Window 12:31 Camera Tool 13:30 Create Different Scenarios 14:47 Analyze the output of Multiple Scenarios in One View 16:51 Finding an Exact Value With Goal Seek 17:23 Insert Cut Cells 18:23 Sumproduct 20:09 Evaluating Your Formula 20:40 How to Create Conditional Formatting 22:31 Custom Formatting 24:07 Create a Combo Chart 25:12 Centering Across Selection 25:50 Vertical Headers 26:09 Insert a Timeline to a Pivot 26:39 Create a Table Of Contents 27:17 Insert Icon into Cell 28:23 Create Bulk Named Ranges 28:59 Create a Custom Sort


Make Tasks Automatic in Excel - Part 1/2


Sunday, July 21, 2024

Friday, July 19, 2024

Once you know this formula, NOTHING can stop you.

Law of attraction

致富路上的绊脚石!这些思维定式,让你发不了财!发财致富必备的心理学知识!

掌握GPT-4.0的秘密 16个案例带你玩转新一代AI技术


Key points for quick navigation: 00:00 Video introduction and GPT-4.0 press conference demonstration - Chinese translation and interpretation of the video introducing the GPT-4.0 press conference - Share the 16 undemo cases released on the official website of GPT-4.0 and perform bilingual subtitle production 01:49 GPT-4.0 performance in real-time conversations - GPT-4.0 demonstrates real-time camera opening and interaction capabilities during voice conversations - Demonstrated ability to sing and be funny in conversation - GPT-4.0 shows the ability to interact with human emotions in performance 06:15 Joke understanding in interaction with GPT-4.0 - Demonstrate GPT-4.0’s use of language in understanding and answering jokes - Demonstrated ted Ced ChatGPT’s humorous language capabilities, including the understanding and application of puns
10:39 AI demonstrates emotion and tone adjustment - Demonstrated GPT-4.0's ability to adjust responses and add emotions based on mood and tone - Demonstrates how GPT-4.0 should behave emotionally when interacting with humans 13:02 �️ Us️ Use Use ChatGPT to create different voice characters - Demonstrate how to leo let let ChatGPT play different voices for interaction - Explore the use ose ofe of ChatGPT to create multiple fictional groups for discussion and debate - Shows how to let GPT adjust speech speed and emotional expression during interaction. 14:584:58 :58 �58 ChatGPT’s image recognition and language interactiontion ion - ChatGPT recognizes objects and translates languages ​​in real time through the cameramera era - ChatGPT translates objects in Spanish, showing new application scenariosrios ios
- ChatGPT demonstrates the ability to interact and teach with humans 16:346:34 :34 � ChatGPT visual recognition teaching on Pad - Demonstrates a case of visual interaction won win with ChatGPT on Pan Pad Pad - ChatGPT can recognize pictures and teach interactively with people - It is very convenient to use the pen to introduce mathematics on the Pad 18:08 Applicatioationtion of ChatGPT in teaching and conferenciencinncing - ChatGPT teaches math and other topics through camera interactiactioction - ChatGPT can discuss with humans in meetinetingtings - ChatGPT helps summarize meetings and provide input 23:
23:523:58 ChatGPT’s perception of environment and activitivitivities - ChatGPT interacts with the camera and determines the scenes and activities of the environmronmeonment - ChatGPT identifies whether an event is live or recorecordcorded - ChatGPT can interpret the surrounding environment and provide intelligent interaction 28:068:06 :06 �06 ️‍️ ChatGPT assists real-time help for the visually imp impaimpaired - ChatGPT helps visually impaired people recognize their surrounding environment through visual speech function - Visually impaired people can learn about the external environment and activities ies tes through Chh Cha ChatGPT - ChatGPT provides real-time assistance to make life more convenient and secure Made with HARPA AI