excel training microsoft - excel advance

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Excel Advance

excel training microsoft - Excel Advance

resolvedResolved · Low Priority · Version Standard

Mariagiulia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel Advance

In the Naming range for ormulas, if you name the range and you want to change it after finished the formulas, how can you do it? E.G. I have named the range cell_00 and I wnat to call it Sales_00, how do I do? Thanks

RE: Excel Advance

Insert > Name > define.

It should automatically update your formulae once the cells have calculated. Alternatively, if you have calculation set to manual (you can check this by going tools > options... and selecting the 'calculation' tab) then press F9 and the formulae will update


 

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips


Server loaded in 0.08 secs.