엑샐

페이지 정보

profile_image
작성자케이 조회 53회 작성일 2021-10-16 22:38:33 댓글 0

본문

50 Ultimate Excel Tips and Tricks for 2020

The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You'll find solutions to the most common challenges you face in Excel.

Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533

Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down List 8:05
11. FILTER() 9:15
12. Remove Duplicates 10:43
13. Difference Between Lists 11:31
14. Flash Fill 12:15
15. AutoFill 13:06
16. Data Types 13:53
17. Transpose 15:11
18. Freeze Panes 15:37
19. Text to Columns 16:27
20. Recommended Pivot table 17:25
21. Slicers 18:04
22. Conditional Formatting 19:01
23. IF() 20:29
24. 3D References 21:12
25. Forecast Sheet 22:45
26. SUMIFS() 24:00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Filled Maps 26:26
30. PMT() 27:13
31. Show Formulas 28:20
32. Advanced Select 29:10
33. Named Range Shortcut 29:56
34. Hide Cells 30:47
35. COUNTBLANK() 31:30
36. Natural Language Query 31:59
37. Goal Seek 33:08
38. Insert Screenshot 34:30
39. Power Pivot 35:14
40. 3D Maps 36:16
41. ISBLANK() 39:08
42. Analysis ToolPak 39:45
43. CONVERT() 40:48
44. Get Data from Web 41:24
45. People Graph 42:59
46. SORT() 44:18
47. Status Bar Info 45:36
48. Insert Multiple Rows 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50

#seletraining #excel #tipsandtricks
Lisa S. : Permit me to say I find your voice calm, soothing, and informative without the least bit of arrogance detected. Maybe it is because I am 59 years of age and familiar with the degree of professionalism displayed from all of my years of employment back home in NYC, but I must commend you not for these useful tips alone but the manner in which they are presented, clear, precise and encompassed by a voice that makes the lessons easy to comprehend and far less intimidating than other turorials. Thank you...
Karol Moździerz : Superb presentation, great to see many of things improved in the latest versions. Much tedious VBA work can be now done directly in the cells. Thanks for the tutorial!
Mohammad Anis Khushal : This is so helpful! I learned so much from it! Thanks Sele Training! I also enjoyed the 30 Outlook Tips & Tricks! I'm recommending these videos to colleagues!
John Conlin : Thanks for all the help, this will help me GREATLY when I go to engineering college!
Mayank Yadav : You have taught me a lot in excel. Your teaching makes excel more fun, logical & interesting. Thanks

Excel VBA Beginner Tutorial

Excel VBA Beginner Tutorial

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

Join our online community! - https://www.offsitebylearnit.com

Excercise Files: https://bit.ly/3kVR38Y

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection \u0026 Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08

#ExcelVBA
Learnit Training : The link to the exercise files is in the video description
Ian R : Is it just me or is the audio really pleasant to the ears?
Andrew Lim : If only all my ex-teachers have such beautiful voices ...
lesnyk255 : I taught myself some VBA by back-engineering macros I'd recorded, but there's SOOO much more to it that I've never understood. I'm 25 minutes into this and I've already learned several tricks that will make life easier! Taking a break now, but I will be back for more. This is a godsend.
Sridhar Sockalingam : This course was the best among several I tried out recently. It assumes that you do not know anything or very little about Macros and VBA and walks you thru them step by step. Absolutely great teaching method. Very well paced and with clear explanations and examples. The downloadable files make it so easy to practice as well. Thank you for the excellent course!!

10 Excel Things You Should NEVER Do and What to do Instead

10 things you should never do in Excel. Download the Excel file here: https://www.myonlinetraininghub.com/10-common-excel-mistakes-to-avoid

0:00 Introduction
0:12 Merge \u0026 Center Cells
1:49 Non-tabular Data
3:21 Dates Formatted as Text
4:26 External Links
5:40 Formatting Ranges
7:07 Formatting to Encode Data
8:10 Formatting Colours
8:33 Cells Containing Multiple Records
9:13 Cells Omitted from SUM Formulas
10:34 Old .xls File Types

Links to solutions:

- Fix non-tabular data with Power Query: https://www.myonlinetraininghub.com/power-query-unpivot-scenarios

- Fix dates formatted as text: https://www.myonlinetraininghub.com/fixing-excel-dates-formatted-text

- Use Power Query to get data instead of External Links: https://www.youtube.com/watch?v=L4BuUzccLpo

- OFFSET function for dynamic SUM ranges: https://www.myonlinetraininghub.com/excel-offset-function-explained

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
Heri Hardiana : Been years working with excel, but just found out "center across selection". Thank you
Jatin Maharaj : Centre across selection???? I've been Excelling in the stone-age! Plus the other tips and tricks are super-helpful! Thanks Mynda!
Ron Spi : This is one of those videos that remind me an Advanced Admin Class in Excell. I remember when I was stunned to find advanced features in one of the complex commands and asked: "Is this a new feature?". The instructor replied, "since 1997". Excel is such a huge boatload of functions and possibilities, it can be overwhelming and many don't use more than 1% of the functions anyhow. As a developer, it is always refreshing to see more and more usages for those features and functions. Thank you for the video. Loved it!
Dayve Ferrick : This video was worth it as soon as I saw Center Across Selection. :)
Ernesto Chavez : There is something, always something, that those ex-"Excel experts" can learn. I learn and enjoy. Thank you, Mynda.

... 

#엑샐

댓글목록

등록된 댓글이 없습니다.

전체 5,504건 209 페이지
게시물 검색
Copyright © www.igarrett.co.kr. All rights reserved.  Contact : help@oxmail.xyz