Data corner: Microsoft Excel and Powerpoint (transitions, pivot tables, VBA, 3D models, conditional formatting)

 

Skill #1: 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

Resources: 

  1. Making Slide Transitions (Text and Video)
  2. Applying Slide Transitions (Video, ~5 minutes)
  3. Using and Applying Transitions (Step-by-Step)

If you want a way more in-depth look into what you can do:

Skill #2: 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. 

Resources: 

  1. What is a Pivot Table (Beginner’s Guide)
  2. Create a Pivot Table to Analyze Data
  3. Step-by-Step of How to Create and Use Pivot Tables
  4. A General Google Page with Loads of Videos on Pivot Tables

If you want a way more in-depth look into what you can do:

Skill #3: VBA (Visual Basic for Applications) 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. 

Resources: 

  1. What is VBA (Beginner’s understanding)
  2. VBA Tutorial for Beginners (Video, ~8 minutes)
  3. General Google Page with Load of Videos on VBA Tutorials 
  4. How to Use VBA 

If you want a way more in-depth look into what you can do:

 

Skill #4: 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. 

Resources:

  1. How to Insert a 3D Model in PowerPoint
  2. 3D Style for Advertising 

If you want a way more in-depth look into what you can do:

Skill #5:  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. 

Resources:

  1. Highlighting Patterns and Trends with Conditional Formatting
  2. Using Conditional Formatting in Excel (Video, ~7 minutes)
  3. Step-by-Step (with Visuals) on How to Use Conditional Formatting

If you want a way more in-depth look into what you can do:

Comments

You must login to post a comment. Need a ViaNolaVie account? Click here to signup.
4/21/25
03:50

Para mí, apostar es como el ají chileno: ¡cuanto más picante, mejor! Hace tiempo dejé de tomarme las apuestas a la ligera, ahora lo hago con análisis, emoción y estrategia. Y fue justo en ese camino donde encontré un verdadero aliado: apuestas en Melbet Chile.

La plataforma es súper intuitiva, todo en español, retiros rápidos, atención al cliente que responde al tiro, y unas cuotas que realmente pican (en el buen sentido). Suelo apostar en fútbol y tenis, y con cada jugada siento que mejoro, afino mis predicciones y, lo mejor de todo, ¡gano!

Melbet en Chile no es solo una casa de apuestas, es una experiencia. Adrenalina, pasión y ese saborcito a victoria que solo el buen ají sabe dar. Así vivo yo mis días de partido: con el auténtico sabor del ají apostador chileno.

Lisa Williams