Portable Excel

by



LibreOffice Portable. LibreOffice is free and is based on OpenOffice that is compatible with files. Download latest version of Microsoft Excel 2016 for Windows. Safe and Virus Free.

June 24, 2020 - by Bill Jelen

If you have the full version of Power Pivot, you can use the DAX formula language to create new calculated fields. From the Power Pivot tab in the Ribbon, choose Measures, New Measure.

Give the field a name, such as Variance. When you go to type the formula, type =[. As soon as you type the square bracket, Excel gives you a list of fields to choose from.

Portable excel program

Note that you can also assign a numeric format to these calculated fields. Wouldn’t it be great if regular pivot tables brought the numeric formatting from the underlying data?


In the next calculation, VariancePercent is reusing the Variance field that you just defined.

So far, you've added several calculated fields to the pivot table, as shown below.

But you don’t have to leave any of those fields in the pivot table. If your manager only cares about the variance percentage, you can remove all of the other numeric fields.

Note that the DAX in this bonus tip is barely scratching the surface of what is possible. If you want to explore Power Pivot, you need to get a copy of Power Pivot and Power BI by Rob Collie.

Thanks to Rob Collie for teaching me this feature. Find Rob at PowerPivotPro.com.

Title Photo: Sheldon Nunes at Unsplash.com

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Portable versions

LibreOffice Portable

LibreOffice Portable is a full-featured portable version of LibreOffice for Windows – including a word processor, spreadsheet, presentation tool, drawing package and database – packaged as a portable app, so you can take all your documents and everything you need to work with them wherever you go. It is packaged in PortableApps.com format so it can work with the PortableApps.com platform and its automatic updater and app store, work with other portable menus, or work by itself from a USB, cloud or local drive. And it is open source and completely free.

Portable

Download Microsoft Excel Portable

  • LibreOffice 7.1.2 Portable MultilingualStandard <--> LibreOffice 7.1.2 Portable MultilingualAll
  • LibreOffice 7.0.5 Portable MultilingualStandard <--> LibreOffice 7.0.5 Portable MultilingualAll
  • LibreOffice 6.4.7 Portable MultilingualStandard <--> LibreOffice 6.4.7 Portable MultilingualAll

The All Languages download (MultilingualAll) includes all languages supported by LibreOffice

Portable Excel

LibreOffice is packaged for portable use by PortableApps.com with permission and assistance from The Document Foundation. For more information and support please visit this page (for LibreOffice Portable Fresh) and this page (for LibreOffice Portable Still).