Learn Excel VBA Animation for dashboards reports charts etc

Create impressive, interactive, modern Excel projects with animations for great user Experience. Let their jaw drop!
4.5 (38 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
401 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 88
  • Length 13 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

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:

  • move around shapes in Excel with codes,
  • rotate shapes,
  • understand 3D rotations in X, Y, Z axis
  • Morphing of shapes
  • create amazing animated splash screens to create first impression when a user clicks open your Excel workbook. Its a winning trick you'd always use once you learn
  • create loading screens like seen on web pages / mobile apps in your Excel workbooks
  • create animated password access splash screen system to your Excel workbooks.
  • learn different styles of animated menus like slide out menus, slide down menus, scaling menus, toggle button animated menus
  • loop animations
  • chart animation / graph animation in Excel
  • Learn text animation, that you'll always use in all simple to big Excel projects. Because it's insanely easy and useful!
  • learn to apply various animations in all kinds of dashboards/reports/simple information workbook
  • learn awesome button animations for that great user experience every time someone interacts with your dashboards/reports/projects
  • creative mouse hover animation for all projects
  • various transitions and effect animations
  • learn all properties of shapes such as transparency, blur, Scale height/width, glow, color to achieve amazing animation effects that can be applied to any project.

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.

What are the requirements?

  • Basic working knowledge of Microsoft Excel
  • you would preferably need Excel 2010 or above, though you should still be able to follow with 2007 version.

What am I going to get from this course?

  • With over 12 hours of videos and increasing, you'll learn scores of animation tricks in Excel
  • Learn super easy VBA codes for achieving all kinds of animations. No prior coding experience required.
  • Learn in-trend professional mobile and Web style animated menus that can be applied to any Excel project and enhance the user Experience of your projects
  • Create awesome animated splash screens for any Excel project such as animation with password access to a work book, loading animation when a workbook is clicked open, Sci-fi style animated splash screen menus
  • Learn different properties of shapes such as glow, blur, transperancy to achieve tricky animations
  • Master mouse hover animation to create professional Excel projects
  • Learn typography or text animation for flashing important text messages and surely can be applied to any Excel projects
  • Learn animation for creating non stop loop animation
  • Master the shape layer system for designing great projects
  • Create beautiful graph animations
  • Learn 3D style animation effects in Excel
  • Learn to design icons in Excel
  • After completing this course you'll be confident to create any subtle to complex animation that will turn any project a professional work and surely you'll become an awesome developer and designer
  • Create all kinds of chart animation such as line chart animation, bar graph animation, pie chart animation, doughnut chart animation

What is the target audience?

  • Anyone wanting to add professional animations to excel projects such as animated splash screens, animated menus, text animations, graph animation and any creative animation you can think of or have come across and turn any Excel projects a professional work
  • Anyone wanting to add professional animations to excel projects
  • Anyone who loves animation in general and want to take Excel skill to the next level
  • Anyone who likes to get creative at work

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the Course
Introduction to the course
Preview
02:33
Article

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
Article
Section 2: Introduction to shapes/objects in Excel. It's basic but essential learning.
05:52

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!

05:16

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.

04:58

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.

03:56

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

03:37

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
04:10

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
02:14
11:15

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.

Range property
03:38
Cells property
03:36
05:27

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.

11:56

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.

04:07

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.

08:35

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.

17:20

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.

15:03

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
13:04

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
03:38

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.

11:46

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
09:50

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
12:52
Section 7: ZOrder of shape and Mouse Hover animation tricks
ZOrder of shape animation Part 1
Preview
04:27
ZOrder of shape animation Part 2
15:18
Mouse hover animation
12:18
Web style icon animation Part 1
Preview
03:45
Web style icon animation Part 2
06:54
Section 8: Immediate Window view workflow- Very important
Immediate window - very important
09:44
Bouncing animation effect
13:57
Robot arm animation part 1
Preview
06:58
Robot arm animation part 2
14:23
Section 9: Progressive circle animation utilizing a Doughnut chart trick
01:54

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
08:01
Progressive circle animation Part 3
12:46
Section 10: Splash screen animation
Aspect ratio
06:55
03:14

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
14:03
Splash screen animation part 3
11:52
Splash screen animation part 4
08:47
Splash screen animation part 5
07:30
04:39

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
18:07
Animated password access Splash Screen-Part 3
15:46
Animated password access Splash Screen-Part 4
13:29
Animated password access Splash Screen-Part 5
07:36
Shape adjustment animation part 1
Preview
04:28
Shape adjustment animation part 2
13:51
Shape adjustment animation part 3
14:12
Shape adjustment animation part 4
17:56
02:31

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
19:26
Section 11: Typography Animation
Text animation - Typing effect Part 1
Preview
05:10
Text animation - Typing effect Part 2
07:22
Section 12: ThreeD camera animation
05:03

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
06:29
Section 13: Bonus lessons on animation tricks
08:46

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
18:25
05:16

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
13:02
Mobile app style animated menu Part 3
13:28
Sci-fi style animated splash screen Part 1
04:50
Sci-fi style animated splash screen Part 2
11:05
Sci-fi style animated splash screen Part 3
03:24
Calendar flip animation 3D effect part 1
Preview
03:45
Calendar flip animation 3D effect part 2
13:13
Calendar flip animation 3D effect part 3
11:56
Calendar flip animation 3D effect part 4
06:46
Section 14: Chart animation for killer dashboards
Bar graph animation Part 1
02:18
Bar graph animation Part 2
10:52
Bar graph animation Part 3
08:00
Line graph animation Part 1
01:26
Line graph animation Part 2
10:52
Line graph animation Part 3
06:08
Progressive line graph animation Part 1
04:49
Progressive line graph animation Part 2
16:02
Progressive line graph animation Part 3
18:56
Progressive line graph animation Part 4
09:20
Pie chart animation part 1
02:39
Pie chart animation part 2
09:25
Pie chart animation part 3
05:11
Pie chart animation part 4
11:14
Doughnut chart animation part 1
02:32
Doughnut chart animation part 2
11:44
Doughnut chart animation part 3
15:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kishon Deori, Business Intelligence expert , Animator & video compositor

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! 

Ready to start learning?
Take This Course