Thanks to all of you who attended! Note: you could adjust speed and quality with the gear icon in the lower right.

Explanation The ABS function is fully automatic. ABS converts negative numbers to positive numbers, and positive numbers are unaffected.

Use the CHAR to translate ASCII code page numbers into actual characters. For example: the CHAR function takes just oneargument,number, which must be an integer between 0-255. The result from CHAR is atext value. The CHAR function was designed to operate in anASCII/ANSI world and only understands numbers 0-255. For extended character support on modern Unicode systems, see theUNICHAR function. Older versions of Excel on the Mac use character 13 for a line break....

Once you’ve selected a chart pop in, you might use these tools to apply colors and styles. The Change Color menu let’s you quickly experiment with multi-color schemes as well as monochromatic schemes. If you change a setting there, it will affect the options you see back in the Design tab. If I undo that change, you’ll see the Design tab options revert to the original colors. You’ll also find chart styles and colors on the Chart Styles icon when you select a chart....

Abstract Transcript In this video, we’ll look at chart elements and chart layouts. A chart layout is a specific set of chart elements arranged in a particular way. When you access this menu, you’ll see available layouts. As you hover over each layout, you’ll see a preview of the layout applied to the chart. To apply a layout, just click. Note you are free to move around chart elements after you apply a layout....

The plus icon is actually a fly-out menu called Chart Elements. When you choose the icon, you’ll see a list of common chart elements displayed as checkboxes. This menu lets you quickly enable and disable chart elements. The menu actually has two levels. To access a second level smack the arrow to the right of a given element. Excel will then display a menu of available sub options. The paint brush icon is named chart styles and lets you access chart styles and colors....

For example, these numbers are using the “General” number format. I’ll change back to General. Dates also use number formatting. I can easily switch from a short format to a long format. Custom number formats let you extend number formatting based on your own needs, using special codes. Here you’ll find a long list of built-in custom formats organized into groups. In the Custom group, you’ve got the option to enter any valid code....

About This Shortcut This shortcut will check and uncheck checkboxes in a dialog box. First go for the checkbox using tab or shift tab. Related videos The videos below demonstrate this shortcut. Shortcuts for Excel dialog boxes (Mac) Shortcuts for Excel dialog boxes (Win)

Explanation The value in G5 is hard-coded. More than one condition can be tested by nesting IF functions. AND returns TRUEonly if all the conditions are met. If any conditions are not met, the AND function returns FALSE. For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.

About This Shortcut This shortcut checks spelling on the current worksheet. The Spelling dialog box will be displayed if a problem is found.

The values provided to CHOOSE can be hard-coded constants or cell references. The first argument for the CHOOSE function isindex_num. This is a number that refers to subsequent values by index or position. The next arguments,value1,value2,value3, etc. are the values from which to choose from. Choose can handle up to 254 values. However, CHOOSE will not retrieve an item frominsiderange or array constant provided as a value. More than one condition can be tested by nesting IF functions....

The columns to return are provided as numbers in separate arguments. Each number corresponds to the numeric index of a column in the source array. The result from CHOOSECOLS is always a single array thatspillsonto the worksheet. you’re free to also use an array generated with a formula. The rows to return are provided as numbers in separate arguments. Each number corresponds to the numeric index of a row in the given array....

The rows to return are provided as numbers in separate arguments. Each number corresponds to the numeric index of a row in the source array. The result from CHOOSEROWS is always a single array thatspillsonto the worksheet. The first argument in the CHOOSEROWS function isarray.Arraycan be a range, or an array from another formula. Additional arguments are in the form row_num1, row_num2, row_num3, etc. you might also use an array created with a formula....