Excel Spreadsheet Discussion forum: Quick tips - Do you have any tips to share?

Views: 29, Replies: 8 » Jump to the end
Imageweeds
Jul 11, 2010 9:13 AM CST
FL. Panhandle
Not all those who wander are lost.
I would like to keep this thread for questions/answers and tips for our readers!
Let the fun begin. Oh, I started a PAGE to collect the quick tips, questions and answers for easy reference. Help me fill it up!
Connie
Talk with people around the world.
Visit Carpe diem and seize the day!
Also, Jigsaw Puzzles, Excel forum and tutorials.
Imagesmiley
Oct 25, 2011 5:04 PM CST
Name: Julie
Kenmore, NY
A super quick tip that I thought a lot of people knew, but am finding out otherwise:

if you are looking for a particular word or number, press the Ctrl + F buttons at the same time. It will open a "find" window. Type in what you're looking for and it will find it anywhere in the spreadsheet. Works in Word also.
ImageTwinLakesChef
May 12, 2013 7:10 AM CST
Name: Arlene Marshall
Twin Lakes, IA & Orange, CA
Zone 4B
Good Tip!
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"
Imagesmiley
May 16, 2013 10:16 AM CST
Name: Julie
Kenmore, NY
Boy, I learned a neat trick the other day. They guys at work asked me to fix a spreadsheet that they've been screwing up for almost 3 years (originator passed away). This spreadsheet is so large ~ it goes over to column FN and has 12 worksheets (one for each month).

They thought it would be hunky dory to keep a running total of how much they produced both during the month and the previous month, for a grand total. The total for the month was easy (autosum) but how to get the previous month total??

So easy!

Go to that cell (where you want the previous total) and enter the = sign.
Go to the worksheet where that particular cell is and click on it.
Then hit "enter".

VOILA!

Then I autosummed the 2 numbers to give them the grand total. I was able to do that throughout the year for them.

If they screw it up again.... well..... Grumbling
ImageTwinLakesChef
May 21, 2013 10:05 AM CST
Name: Arlene Marshall
Twin Lakes, IA & Orange, CA
Zone 4B
Julie,
I do that with a spread sheet I keep for payroll. There is a tab for each employee and a Totals tab.
I enter the employee information each payroll and it pulls the totals of all employees for that pay period.

It really helps me to double check myself when I do quarterlies. I sleep better at night knowing I have that spread sheet to cross check myself.

I have another, even bigger spread sheet for inventory (which my DH used to do by hand on those green ledger sheets). Our inventory is more accurate and it also costs out the product.

What did people use to do without Excel? I love it.
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"
Imagesmiley
May 21, 2013 3:31 PM CST
Name: Julie
Kenmore, NY
Oh, nice! We use a payroll service or I'd probably be dmailing you, LOL.

I love it too and would be lost at work without it.
ImageTwinLakesChef
May 22, 2013 6:16 AM CST
Name: Arlene Marshall
Twin Lakes, IA & Orange, CA
Zone 4B
If something were to happen to me, my DH would have to use a payroll service.
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"
Imagesmiley
May 22, 2013 3:18 PM CST
Name: Julie
Kenmore, NY
I certainly hope that doesn't happen. Smiling

ImageTwinLakesChef
May 24, 2013 2:31 AM CST
Name: Arlene Marshall
Twin Lakes, IA & Orange, CA
Zone 4B
Won't be my problem if it does. My daughter does know my payroll program so she would help.
Yum Yum Divas ~ ~ "Most recipes are not invention . . . but evolutions"

« Back to the top
« Cubits.org homepage
« Carpe diem cubit homepage
« Excel Spreadsheet Discussion forum

You must first create a username and login before you can reply to this thread.

Carpe diem

This is a meeting place for people all over the world to discuss and share information about all areas of this ever shrinking globe. NEW!! I have added a forum for discussions about using Excel and tutorials in the PAGES section.

» Home
» Forums
» Articles
» Pages
» Links

Cubit owner: weeds

Admin team:

» Contact the admins













Want to browse around and see what other Cubits are about? Try the Cubit Finder