advanced excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel

Advanced Excel

resolvedResolved · Medium Priority · Version 2003

Advanced Excel

I didn`t really understand the utility of using scenario.
I also would like to know if with macro when I record the job, i actually refind it the next day on a new sheet

RE: Advanced Excel

Stefania - scenario is used to ask "what if" about the result of your data. As we practiced, we actually earned 20% last year, we would like to know what costs or income would need to change in order to increase our profit - we would use a scenario.


If you create a macro and store it in the workbook you are working in, it will only be available in that workbook. If you want Macros to be available in new and other workbooks, then when you create it you have the option to save it for all workbooks.

good luck

RE: Advanced Excel

I Julie,
Thanks a lot for your reply.
I will continue to practice in order to understand better what we did together at the training course.

Stefania


 

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips


Server loaded in 0.09 secs.