Bite-Size Excel Tutorial Series target anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
-
Consolidate Multiple Sheets -Excel In A Capsule (Episode 1)
-
Hide and Protect Formulas - Excel In A Capsule (Episode 2)
-
Copy Visible Cells Only - Excel In A Capsule (Episode 3)
-
Create Data Entry Form - Excel In A Capsule (Episode Four)
-
No More Merge & Center - Excel in a Capsule (Episode Five)
-
Functions Fail ? Not Anymore- Excel In A Capsule (Episode 6)
-
Awesome Bullets on the Fly - Excel In A Capsule (Episode 7)
-
Banded Rows or Columns Conditional Format- Excel In A Capsule (Episode 8)
-
Invert A list Horizontally and Vertical Using Function- Excel In A Capsule (Episode 9)
-
Dependent Validation…No Drop Lists - Excel In A Capsule (Episode 10)
-
Merge A Table To Itself In Power Query… Excel In A Capsule (Episode 11)
-
Lightning Fast Horizontal Line…Word In Capsule (Episode 12)
-
Translation Function… Excel In A Capsule (Episode 13)
-
STOP Overwriting Your Drop Lists … Excel In A Capsule (Episode 14)
-
Create A Signature...Reuse It with A Click - Word In a Capsule (Episode 15)
-
Picture Inside Text… Impress Your Clients PowerPoint In A Capsule Episode 16
-
Rename Sheets On The Fly With A Drop List- Just Amazing!! Excel In A Capsule (Episode 17)
-
Smart Data Cleansing... Functions Or Power Query Excel In a Capsule (Episode 18)
-
Sorry ...It is Case Sensitive - Custom Data Validation In Excel
-
Randomizing Items in Excel Drop Lists With Every Selection
-
The New STOCKHISTORY Function...Just Released