What are some great resources to learn VBA for MS Access and Excel?

Asked by Last Modified  

3 Answers

+2 Basic Excel Advanced Excel

Follow 3
Answer

Please enter your answer

Ok if one is using Excel, you might focus on Excel + Microsoft SQL Server Express instead of VBA + Access. Both Access and AQL Server are databases, but Access has an engine to develop forms and reports if it was for Excel that may be preferred front end instead of Access. To focus on the core of Excel...
read more
Ok if one is using Excel, you might focus on Excel + Microsoft SQL Server Express instead of VBA + Access. Both Access and AQL Server are databases, but Access has an engine to develop forms and reports if it was for Excel that may be preferred front end instead of Access. To focus on the core of Excel VBA without having lots of chapters on fewer core topics, a book called "Excel 2003 Power programming" would be beneficial. After this, to get an excellent overview of best practices, Bullen, Bovey and Green's "Professional Excel Development" will be like the bible. So, after this, you will have a framework to dive either into programming for particular applications or particular features like programming charts. Hope this helps read less
Comments
Dislike Bookmark

Tutor

Excelforum.com is one of nice support site for your mixed questions.
Comments
Dislike Bookmark

Practice Lead in Digital Marketing (Manager)

If you want practical knowledge then Join professionals rather an institute, I give advance excel and VBA Process Automation training
Comments
Dislike Bookmark

View 1 more Answers

Related Questions

How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Dhanshri
1 0
7
Use of INDEX in MS Excel?
INDEX function is a powerful tool that allows you to retrieve values from a specified range or array based on row and column numbers. INDEX(array, row_num, ) As it requires row_num and column_num, it is...
Prabhakar
0 0
6
I need excel analysis like a professional ..... Plz help
Hi Ohid, call me
Ohid
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Poojashree
0 0
5
I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.
As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like -...
Francis
0 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Hidden Gems Of MS Excel - Auto Fill: Only Weekdays OR Only Months OR Only Years
Fill dates Automatically in worksheet cells. The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known. 3rd format - Only Weekdays 4th format - Only Months* 5th...

Ankur Sharma

3 0
0
Coaching on Microsoft Excel
Are you excited to enhance your data management skills and increase your productivity? Contact me directly in chat for instruction on essential tools and techniques to take your Microsoft Excel skills...

Vidhya Srinivasan

0 0
0
Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

Ankur Sharma

2 0
0
Top 30 formulas in Excel
Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite. Vlookup If Iferror Sum Count Sumif Countif CountA Index Match Left Right Mid Tri...

Vikas Chauhan

0 0
1
Multiple rows selections
G

Gagan G.

0 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you