Publisher's Synopsis
Do you feel intimidated by how complex Excel can seem? Confused by VBA Programming?
I know how you feel but keep on reading if you want to know how to overcome this....Did you know that up to 78% of middle-skill jobs require applicants to be proficient in MS Excel? It is shown that those who were able to prove their mastery of the program were set to receive up to 30% more than their peers. But there's far more to Excel than just being a potent addition to your resume.
Excel is essentially one of the most powerful software tools for collecting and analysing data when used to its full potential. But all too often you may not be making the most of what excel has to offer.
It is estimated that on average people only use 20% of functions available on excel because they are unaware of what each button and function does, are you part of the average? Well go beyond being average and learn new skills that will set you apart from the rest.
Whether you want to enhance your productivity at work, in business or use it as a tool to help you organise your personal finances this is for you.
Book 1) For Beginners
- Reasons why excel is and will continue to be one of the most important software tools to get ahead in your career and personal finance.
- How to navigate around the Excel interface
- An in-depth look at formulas and functionsand when to use them
- Essential terms and vocabulary you must be familiar with in order to become a fluent excel user
- Sorting and filtering data.Common mistakes that users make when using this function and how this could be used more efficiently.
- Amazing charts and reportsis the best way of presenting data. We will take a look at how to create charts and reports that can be used in meetings or present your monthly income and expenditure.
- Learn simple techniques to get your data message across clearly by making your worksheet presentable and less intimidating to others at work.
- Pivot tables.What are they and the advantages of them over other excel functions with examples and exercises on how and when to use them
- What are Macros? This will be explained with examples of how and when they are used in excel?
- How are macros created? This leads to introducing what VBA programmingis
- What you can use Visual Basic Application and will go into detail how VBA can help automate documents such as word processing.
- How to navigate your way around an IDE (Integrated Development Environment)and what each window represents.
- Clear steps on how to write a programand the 5 important questions you must think about before you start to write.
- The syntax and the structure you must follow when writing code in VBA.
- How to use the macro recorder and it's importance when performing tasks.
- The four decision-making and Loop statementsthat VBA programming uses
- What arrays are and how could we use this in VBA programming
- What the user interface is and how to design a form. This shows clear illustrations on how to create this.
