Make Switch To Excel 2013. This video shows you the Top five things that have changed in Excel 2013. Just choose FileInfo and click the Convert button.
If you already know Excel 2003 and want to get up to speed fast with Excel 2013 you are in the right place. You can Create a Table in Excel by selecting data and then on Insert tab click on TableYou can add calculated column quickly in Table and add data with the. Switch from an earlier version of Excel to Excel 2013.
You can workaround this limitation by constructing a formula to match against TRUE like this.
Each of the values are compared to the expression and the first one to match has its corresponding result returned. You can add a SWITCH function to your copy of Excel 2013 2010 or 2007 with the Excel PowerUps add-in. Use the linked to cell value to make changes to your charts dashboards formulas as needed. To make you even more awesome I made a short video tutorial explaining the whole thing.