課程介紹

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you w

…[更多細節]

哪些人適合這堂課？

• This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

學習目標

• Learn how to automate daily routine tasks within Excel
• Learn best practices when creating macros and streamline your VBA code
• Determine when it’s best to use the Macro Recorder versus VBA
• Learn how to write custom VBA Macros to create more robust automation
• Learn VBA programming concepts to create dynamic, re-usable code
• Complete real world Macro/VBA projects from beginning to end

課程介紹

If you already use Excel, you know how repetitive and time consuming some tasks can be. This course is designed to teach you how to take those repetitive and time consuming Excel tasks, and make them happen in a click of a button! If you use Excel a

…[更多細節]

哪些人適合這堂課？

• This course is meant for people who know how to use the basic features of Excel and want to unlock it’s true power.

學習目標

• Automate your Excel workload
• Impress your boss with your Excel wizardry!
• Build your Resume by adding Excel Programming to your Skills

課程介紹

This course is an Introduction to VBA & Macros in excel.

In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs.

As always, to make things easier we have included links

…[更多細節]

哪些人適合這堂課？

• Some knowledge of excel and its features will make it easier for you to follow this course

學習目標

• By the end of this course, you will be able to write programs to customise Excel.

課程介紹

COMPLETELY REDONE ON SEPTEMBER 2020 WITH NEW VIDEOS!

Become a proficient Excel Macros & VBA Programmer in a very short time.

Excel VBA is powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Exce

…[更多細節]

哪些人適合這堂課？

• All Excel users who have always been interested in macros but have never found a good resource to learn them
• Individuals who wish to turn Microsoft Excel into a powerful tool in their daily work
• Students with willingness for learning
• Business Professionals and Entrepreneurs

學習目標

• Create and Modify Macros in Excel
• Understand VBA and create your first piece of code
• The course is full of code examples that you can use straight away
• Become a proficient Excel Macro Programmer in a very short time
• Know the difference between Macros and VBA
• Choose the right Loop for each task
• Learn Automation secrets in Excel VBA
• Follow along with included Excel project files
• Learn from an instructor with over 16 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
• Learn the most current version of Microsoft Excel
• Course updated regularly
• An instructor ready to answer your questions in less than 24 hours
• Watch high-quality video lectures with lifetime access
• Quizzes and exercises
• Certificate of completion

課程介紹

Are you tired of the same long, boring days creating dashboards, charts and Vlookups while barely having time to do anything else?

Wouldn’t it be cool if you could automate all these tasks, spend less time in front of the computer and more time adva

…[更多細節]

哪些人適合這堂課？

• Anybody that is adept at Excel and wants to learn automation
• People that want to Excel at the workplace and become an authority in this field
• Individuals that love programming and automating tasks & work consistently in Excel

學習目標

• Understand how to make Excel work for them, rather than spending time on the same manual tasks
• Master Excel programming through practice – there are 9 distinct code sequences that they will write
• Build their first macro and run a macro using a button
• Create user-friendly auto-filters by writing code
• Manipulate Excel Comments with VBA
• Build interactive charts with drop-down menus for a more user-friendly Excel experience
• Automatically send emails via Excel and avoid the manual work of reporting

課程介紹

The objective of this course is to make you expert in writing own macros code Exclusive for Report Automation. 

If you see the course outline its all practical topics and only those codes has been taught which is regularly used in the report automat

…[更多細節]

哪些人適合這堂課？

• Those interested in learning Excel Macros to Automate Regular reports
• Finance Professionals
• Marketing Executives
• Admin
• HR Professionals
• Project Co-ordinators
• Account Professionals

學習目標

• 1) Macros Recording & Running and will start with Basic Codings
• 2) You will learn how to Consolidate Multiple Sheets into one
• 3) Filtering Project : Where you will learn to create Seperate Sheet for each Filtered items with Simple Coding
• 4) You will also learn how to Implement IF Condition with Macros (VBA)
• 5) Consolidation Project : You will learn how to write the Code to Consolidate Multiple Sheets of Multiple Files

課程介紹

Do you have an intermediate understanding of Excel but are keen to break through to true mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

With this course you will learn how to create an

…[更多細節]

哪些人適合這堂課？

• Our Advanced Excel course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

學習目標

• Create complicated, problem-solving formulas with advanced logic, master Pivot Tables, automate complex tasks and much more…

課程介紹

This course focuses on how to record and re-use Macros in Excel without programming skills. You’ll learn to work in Excel’s Developer Tab and learn where macros are stored. You look at the differences between absolute and relative macros and how to m

…[更多細節]

哪些人適合這堂課？

• If you are an extensive user of Excel, have completed Excel Level 3 – Advanced, and use the programme daily for completing repetitive tasks, then this course is ideal for you. Completing this course will save you many hours at work through the automation of tasks.

學習目標

• This course will help you learn how to work with and manipulate Macros recorded in Excel. It will introduce you to the VBA Development environment to make basic alterations to recorded Macros. The course also provides examples of useful recorded Macros.

課程介紹

This course is designed in a way to first explain some basic theory about macros and then to explain and show the most important aspects of Macros in Excel. We will not go into the depths, we will cover only the basic aspects which are needed to star

…[更多細節]

哪些人適合這堂課？

• This course is for Microsoft Excel users, who want to automate their repetitive tasks in Excel.

學習目標

• Record, edit and debug a macro in Microsoft Excel

課程介紹

You don’t have to be a programmer to start using the basics of Excel Macros. Excel makes it easy to identify your list of actions and automate them with buttons and/or shortcut keystrokes. 

This video lecture covers all the basics of Macros in Excel

…[更多細節]

哪些人適合這堂課？

• Anyone who wants to learn how to create macros in Excel

學習目標

• Create simple to intermediate complex macros
• Create custom macro buttons
• Modify macros
• Create Quick Access Toolbar buttons for macros
• Learn how macros can be universal or specific to certain cells
• Learn to avoid problems with macros
• Create shortcut keys to macros
• VBA Macro Basics