Be Super Efficient using simple Automation techniques

Be Super Efficient using simple Automation techniques of Excel to reduce time and effort.
5.0 (1 rating)
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.
435 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 17
  • Length 2.5 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 9/2015 English

Course Description

Understanding the Development environment would be one of the prime takeaways. The automation is as quick as a fairy's magic wand, you think and it is done for you.

This course talks about the automations and time saving techniques leading to error free and diligent results. The industries and functional specializations such as Information Technology, Administration, accounting, Finance, Marketing, Operations, Human Resource Management, Health care benefit the most by using Excel.

We can explore the Developer Ribbon of Excel, record simple macros, appreciate the components of VBA Integrated Development Environment, rectify recorded macros and understand basic data types.

What are the requirements?

  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment

What am I going to get from this course?

  • Explore the Developer Ribbon of Excel
  • Record simple macros
  • Appreciate the components of VBA Integrated Development Environment
  • Rectify recorded macros
  • Understand basic data types, operators

What is the target audience?

  • Anyone who uses MS Excel as part of their job or profession can choose this course to get a hold of Lookup functions and increase their productivity
  • There is no eligibility Criteria

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: Course Introduction
Course Introduction
Preview
02:35
Section 2: Introduction and classification of Macros
Introduction and classification of Macros
Preview
04:51
Section 3: Exploring the Developer Ribbon
Exploring the Developer Ribbon
Preview
04:15
Section 4: Recording simple Macros
Recording Simple Macros Part 1
17:28
Recording Simple Macros Part 2
11:23
Section 5: Overview VBA IDE - components and features
Overview VBA IDE - components and features Part 1
13:45
Overview VBA IDE - components and features Part 2
07:47
Section 6: Exploring VBA Editor - Modules, functions and Expressions
Exploring VBA Editor
12:17
Section 7: Rectifying recorded Macros
Rectifying recorded Macros
Preview
18:16
Section 8: Coding simple Sub Procedures in VBA
Coding simple Sub Procedures in VBA Part 1
15:36
Coding simple Sub Procedures in VBA Part 2
08:25
Section 9: Understanding basic data types, operators, and data handling methods
Understanding basic data types, operators, and data handling methods
Preview
13:03
Section 10: Additional Material
Additional Material 1
1 page
Additional Material 2
5 pages
Section 11: Exercises
Exercises
1 page
Section 12: Practice test
Practice test 1
20 questions
Practice test 2
20 questions
Section 13: Course Conclusion
Review Appreciated
Article
Quick Bonus for You!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course