udmy-mevbaafidr.nfo
Udemy - Master Excel VBA Animation for Interactive Dashboard Reports (2017-02)
https://www.udemy.com/microsoft-excel-animation-for-great-user-experience/
Learn the most secret skill in Excel with no prior VBA Macro knowledge.
Get instant visibility in office with animation
Lectures: 89
Video: 13.5 Hours (720p : 1280x720)
Skill level: All Levels
Language: English (AAC : 2.0 190 kbps)
Subtitles: N/A
Instructed by: Kishon Deori
Size: 1.61 GB
Container: MP4
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?
- 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
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
===============================================================================
SECTION 01 Introduction to the Course
01. Introduction to the course - 2:33
02. Watch the videos in HD mode only - 0:00
03. Download the working files here - 0:00
LearnExcelAnim ExcerciseFiles_updated Sep 2016.zip
SECTION 02 Introduction to shapes/objects in Excel.
It's basic but essential learning.
04. Introduction to shapes in Excel - 5:16
05. Align and group shapes, Zorder of shapes - 9:23
SECTION 03 Introduction to VBA
06. Exploring the VBA editor - 3:34
07. Saving a macro enabled workbook - 2:14
08. Writing first macro in the VBA editor - 11:15
Left And Top Properties Of Shape
09. Range property - 3:38
10. Cells property - 3:36
11. What is a variable? - 5:27
Variables
12. Write your first animation macro/VBA codes - 11:56
First Animation Code
13. Visible property of shapes in VBA - 4:07
Variables
14. IF function-Logical function - 8:35
I Ffunctions
15. Different ways to run a macro - 17:20
First Animation Code
16. Recording macros to get codes generated by Excel and understand them - 15:03
SECTION 04 For Loop Animation
17. For loop Animation - 13:04
For Loop Animation Start
For Loop Animation End
SECTION 05 Creating a sliding down menu
18. Sliding down menu part 1 - 3:38
SlideDownMenu_Start.xlsm
SlideDownMenuEnd.xlsm
19. Sliding down menu part 2 - 11:46
SlideDownMenu_Start.xlsm
SlideDownMenuEnd.xlsm
SECTION 06 Creating a clock animation with rotation property of shapes
20. Creating an animated clock part 1 - 9:50
Rotation Animation Start
simpleClock Anim_End.xlsm
21. Creating an animated clock part 2 - 12:52
Rotation Animation Start
Rotation Animation End
SECTION 07 Immediate Window view workflow - Very important
22. Immediate window - very important - 9:44
imediate window find shape positions,properties states.xlsm
23. Bouncing animation effect - 13:57
imediate window find shape positions,properties states.xlsm
SECTION 08 ZOrder of shape and Mouse Hover animation tricks
24. ZOrder of shape animation Part 1 - 4:27
zOrder of Shap anim_start.xlsm
zOrder of Shap anim.xlsm
25. ZOrder of shape animation Part 2 - 15:18
26. Mouse hover animation - 12:18
Mouse hover anim.xlsm
Mouse Hover Anim_Start.xlsm
27. Web style icon animation Part 1 - 3:45
icon anim Mouse Hover_Start.xlsm
icon anim Mouse Hover_End.xlsm
28. Web style icon animation Part 2 - 6:54
SECTION 09 Robot Arm animation
29. Robot arm animation part 1 - 6:58
RobotArmAnim_Start.xlsm
RobotArmAnim_End.xlsm
30. Robot arm animation part 2 - 14:23
SECTION 10 Progressive circle animation utilizing a Doughnut chart trick
31. Progressive circle animation Part 1 - 1:54
ProgressiveCircle_End.xlsm
ProgressiveCircle_Start.xlsm
32. Progressive circle animation Part 2 - 8:01
33. Progressive circle animation Part 3 - 12:46
SECTION 11 Splash screen animation
34. Aspect ratio - 6:55
Aspect Ratio.xlsm
35. Splash screen animation part 1 - 3:14
SplashScreenAnim_Start.xlsm
SplashScreenAnim_End.xlsm
36. Splash screen animation part 2 - 14:03
Splash Screen Start
37. Splash screen animation part 3 - 11:52
Splash Screen Start
38. Splash screen animation part 4 - 8:47
39. Splash screen animation part 5 - 7:30
40. Animated password access Splash Screen-Part 1 - 4:39
SecurityWallAnim_End.xlsm
SecurityWallAnim_Start.xlsm
41. Animated password access Splash Screen-Part 2 - 18:07
42. Animated password access Splash Screen-Part 3 - 15:46
43. Animated password access Splash Screen-Part 4 - 13:29
44. Animated password access Splash Screen-Part 5 - 7:36
45. Shape adjustment animation part 1 - 4:28
46. Shape adjustment animation part 2 - 13:51
47. Shape adjustment animation part 3 - 14:12
48. Shape adjustment animation part 4 - 17:56
49. Loading effect animated splash screen Part 1 - 2:31
50. Loading effect animated splash screen Part 2 - 19:26
SECTION 12 Typography Animation
51. Text animation - Typing effect Part 1 - 5:10
52. Text animation - Typing effect Part 2 - 7:22
SECTION 13 ThreeD camera animation
53. ThreeD camera animation part 1 - 5:03
Three D Camera Anim Start
54. ThreeD camera animation part 2 - 6:29
Three D Camera Anim End
Three D Camera Anim Start
SECTION 14 Bonus lessons on animation tricks
55. Sci-fi style animated splash screen Part 1 - 4:50
hexagoneMenu _Start.xlsm
hexagoneMenu_End.xlsm
56. Sci-fi style animated splash screen Part 2 - 11:05
57. Sci-fi style animated splash screen Part 3 - 3:24
58. Speedometer chart animation - 15:30
59. Button animation : Mouse over sweeping effect - 14:11
scalingBtnAnim.xlsm
60. Shape animations in After effects style Part 1 - 5:20
61. Shape animations in After effects style Part 2 - 11:39
62. Web style mouse hover animated menus part 1 - 4:35
WebStyle menu1_End.xlsm
WebStyle menu1_start.xlsm
63. Web style mouse hover animated menus part 2 - 23:46
64. Web style mouse hover animated menus part 3 - 10:17
65. Web style mouse hover animated menus part 4 - 12:34
66. Web style mouse hover animated menus part 5 - 6:06
67. Calendar flip animation 3D effect part 1 - 3:45
CalendarAnim_End.xlsm
CalendarAnim_Start.xlsm
68. Calendar flip animation 3D effect part 2 - 13:13
69. Calendar flip animation 3D effect part 3 - 11:56
70. Calendar flip animation 3D effect part 4 - 6:46
SECTION 15 Chart animation for killer dashboards
71. Bar graph animation Part 1 - 2:18
ColumnGraphAnimation_End.xlsm
ColumnGraphAnimation_Start.xlsm
72. Bar graph animation Part 2 - 10:52
73. Bar graph animation Part 3 - 8:00
74. Line graph animation Part 1 - 1:26
lineGraphAnimV1_End.xlsm
lineGraphAnimV1_Start.xlsm
75. Line graph animation Part 2 - 10:52
76. Line graph animation Part 3 - 6:08
77. Progressive line graph animation Part 1 - 4:49
Progressive lineChartAnim_End.xlsm
78. Progressive line graph animation Part 2 - 16:02
79. Progressive line graph animation Part 3 - 18:56
80. Progressive line graph animation Part 4 - 9:20
81. Pie chart animation part 1 - 2:39
PieChartAnim_end.xlsm
PieChartAnim_Start.xlsm
82. Pie chart animation part 2 - 9:25
83. Pie chart animation part 3 - 5:11
84. Pie chart animation part 4 - 11:14
85. Doughnut chart animation part 1 - 2:32
DoughnutChartAnim_End.xlsm
DoughnutChartAnim_Start.xlsm
86. Doughnut chart animation part 2 - 11:44
87. Doughnut chart animation part 3 - 15:35
88. Doughnut chart animation part 4 - 13:25
89. Doughnut chart animation part 5 - 17:32
|
|