#Expert #Tutorials #Tips
Learn many of the Beginner/ intermediate / Advance Excel skills, tips, and tricks that you’ll need in order to be able to use Excel effectively. In this video you’ll learn Excel Tips & Tricks that will make you more productive Here is playlist of Excel
Learning Videos: https://www.youtube.com/playlist?list=PLgtUIQF5JvK9oVZNZ65X7QItUgZYo9go_
List of Tutorial/Tips in Video
1 Set Date Default Format
2 Center Heading Without Merge
3 Create Auto Update Table
4 Add Formula Automatically After Table
5 Flash Fill
6 AutoSum (Alt =)
7 IF Function
8 AND, OR Functions
9 Nested IF Function
10 Errors Handling
11 Copy Text/Formula On Clipboard For Later Use
12 Convert All The Formulas Into Values
13 Select And Delete All Formatting At Once
14 Use Control + Enter To Fill An Entire Range
15 Protect The Sheet But Only Allow Entry In Limited Cells
16 Toggle Between Open Excel Books
17 Enable Data Entry Only When The Previous Cell Is Filled
18 Create Your Own Error Messages In Data Validation
19 Display A Message When A Cell Is Selected
20 Only Date Or Number Allows In The Cell
21 Select Cell Value Only From List
22 Move Rows And Columns Without Cut Paste
23 Multiply/Divide With A Number Using Paste Special
24 Select Visible Cells Only
25 Make A Copy Of A Worksheet
26 Angle Cell Text To Take Columns’s Width Narrow
27 Join Contents In Two Or More Cells – Concatenate
28 Convert Date To Quarter
29 Right Click Menu
30 Format Painter
31 Formula Should Not Change While Adding Rows
32 Insert Current Date/Time In Cell
33 Remove Gridlines Or Change Grid Lines Color From A Sheet
34 Change Sheet Name And Color
35 Hide And Show Sheets
36 Quick Analysis
37 Split Single Excel File In Multiple Windows
38 Freeze Panes To Always Display Headers Or Columns
39 Split Worksheet Into Windows
40 How To Repeat The Top Row In Print
41 Sorting Days, Months
42 Create Custom Sorting Criteria
43 Perform Multi-Level Sorting
44 Filter Top 10 Records
45 Create Summary With Pivot Table
46 Create Unique / Distinct Count In Pivot Tables
47 Filter, View & Ranking In Pivot Table
48 Create Your Own Calculated Field In Pivot Tables
49 Ageing Or Range Analysis
50 Insert Chart For Table
51 Chart Formatting
52 3D Charts
53 Fix Chart Size And Position
54 Go To The Last Cell
55 Adjust Column Width , Row Height
56 Highlight Row / Column Very Quickly
57 Delete Row / Column Very Quickly
58 Adjust Page For Printing – Page Break
59 Remove Blank Cells From A List
60 Groups And Subtotals
61 Highlight Duplicate Values In Rows
62 Highlight Every Row/Column Based On Logic/Condition
63 Get A Unique List – Remove Duplicate
64 Split A Cell By A Diagonal Line To Get 2 Headers
65 Create Named Ranges From Data
66 Fix the Reference With Dollar($) Sign – Absolute References
67 Snap Objects/Pictures To Cell Borders
68 Create A Simple Gantt Chart Using Conditional Formatting
69 Evaluate A Formula Step By Step
70 Find And Replace Partial Matches
71 Put A Comment In An Excel Formula
72 Display Negatives Values In Red Using Number Formatting
73 Insert Picture Into A Comment Box
74 Display Number As Text Using Custom Number Formatting
75 Format Large Numbers In Millions, Billions
76 Intersect Operator
77 Convert Column Format Type From Number To String
78 Work With Imported Data
79 How To Use VLook-Up Function
80 How To Use VLook Formula For Multiple Columns
81 Create Simple Query
82 3D Sum
83 SUMIF Function
84 COUNT, COUNTA, COUNTIF & COUNTIFS
85 Enter Bullets
86 Text Manipulation Functions
87 Import Data From Web
88 Reduce The File Size
89 Reference To An Area In A Worksheet
90 Display Columns Headers As Numbers (Instead Of Alphabets)
91 Get Camera Tool – Screen Clipping
92 Grouping And Ungrouping Sheets
93 Locate A Keyboard Shortcut
94 Save AutoRecover Information Every X Minutes
95 Hide Ribbon
96 Customising The Ribbon
97 Open Excel Templates
98 Get The Developer Tab Displayed Ribbon
99 Write A Small Macro
100 Enable Macros
