David Rojas

Data Analysis and Business Modeling with Excel 2013

    Sofya Latyshevahar citeretfor 6 år siden
    Bar chart (column chart): This chart is used to make comparisons. The y axis is usually numeric and the x axis is categorical.
    Sofya Latyshevahar citeretfor 6 år siden
    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
    Sofya Latyshevahar citeretfor 6 år siden
    Highlight cells A1 through E11, and press Ctrl + T to convert our data into an Excel table.
    Sofya Latyshevahar citeretfor 6 år siden
    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
    Sofya Latyshevahar citeretfor 6 år siden
    Dates and create a macro:
    Go back to Excel by pressing the Alt + F11 keys.
    Sofya Latyshevahar citeretfor 6 år siden
    =PROPER(
    and select cell A2, and then press the Enter key on your keyboard, as shown in the following screenshot:
fb2epub
Træk og slip dine filer (ikke mere end 5 ad gangen)