Publisher's Synopsis
Do you want to take your Excel skills to the next level?
Whether you want to enhance your productivity at work, in business or harness new skills Expert @ Excel: VBA Programming & Power BI is for you.
Topics Covered In This Book Include:
Book 1) VBA Programming
- What you can use Visual Basic Application and will go into detail how VBA can help automate documentssuch 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 syntaxand the structureyou must follow when writing code in VBA.
- How to use the macro recorder and it'simportance when performing tasks.
- The four decision-making andLoop statements that VBA programming uses
Book 2) Power BI
- How to navigate around the Power BI Desktopand the interface of the data model
- Understand the different views, Data model and Query Editorinterface
- Learn how to use Query editor improving performance and loading data into the data model.
- How to perform basic mathematical operations
- The difference between the M-language(Query editor) and DAX(Data model)
- Understand how to work in the report view to visual results and learn how to create your first visualisationsinterface
- Access your results from different devices through Power BI Mobile.
- How to custom visuals work when using Power BI for developers
- Include End of Chapter ExercisesThat Will Test Your Newly Acquired knowledge with answers included.
- Any much much more..........
2 Books in 1 has to offer!