Techy Stuff
Follow
Find tag "excel"
13.6K 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!

Analyze your data instantly - Excel

Analyze your data instantly - Excel | Techy Stuff | Scoop.it
Learn about data analysis at your fingertips. Quickly create a chart to visualize your data, add sparklines to show data trends, create a PivotTable for in-depth data analysis, apply conditional forma...
more...
No comment yet.
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, 12:26 PM

nuevas

Scooped by Patty Ball
Scoop.it!

Getting to Know the Parts of an Excel 2007 Chart - For Dummies

Getting to Know the Parts of an Excel 2007 Chart - For Dummies | Techy Stuff | Scoop.it
The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and
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!

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.

To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resource...
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!

Learn Excel IF Formula - 5 Tricks you Didnt know

Learn Excel IF Formula - 5 Tricks you Didnt know | Techy Stuff | Scoop.it
Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just me then..)...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Excel 2010 Duplicate & Unique Values

Excel 2010 Duplicate & Unique Values | Techy Stuff | Scoop.it
Want to find duplicate or unique entries in Excel 2010? The option is there but the location has been changed. Please note that this post is not about remo
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Remove duplicates - A free online tool for removing duplicates from spreadsheets

A free online tool for removing duplicates from spreadsheets
Patty Ball's insight:

cool tool

more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

6 Entertaining Games Made Entirely in Microsoft Excel

6 Entertaining Games Made Entirely in Microsoft Excel | Techy Stuff | Scoop.it
Want to kill time at work? Look no further than your friendly office tool, Excel. Here are six unbelievably cool games made entirely in Microsoft Excel.
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

MVP #34: Pie Charts and Column Charts in Excel |Productivity Tips, MS Excel and Inspiration

MVP #34: Pie Charts and Column Charts in Excel |Productivity Tips, MS Excel and Inspiration | Techy Stuff | Scoop.it
more...
No comment yet.
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!

Microsoft Excel: Splitting One Cell Row into Multiple Rows

Microsoft Excel: Splitting One Cell Row into Multiple Rows | Techy Stuff | Scoop.it
With Excel, you can split one cell into multiple rows or a comma delimited cell into multiple rows. This tutorial explains how. If your job requires you to manipulate or organize large amounts of d...
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!

10 Commandments for Excel Charts (Microsoft Excel)

10 Commandments for Excel Charts (Microsoft Excel) | Techy Stuff | Scoop.it
Excel makes creating charts easy. Even though it is easy, you still need to exercise prudence in making sure that your chart conveys information the best it possibly can. (Tips.Net)
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!

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!

How to Lookup Values to Left?

How to Lookup Values to Left? | Techy Stuff | Scoop.it
SituationThere is no argument that VLOOKUP is a beautiful & useful formula. But it suffers from one nagging limitation. It cannot go left.Let me explain, Imagine you have data like below. Now, ...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

September Office tip mailbag: A little magic - TechRepublic

September Office tip mailbag: A little magic - TechRepublic | Techy Stuff | Scoop.it
Susan Sales Harkins answers Microsoft Office questions received from readers. This month the topics involve Excel and Word.
Patty Ball's insight:

Excel fill handle magic

more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

How to Find Duplicates in Excel

How to Find Duplicates in Excel | Techy Stuff | Scoop.it
When you make a composite spreadsheet from several other spreadsheets, you may find some duplicate values in it. Microsoft Excel offers several ways to find duplicate entries and remove them from your spreadsheet, if you wish.
Patty Ball's insight:

4 ways to remove duplicate entries in Excel

more...
No comment yet.