Data Analysis and Business Modeling with Excel 2013

Bar chart (column chart): This chart is used to make comparisons. The y axis is usually numeric and the x axis is categorical.

The next steps will show you how to create a button using VBA that will filter all of our data in a flash:
Press Alt + F11 and create a sub procedure called
Clear_Slicer

Highlight cells A1 through E11, and press Ctrl + T to convert our data into an Excel table.

Sub Clear_Slicer()
' Declare Variables
Dim cache As SlicerCache

' Loop through each filter
For Each cache In ActiveWorkbook.SlicerCaches
' clear filter
cache.ClearManualFilter
Next cache
End Sub

Dates and create a macro:
Go back to Excel by pressing the Alt + F11 keys.

=PROPER(
and select cell A2, and then press the Enter key on your keyboard, as shown in the following screenshot: