Co-Created Resource Database: Microsoft Excel and Powerpoint

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:

• https://edu.gcfglobal.org/en/powerpoint/applying-transitions/1/
• https://www.youtube.com/watch?v=Ey1atEavZ-M

• https://www.customguide.com/powerpoint/powerpoint-transitions

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

• https://support.microsoft.com/en-au/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576#:~:text=Insert%20a%20PivotTable,to%20be%20created%20for%20you.
• https://www.excel-easy.com/data-analysis/pivot-tables.html
• https://www.polymersearch.com/blog/pivot-tables
• https://www.google.com/search?sca_esv=589059757&rlz=1C5CHFA_enDK1075DK1075&sxsrf=AM9HkKnf4JqFjpLEecAUg4RU-KKDErVaNQ:1702035165603&q=how+to+add+pivot+tables+in+excel&tbm=vid&source=lnms&sa=X&sqi=2&ved=2ahUKEwjcksOL3_-CAxVTFRAIHVnmA5YQ0pQJegQICRAB&biw=1183&bih=1011&dpr=1.33#upstate=iv&v=cid:f7c53d5d,vid:Usd FoTA 68,st:0

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

• https://www.investopedia.com/terms/v/visual-basic-for-applications-vba.asp#:~:text=Visual%20Basic%20for%20 Applications%20 is,forms%2C%20graphs%2C%20and%20reports.
• https://www.youtube.com/watch?v=CMlKBwKcFJc

• https://www.google.com/search?sca_esv=589070032&rlz=1C5CHFA_enDK1075DK1075&tbm=vid&sxsrf=AM9HkKmYCURQOMLtXttlkMoF_JXDYHzcIw:1702035566602&q=what+is+visual+basics+for+applications+on+excel&sa=X&ved=2ahUKEwjxj97K4P-CAxXwIxAIHebRBFMQ8ccDegQIEBAH&biw=1183&bih=1011&dpr=1.33#upstate=iv&v=cid:27ec39b8,vid:C14ra4poSCc,st:0
• https://www.guru99.com/creating-your-first-visual-basic-for-applications-vba-in-excel.html

Link to learn more:

https://www.google.com/search?sca_esv=589070032&rlz=1C5CHFA_enDK1075DK1075&sxsrf=AM9HkKnjnre9ybyUkwcVXLe-obTVV3bhSQ:1702035764170&q=advanced+vba+course&tbm=vid&source=lnms&sa=X&ved=2ahUKEwi54vio4f-CAxW0W_EDHc8jD6UQ0pQJegQIDhAB&biw=1183&bih=1011&dpr=1.33#upstate=iv&v=cid:6264f8f9,vid:MeKL_n6SiYY,st:0

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

• https://slidemodel.com/how-to-insert-3d-model-in-powerpoint/
• https://www.google.com/search?q=3d+models+in+powerpoint&rlz=1C5CHFA_enDK1075DK1075&oq=3d+models+in+powerpoint&gs_lcrp=EgZjaHJvbWUyCQgAEEUYORiABDIICAEQABgWGB4yCAgCEAAYFhgeMggIAxAAGBYYHjIICAQQABgWGB4yCAgFEAAYFhgeMggIBhAAGBYYHjIICAcQABgWGB4yCAgIEAAYFhgeMggICRAAGBYYHtIBCDMxMzBqMGo5qAIAsAIA&sourceid=chrome&ie=UTF-8#fpstate=ive&vld=cid:87bd3bcd,vid:xhH9cToZGBk,st:0
• https://slidesgo.com/slidesgo-school/powerpoint-tutorials/how-to-insert-a-3d-model-in-powerpoint

Link to learn more:

https://www.google.com/search?q=how+to+create+4d+simulation+in+powerpoint&rlz=1C5CHFA_enDK1075DK1075&oq=how+to+create+4d+simulation+in+powerpoint&gs_lcrp=EgZjaHJvbWUyCQgAEEUYORigAdIBCDk2MDFqMGo5qAIAsAIA&sourceid=chrome&ie=UTF-8#upstate=iv&v=cid:77492924,vid:2-9g6fVL7uQ,st:0

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

• https://support.microsoft.com/en-au/office/highlight-patterns-and-trends-with-conditional-formatting-eea152f5-2a7d-4c1a-a2da-c5f893adb621#:~:text=Conditional%20 formatting%20makes%20it%20 easy,which%20me%20a%20 certain%20 condition
• https://www.youtube.com/watch?v=Jp29JYGq5Hw&t=1s
• https://www.excel-easy.com/data-analysis/conditional-formatting.html

Link to learn more:

https://www.google.com/search?q=complex+and+advanced+conditional+formatting+in+excel&source=lmns&tbm=vid&bih=1011&biw=1183&rlz=1C5CHFA_enDK1075DK1075&hl=en&sa=X&ved=2ahUKEwiyutXO5P-CAxVmFhAIHev1B2UQ0pQJKAF6BAgBEAQ#upstate=iv&v=cid:da902f8c,vid:LOefziJDE,st:0

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.