Zillion Trainings

Data Types in Excel - People

TEXTBEFORE and TEXTAFTER function

Creating Easy Data Entry Forms

Excel Pivot Table Tips - Convert Pivot Table Blanks into ZERO

Number System - Convert Decimal numbers to Binary, Octal & Hexa-decimal

Difference between two lists using FILTER

Navigation Pane in Excel

GCD & LCM in Excel

Frequency Function in Excel

Replace Function in Excel

Text Concatenation

Data Types in Excel - People

Trunc Function in Excel

NumberText function

INT function in Excel

How to write a lookup formula for Case Sensitive texts

Extract Day, Month and Year from a Date using Date Functions

Automatic Borders

MS Word - Convert Number to Words

Index Match Match For beginners

Take Function

MS Word - Horizontal Rule

Dynamic Filter

Conditional Formatting in Chart

NEW FEATURE IN EXCEL : Leading Zeros

Multiplication Table

Basic Date functions in Excel

Hand made Chart

Waffle Chart in Excel

Separate Text And Numbers From Mixed Data using GoTo Special

Pivot Table - Percentage

Number System - Convert Binary numbers to Octal, Decimal & Hexa-decimal