Looking for a Tutor Near You?

Post Learning Requirement » x
Ask a Question
x

Choose Country Code

x

Direction

x

Ask a Question

x

Hire a Tutor
Dubai

Presentation On Advanced Excel , Power Query, Power BI , Macros And VBA

Home > PowerPoint Slides > Presentation On Advanced Excel , Power Query, Power BI , Macros And VBA
Published in: Computer
650 Views

Become an Excel Expert , with Excel, Macros , VBA, Power Point, Power Query, Power BI

Mohammed M / Dubai

12 years of teaching experience

Qualification: MBA

Teaches: Sales Training, Education, Advanced Excel, Programming Technology

Contact this Tutor
  1. E Master Business Analytics in EXCEL Myexcelacademy Course design by Mohammed Mustafa
  2. E Message from me... Mohammed Mustafa I designed this course keeping in mind the employee struggling to hone their Excel skills and gain more proficiency in data analysis using various methods and tools like Excel, Power Query & Power BI. I hope that you will enjoy this course and gain insights and harness the ideas using formulas, pivot tables, macros , animation using VBA, data manipulation with Power Query and visualization using Power BI. macro dax anmiation sumproduct number large small sumifs sumif countif date function wildcards slicer subtotal iferror text excel shortcuts counta maxifs solver conditional formatting row power bi named range ed ate power query indirect pivot table advanced filter vlookup getpivot index data validation offset match countifs form control nestedformulas eomonth max
  3. Summarizing data using Pivot tables Use macros with Pivot tables Getpivot formula Multiple Filter pages Adding and using Slicers
  4. Building a Dashboard Using Dynamic Date Ranges Using form controls Using macros to update Use of Conditional Formatting Custom Number formatting
  5. Recording Macros Understanding Range object Understanding variables Using aggregation in VBA Using shapes in VBA Creating a summary report in VBA
  6. Importing data into Power Query Merging query connections Combining multiple files Multiple case studies Using Parameters in Power Query
  7. Using form controls for the setup Using named ranges Create animation effect Animating the chart in Excel Animating 2 series together using VBA
  8. The Future - Power BI Intro to Power BI Key Pillars of Power BI Writing Dax calculations Time intelligence functions Custom visuals, Custom tool tips
  9. OFFSET EDATE & SORT & SORT BY z O FORM CONTROLS VLOOKUP XLOOKUP EXCEL SHORTCUTS COUNTA INDIRECT POWER Bl IFERROR DC APDS ADVANCED SUMIFS FILTER SUMIF MACROS MATCH ROW SMALL DAX COUNT IF OFFICE 365 FUNCTIONS EXCEL SOLVER SUBTOTAL ANIMATION LARGE FILTER TEXT UNIQUE rF GETPIVOT INDEX MAX DATE POWER QUERY FUNCTIONS TEXT FUNCTIONS Course design by Mohammed Mustafa

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related PPTs

Upload PPTs

If you have your own PowerPoint Presentations which you think can benefit others, please upload on MyPrivateTutor. For each approved PPT you will get 50 Credit Points and 50 Activity Score which will increase your profile visibility.

Upload Now