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.
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.
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!
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.
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.
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.
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.
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.
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.
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!