0 Comments
|
Be the first to comment
0 Comments
|
Member has blocked you from commenting
Confirm Block
Are you sure you want to block this member?
This member will not be able to send you messages, comment on your videos/profile or subscribe to your channel.
You can cancel blocking anytime from the member's page
1 Subscribers
- Recently Added
- Most Discussed
- Most Viewed
- Highest Rated
'countif' and 'sumif'...
Added Yesterday
Rated 2.29 | 22 Views | 0 Comments
'count' and 'sum' functions are widely
used but 'countif' and 'sumif' can solve
more problems in Excel, especially, when
you need to do criteria based...
Submitted by: takyar
01:22
How to Create Your First Macro...
Added 22-Nov-09
Rated 3.51 | 671 Views | 0 Comments
Macros are written in a programming
language called Visual Basic for
Applications (VBA) which resembles VB in
many ways. VBA has its own grammar or...
Submitted by: takyar
02:29
Import Text Files into...
Added 19-Nov-09
Rated 2.88 | 87 Views | 0 Comments
Text files can be imported into
Microsoft Excel for further analysis.
Submitted by: takyar
00:52
How to Create an Invoice in...
Added 16-Nov-09
Rated 3.71 | 138 Views | 0 Comments
Invoices form the heart of any business
- big or small. You can create amazing
invoices with automatic complicated
calculations.
Submitted by: takyar
02:51
Macro: A Command Button in MS...
Added 15-Nov-09
Rated 3.63 | 407 Views | 0 Comments
Click on the command Button to run the
macro in your Microsoft Excel document.
Submitted by: takyar
01:43
Protect Formulas and Cells in...
Added 13-Nov-09
Rated 3.66 | 246 Views | 0 Comments
Hiding the formulas from the users and
allowing only specific cells to be
edited in an Excel worksheet has many
advantages.
Submitted by: takyar
03:04
Macro in Microsoft Excel
Added 05-Nov-09
Rated 3.57 | 323 Views | 0 Comments
Automate your calculations in Excel
using Macros. You need to have a
knowledge of VBA (Visual Basic for
Applications). VBA for Excel is easy to
learn.
Submitted by: takyar
00:55
Dynamic Named Ranges in Excel
Added 03-Nov-09
Rated 1.20 | 4 Views | 0 Comments
Named ranges- both dynamic and static-
can help in accessing data in
interesting ways in Excel to perform
quick calculations.
Submitted by: takyar
04:02
Calendar in Excel
Added 01-Nov-09
Rated 3.13 | 128 Views | 0 Comments
Dates and time in any work are
important. Using a calendar can make
date entries easier and quicker. We
describe a simple method involving a
single...
Submitted by: takyar
05:15
Sensitivity Analysis Using...
Added 28-Oct-09
Rated 0.02 | 83 Views | 0 Comments
You can perform sensitivity analysis
using data tables or the scenario
manager in Solver. The main advantage of
using the scenario manager is that
you...
Submitted by: takyar
07:08
