Posts

You are here

In general, Excel shortcuts on the Mac are more similar than different from Windows shortcuts. But it may not feel that way, especially if you come from a Windows background. Here are the 5 key differences you’re gonna wanna be aware of. First, many shortcut keys on the Mac are often abbreviated as symbols. Here’s a list of those symbols and the keys they represent. Second, function keys behave differently on a Mac....

Even basic shortcuts you’ve been using for years in Windows may not work as you expect. These symbols have a long history on the Mac, and you’ll find them in menus everywhere. There really aren’t too many symbols, so I recommend that you bite the bullet and memorize them. The table below shows some example shortcuts with a translation. Function keys Like their counterparts in the Windows world, Mac keyboards have function keys....

Work faster in Excel with over200 keyboard shortcutsfor both Windows and the Mac listed side-by-side on one handy PDF. This free PDF lists shortcuts by section with many useful links. Download the PDF below.

Every once in a while, you might find Excel behaving in a bizarre or unexpected way. One example is when youaccidentally trigger the scroll lock feature. Another example is when one or more formulas suddenly stops working. This can be very confusing, and you might think you’ve somehow broken your spreadsheet. However, it’s likely a simple problem. With a little troubleshooting, you’re able to get things working again. Show Formulas is meant to give you a quick way to see all formulas in a worksheet....

AnExcel Tableis a special object for managing data in Excel. Excel Tables have a name which appears in thename boxwhen the entire table is selected. For a complete introduction to Excel Tables see:Excel Tables. This makes it easy to work with the data like a database. Filters- although filters can be applied to any normal table, they are automatically available in an Excel Table. Structured references-structured referencesmake it easy to refer to table rows and columns without specific cell references....

Excel provides four options for Tables you should be aware of. The first option controls whether a table range will automatically adjust as data changes. By default, this option is enabled, since this feature is a key benefit of tables. For example, if I enter a new row in this table, the table expands to include it. The same is true when I add a new column header. In Windows, the setting that controls this behavior is in the proofing area, under Autocorrect controls....

Excel Tables are one of the most interesting and useful features in Excel. This article provides an introduction and overview. Creating a table is fast you’re free to create an Excel Table in less than 10 seconds. Navigate directly to tables Likenamed ranges, tables will appear in the namebox dropdown menu. Just nudge the menu, and snag the table. Excel will navigate to the table, even if it’s on a different tab in a workbook....

Abstract Transcript In this video, we’ll take a look at the TEXTAFTER function. Let’s look at an example. In this worksheet, we have a list of email addresses. TEXTAFTER accepts six arguments, but only the first two arguments,textanddelimiter, are required. In this case, the text comes from column B, and the delimiter is the @ symbol. Notice I need to wrap the “@” symbol in double quotes to indicate a text value....

Abstract Transcript In this video, we’ll take a look at the TEXTBEFORE function. A delimiter can be one or more characters. Let’s look at an example. In this worksheet, we have a list of email addresses. Although TEXTBEFORE accepts six arguments, only the first two arguments,textanddelimiter, are required. In this case, the text comes from column B, and the delimiter is the @ symbol. Notice that I need to wrap the @ symbol in double quotes because it’s a text value....

Abstract Transcript In this video, we’ll take a look at the TEXTSPLIT function. TEXTSPLIT is an Excel function designed to split text into separate cells using a given delimiter. In this worksheet, we have a list of email addresses. The goal is to split each email into a separate name and domain. As I start to enter TEXTSPLIT, Excel will match the function and I can use Tab to autocomplete....

In other words, as we approach midnight, the value of time approaches 1. Formatting time Time is displayed in Excel using a number format for time. More on custom number formatshere. For example, 0.5* 24 = 12 hours, 0.25* 24 = 6 hours, etc. For more details, seeConvert Excel time to decimal value.

Below are some of the topics covered on our site.