Expert @ Excel: VBA Programming and Power Bi: Step-By-Step Guide to Learn and Master Pivot Tables and VBA Programming to Get Ahead @ W
Reed, Daniel
相關主題
商品描述
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:
2 Books in 1 has to offer
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