en
Knjige
David Rojas

Data Analysis and Business Modeling with Excel 2013

  • Sofya Latyshevaje citiralaпре 8 година
    Bar chart (column chart): This chart is used to make comparisons. The y axis is usually numeric and the x axis is categorical.
  • Sofya Latyshevaje citiralaпре 8 година
    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 Latyshevaje citiralaпре 8 година
    Highlight cells A1 through E11, and press Ctrl + T to convert our data into an Excel table.
  • Sofya Latyshevaje citiralaпре 8 година
    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 Latyshevaje citiralaпре 8 година
    Dates and create a macro:
    Go back to Excel by pressing the Alt + F11 keys.
  • Sofya Latyshevaje citiralaпре 8 година
    =PROPER(
    and select cell A2, and then press the Enter key on your keyboard, as shown in the following screenshot:
fb2epub
Prevucite i otpustite datoteke (ne više od 5 odjednom)