Techy Stuff
16.2K views | +0 today

# Techy Stuff

Interesting tech links for the Geeks and wannabees
Curated by Patty Ball
 Scooped by Patty Ball

## How to Count Cells with COUNTA

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.
No comment yet.
 Scooped by Patty Ball

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

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 ...
No comment yet.
 Scooped by Patty Ball

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

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...
No comment yet.
 Scooped by Patty Ball

## Excel Functions | exceljet

No comment yet.
 Scooped by Patty Ball

## Nesting IF Worksheet Functions (Microsoft Excel)

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.
No comment yet.
 Scooped by Patty Ball

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

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
No comment yet.
 Scooped by Patty Ball

## Comprehensive Guide to VLOOKUP & Other Lookup Formulas

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...
No comment yet.
 Scooped by Patty Ball

## Introduction to Excel SUMIFS Formula

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...
No comment yet.
 Scooped by Patty Ball

## SUMIFS Function

Excel's SUMIFS function adds the cells in one row or column specified by multiple criteria
No comment yet.
 Scooped by Patty Ball

No comment yet.