Skill: How to apply transitions in Powerpoint
Quick Written Explanation: Transitions are necessary to create a more interactive powerpoint. It will allow for only some words on a slide at one point in time, and then more being added later on. This is also effective in adding graphics to a slide. This feature also deals with the switching of one slide to another
Resource List:
Link to Learn more:
https://www.youtube.com/watch?v=RJDpRUKwaNo
This link teaches the best morph transitions in powerpoint. These include the zoom effect, scaling, and revealing. Each of these are more intricate than the generic ones I covered.
Skill: Pivot Tables in Microsoft Excel
Quick Written Explanation: A pivot tool is an extensive tool used to analyze data in Excel. It allows you to calculate numerical ideas, summarize, compare and notice patterns. Pivot tables are far easier than manually typing in statistics such as averages, as they derive the data for you, making it much more efficient and easy.
Resource list of resources / videos
Link to learn more:
https://www.youtube.com/watch?v=-CyKEJXrYTI
This is a video on advanced pivot tables from youtube. It is a two hour and forty minute video that includes a recap on the basics as well as more complex ideas. It is an advanced course that covers importing data from text files, Access, cleaning and tabular data, grouping and ungrouping, errors, and analyzing different formats and styles of Pivot Tables.
Skill: Visual Basic for Applications (VBA) on Excel
Quick Written Explanation: VBA is a language that is owned by microsoft. It allows you to create macros which automate repetitive words and data processing functions. This makes it easier to get data statistics, generate data summaries, and create graphs.
Resource list of resources / videos
Link to learn more:
This is a link to an advanced VBA youtube Course. It covers the basics and then gets into much more advanced elements of the language. The video is two hours long with tutorials and examples. An individual looking to learn more about the language should watch this advanced video.
Skill: 3D Models in Powerpoint
Quick Written Explanation: Adding 3D models in Powerpoints can make a presentation more visually and aesthetically pleasing. This will allow receivers to pay more attention and remember your presentation. Although very simple, many people do not know how to do this, so they will be intrigued upon seeing it as they are being presented to.
Resource list of resources / videos
Link to learn more:
This link not only talks about 3D models but animations. It teaches you how to get videos and video graphics in powerpoint. Although the next step would be 4D simulation models, that is still in the works and not yet available on Powerpoint.
Skill: Conditional Formatting with Excel
Quick Written Explanation: Conditional formatting is used to stratify data. It highlights specific factors or conditions of data to derive similarities and comparisons. Conditional formatting allows for the derivation of statistics and important values such as unskewed averages, outliers, and finding trends.
Resource list of resources / videos
Link to learn more:
This link is to an advanced Conditional Formatting video. It first covers the basics and then gets into much more advanced ideas. The video includes 30 examples to teach this trick. It is over an hour long and goes in depth on everyone an individual needs to know on Conditional Formatting.
Empowering the next generation of artists: the Impact of YAYA Arts Center
In this article, Claire McKee, Izzy Von Simson, Gavin Galusha, and Seth Gelwarg explore the non-profit Young Aspirations Young Artists (YAYA) and the organization's impactful role in the New Orleans youth community. The authors interviewed Averi Matthews, an art enthusiast, YAYA alum, and current YAYA program manager, to gain a multifaceted perspective on the organization and its offerings.
Environmental initiatives in NOLA: Composting — The key to maximizing New Orleans’s rich cuisine
This article explores the mission and impact of Schmelly's Dirt Farm, an organics recycling company focused on transforming commercial food waste into compost and soil products. Author Miles Brooke shares the expertise and work of Schmelly's founder and owner, Nico Krebill, as well as the dirty details about composting!
