![Formula in excel to multiply Formula in excel to multiply](/uploads/1/2/5/6/125644402/363618179.gif)
![Formula in excel to subtract Formula in excel to subtract](http://www.excel-helps.com/upload/image/posts/add-line-break-based-on-os.png)
Mac Excel Guide If you plan on using your Mac for intensive Excel usage, we recommend installing a virtual machine software to simultaneously run Windows and Office for PC within your Mac OS. We recommend either VMware or Parallels. In either case, we highly recommend the following tweaks to simplify your Excel. Enabling F1 - F12 Function Keys.
Advanced Formulas in Excel – Index, Match, and Indirect You’ll learn how to use the INDEX, MATCH, and INDIRECT functions (as well as ADDRESS) in this lesson to enhance the normal lookup functionality in Excel, and you’ll see how those functions improve upon VLOOKUP and HLOOKUP. We’ll add additional lookup functionality to the customer due diligence file, and then you’ll get to practice on your own with a case study where you compare the financial performance of several REITs and have to work with “messy” data to do so.