Summary
Throughout this chapter, we have concentrated on more advanced functions, using IF; creating parameter tables and, my personal favorite, using Index and Modulo functions; and lastly, appending files and tabs.
We have seen that when using the IF statement, it was relatively similar to Excel, but when we used the nested IF statement when deciding on whether something was to be picked up in the store or to be delivered the OR command became very important. The parameter tables are great if you are using the same template every month and all you want to do is change the data source from one file to another. Changing the table in Excel allows you to update the data source without leaving Excel and going into Power Query Editor, which saves you time. Next, we saw that the Index and Modulo functions are really useful when you have an Excel document that does not have the correct formatting or perhaps has data that is not even in columns. Using these functions allows you to take...