Techy Stuff
Follow
Find tag "functions"
12.8K views | +7 today
Techy Stuff
Interesting tech links for the Geeks and wannabees
Curated by Patty Ball
Your new post is loading...
Your new post is loading...
Scooped by Patty Ball
Scoop.it!

How to Count Cells with COUNTA

How to Count Cells with COUNTA | Techy Stuff | Scoop.it
Excel's COUNTA function is a great way to count non-blank cells in your spreadsheets. We'll show you how to use this simple but useful function.
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK]

What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK] | Techy Stuff | Scoop.it
I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It ...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

vlookup(), match() and offset() - explained in plain english [spreadcheats]

vlookup(), match() and offset() - explained in plain english [spreadcheats] | Techy Stuff | Scoop.it
VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understandin...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Excel Functions | exceljet

Excel Functions | exceljet | Techy Stuff | Scoop.it
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Nesting IF Worksheet Functions (Microsoft Excel)

Nesting IF Worksheet Functions (Microsoft Excel) | Techy Stuff | Scoop.it
The IF worksheet function is very handy to make conditional evaluations. You are not limited to a single IF comparison, however. Excel allows you to easily nest IF statements within each other.
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Planning Your Day with Excel 2007's NOW, TIME, and TIMEVALUE Functions - For Dummies

Planning Your Day with Excel 2007's NOW, TIME, and TIMEVALUE Functions - For Dummies | Techy Stuff | Scoop.it
Excel 2007's time functions enable you to convert text entries representing times of day into time serial numbers so that you can use them in calculations. Some common
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Comprehensive Guide to VLOOKUP & Other Lookup Formulas

Comprehensive Guide to VLOOKUP & Other Lookup Formulas | Techy Stuff | Scoop.it
This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on ...,

What is VLOOKUP Formula...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Introduction to Excel SUMIFS Formula

Introduction to Excel SUMIFS Formula | Techy Stuff | Scoop.it
If SUMIF formula is like a regular knife that you can use to slice up your data and get what you want, then SUMIFS is like a Swiss army knife. What is SUMIF? We all know that SUMIF formula helps to...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

SUMIFS Function

SUMIFS Function | Techy Stuff | Scoop.it
Excel's SUMIFS function adds the cells in one row or column specified by multiple criteria
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Excel Text Functions - learn MS Excel 2010

Excel Text Functions - learn MS Excel 2010 | Techy Stuff | Scoop.it
more...
No comment yet.