Category: SPREADSHEET MODELLING AND ANALYSIS

AtoZPOSTS.COM brings a wonderful opportunity to study the spreadsheet and its analysis and excel concepts. These posts describes about  Basic functions and utilities , Text functions , Sorting and filtering data , Graphs ,IF statement analysis, COUNTIF, SUMIF, Conditional formatting,Lookup functions, Pivot table and its applications
, Filter data using slicers in multiple pivot table,Dashboard:Visualize aggregate data using pivot table, Create and record macro in spreadsheet,Msgbox,declaring variables, Writing a subroutine and function in VBA, IF Then statement, Case statement, For loop, While loop and Do until, Worksheet and range object, Goal seek ,Data table ,Scenario Analysis .

 

0