Master Excel VBA Animation for interactive dashboard reports
4.4 (75 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.
719 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Excel VBA Animation for interactive dashboard reports to your Wishlist.

Add to Wishlist

Master Excel VBA Animation for interactive dashboard reports

Learn the most secret skill in Excel with no prior VBA Macro knowledge. Get instant visibility in office with animation
4.4 (75 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.
719 students enrolled
Created by Kishon Deori
Last updated 4/2017
English
Learn Fest Sale
Current price: $10 Original price: $100 Discount: 90% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 13.5 hours on-demand video
  • 2 Articles
  • 40 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Easily add professional animated menus to any Excel projects for great user Experience
  • Add unlimited awesome button animations for that nice user feel
  • You will learn tons of animation tricks for great user Experience
  • Learn super easy VBA codes for achieving all kinds of animations. No prior coding experience required.
  • 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
  • Make every Excel project interactive with meaningful animations
  • Master the most creative skill in Excel, that's animation
  • Learn different properties of shapes such as glow, blur, transperancy to achieve tricky animations
  • Master mouse hover animation to create professional Excel projects
  • Create beautiful graph animations
  • Learn 3D style animation effects 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
View Curriculum
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.
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 90 Lectures Collapse All 90 Lectures 13:41:59
+
Introduction to the Course
3 Lectures 03:00

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.

Watch the videos in HD mode only
00:15

Download the working files here
00:11
+
Introduction to shapes/objects in Excel. It's basic but essential learning.
2 Lectures 14:39

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!

Introduction to shapes in Excel
05:16

Align and group shapes, Zorder of shapes
09:23
+
Introduction to VBA
11 Lectures 01:26:45

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.

Exploring the VBA editor
03:34

Saving a macro enabled workbook
02:14

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.

Writing first macro in the VBA editor
11:15

Range property
03:38

Cells property
03:36

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.

What is a variable?
05:27

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.

Write your first animation macro/VBA codes
11:56

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.

Visible property of shapes in VBA
04:07

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.

IF function-Logical function
08:35

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.

Different ways to run a macro
17:20

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.

Recording macros to get codes generated by Excel and understand them
15:03
+
For Loop Animation
1 Lecture 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.

For loop Animation
13:04
+
Creating a sliding down menu
2 Lectures 15:24

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.

Sliding down menu part 1
03:38

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.

Sliding down menu part 2
11:46
+
Creating a clock animation with rotation property of shapes
2 Lectures 22:42

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

Creating an animated clock part 2
12:52
+
Immediate Window view workflow- Very important
2 Lectures 23:41
Immediate window - very important
09:44

Bouncing animation effect
13:57
+
ZOrder of shape and Mouse Hover animation tricks
5 Lectures 42:42

ZOrder of shape animation Part 2
15:18

Mouse hover animation
12:18


Web style icon animation Part 2
06:54
+
Robot Arm animation
2 Lectures 21:21

Robot arm animation part 2
14:23
+
Progressive circle animation utilizing a Doughnut chart trick
3 Lectures 22:41

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 1
01:54

Progressive circle animation Part 2
08:01

Progressive circle animation Part 3
12:46
5 More Sections
About the Instructor
Kishon Deori
4.4 Average rating
75 Reviews
719 Students
1 Course
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!