Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training courses -

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - 1593

excel training courses - 1593

ResolvedVersion Standard

Vela has attended:
Excel Intermediate course
Excel Advanced course

1593

I am trying to create 3-D formulate to link work sheets.I am not getting the right answer.
(1) On total sales for 1999-200,on report sheet,on the first cell, I HAVE GOT $5372210.26 but
I don't follow the command-Select-math& Trig to complete the full work sheet.
Can you please explain step by step. Thanks

RE: 1593

Note when you link to workbooks outside of Excel this makes them Absolute that is with dollar symbols $$ which you do not want try removing the dollar symbols and this may work

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.