Dynamic filter table cá¡lculo operations and PowerPivot in Excel 2010 New Horizons Lebanon
Price: TBA
  • Duration: 1 Hour

Course details

The Dynamic tables are A handy tool for summarizing large amounts of data efficiently and facilitate its handling. However, it is sometimes useful to filter the data in a dynamic table and Excel 2010 provides filtering functionality for this specific purpose. For those who need a more visual representation of data, Excel 2010 provides a new feature called segmentation data, which is basically one graphical representation of a dynamic filter table. Excel also © n offers various ways that can be applied to operations cá¡lculo Dynamic data tables using summary functions and operations of custom cá¡lculo. This course presents and describes all these Useful features in Excel 2010.

  • cá¡lculo operations used in dynamic table reports
  • filter data in dynamic table reports
  • creating and using Slicers
  • identify the functions of the interface elements PowerPivot
  • identify the functions of the PowerPivot for Excel
  • change the functions in dynamic table reports
  • create your own formula in a dynamic report table
  • enable multiple filters and apply a report filter
  • Slicers used to filter data from a report dynamic table
Updated on 08 November, 2015

About New Horizons Lebanon

As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.

See all New Horizons Lebanon courses
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or