Knowledge and good attitude is the Key to riches! More knowledge is more wealth! Knowledge is something nobody can take away from you!
m
Wednesday, July 31, 2024
Sunday, July 28, 2024
Make a Habit Tracker in Excel + FREE File
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
Wednesday, July 24, 2024
Tuesday, July 23, 2024
Sunday, July 21, 2024
Make a Dynamic Profit & Loss Dashboard with Pivot Tables
Friday, July 19, 2024
掌握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
Subscribe to:
Posts (Atom)