Freezing Panes
Shubham Dhiman
06:29
0 Comments
If you have a large table of data in Excel , it can be useful to freeze rows or columns. This way you can keep rows or columns visible w...
Read More
Saturday, 19 March 2016
Conditional Formatting
Shubham Dhiman
06:23
0 Comments
Create conditional formulas to find data or apply formatting When Excel's built-in conditional formatting rules don’t meet your ne...
Read More
Basics
Shubham Dhiman
06:13
0 Comments
This section explains the basics of Excel . 1 Ribbon : Excel selects the ribbon's Home tab when you open it. Learn how to minimiz...
Read More
IFERROR Excel Formula
Shubham Dhiman
04:56
0 Comments
Introduced since Excel 2007, IFERROR() formula checks a formula (or expression) and returns the value of formula if there is no error, oth...
Read More
Shubham Dhiman
04:47
0 Comments
Logical Functions Learn how to use Excel's logical functions such as the IF, AND and OR function. Functions ...
Read More
Format Painter : Time Saving Trick
Shubham Dhiman
03:42
0 Comments
Format Painter You can use the Format Painter to quickly apply formatting from text, shapes, and pictures to another text selection, ...
Read More
Excel 2007 Quick Access Toolbar
Shubham Dhiman
03:26
0 Comments
The Microsoft Quick Access Toolbar (QAT) is a toolbar menu that appears in Microsoft Excel, Microsoft Word, and other Office 2007 and ab...
Read More
Shortcut Key Tips
Shubham Dhiman
01:31
0 Comments
Why Learn Excel 2007 Keyboard Shortcuts? There are people who believe that Microsoft Office Excel is just for balancing your personal bu...
Read More
