Showing posts with label illustration. Show all posts
Showing posts with label illustration. Show all posts

Tuesday, August 26, 2025

Filter Data Based on Active Cell Value - An illustration

Filter Data Based on Active Cell Value Press Shift + F10 → E → V. Press Shift + F10 → E → V. Press Shift + F10 → E → V. Filter Data Based on Active Cell Value Filter Data Based on Active Cell Value Filter Data Based on Active Cell Value Supposed data Supposed data Supposed data You can instantly filter your data based on the value of the cell you have selected—no need to set up a separate filter first You can instantly filter your data based on the value of the ... You can instantly filter your data based on the value of the cell you have selected—no need to set up a separate filter first illustration Patreon and LinkedIn links LinkedIn Profile /usmanzafarparacha /usmanzafarparacha /usmanzafarparacha LinkedIn Patreon profile /uzparacha /uzparacha /uzparacha Patreon Usman Zafar Paracha 1 Usman Zafar Paracha Usman Zafar Paracha It gives It gives It gives Usman Zafar Paracha 2 Usman Zafar Paracha Usman Zafar Paracha Usman Zafar Paracha 3 Usman Zafar Paracha Usman Zafar Paracha Click the cell containing the value you want to filter by (the active cell), e.g., IT Click the cell containing the value you want to filter by (th... Click the cell containing the value you want to filter by (the active cell), e.g., IT Excel will filter the table to show only the rows where Department = IT Excel will filter the table to show only the rows where Depar... Excel will filter the table to show only the rows where Department = IT This is an easy way to filter data without manually setting filter dropdowns! This is an easy way to filter data without manually setting f... This is an easy way to filter data without manually setting filter dropdowns! Excel example data Excel example data IT Selecting the active cell Selecting the active cell Selecting the active cell Excel example data filtered

Wednesday, October 23, 2024

Day 29: Blender tutorial for making illustrations – Preparing a YouTube-Ready Video

 


Step 1: Review the Final Video

Before diving into YouTube optimizations, you’ll need to ensure that your video is polished and fully edited. Recheck:

  • Voice Syncing: Ensure that your voiceover aligns with the visuals.
  • Subtitles & Captions: If you added subtitles on Day 27, confirm they appear at the right times.
  • Transitions & Animations: Make sure animations, transitions, and effects are smooth and visually appealing.
  • Audio Quality: Ensure clear, crisp audio without background noise.

Step 2: Choose the Correct Video Format

YouTube supports multiple video formats, but the preferred and most widely compatible is MP4. Blender allows exporting animations in MP4 format.

  1. Go to the "Output Properties" tab in Blender.
  2. Under File Format, select FFmpeg Video.
  3. Container: Choose MPEG-4 (MP4) for YouTube compatibility.
  4. Codec: Ensure the video codec is set to H.264, which offers the best balance of quality and file size.
  5. Audio Codec: If you added a voiceover, select AAC for the audio codec, which is also YouTube-friendly.

Step 3: Set Resolution & Frame Rate

For optimal YouTube video quality, adjust the resolution and frame rate in Blender:

  • Resolution: Set the resolution to 1920x1080 pixels (Full HD). This is the standard for YouTube videos and ensures your content looks crisp.
  • Frame Rate: YouTube videos should ideally be at 30 FPS (frames per second) or 60 FPS for smoother animations.
    • You can change this under Dimensions > Frame Rate in Blender’s Output Properties.

Step 4: Adjust Bitrate for Video Quality

You want a good balance between file size and quality. When exporting your video, pay attention to the bitrate:

  • Bitrate for Full HD: Set the bitrate to 10,000–12,000 kbps for high-quality 1080p video.
    • You can set this in Blender under the "Encoding" options (part of the Output Properties tab).

Step 5: Add a Thumbnail

Thumbnails are crucial for YouTube videos, as they determine whether viewers click on your video. You can create a custom thumbnail in Blender using a still frame from your video or a separately designed image.

  1. Select an appealing frame from your video or create a separate visual using text and graphics.
  2. Export it as an image (preferably PNG or JPEG).
  3. Make sure the thumbnail has a resolution of 1280x720 pixels.

Step 6: Optimize Video Title, Description, and Tags

Now that your video is YouTube-ready, let’s focus on the metadata to maximize visibility.

  • Title: Create a clear, engaging, and descriptive title.
    • Example: "Learn Medical Concepts with Blender Animations | Flowcharts & Diagrams Explained"
  • Description: Add a detailed description summarizing the video content.
    • Include relevant keywords like "Blender tutorial," "flowcharts," "educational diagrams," "Quran learning," or any other topic covered.
    • Add your Patreon link, social media handles, or any links to additional resources.
  • Tags: Use relevant keywords that describe your video. For example, "Blender," "educational videos," "flowcharts," "mindmaps," and your niche like "biology," "Quranic learning," etc.

Step 7: Video Settings for Uploading

Before uploading, double-check the following YouTube settings:

  • Privacy Setting: Choose Public to make the video available to everyone, or Unlisted if you want to share it with select individuals first.
  • Category: Select the correct category, such as Education.
  • Monetization (Optional): If you’re eligible for monetization, turn this on.
  • Video Language & Captions: Set the language of the video and enable captions if applicable.

Step 8: Video End Screens and Cards

Enhance engagement by adding:

  • End Screens: Include clickable elements at the end of your video for viewers to subscribe, watch more videos, or visit your website.
  • Cards: You can add interactive elements during the video to link to related content or playlists.

Step 9: Review and Upload

Once everything is set:

  1. Upload your video using YouTube's "Upload" feature.
  2. Double-check the preview of the video to ensure everything (title, description, thumbnail) appears correctly.
  3. Publish your video.

Outcome

Your video is now YouTube-ready and will have the right quality, engaging metadata, and appealing visuals to attract and retain viewers.

Source:
ChatGPT


Wednesday, October 16, 2024

Day 22: Blender tutorial for making illustrations – Designing Interactive Diagrams (Clickable or Animated Paths)


Today, you will learn how to create interactive or animated diagrams in Blender. These diagrams will guide viewers through different paths, making your educational videos more engaging and interactive. You’ll animate elements that can trigger different actions, such as moving along a flowchart path or highlighting a section of a mind map.


Step-by-Step Guide:

1. Setting Up Your Scene

  • Open Blender and set up a new project.
  • Switch to 2D Animation mode by selecting it from the splash screen or creating a new 2D workspace.
  • Clear the default objects if necessary and start with a clean workspace.

2. Creating the Diagram Base

  • Use Grease Pencil to draw a flowchart, mind map, or any other educational diagram. You can create nodes using simple shapes like circles or squares and connect them with lines or arrows.
  • Add text labels to each node using the Text tool, explaining each part of your diagram.

3. Preparing the Animation

  • Select the elements (nodes and lines) that will be animated.
  • Create an animation timeline by opening the Dope Sheet and setting keyframes for your nodes and text.
  • For interactive paths, you’ll need to animate the movement between different sections. For instance, create animations that show a progression from one node to another using keyframes.
  • Add keyframes for movement (location), scaling, or rotation, depending on how you want elements to interact.

4. Adding Triggers and Interactivity

  • Path Animation: Use Bezier curves to define movement paths between nodes or sections. Convert a curve into a path and assign objects (like arrows or markers) to follow it.
  • In the Object Data Properties panel, under Path Animation, adjust the Frames to control how long it takes for the object to move from start to finish on the path.

5. Enhancing Interactivity with Visibility

  • You can animate visibility to create the effect of items appearing or disappearing as users "interact" with the diagram. Use keyframes on the Visibility property (found under the Object Properties panel).
  • For example, you can animate text to appear sequentially as viewers progress through different nodes.

6. Refining with Camera Movements

  • Add a camera and animate its movement using keyframes. You can move the camera from one section of the diagram to another, creating a dynamic and interactive feel.
  • Go to the Timeline, select the camera, and add keyframes to adjust its position and focal length to zoom in or out on different parts of the diagram.

7. Testing and Previewing

  • Use the Timeline to scrub through your animation and check the flow. Make sure that the interactive paths are smooth, and the timing feels natural.
  • Adjust the duration and easing of transitions to enhance user engagement.

8. Rendering the Animation

  • Once satisfied with the interaction and animation, go to the Render Properties tab.
  • Set your render output to the desired video format (e.g., MP4), adjust resolution, and select Output Folder to save your video.
  • Click on Render Animation to export your interactive diagram as a video.

9. Adding Sound or Voiceover

  • Import the rendered video into a video editing software (e.g., Blender’s Video Sequence Editor or another software of your choice).
  • Record and sync your voice narration to the animation, explaining each part of the diagram as it progresses.

Outcome:

  • By the end of Day 22, you will have created an interactive or animated flowchart or mind map that guides viewers through a process with animations that move along paths. This will be ready to include in your illustrative videos with voiceover narration.

Source:
ChatGPT

Sunday, October 13, 2024

Post 24/30: VFX tutorial for Blender – Creating Realistic Glass with Refraction in Blender

 

Goal: Learn to create realistic glass materials with refraction and render a visually appealing glass object that distorts light.


Step-by-Step Guide:

1.     Open Blender & Set Up a New Scene:

    • Open Blender and create a new project by selecting FileNew.
    • Delete the default cube by right-clicking it and pressing X to remove it.
    • Press Shift + A to open the add menu and choose a new object (e.g., a sphere or cylinder) to act as your glass object. This will be your primary subject for refraction.

2.     Setting Up Glass Material:

    • Select your object, and in the right-hand panel, switch to the Shading workspace.
    • With the object selected, click on the Material Properties (the sphere icon) and click New to create a new material.
    • In the Shader Editor, under the Principled BSDF shader, set the following:
      • Base Color: Leave this as it is (optional: slightly tint it if you want colored glass).
      • Transmission: Set this to 1.0 to make the object transparent like glass.
      • Roughness: Set this between 0.0 (for clear glass) to 0.2 (for frosted glass).
      • IOR (Index of Refraction): Set this to 1.45 (the value for glass).

3.     Adding Refraction:

    • Make sure Transmission is enabled in the Principled BSDF shader to allow light to pass through the object and create realistic refraction.
    • In the Render Properties tab (camera icon), scroll down to the Screen Space Reflections section and check the box to enable it.
    • Then expand this section and ensure that Refraction is enabled.

4.     Set Up the Lighting:

    • Good lighting is essential to make the glass effect stand out. Press Shift + A and add an Area Light or an HDRI environment.
    • Position the light so that it shines onto your glass object from an angle to create beautiful reflections.
    • You can adjust the strength and size of the light source for different effects. Start with a strength of around 1000.

5.     Add a Background or Ground Plane:

    • Add a plane beneath your glass object by pressing Shift + AMeshPlane. Scale the plane by pressing S and dragging your mouse to size it appropriately.
    • You can add a simple material to the plane by following the same steps as adding materials for the glass. For a reflective surface, add a slight metallic sheen or a glossy shader.

6.     Camera Setup:

    • Press Shift + ACamera to add a camera to the scene.
    • Position the camera by pressing Numpad 0 to enter the camera view. Use G to move and R to rotate the camera until you have a good composition of the glass object.
    • Adjust the camera's focal length in the Camera Properties to add artistic blur or depth if needed.

7.     Final Rendering Settings:

    • In the Render Properties tab, set the render engine to Cycles for more realistic lighting and refraction effects.
    • Scroll down and increase the Samples (start with 128 for preview, and go higher, like 512 or 1024, for the final render) for better quality.
    • Under the Film section, enable Transparent if you want to have a transparent background in your final render.

8.     Render the Scene:

    • Once your setup is complete, go to the Render menu at the top and click Render Image.
    • After the render finishes, save your image by clicking ImageSave As… in the render window.

Shareable Visual:

  • Your final result should be a realistic, reflective glass object that distorts the light passing through it, with clear refraction visible. You can share this rendered image or animation to showcase your mastery of glass materials in Blender.

This task will help you learn the fundamentals of creating glass effects, playing with reflections, and working with lighting to produce realistic materials in Blender.

Source:
ChatGPT