When working with Excel spreadsheets there are four steps I always go through before starting with anything.
First off what I do is apply filters. With big tables there is always some filtering needed — Under Home tab and Editing section choose Sort & Filters and then click on Filters.
Continue readingType in „=” and „randbetween”. Then put in brackets and between them the first number is your lowest and second is the highest between which the random number is generated.
Continue readingSelect your table and sort the column where the groups are displayed. To sort, go under Home and Editing section. Click on „Sort & Filter” and choose on of the first two. Next go to Data and click on Subtotal. Under „At each change in” select the column the group is in. In the next section select the function you want to be used and in the third bit select the column the subtotal is added to. Click on OK when you’re done.
Continue readingWe have 2 big sheets with data and we want to compare them. Our first sheet includes all the products we have in inventory as at August 31 and the second sheet contains inventory status as at September 30.
Continue reading