Tutor profile: Ben L.
Subject: The Adobe Suite
In Premiere Pro, what is the best way to organize numerous clips in my timeline?
Premiere Pro is far more customizable that it may initially seem. One example of this is in how quickly you can organize your clips into categories by assigning color, and then make that process even easier by assigning keyboard shortcuts to changing clip color. Assuming you've decided to use five different colors to categorize your clips, you can then open the keyboard shortcuts screen and assign shortcuts to those colors. At that point, it's a simple matter of selecting your clips and hitting your keyboard shortcut. Like the rest of the Adobe Creative Cloud apps, Premiere Pro has a wealth of customization options, including workspace layout, keyboard shortcut bindings, quick and simple device and hardware configuration, and so much more.
Subject: Microsoft Suite
What is the easiest way in Excel to sort and filter a large spreadsheet of unsorted information?
PivotTables provide a powerful tool for taking unsorted information and controlling it with specific sorting and filtering tools. The only real requirement for PivotTables to work is headers. As long as you have clear column or row headers in your source information, the PivotTable will search through those columns and rows to filter out information based on what it finds. For example, if you have a large spreadsheet that has automatically tracked answers from form submissions (through Microsoft Forms for example), the PivotTable can look through that information and, with a quick click from you, show each entry in which someone answered "yes" to a question. Or, count how much money a salesperson has made. And much more. Once you've added your PivotTable, you use the four sort and filter boxes (Filters, Columns, Rows, Values) to quickly tell Excel what information you want to see. For example, if you want to see how many Apple Watches have been sold in your store over the last week, you can add your Apple Watches column to the Column box, add your Date Sold column to the Filter box to filter the date to the last week, and then add your Quantity Sold per Day column to the Values box. This will give you exactly the information you're looking for.
Who is the most impactful character in fiction history? Provide your reasoning.
Jean Valjean is one of literature’s greatest heroes. A simple human being, much like you and me, thrust into impossible and oppressive circumstances, and still finding resolution through love, kindness, and the power of the human spirit. In all the great classics of human literature, rarely is a character so perfectly parallel to the everyman, so relatable and yet, such a titan among men. To me, Jean Valjean is the greatest example of individual power, offering the greatest example of our ability for good in the history of the written word. Victor Hugo, one of the greatest (if not the greatest) writer in history, penned the masterwork Les Misérables during nineteen years of exile imposed on him for his activism and outspoken progressive views. Many have speculated that the novel’s main character, Jean Valjean, is strongly analogous to the author himself. Just as Valjean served nineteen years of hard labor for the “crime” of taking a loaf of bread to feed his starving family, so too did Hugo serve nineteen years of exile for the “crime” of speaking for those from whom society had stripped a voice. Such a punishment is enough to shed any semblance of humanity from even the strongest person, and such was the case with Valjean. Desperate for food following his release from prison, and turned away from work again and again due to his status as a convict, Valjean steals precious silver plates and cutlery from a Bishop in a small town in Digne. When Valjean is caught and brought back to face his victim, the bishop flatly lies to the police, claiming that the silver was a gift. This great act of kindness softens a heart made stone by nineteen years of unjust punishment, and Valjean spends the rest of his life saving others, even while being constantly pursued by Inspector Javert, who would see Valjean back in prison. Even after years of this pursuit, when Valjean is given the chance to kill Javert, Valjean instead frankly forgives him for the years of misery, and lets him go. Again, a hard heart is softened by kindness, and Javert chooses to end his own life rather than risk further harm to Valjean, essentially giving is life for the man he had previously believed was worthy of nothing more than a life in prison. This extreme example is the result of but one act of kindness, but Valjean, not to mention Victor Hugo himself, were responsible for so many more. Even now, 175 years after the novel was published, new interpretations of the work continually remind us of the incredible power of kindness, and the ability inherent within each and every one of us, to rise above the greatest of challenges, and together, build a more perfect world.
needs and Ben will reply soon.