The Teacher

Mastering Microsoft Excel: A Step-by-Step Guide to Uncover Hidden Features

2024-03-19T18:36:00.001+05:30

Microsoft Excel is a powerful tool used by millions of professionals worldwide for data analysis, organization, and visualization. However, many users may not be aware of its hidden features and shortcuts that can significantly enhance productivity. In this blog post, we will provide a comprehensive guide to unlocking the full potential of Microsoft Excel, from accessing hidden features to optimizing workflow.

Step 1: Accessing Microsoft Excel The first step in mastering Excel is accessing the application itself. If you're using Microsoft 365, simply navigate to the Start menu and click on the Excel icon. Alternatively, you can right-click on the Excel icon in the Start menu to reveal its properties, including the exact file location.

Step 2: Pinning Excel to Start Menu To streamline access to Excel, you can pin it to the Start menu. This allows you to open Excel with just a single click, eliminating the need to search for the application every time. Simply right-click on the Excel icon in the Start menu and select "Pin to Start" to create a shortcut.

Step 3: Understanding Application File Paths It's essential to understand the file paths of applications for troubleshooting purposes. By knowing the exact location of the application files, you can easily recreate missing icons or resolve any issues that may arise. Take note of the target path of Excel and other applications for future reference.

Step 4: Creating Desktop Shortcuts Another handy trick is creating desktop shortcuts for frequently used applications like Excel. This allows you to access the application directly from your desktop, saving time and streamlining your workflow. To create a desktop shortcut, right-click on the Excel icon, select "Send to," and then choose "Desktop (create shortcut)."

Step 5: Utilizing Desktop Shortcuts for Quick Access With desktop shortcuts in place, you can quickly access Excel and other applications with just a single click. This enhances productivity by eliminating the need to navigate through menus or search for applications. Organize your desktop shortcuts for easy access to your most-used programs.

Conclusion: Mastering Microsoft Excel is key to maximizing productivity and efficiency in various professional settings. By following the steps outlined in this guide, you can uncover hidden features, streamline your workflow, and become a more proficient Excel user. Whether you're a beginner or an experienced user, these tips and tricks will help you unlock the full potential of Excel and excel in your work.

Remember to practice and explore additional features to further enhance your Excel skills. With dedication and continued learning, you can become a master of Microsoft Excel and excel in your professional endeavors. Happy Excel-ing!

3D Cube Animation using CHATGpt by Rajiv

2024-03-18T18:48:00.001+05:30

3D Cube Animation

Front

Right

Back

Left

Top

Bottom

Superman and Batman Animation With Head Shift Effect in PowerPoint 2016 / 2019 Tutorial

2019-09-09T09:46:00.000+05:30

Superman and Batman Animation in PowerPoint 2016

One of my favorite animation, not just because I tried something new with this 15 seconds long animation but unknowingly this short move is also predicting an event. Watch the tutorial and see if you can find it. Anyway, let’s concentrate on studies.

Let me clearly explain you one thing that if you are serious about doing animation stuff in PowerPoint; then according to my studies; you must also be a good Graphic Designer. So, if we talk about these two Superman and Batman Characters then surely they has been drawn using Shape Tools and if you are a beginner then you must give a watch to Microsoft Word Drawing / Shapes Tools Tutorial Video series. Remember, Shapes Tools work similarly in most of the Microsoft Office (Word, Excel and of-course PowerPoint) apps. You can’t learn that how to draw this or that character; instead you should learn to use the Tools and your mind will amazingly combine all those techniques to bring up some wonderful results.

Look at the Framework:

Superman and Batman Character Design Framework View

You must know How To Use Selection Pane in Microsoft Office or you can imagine working with so many shapes on a single PowerPoint Slide. Isn’t? Look at the list of Grouped objects used in this presentation.

So Before Learn To Animate, Learn to Draw!

Let’s talk about the Animation Effects used in this presentation. Look at those different Signs in front of Layers / Objects names :

Selection Pane

Animation Pane

The Yellow Stars represents Emphasis effects and those lines with Red / Green dots represent Motion Paths. Keep in mind that looking into the Animation Pane, the first thing you should notice the type of Animations used in the presentation. So, about images illustrate that only 2 types of animations has been applied in this presentation : Emphasis and Motion Paths.

Motion Paths and Emphasis Effect Signs

A more deeper look into the Animation list of this presentation will also let you know that almost same animation effects has been used for both Superman and Batman with almost same Delay Timings and Animation Duration.

All animations in this presentation are starting With Previous on specified Delay Timings and for said Duration. Selecting an animation from the list will display it Start type (Mouse Click, With Previous or After Previous), Duration and Delay Timings in the Timings section.So, if you are Beginner To PowerPoint then you should watch my video on Introduction to PowerPoint 2016 for more information on how to apply Animation Effects while working inside your first presentation with a brief information from Welcome Screen to various other “Dare to Know!” stuff.Double-clicking on an Animation effect from the Animation Pane will open the Properties window of that effect.

Animations List with Duration, Delay Timings, Start With type and Repeats

You can learn more about effect properties by double-clicking on an animation in the Animation Pane window.

Animation Properties Window

Superman and Batman Animation PowerPoint Presentation Download Link

File Size : 88KB

File Format : PPTX

To learn more, Watch our video on Superman and Batman Motion Graphics Animation in PowerPoint 2016 / 2019.

The Ice Cream | Animated Loader and Spinner in PowerPoint 2016 Tutorial

2018-05-17T10:29:00.001+05:30

In this Microsoft PowerPoint 2016 Tutorial video, we are going to create a nice Ice Cream Animated Loader and Spinner, which you can use in Youtube Live Streaming or other projects.

About the Animation
=================
The Ice Cream has been drawn using the Shape Tools - Rounded Corner Rectangle and Straight Corner Rectangle. The Merge Shapes / Subtract command has been used in this project and don't think that there will be any other way of doing that in PowerPoint.

Diagonal Down Right Motion Path has been used to move the ice cream bars and Fade Entrance Effect and Font Color Emphasis effect has been used for text.

Don't Forget to Like, Share & Comment Before Downloading the Presentation and all my presentations are free to use.

Presentation and Assets Download Link: (Free To Use for your Projects)
https://goo.gl/fzF3VJ

Animation Inspiration From:
https://codepen.io/astrixsz/pen/RRxyKz

Check Out My Other Works
========================
For More Microsoft Windows 10 Tutorial Videos Visit @
https://goo.gl/4aJGnP

Watch Best How To and Tips and Tricks Videos @
https://goo.gl/qzrP13

Watch Excel 2016 Tutorials @
https://goo.gl/CDgCaL

Watch Word 2016 Tutorials @
https://goo.gl/zZx9Bk

Watch More PowerPoint 2016 Tutorials @
https://goo.gl/YSFjgt

Top 40 PowerPoint Animation Tutorials, That You Might Haven't Seen Before
https://youtu.be/sz4PpIpzoQ8

Watch More Motion Graphics in PowerPoint Tutorials :
https://goo.gl/7ujIsn

For More Animated Motion Backgrounds :
https://goo.gl/dk5pjk

Watch More Animated Loaders and Spinners :
https://goo.gl/P1Py0r

For Kinetic Typographic and Advanced Text Animation in PowerPoint :
https://goo.gl/b3fuys

Support Us @ www.patreon.com/TheTeacher
Subscribe Us @ www.youtube.com/TheTeacher
Circle Us @ www.google.com/+TheTeacher
Like Us @ www.facebook.com/BeMyTeacher

#PowerOfPowerPoint
#BeCreative
#SeeSomethingNew
#PossibilitiesWithPowerPoint

Drop your creative work video link in the comment section.

Presented By The Teacher

The Impossible Rotation Effect | Animated Loaders and Spinners in PowerP...

2018-05-16T11:00:00.001+05:30

In this PowerPoint 2016 tutorial video, I will illustrate that how you can use a few techniques to create the Impossible Rotation Effect moving through the text.

Watch More Animated Loaders and Spinners :

https://goo.gl/P1Py0r

You can also use these animated loaders in Live Streaming and you can see an example in my previous video.

https://youtu.be/4GkgBEDXuuY

About the Presentation

===================

I am using Frame Shape and later we convert that shape into a picture using Copy and Paste as Picture command. After creating a duplicate of the Frame Picture, I cropped them in way as they look like a single Frame Picture. After sending one of the top frame behind all the other objects, I used SPIN Emphasis effect. For text effect, I used Font Color - By Letter with 10% delay.

Animation Inspiration From:

https://codepen.io/jamesmellers/pen/X...

Presentation Download Link:

https://goo.gl/wCbEcd

Check Out My Other Works

========================

For More Microsoft Windows 10 Tutorial Videos Visit @

https://goo.gl/4aJGnP

Watch Best How To and Tips and Tricks Videos @

https://goo.gl/qzrP13

Watch Excel 2016 Tutorials @ 

https://goo.gl/CDgCaL

Watch Word 2016 Tutorials @ 

https://goo.gl/zZx9Bk

Watch More PowerPoint 2016 Tutorials @

https://goo.gl/YSFjgt

Top 40 PowerPoint Animation Tutorials, That You Might Haven't Seen Before

https://youtu.be/sz4PpIpzoQ8

Watch More Motion Graphics in PowerPoint Tutorials :

https://goo.gl/7ujIsn

For More Animated Motion Backgrounds :

https://goo.gl/dk5pjk

For Kinetic Typographic and Advanced Text Animation in PowerPoint :

https://goo.gl/b3fuys

Subscribe Us @ http://www.youtube.com/theteacher

Like Us @ http://www.facebook.com/bemyteacher

Circle Us on Google Plus @ http://www.google.com/+theteacher

Visit Us @ http://www.theteacherpoint.blogspot.com

Presented By The Teacher

Video Link:

https://youtu.be/f0JSVxllsCA

Particles Text Effect in PowerPoint 2016 | Motion Graphics Tutorial

2018-03-03T19:30:00.001+05:30

So, in this Blog Post, I am going to describe 10 Easy Steps to create Particles Text Effect Motion Graphics in PowerPoint 2016. Let me first give the credit to Morocco Tutorials, a Youtube Channel, as the background Particles Text Effect video has been created by him using After Effects. When I first saw the preview, I thought, why not try to create this effect in Microsoft PowerPoint. First, have a look at the animation.

As you can see, in the first few frames, Particles are moving off the screen and when they reaches in the middle of the screen, text starts appearing with one letter in a time, which creates an illusion as if the particles are dropping one character behind. Moreover, in this post, I am going to tell you about the basic concept used in this presentation and I think that is the most important part of learning. Instead of, just following the step by step instructions.

The concept behind this animation is totally simple. What you only need to know is, how to do this? Before, I start telling you about the steps used to create this animation, make sure to check the version of PowerPoint installed on your system. This effect is hardly impossible to create in PowerPoint 2007 and earlier versions because they don’t have Merge / Combine Shapes Tool.

If you have PowerPoint 2010, then you need to read this article that How to enable Merge / Combine Shapes in PowerPoint 2010. This effect can easily be done in PowerPoint 2013 / 2016. But, before I begin, let me make it very clear to you that the steps which I am going to describe below will only guide you about the concept of the animation, not where to click. You can watch the embedded video below for each step with more detail information.

Understanding the Concept

Step 1 : First we draw a full Slide Size Rectangle

Step 2 : Then, we type our Text using WordArt from the Insert menu. After formatting the text, make sure to Align the text in the Center and Middle of the slide using Align options from the Format menu.

Step 3 : We need to combine the Rectangle with our text using Combine / Merge Shape Tools. For that, select the Rectangle first, hold down the SHIFT key and then select the WordArt Text Box. From the Home tab, open the Merge Shapes drop down button and then click on Combine.

As you can notice in the above picture that PowerPoint wiped out the text within from the Rectangle and the slide background is clearly visible. That is what the combine command does. It actually combines the letter in to the text box and remove them from the slide and the letters get printed on to the Rectangle.

Step 4 : Create a duplicate of the entire text (in my case that’s “The Teacher”) but this time you need to have each letter in a separate Text Box. I mean, you have to type each letter separately using WordArt. All the letters like “T” “h” “e” should have their own corresponding text boxes and for that you have to type each letter individually or you can take the help of Copy / Paste command by typing a letter then making a duplicate (after selecting a Text Box, you can also press CTRL+D to create a duplicate), and then replacing the characters. You can watch the video to know how I did that. I am using Smart Cut n Paste command (hold down the CTRL key while dragging and dropping text boxes) to quickly create duplicates and that is what I’m doing in the video.

(Placing letter “T” text box on the top of combined shapes to hide the white part. The rectangle and text color should be same, which in my case is Black, to hide everything on the slide.)

BTW, you can also take the help of Selection Pane (from the Home / Format Tab) to easily manage objects on slide. Like, you can select, hide, rename and move objects, right from the Selection Pane. If you are a beginner to PowerPoint, then I must say that you should watch my Work With Multiple Objects using Selection Pane for more information.

Step 5: Now, select all the letters / text boxes (either select the first letter, hold down the SHIFT key and then start selecting the other boxes or use Selection Pane. In Selection Pane, select the first Letter, hold down the Shift key and then click on the last one. That’s easy you know!). After selecting all the letters, go to the Animations tab, hit the Add Animations drop down button and then apply Fade Out from the Exit effect list and for the Start option, set all of them to Start – With Previous and add a Delay of 1 Second. That will apply the Exit Fade Out effect to all the letters / text boxes at once, hiding all of the letters at once in the slideshow. But, we want each letter to fade out with a little delay.

Step 6 : Insert the Particles Behind Text video. We want a lot of particles to appear behind the combined shape (The Teacher), so we will Trim the video to about 1.5 seconds from the beginning from the Playback menu, to have a lot of particles on the screen. From the Playback menu, set the video to Start – Automatically and also from the Animation pane, set it to Start - With Previous and move the video on the top of the animation list by dragging and dropping. Select the video and send it behind the other objects using Send To Back command from the Format menu.

So, when you will see the slide show after applying the Step No. 6, all the letters will get disappear at once and you will see Particles running behind the combined rectangle and will create an illusion as all the letters are filled with the Particles.

Step 7 : From the Playback menu, make sure to check “Loop Until Stopped” option, so the particles continuous to scroll behind until end of the animation.

Step 8 : Now, insert the Particles in Front of the Text video. Set it Play Automatically from the Playback menu and also set Start – With Previous from the Animation tab and move the video on top of the Animation list. As this video will remain on top of all the other objects on the slide, so when you will see the Slideshow, it will hide all the other objects behind it. Even the video is transparent but video transparency is not available in PowerPoint. So, what we are going to do now is to apply the Transparency Emphasis Effect to the Particles video on top.

Step 9 : Move the Transparency effect to number 2 in the animation list. Just below the Particles in Front of Text video. So that when you see the Slide Show, Particles in Front of Text video will play and at the same time the Transparency effect will start working and you will start seeing the objects behind the Particles video.

Step 10 : The final step is to add a delay between all the Fade Out effect for letters, so they must not appear all at once. Instead, each letter should appear with a little delay as the Particles are leaving behind their trail in form of letters and for that you need to add a delay between each Fade Out exit effect.

You can go with 0.25 Seconds delay between each letter or you can set your own timings depending on letters you want to appear on the screen at exact time. Finally, Insert the Background Audio and impress your Teacher / Friends with your impressive PowerPoint Presentation. BTW, you can also use this presentation as your Youtube Intro.

You can watch our Particles Text Effect in PowerPoint 2016 video for more detailed information.

Particles and Background Music Download Link

Do More, With Windows

2016-05-30T09:58:00.000+05:30


Access Windows Desktop Without Minimizing Anything	Prank Your Friends, an Old Windows Trick	Understanding and Configuring Default Printer Settings

Play Custom Videos at Windows Lock Screen	25 Best Windows 10 Keyboard Shortcut Keys	Customize Folder View Options