Menu

Power Pivot

Excel Pivot Tables Worksho

Excel Basic Course

  1. Understanding Pivot Tables
  2. Source data for Pivot Table reports
  3. Creating Worksheet Lists
  4. Using Names
  5. Create A Name
  6. Using a Name in a Formula
  7. Creating Names for a Multiple Rows or Columns
  8. Creating Names for a Value or Formula
  9. Creating a Pivot Table
  10. Pivot Table Field List
  11. Pivot Table Tools
  12. Rearranging the Pivot Table
  13. Changing the Report Field Titles
  14. Formatting Data Fields
  15. Using the Report Filter
  16. Displaying Filtered Fields on Separate Worksheets
  17. Formatting the Pivot Table
  18. Sorting Data
  19. Removing Data
  20. Refreshing Data
  21. Using Formulas Functions
  22. Create a Calculated Field
  23. Add or remove subtotals in a Pivot Table report
  24. Display Or Hide Details
  25. Working with Multiple Data Ranges
  26. Setting up the source data
  27. Creating PivotCharts
  28. Creating the Chart
  29. Chart Tools
  30. Using Pivot Table Data Outside The Pivot Table Report
  31. Create relationships between data from different sources,
  32. Creating a Pivot Table from a Database
  33. Databases you can access
  34. Using Microsoft Query
  35. Microsoft Query Toolbar
  36. Returning Data to Excel
  37. Publishing an Excel Workbook
  38. When to Use Excel Services

    PowerPivot For Excel

    One Day Workshhop

    1. Explore the PowerPivot Application
    2. Accessing the Power Pivot add-in
    3. Navigating the interface
    4. Working with Data
    5. Import Data from Various Data Sources
    6. Refresh Data from a Data Source
    7. Manage Data Model
    8. Create Relationships
    9. Manipulating PowerPivot Data
    10. Sort and Filter PowerPivot Data
    11. Working with Tables
    12. Create Linked Tables
    13. Organize and Format Tables
    14. Create Calculated Columns
    15. Extract Data from Tables Using Functions
    16. Create and Manage Table Relationships
    17. Creating PowerPivot Reports
    18. Using DAX Functions in PowerPivot
    19. Manipulate PowerPivot Data Using DAX Function​
    20.  Key Performance Indicators (KPI)

<iframe width=”311″ height=”260″ src=”https://www.youtube.com/embed/qlmEMJU3VHo” frameborder=”0″ allow=”autoplay; encrypted-media” allowfullscreen></iframe>