Easily insert an English formula in your non-English Excel version

April 3, 2017 0

Easily paste English formulas into your local Excel version, such as for example a Dutch Excel versionSave 5 minutes a day by using ASAP Utilities to insert English formulas you found as examples. “How to use English formula examples in your local Excel version?” On the Internet you can find an enormous amount of useful formulas for Excel. Most of these examples use the “international” formula notation. They use English function […] Read More

Easily change the text in selected cells to UPPERCASE

March 30, 2017 0

Easily make text uppercaseSave 5 minutes a day by using ASAP Utilities to quickly change your text to uppercase. “How to quickly capitalize all text” Have you ever had data in a worksheet where all the text was all lowercase? Then you had to retype it all to get it into uppercase? No more! Just select the cells […] Read More

Insert Random Dates and Times in Excel

March 27, 2017 0

Example - Random dates and timesWe just received the following question: “Would it be possible to add random date and times?” Yes, this can (already) be done with just Excel. We might add a tool for it in ASAP Utilities that will ask you for the input in the future, but it isn’t hard to do yourself with the combination […] Read More

Tip: Quickly find the tool you need

March 24, 2017 0

Easily search, find and run the tools from ASAP UtilitiesSave 5 minutes a day by using the built in Search-tool to quickly find the tool from ASAP Utilities that helps you. “Easily find the tool that can help you” You can’t find the tool that you used previously? Or you don’t know if a specific tool exists in ASAP Utilities? Don’t worry, our built-in […] Read More

Tip: Test your model/template in different screen resolutions

March 21, 2017 0

Quickly test how your model or template will look on computers with different screen resolutionsSave 5 minutes a day by using ASAP Utilities to easily test how your workbook looks with other display settings. “Easily see how your template/model looks to other users” When you develop a template, you’ll have to keep in mind that the information that you can see on screen, isn’t always what other users see. […] Read More

March 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

March 10, 2017 0

Excel 2016 includes a powerful set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce two new data transformation and connectivity features that have been requested by our customers. —Read on for details.

The post March 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

Read More

January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

February 8, 2017 0

Excel 2016 includes a powerful set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce six new data transformation and connectivity features that have been requested by our customers. —Read on for details.

The post January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

Read More

1 2 3 4 16
Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips