98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel
Advanced Excel
Resolved · Medium Priority · Version 2003
Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Changing Excel file and worksheet defaultsThe 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. |