Impress Your Audience... Excel Scenario Manager As NEVER Before
5.7 هزار بار بازدید -
4 سال پیش
-
A Scenario is a set
A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results.
In this tutorial we combine the functionality of the Scenario Manager with other tools in Excel to increase it's usefulness exponentially. watch it and share your thoughts in a comment.
one of my YouTube friends shared a Macro to automate switching scenarios in a different way than mine, Thank you Wayne Edmondson:
Sub Original()
ActiveSheet.Scenarios("Original").Show
End Sub
You can download the exercise file and follow along by clicking on the link:
https://officeinstructor.com/public/
These video tutorials are created for YOU. Please support my channel by liking, commenting, Sharing and above all Subscribe and ring the bell.
In this tutorial we combine the functionality of the Scenario Manager with other tools in Excel to increase it's usefulness exponentially. watch it and share your thoughts in a comment.
one of my YouTube friends shared a Macro to automate switching scenarios in a different way than mine, Thank you Wayne Edmondson:
Sub Original()
ActiveSheet.Scenarios("Original").Show
End Sub
You can download the exercise file and follow along by clicking on the link:
https://officeinstructor.com/public/
These video tutorials are created for YOU. Please support my channel by liking, commenting, Sharing and above all Subscribe and ring the bell.
4 سال پیش
در تاریخ 1399/12/03 منتشر شده
است.
5,714
بـار بازدید شده