Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
An app can truly delight a user when animation is used in ways beyond the obvious. A menu icon that becomes an arrow or playback controls that seamlessly change from one to the other serve dual functions: to inform the user and to imbue your app with a moment of wonder and a sense of superb craftsmanship. – Material Design > Delightful Details, Google
Beautiful, subtle animation pervades the iOS UI and makes the app experience more engaging and dynamic. Appropriate animation can:– Communicate status and provide feedback,Enhance the sense of direct manipulation, Help people visualize the results of their actions
– iOS Human Interface Guidelines > UI Design Basics, Apple
Excel animation exposed! Yes, animation has always been a secret and unknown skill even to the most advanced Excel user/developer anywhere, but with this course anyone with basic Excel skill can get started with animation and enhance the user experience of a report or a dashboard. Just in day, you'll learn the fundamentals of achieving animation in Excel and add that modern app experience to all your projects. It really rocks and help you build your profile as a creative tech professional!
**The only Excel animation course you'll find anywhere! It's a professionally designed course recorded with super easy concepts and tricks for creating unlimited beautiful and meaningful animations for any Excel dashboard, reports, charts or anything. No prior experience of coding required. Animation possibilities will change the way you work in Excel and make you a creative developer. Now take your Excel work to a whole new level! Satisfaction guaranteed.**
Do you want to get super creative at work and make every Excel project impressive? Do you want to wow your users: your clients, customers, your boss and anyone? Get started learning Excel animation and become highly wanted ! There's no limit with Excel animation, create what you can think! Get things to action in no time! Create professional animation such as splash screen animations for all Excel projects and have your users jaws dropped as soon as they click open a workbook. Never before animation in Excel was so easy and awesome as this course requires no prior knowledge of coding and all you need to know is just the bare basics of Excel and you are ready to become an excellent animator. Everything is covered step by step from beginner's to master level. Animation in Excel is achieved through VBA (programming language of Excel), but they are super easy and in fact easier than writing some excel formulas like Vlookup. Also in adition to learning concepts and writing simple codes, I'll also show you how you can record macros and modify the codes a very little to achieve any desired animation. This means you'll not have to take the stress of remembering codes and yet understand how things work and when required you'll be able to write animation codes from the scratch! So in any case you'll end up becoming a developer and a creative professional with this course. If you are a complete beginner, you gonna love it. It's super easy to get started with animation in Excel. And if you are already an advanced Excel user or a seasoned VBA programmer, you would be so glad to come across this course, as you will learn tons of tricks to create awesome animations in Excel.
How many people do you know who knows animation in Excel? Chances are not many or maybe none! So be the first to upgrade your skill in Excel! With the Exercise files/ working files included, everything in this course is step by step learning. From writing your first macro/program to writing beautiful animation codes which are not only very easy but very fun to learn. And the best part is you don't have to remember any codes, as Excel will generate those codes when you record a macro. I will take you through all the projects by recording macros and then just make little tweaking to the codes generated by Excel. And also I'll show you how to get the codes from the internet that you are looking and create animations with that. So like I said, no stress on the brain learning codes and it's just fun animating. So some of the things you'll learn are:
Fun is guaranteed throughout this course as you would be amazed to see yourself animating your imagination right within Excel. By the end of the course, you'll be armed with tons of tricks to create any kind of professional animation for any projects. And if you get stuck somewhere or trying out new animation ideas just post your questions on Udemy forum and I'm always around for quick support.
This course is frequently updated with new animation tricks so that you continue to gain from this course. And this course also comes with 30 days of risk free money back guarantee from Udemy. So, for any reason if you are not satisfied, you get full refund, no questions asked. So, go ahead and enroll in this course today and become a creative tech professional.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to the Course|
Introduction to the coursePreview
Depending upon the speed of your internet connection, Udemy player may automatically choose a lower format for streaming the videos and they might look little blur. You need to select the HD (720p or 1080p) format for best viewing result from the setting option on the Web player. All the videos in this tutorials are uploaded with HD format for best experience.
Download the working files here
|Section 2: Introduction to shapes/objects in Excel. It's basic but essential learning.|
Shapes are the building block of any design. If you want to design a tool, you must use shapes and images not just in excel but in any tool. If you learn the tricks to manipulate shapes in Excel, you'll be able to design beautiful objects and then apply creative animation to them. There are many default shapes in excel to get started and then you can shape them according to your requirement. Graphic designing comes with a lot of practice. The more you practice the beautiful art you can create. So make a habbit to create something new always!
Like all graphic designing tool, even in Excel you can create your own design. Icon design in Excel is a creative skill and you can design many graphics right within Excel. In this lesson we'll create a simple delete icon and learn some properties and tools to create assets.
Grouping of shapes is a very important workflow in any graphic designing tool including Excel. Groups can also be applied to VBA codes and thus animated several shapes in a group with just one line of code. So whenever possible group your shapes specially when there are too many shapes in a project. And as you get better with deisgn and animation, you'll start to have tons of shapes and images in your projects.
The layer system or the selection panel in Excel or any graphic designing tool is the key to creating desired design. When we design something we tend to combine multiple shapes, colors to come up with a single intended shape. In this lesson we'll learn the layer system and how it can leverage us to create assets withing Excel
zOrder has these functions:- 1). Send Backward : Send a shape to backward of the immediate shape behind 2). Send to back: Send a shape to the bottom of the layer system(Behind all shapes). 3). Bring Forward: Bring a shape to front of the immediate shape above. 4) Bring to Front : Bring a shape to the top of the layer system. This shape will be above all the shapes in the worksheet/selection panel/layer sytem. We'll also use this function very frequently through VBA codes in our later chapters.
|Section 3: Introduction to VBA|
In this lesson we'll learn what is VBA and it's application. Well VBA is a programming language for Excel and it stands for Visual Basic Application. VBA is primarily used to automate tasks, however in this series of tutorial we'll use VBA to achieve great animations in Excel. Animation in Excel can be achieved only through VBA and they are super easy. You'll learn the VBA basics in this course to create awesome animation. However if you want to use VBA to automate tasks then you need to learn the other side of VBA. There are many VBA tutorials on the Udemy site, you might like to consider one if you want to master VBA. But without animation, no project can be so lively and professional in a project.
Saving a macro enabled workbook
Lets get started writing out first macro. This is a simple macro changing the location of a shape from one point o another in Excel. Unlike the crazy codes for automating tasks in Excel, animation codes are pretty straight forward and the result is instant feedback. Its much about being creative.
A variable is a data type that can be changed over a period of time based on conditions. We'll learn how a variable is defined and a how a variable can be called.
As we know now, animation in Excel can be achieved only through VBA. And primarily we animate mostly the shapes/images in Excel as they can be moved around and shapes have tons of properties to animate at different interval of time.In this lesson we'll learn the most important concept called time delay or pausing of time in Excel through VBA. Whenevr there is an animation there is a time factor involved. Without time nothing really can animate. When I reach out to the water bottle, there is a time taken for that activity for that animation. And thus we need to apply a a time delay concept in Excel to give that travel time/time taken time for animation. This time delay macro in this course is called timeFrame and without this no animation can be achieved. It is like keyframe in real life animation softwares. This small chunck of codes called the timeFrame macro needs to be pasted in every animation project and we would not be writing this in any project. Just paste it to all projects. And when we apply this timeFrame macro we can pause time in excel for anytime we tell Excel to pause and when we apply pause time with different time at different locations, points, and other state of properties of shapes, we achieve different variations of animation.
Visible property is one of the most used function in graphic design tool or programming language. It's a Boolean function, simple true or false statement but super useful. We'll be using this function almost in all our projects later in this series of tutorials.
IF functions are logical/conditional reasonings and it is the "The most used" function in any programming language. In this lesson we'll learn to write simple IF logic in the VBA editor and in the later chapters we'll use more IF conditions. Understanding and mastering IF functions will really help you become a better programmer. So go ahead a practice a lot of IF functions beyond this lesson.
There are many ways to run a macro and each way is helpful for different situations. You can run a macro by pushing a button or run a macro based on a change of a cell value or even run a macro as soon a workbook is clicked open like a splash screen. Based on your project requirement you can leverage one of these in your projects.
Recording a macro and checking out the recorded VBA codes is a great way to learn VBA. If you are serious about mastering VBA, get your way out to record different activities. Once recorded, all the codes will be available for you to study. As you would know the activities that you performed, it becomes easy to understand how those activities are translated into codes and how these codes can be reused to automate those activities. So keep recording ideas in your mind and get those codes for use in your project.
|Section 4: For Loop Animation|
Loop functions are extensively used in all programming languages. The tasks of a loop function is to automate the repeated similar tasks. In this lesson we'll learn For Loop function, and this is so helpful that we'll use it it in most of our animation projects. It'll really save you a tons of time writing Excel animation codes.
|Section 5: Creating a sliding down menu|
In this lesson we'll create a simple sliding down menu. This is a very simple code just added some Top points to the shape for downward and upward animations. This kind of menus are seen everywhere in mobile apps, web pages, it really helps to keep your project clean and more interactive and most of all it gives that professional feel to it. You can also create different variations of such menus by checking out some of your favorite mobile apps or webpages. All those variations are possible to be achieved right within Excel! In this lesson we'll design the menu system.
In this part of the Sliding down menu project we'll start to write macros in the VBA editior to add downward and upward animation to the slidingRect our menu.
|Section 6: Creating a clock animation with rotation property of shapes|
In this lesson we'll create a real world animation clock. We'll employ the rotation properties of shapes to achieve the clock functionality. To rotate a shape we need understand the pivot point of a shape. By default the shapes' pivot points in excel is at it's own center point. So if we want animate a shape from it's bottom or top edges/pivot points we'll need to group the shape with a circle and then make the circle invisible. We can then use the new group name in the VBA editor to achieve that rotation animation.Shape rotation is one of the most used properties for animation.
Creating an animated clock part 2
|Section 7: ZOrder of shape and Mouse Hover animation tricks|
ZOrder of shape animation Part 1Preview
ZOrder of shape animation Part 2
Mouse hover animation
Web style icon animation Part 1Preview
Web style icon animation Part 2
|Section 8: Immediate Window view workflow- Very important|
Immediate window - very important
Bouncing animation effect
Robot arm animation part 1Preview
Robot arm animation part 2
|Section 9: Progressive circle animation utilizing a Doughnut chart trick|
In this project we'll create a progressive circle animation indicating a completion of a tasks by utilizing a doughnut chart animation in Excel. Other than the actual application of a doughnut chart, it's got many items to create cool animations. We'll also create other amazing animation in Excel as well by messing around with doughnut charts in our later chapters.
Progressive circle animation Part 2
Progressive circle animation Part 3
|Section 10: Splash screen animation|
Splash screens are the items that flashes on the screen before a user goes to the main contents of a project. It happens as soon as a workbook is clicked opened. Splash screens are often seen on the start of a mobile game and other popular web apps. Its a great way to flash important or key information to the users before they go to the actual project. You can surely showcase your professional skill with animations added to the splash screen and build a great rapport with your user. In this lesson you'll learn to create a splash screen in Excel with some doughnut chart tricks. So go ahead and take your animation skills to the next level by creating some awesome splash screen.
Splash screen animation part 2
Splash screen animation part 3
Splash screen animation part 4
Splash screen animation part 5
In this lesson we'll create a password access animated splash screen utilizing an activeX textbox for password input. This is a very exciting and impressive way to create a password access system in Excel and replace the default boring password system. This animated password access will increase user interaction and give a great user Experience.
Animated password access Splash Screen-Part 2
Animated password access Splash Screen-Part 3
Animated password access Splash Screen-Part 4
Animated password access Splash Screen-Part 5
Shape adjustment animation part 1Preview
Shape adjustment animation part 2
Shape adjustment animation part 3
Shape adjustment animation part 4
In this lesson we'll create animated loading screen in Excel. This a simple loading effect that you would often see in most websites and it kind of gives that same great feel when you apply it in Excel projects. After you've learned this, you would end of appyling your own loading screen in all your important Excel projects as it will greatly improve the overall porfessional feel of your project.
Loading effect animated splash screen Part 2
|Section 11: Typography Animation|
Text animation - Typing effect Part 1Preview
Text animation - Typing effect Part 2
|Section 12: ThreeD camera animation|
Although Excel is not a 3D application, there are some faking of 3D effects that can be achieved in Excel. In this lesson you'll learn some threeD functions that can be taken to the next level. You can always mix and match a 3D effects with other animation.
ThreeD camera animation part 2
|Section 13: Bonus lessons on animation tricks|
In this lesson we'll create an animated menu in Excel driven by a toggle button. This is achieved by applying the scaleHeight function of shapes. This kind of animated menu are often seen on web pages and mobile apps and just about any tool. So why not we use in our Excel projects as well. It will surely make our project look and feel professional.
Animated menu driven by a toggle button Part 2
In this lesson we'll create a mobile app style animated menu in Excel. Just like we see these animated menus in Android apps and ios apps. It's really a cool animation that can change the look and feel of our Excel projects. Its just great menu system!
Mobile app style animated menu Part 2
Mobile app style animated menu Part 3
Sci-fi style animated splash screen Part 1
Sci-fi style animated splash screen Part 2
Sci-fi style animated splash screen Part 3
Calendar flip animation 3D effect part 1Preview
Calendar flip animation 3D effect part 2
Calendar flip animation 3D effect part 3
Calendar flip animation 3D effect part 4
|Section 14: Chart animation for killer dashboards|
Bar graph animation Part 1
Bar graph animation Part 2
Bar graph animation Part 3
Line graph animation Part 1
Line graph animation Part 2
Line graph animation Part 3
Progressive line graph animation Part 1
Progressive line graph animation Part 2
Progressive line graph animation Part 3
Progressive line graph animation Part 4
Pie chart animation part 1
Pie chart animation part 2
Pie chart animation part 3
Pie chart animation part 4
Doughnut chart animation part 1
Doughnut chart animation part 2
Doughnut chart animation part 3
I have a Business Management degree from Bangalore University and a long time Excel expert. I create professional Excel reports/dashboards for top clients and conduct Excel workshops for business professionals. I'm also a 2d and 3d animator with video compositing expertise. I have excelled in VBA animation subject which is unknown even to the advanced Excel user. I have taught many professionals on how to add animations to Excel dashboard, reports and add great functionalities. I like to be productive and creative at work. I like to continuously increase my skills and stay in tuned with the technology industry. Am also a hard core iOS music apps user and like to record my guitar right into my iPhone and mix and master the entire song right within mobile. Besides desktop editing, I do professional video composting and editing right in Android high end phones with paid subscriptions to some great apps that amazes me with the capability of video productions right from your pocket!