- Duration: 1 Hour
Course details
PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.
- use calculations in PivotTable reports
- filter data in PivotTable reports
- create and use slicers
- identify the functions of elements of the PowerPivot interface
- identify the features of PowerPivot for Excel add-in
- change functions in PivotTable reports
- create your own formula in a PivotTable report
- enable multiple filters and apply a Report filter
- use slicers to filter data in a PivotTable report
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.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel : Top 50 Formulas Course LineAED 88
AED 1,763Duration: Upto 1 Hour - Microsoft Excel : Top 50 Formulas Course CentralAED 84
AED 367Duration: Upto 1 Hour