Using Excel 2010 Functions DSUM Tracing precedent cells Getting help about using functions DMIN Tracing the dependents of a cell TODAY DMAX Displaying all formulas within a DAY / MONTH / YEAR DCOUNT worksheet Adding comments SUMIF Using nested functions ROUND MACROS COUNT USING DATA TABLES Displaying the Developer tab COUNTA Using a one input Data Table Recording and running simple COUNTIF Using a two input data table macros PROPER / UPPER / LOWER Viewing the macro code (VBA) CONCATENATE Recording a more complex macro PIVOT TABLES FV Basic editing of VBA code Creating a Pivot table NPV Reusing VBA code Arranging data in the Pivot table PMT Macro security levels Refreshing the Pivot table PV Changing the Quick Access Toolbar Summarizing data RATE Grouping data within a Pivot table Macro icon HLOOKUP Filtering and sorting Pivot tables VLOOKUP Using the Show Pages option IF AND SCENARIOS OR Using the Scenario Manager ISERROR Showing a scenario Viewing an alternative scenario Create a scenario summary
Using Excel 2010 Functions Getting help about using functions TODAY DAY / MONTH / YEAR SUMIF ROUND COUNT COUNTA COUNTIF PROPER / UPPER / LOWER CONCATENATE FV NPV PMT PV RATE HLOOKUP VLOOKUP IF AND OR ISERROR DSUM DMIN DMAX DCOUNT Using nested functions USING DATA TABLES Using a one input Data Table Using a two input data table PIVOT TABLES Creating a Pivot table Arranging data in the Pivot table Refreshing the Pivot table Summarizing data Grouping data within a Pivot table Filtering and sorting Pivot tables Using the Show Pages option SCENARIOS Using the Scenario Manager Showing a scenario Tracing precedent cells Tracing the dependents of a cell Displaying all formulas within a worksheet Adding comments MACROS Displaying the Developer tab Recording and running simple macros Viewing the macro code (VBA) Recording a more complex macro Basic editing of VBA code Reusing VBA code Macro security levels Changing the Quick Access Toolbar Macro icon Viewing an alternative scenario Create a scenario summary
Excel%20Advanced%202010%20Citrus.docx