Excel Tips and Tricks for All Levels
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Loading ...#N/A Add Comments Auto_Open Basic Macro Cell Calculation Column Headers Concatenate Contest Count CountA CountBlank CountIf Custom Function Date Drop Down Menu Excel Formulas Excel Forum Excel Info Excel Macros Excel Version Extract Names Find Formatting HLookup Hyperlink ISBLANK ISERROR ISNA IsText Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Macros or Formulas Macro Usage Match Mid Office 2010 Office Live Pivottable Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute Sub vs Function Sum Across Sheets SumIf Text To Columns Today Trim Unique Values Userform Userform Attempt VLookup