Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

3m

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

6m

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

9m

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

How to Add Slicers

MS Excel in Bangla Pivot Table

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

3m

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

6m

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

9m

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

FAQs

Select Insert > Slicer from the Home tab. Select the check boxes for the fields you want to display in the Insert Slicers dialogue box, then click OK. For each field you select, a slicer will be produced. Any of the slicer buttons will apply that filter to the associated table or PivotTable when you click it.

  • In the Pivot Table, select any cell.
  • Select Insert –> Filter –> Slicer from the Insert menu.
  • Select all the dimensions for which you want Slicers in the Insert Slicers dialogue box.
  • Click OK.

The PIVOTTABLE TOOLS tab appears when you click a cell in your PivotTable. Insert Slicer after clicking ANALYZE. Each field in the PivotTable has options in the Insert Slicer dialogue box. Select the fields with which you want to slice the PivotTable and click OK.

  • In the pivot table, select a cell.
  • Select Slicer from the Insert tab on the Ribbon.
  • Add check marks to the slicer(s) you want to create in the list of pivot table fields.
  • If necessary, move and resize the slicers to fit on the worksheet's empty regions.

  • Select an empty section of the Slicer by clicking on it.
  • Select the Buttons group from the Options tab of the Excel Ribbon.
  • Increase or reduce the number of columns by using the Up and Down arrows.

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere