Techy Stuff
16.3K views | +2 today
Follow
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!

For Seniors: How to Write Excel Formulas - For Dummies

For Seniors: How to Write Excel Formulas - For Dummies | Techy Stuff | Scoop.it
A formula is a math calculation, like 2 + 2 or 3(4 + 1). In Microsoft Excel, formulas are different from regular text in two ways: They begin with an equal sign, like
Patty Ball's insight:
By Faithe Wempen from Office 2010 For Seniors For Dummies
more...
Angel Brian Gutierrez Gardeazabal's curator insight, November 10, 2013 1:22 PM

Una herramienta que nos ayuda muchisimo con la gestion de inventarios

jesus pedro's curator insight, April 20, 2014 12:26 PM

nuevas

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!

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.
Rescooped by Patty Ball from FrankensTeam's Excel Collection
Scoop.it!

Excel CLEAN Formula

Excel CLEAN Formula | Techy Stuff | Scoop.it
Excel CLEAN Function will remove the non-printing characters typically brought in from other applications or web pages.

Via Kris
more...
Kris's curator insight, July 18, 2013 2:47 PM

CLEAN - to remember :-)