Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.
Tips for Using the ODS Excel Destination
The SAS® Output Delivery System provides the ability to generate output in various destination formats (for example, HTML, PDF, and Excel).
How to Use the AdWords IF Function
The AdWords IF function gives PPC marketers more effective and personalized options for messaging consumers in the same campaign. Here's how it works...
Learn to use Excel Like a Pro
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
How to resolve errors when opening Excel files in MapInfo Pro 64-bit.
How to resolve errors when opening Excel files in MapInfo Pro 64-bit. This link goes to the related Knowledge Base Article: pitneybowes.my.salesforce...
How to Use the Name Box in Excel
Don't overlook the Name Box in Microsoft Excel! Here's why it's useful and how it can boost your spreadsheet productivity.
5 Handy Excel Formulas and How to Use Them
Work more effectively in Excel with these 5 handy formulas, including how to add, concatenate and use lookup formulas.
Using the Formula Function in Operator10 and Synexus
A brief overview of how-to use the formula function.
How to use Excel's conditional formatting to compare lists
Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.
How to use SAS to read a range of cells from Excel
I've said it before: spreadsheets are not databases.
How to Interact with Dynamics AX Data using Microsoft Excel Online
Read this post for an update on Excel integration with Dynamics 365 and AX 2012.
How to use the Update Column Function in MapInfo Pro
This video shows how to use the Update Column Function in MapInfo Pro. This link goes to the related Knowledge Base Article: li360.pitneybowes.com/s/...
Tired Of Amateur Hour? Learn How To Use Excel Like A Pro
With the 2016 version of Excel, Microsoft has really upped the game for people who aren’t great with numbers. You can now easily use one-click access that
What statistic should you use to display error bars for a mean?
In a previous article, I mentioned that the VLINE statement in PROC SGPLOT is an easy way to graph the mean response at a set of discrete time points.
How to Use SQL in Spotfire Data Functions
SQL Statements can be used inside TERR in several ways. One of these is the open source R package sqldf, which can run SQL statements on R data frames. The user simply specifies an SQL statement in R using data frame names in place of table names. As a result, several things happen:
Excel tips: 6 slick shortcuts, handy functions and random-number generators
You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.
What Is Microsoft Power Query for Excel? 5 Reasons to Start Using It
Microsoft Power Query for Excel is a new tool that gives you more control over your spreadsheets than ever before.
How to Use the Real-Time Data Function
How to Use Graph API to Read SharePoint Online Excel Data from Microsoft Flow
Microsoft Flow provides many different actions to interact with SharePoint Online list and libraries. Recently, we had a requirement where excel data to be processed as soon as user upload the file to the document library. Limitation/Issues Initial idea was to utilize the Excel Online (Business) connector related actions like “List rows present in a … Continue reading "How to Use Graph API to Read SharePoint Online Excel Data from Microsoft Flow"
I love Dynamics GP and Microsoft Excel. What are the options to use them together?
Lucas Reuss answer’s his own question in I love Dynamics GP and Microsoft Excel. What are the options to use them together?