Advanced Filtering: Criteria for Advanced Filters, Using Advanced Filters, Selecting/Ordering Advanced Filter Columns. Clearing Filtering, Showing/Hiding AutoFilter, Grouping and Subtotaling List Data. DATE (year, month, day) The Excel date function returns a date given the parameters of year, month, date. PivotTables: Creating a PivotTable or PivotChart from Worksheet Data, Show/Hide the PivotTable Fields Pane, Adding/Removing a PivotTable Field, Refreshing a PivotTable, Rearranging a PivotTable, Adding a PivotChart to an Existing PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting and Filtering a PivotTable, Filtering with Timelines and Slicers. DATEDIF (startdate,enddate,unit) This function calculates the time between two given dates. DAY (serial number) This function returns the actual day of a date, as an integer between 1 through 31. Using a PivotTable to Analyze Multiple Data Sources, Adding Excel Workbook Tables to the Data Model, Creating a New PivotTable from the Data Model. Using the Inquire Add-In: Install the Inquire Add-In, Compare Two Workbooks, Analyze a Workbook.
0 kommentar(er)
