Join Curt Frye for an in-depth discussion in this video Sorting and filtering Excel table values, part of Excel VBA: Process Modeling.
- [Voiceover] When you send your simulations output…to an Excel table,…you gain the ability to analyze your results…in many ways.…Two of the techniques that you can use…on your table data are sorting and filtering.…Sorting let's you change the order of your data…based on the values in one or more columns,…while filtering let's you concentrate on just…the results that matter to you.…In this movie, I will show you how to sort and filter…using an Excel table's filter errors.…My sample file is chapter 0605.…
That's an Excel workbook you can find in…chapter six folder of the exercise files collection.…Again, I want to work with my results data…and that is on the results worksheet.…So, I'll go ahead and click its sheet tab here.…And I see my Excel table,…which already has the Excel filter errors here displayed.…Now, let's say that I want to sort the values in the system…or in the table based on the time that…customers left the system.…
To do that, I would go to the left system column,…which is column C,…click the table header rows filter arrow for that column,…
Author
Released
3/2/2016- Creating a class module in VBA
- Defining class properties
- Creating collections
- Describing process flow and programming goals
- Creating loops
- Increasing capacity of a model
- Running simulations
- Analyzing simulation results
Skill Level Advanced
Duration
Views
Related Courses
-
Windows Server 2012 R2: Configuring Hyper-V
with Timothy Pintello2h 24m Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Defining Necessary VBA Constructs
-
Creating a class module3m 16s
-
Defining class properties5m 58s
-
Creating collections8m 33s
-
-
2. Developing Process Control Structures
-
Deleting unneeded objects2m 38s
-
Running the simulation2m 27s
-
3. Adding a Ticker to Track Time
-
Running the simulation2m 48s
-
4. Adding Customers During the Simulation
-
Running the simulation8m 11s
-
5. Recording Simulation State
-
Adding rework loops to stations11m 22s
-
6. Analyzing Simulation Results
-
Conclusion
-
Next steps1m 55s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Sorting and filtering Excel table values