Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

Excel 2007 Basic 3
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

This is the third beginner class for the Microsoft Excel novice. You will learn: What are Functions, How to Use Functions, Sum, Average, Count, Max, Min, Styles & Themes, Page Layout, Insert Illustrations

Permanent Link
Course Link: Excel 2007 Basic 3
Keywords: excel 2007 basic 3
Post Reply

Re Suzanne Reichenberg Autofill Comment from Alex Hedley @ 11/17/2010
I think this might have something to do with the calculations.

If you press F9 it will re-calculate for you or you can change this in options,
Older versions of Excel:-
Tools | Options | (Can't remember which tab)
File | Options | Formulas

Clicking out of the cell and clicking back into will re-calculate this is why you see it change.
Show Just This Thread        Post Reply
Comment from Suzanne Reichenberg @ 11/17/2010
I have a question re: auto fill with function formulas.  Sometimes, when I've added a column and inserted a formula, when I try to use the auto fill, the answer I receive is the same as the original cell for all other cells.  I check the formula and it changed to pick up the new range of cells but it gives me a wrong answer.  If I click on the cell look at the formula and click again it will then show me the correct answer.  Can you tell me why this happens and how do I correct my problem?  It is very time consuming and makes me question the accuracy of the function/formulas.  Thank you

Reply from Richard Rost:

I'm not sure WHY this is happening. Do you have the latest service pack installed for Office? I'd have to see your spreadsheet to tell you exactly what's going on. This is one of the most compelling reasons to use TABLES in Excel though. If all of your data and formulas are uniform, a table will force the formulas in every column to be exactly the same for every row. I cover them in Excel Basic 4, lesson 6 (next class, which I see you've already ordered.)
Show Just This Thread        Post Reply
Comment from Tommie Burns @ 7/29/2010
it seems to me that there should be a pause button on the lessons so we could then go to Excel on the computer and do the lesson real time.

Reply from Richard Rost:

There is a pause button, both in the Theater and my Video Player software.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 2+7:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

5/4/2014Microsoft Access Expert 20
3/5/2013Excel Tip: Price Markups
2/3/2013Signed Copies of my Excel Book
9/27/2012Excel Expert 10 Handbook Ready
9/18/2012Two New Excel Tips: Date/Time Differences
6/20/2012Excel Tip: Sum Cells Between Two Values
6/16/2012New Excel Tip: Paste Link
3/26/2012Excel Tip: 2D Matrix Lookups
11/18/2011Dashboards in Excel
10/6/2011Excel Expert 11 On Hold

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP