오디오북 라이프의 시작

격이 다른 오디오북 생활을 경험해보세요!

  • 언제든 손쉽게 구독해지 가능
  • 월정액 11900원 부터
  • 무제한 청취
  • 총 5만권 이상의 영/한 오디오북
  • 온가족을 위한 다양한 오디오북
지금 바로 시작해보세요!
kr all devices
Cover for Learn Excel in 24 Hours

Learn Excel in 24 Hours

2 평가

3.5

언어학습
영어
형식
컬렉션

논픽션

Learn to automate Excel using VBA (Visual Basic for Applications)

VBA is a event driven programming language and you can program any actions that you would do manually in an Excel.

You can automate Excel using VBA to pull data from multiple sources, process data, generate reports and graphs and so much more. Called as Macros they help automate repetitive task.

Here is what is included-

Table Of Content

Chapter 1: Introduction to Macros in Excel

What is a macro?

The importance of macros in Excel

What is VBA in a layman's language?

Macro Basics Step by step example of recording macros in Excel

Enable Developer Option

Chapter 2: Your Fist VBA in Excel

What is VBA?

Why VBA?

Personal & business applications of VBA in excel

Visual Basic for Applications VBA basics

Enable Developer Option

Step by step example of creating a simple EMI calculator in Excel

Chapter 3: VBA Data Types, Variables & Constant

VBA Variables

Excel VBA Data-Types

Constant in VBA

Chapter 4: VBA Arrays

What is an Array?

What are Advantages of arrays?

Types of arrays

VBA Array Demonstrated with Example

Testing our application

Chapter 5: VBA Excel Form Control & Activex Control

Creating VBA Form/GUI controls in Excel

How to use ActiveX control in VBA

Prerequisite

Chapter 6: VBA Arithmetic Operators

Chapter 7: VBA String Operators

Chapter 8: VBA Comparison Operators

Chapter 9: VBA Logical Operators

Chapter 10: Excel VBA Call a Subroutine

What is Subroutine?

Why use subroutines

Rules of naming subroutines and functions

Subroutine practical example

Chapter 11: Excel VBA Function Tutorial: Return, Call, Examples

Chapter 12: VBA Range Objects

What is VBA Range?

Introduction to Referencing Objects in VBA

How to refer to Excel VBA Range Object using Range property

Refer to a Single cell using the Worksheet.Range Property

Cell Property

Range Offset property

© 2021 PublishDrive (전자책): 6610000317431

출시일

전자책: 2021년 11월 12일

다른 사람들도 즐겼습니다 ...

  1. Grow Your Money Online Bundle, 2 in 1 Bundle: Money-Making Hacks and Money Making Ideas
    Grow Your Money Online Bundle, 2 in 1 Bundle: Money-Making Hacks and Money Making Ideas C.M. Smith
  2. Summary of Harry Lorayne's Ageless Memory
    Summary of Harry Lorayne's Ageless Memory IRB Media
  3. How To Read People Like A Book: Communication & Social Skills Training - How You Can Analyze People, Understand Body Language, Master Small Talk & Connect Effortlessly
    How To Read People Like A Book: Communication & Social Skills Training - How You Can Analyze People, Understand Body Language, Master Small Talk & Connect Effortlessly Sarah Evanson
  4. Are You Listening: Maximize Your Listening Skills & Get People to Hear YOU!
    Are You Listening: Maximize Your Listening Skills & Get People to Hear YOU! Marsha Sue Petrie
  5. Summary of The Sleep Revolution: by Arianna Huffington | Includes Analysis: by Arianna Huffington | Includes Analysis
    Summary of The Sleep Revolution: by Arianna Huffington | Includes Analysis: by Arianna Huffington | Includes Analysis IRB Media
  6. The Book of Decision: Living in the Light of Reason
    The Book of Decision: Living in the Light of Reason Arcturus Publishing
  7. Positive Life Answers: Overcoming Obstacles to Achieving Your Vision & Goals
    Positive Life Answers: Overcoming Obstacles to Achieving Your Vision & Goals Dr. Mary Ann Mercer
  8. Plant Based Smoothie Recipes : 2 Pack - Avocado & Spicy Anti – Inflammatory Smoothies
    Plant Based Smoothie Recipes : 2 Pack - Avocado & Spicy Anti – Inflammatory Smoothies Melody Rayne
  9. Motivated to Learn: How to motivate yourself for learning, make starting to learn easier and keep motivation to learn
    Motivated to Learn: How to motivate yourself for learning, make starting to learn easier and keep motivation to learn David Velthuis
  10. Robert's Rules of Order: A Comprehensive Guide to Robert’s Rules of Order
    Robert's Rules of Order: A Comprehensive Guide to Robert’s Rules of Order John Cummings
  11. Public Speaking Extraordinaire - Unlock an Abundance of Opportunities: Master Public Speaking and Become A Sought After Expert and Leader in Your Industry
    Public Speaking Extraordinaire - Unlock an Abundance of Opportunities: Master Public Speaking and Become A Sought After Expert and Leader in Your Industry Empowered Living
  12. How to Get a Job Quickly in Linkedin
    How to Get a Job Quickly in Linkedin MAX EDITORIAL
  13. Summary: High Performance Habits: How Extraordinary People Become That Way by Brendan Burchard: Key Takeaways, Summary & Analysis
    Summary: High Performance Habits: How Extraordinary People Become That Way by Brendan Burchard: Key Takeaways, Summary & Analysis Brooks Bryant
  14. Stretching Your Way to a Pain-Free Life: Illustrated Stretches for Sports, Medical Conditions and Specific Muscle Groups
    Stretching Your Way to a Pain-Free Life: Illustrated Stretches for Sports, Medical Conditions and Specific Muscle Groups Aaron Taylor
  15. IMPROVE COMMUNICATION SKILLS: Discover the Power of Clear, Confident, and Effective Communication in All Areas of Your Life (2023 Guide for Beginners)
    IMPROVE COMMUNICATION SKILLS: Discover the Power of Clear, Confident, and Effective Communication in All Areas of Your Life (2023 Guide for Beginners) Hazel Robinett
  16. Top 5 Modern Diets to Improve your Health, Wealth, and Consciousness: Mediterranean, Ketogenic, Vegetarian, Vegan, Paleo Diets with Meal Pans and Shopping Lists: Mediterranean, Ketogenic, Vegetarian, Vegan, Paleo Diets with Meal Pans and Shopping Lists
    Top 5 Modern Diets to Improve your Health, Wealth, and Consciousness: Mediterranean, Ketogenic, Vegetarian, Vegan, Paleo Diets with Meal Pans and Shopping Lists: Mediterranean, Ketogenic, Vegetarian, Vegan, Paleo Diets with Meal Pans and Shopping Lists Nelly Greenleaf
  17. Secrets of the Permafree Book: How to Publish a Free Book on Amazon
    Secrets of the Permafree Book: How to Publish a Free Book on Amazon Dale L. Roberts
  18. Small Talk: A Shy Introverts Guide to Being More Likeable and Building Better Relationships, Even If You Have Social Anxiety, Including Conversation Starters and Tips for Improving Your Social Skills
    Small Talk: A Shy Introverts Guide to Being More Likeable and Building Better Relationships, Even If You Have Social Anxiety, Including Conversation Starters and Tips for Improving Your Social Skills Matt Holden
  19. Our Learning Brain: Engaging Your Brain for Learning & Habit Change (#1 in the MAXIMISING BRAIN POTENTIAL series)
    Our Learning Brain: Engaging Your Brain for Learning & Habit Change (#1 in the MAXIMISING BRAIN POTENTIAL series) Celine Mullins
  20. Lessons From 21 Films
    Lessons From 21 Films M.H.Abou-Zaki
  21. Speed Reading Secrets: Techniques to Read Faster and Retain More
    Speed Reading Secrets: Techniques to Read Faster and Retain More Lucas Adams
  22. Crush Your Job Interviews: Time to Shine. Show What You Are Worth, Eliminate Anxiety and Ace that Interview. Includes Expert Tricks to Navigating the Most Difficult Interview Questions of All-Time
    Crush Your Job Interviews: Time to Shine. Show What You Are Worth, Eliminate Anxiety and Ace that Interview. Includes Expert Tricks to Navigating the Most Difficult Interview Questions of All-Time Ray Black
  23. Accelerated Learning with Emotional Intelligence: Master Emotional Agility to Use Advanced Learning Strategies to Speed Reading, Memory Improvement, Greater Retention and Systematic Expertise
    Accelerated Learning with Emotional Intelligence: Master Emotional Agility to Use Advanced Learning Strategies to Speed Reading, Memory Improvement, Greater Retention and Systematic Expertise Mary L. Poulsen
  24. How to Make Friends & Improve Your Social Skills: Be More Comfortable Talking To Anyone, Develop Effective Communication and Master Conversations to Expand Your Social Circle as an Introverted Adult.
    How to Make Friends & Improve Your Social Skills: Be More Comfortable Talking To Anyone, Develop Effective Communication and Master Conversations to Expand Your Social Circle as an Introverted Adult. Sebastian Mills
  25. Summary of Strong Looks Better Naked: by Khloé Kardashian | Includes Analysis: by Khloé Kardashian | Includes Analysis
    Summary of Strong Looks Better Naked: by Khloé Kardashian | Includes Analysis: by Khloé Kardashian | Includes Analysis IRB Media
  26. Building Mental Strength For Success: A Powerful Book To Activate Winning Mindset, Boost Confidence, Conquer Challenges And Become Mega Successful In Life
    Building Mental Strength For Success: A Powerful Book To Activate Winning Mindset, Boost Confidence, Conquer Challenges And Become Mega Successful In Life Pradip N Das
  27. Influence People + Self-Esteem 2-in-1 Book: : Master the Art of Persuasion and get What you Want & Give Your Self-Esteem a Push with 3,867 Motivational Affirmations and Positive Daily Quotes
    Influence People + Self-Esteem 2-in-1 Book: : Master the Art of Persuasion and get What you Want & Give Your Self-Esteem a Push with 3,867 Motivational Affirmations and Positive Daily Quotes Marshall Noble
  28. You: Breathing Easy: Breath Awareness
    You: Breathing Easy: Breath Awareness Michael F. Roizen
  29. Daily Self-Discipline: The Power of Focus - Beat Procrastination with Daily Habits
    Daily Self-Discipline: The Power of Focus - Beat Procrastination with Daily Habits Dale Clear
  30. Stress Relief: How to Identify and Manage Anxiety and Stress
    Stress Relief: How to Identify and Manage Anxiety and Stress Jimmy Fellon

언제 어디서나 스토리텔

  • 국내 유일 해리포터 시리즈 오디오북

  • 5만권이상의 영어/한국어 오디오북

  • 키즈 모드(어린이 안전 환경)

  • 월정액 무제한 청취

  • 언제든 취소 및 해지 가능

  • 오프라인 액세스를 위한 도서 다운로드

인기

스토리텔 언리미티드

5만권 이상의 영어, 한국어 오디오북을 무제한 들어보세요

11900 원 /월

  • 사용자 1인

  • 무제한 청취

  • 언제든 해지하실 수 있어요

지금 바로 시작하기

패밀리

친구 또는 가족과 함께 오디오북을 즐기고 싶은 분들을 위해

매달 17900 원 원 부터

  • 2-3 계정

  • 무제한 청취

  • 언제든 해지하실 수 있어요

본인 + 1 가족 구성원2 개 계정

17900 원 /월

지금 바로 시작하기