Knowledge about formulas?

Resolved · Low Priority · Version Standard

Mon 17 Mar 2008, 17:00 Delegate Anne said...

Anne has attended:
Excel Intermediate course
Excel Advanced course

Knowledge about formulas?

Suggestions on how to develop knowledge on formulas

Tue 18 Mar 2008, 10:25 Trainer Pete said...

RE: knowledge about formulas?

Hi Anne, Thank you for the post, welcome to the forum, in answer to your question, this is a bit of a biggie... without knowing a great deal about your background it is difficult to point you in the right direction, lets just say that Excel has sufficient to keep a mathematican happy for many years. The way that I learnt about the different formulas was to use the fx button on the Formula bar and went through the formulas that are explained there. I hope that helps. best regards Pete.

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Knowledge about formulas?

Knowledge about formulas?

RE: knowledge about formulas?

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010