Search

The article offers step-by-step instructions for using an array of functions added to the online version of Microsoft Excel including Sort, Sortby, Filter, Unique, Sequence and Randarray.

The article discusses the six new functions and one new chart type that were introduced during the January 2016 Excel update for Office 365 subscribers. These six functions are called CONCAT, TEXTJOIN, IFS, SWITCH, MAXIFS and MINIFS while the new chart type is called funnel chart. Other topics discussed include how to "concatenate" multiple cells and how to avoid nested IF functions in Excel.

The article offers instructions on how to use the nested functions and the function arguments dialog box in Excel.

The article offers information about the use of the spreadsheet computer program Microsoft Excel in accounting, focusing on data analysis with combined functions. The calculation of dynamic formulas with the use of the FIND, LEFT, RIGHT, and LEN functions is described, using the example of a list of personal names organized by first name, surname, and number of characters.

This article presents a lesson in using Microsoft Access and manipulating date and text challenges for data that isn't in the form necessary for use in accomplishing user goals. The article explains the functions that manipulate text and dates and presents a chart showing the functions with examples. A specific example for correcting an incorrect date entry is described.

The article discusses how to use the "SMALL" and "LARGE" functions in Microsoft Corp.'s Excel electronic spreadsheet software program. Topics include how to use SMALL to find the second-smallest number in a list, using LARGE to find the third-largest number, and using SMALL to sort a range with a formula.