The Categories spreadsheet only allows for the addition of 20 categories. My Quicken account, which I am trying to terminate, has over 70 categories in current use. This limits the usefulness of Money in Excel.

When creating a new query in Power Query, by default the property "Enable background refresh" is enabled. Please make this property be unchecked by default. The cases where I need this property disabled outgrow at large the cases where the background refresh can be turned on.

Uma outra função que o Excel deveria ter é o fusionar células (não é mesclar). Se tiver algum valor duplicado, mas em alguma coluna ter algum valor diferente, uma função poderia unir as duas e mantendo apenas valores únicos.

Ex: A1 - japão A2 japão

  B1  em branco   B2  é bonito  


a função fusionar deveria ficar assim: 

  C1 japão C2 é bonito

poderia ter uma função = fusion (a1:a2)

You may a 100% satisfied with the software working functionality then move beforehand for full model license to maintain the get better or transformed emails. It moreover cut up oversize PST document as much as 5GB and assist MS Outlook versions from 90 seven to 2016. Export OST document to PST is performs works very fast in all state of affairs. The software program is designed with many forms of advanced functions. It is available at sincerely $39. For more information associated with this product,

please go with this net site: https://www.inspiredatacare.com/convert-ost-to-pst.html

easy shortcut to remove all the filters on tables in a worksheet.

I work in finance and always filtering and unfiltering multiple columns, it would be fantastic and save so much time to have this shortcut.

thank you
Samantha Casey

Without being able to get my Capital One data in Money in Excel I can only get a small fraction of my finances. Either work with a data aggregator that plays nice with Capital One (not Plaid) or allow me to import my data manually.

Once a user has created a Font and Size they want, Excel will have a button to save that font and size for further new documents.

I'm proposing that header argument be added to the FILTER and UNIQUE Dynamic Array Functions just like we have seen in the STOCKHISTORY function

Change the formula bar for advanced users as well as for beginners. better reading of functions makes work easier for everyone.
Indent the code, view the line (s) where there is an error, quickly see the syntax of a function and a bar that adapts depending on the length of the code that is entered.

Hi Microsoft Excel can you please introduce a feature wherein if more than one tab is hidden it allows us to select more than one tab so we can unhide al required tabs in one go.

reinstall the "change case" button to convert lower case to upper case, upper case to lower case, etc.

When we visualize the data, we need the Chart Title to be dynamized. İt is impossibe to

apply Simple Excel Functions like Textjoin, Concat, Concatenate, etc. on Chart Title Cell.

To keep Chart Title interactive, we implement the necessary Functions combination in

another cell and make link from Chart Title Cell to it.

From time loss point of view, Direct implementation of Functions Combination on Chart

Title Cell would be very practical for Excel Users and appreciated.

Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..

=OpeningBalance(FirstPeriodBalance, PriorBalances)

Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.

The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n-1 closing balance array value.

https://corporatefinanceinstitute.com/resources/excel/study/corkscrew-calculation/

Text to Columns Wizard - Select multiple columns when changing Column data format

On using the Text to Columns functionality, you can change the Column data format (step 3 of 3). You can only select one column at a time and set the format. It would be great to select multiple columns and change the column format to one specific format in one go.

Create a budget template to make sure you aren't spending more than a certain amount per month in a budget (e.g. shopping, dining out)

Add functionality to Money in Excel to allow data to be downloaded from a Bank Account back further than 30-60 days; for at least two years. Or for the time period to be selected by the user.

As a engineering company we need to be able to track changes to a spreadsheet that is inside a teams tab.