Microsoft Excel 2019

• Microsoft Excel 2019 Torrent
• Microsoft Excel 2019 New Features
• Microsoft Excel 2019 For Mac
• Microsoft Excel 2019 Free Download
• Download Microsoft Excel 2019

1. Microsoft Excel with a Microsoft 365 subscription is the latest version of Excel. Previous versions include Excel 2016, Excel 2013, Excel 2010, Excel 2007.
2. For customers who aren't ready for the cloud, Office 2019 is the next on-premises version of Word, Excel, PowerPoint, Project, Visio, Access, and Publisher. 1 See plans and pricing See what's in Office 2019.

Microsoft Office 2019 Product Key Free You need a free license key for Office 2019, Professional, Home and Business 2019. Depending on your model, you can activate the tool for 32-bit and 64-bit. In short, they are focusing on demand.

Excel macros allow you to automate commands to simplify your tasks. Excel 2019 enables you to add an optional Developer tab to the Ribbon that contains its own Record Macro command button (among other command buttons that are very useful when doing more advanced work with macros). To add the Developer tab to the Excel 2019 Ribbon, follow these two steps:

1. Click File → Options or press Alt+FT to open the Excel Options dialog box.
2. Click Customize Ribbon, then select the Developer check box under Main Tabs in the Customize the Ribbon list box on the right side of the dialog box, and then click OK.

Even if you don't add the Developer tab to the Ribbon, the Excel 2019 Status bar contains a Record Macro (to the immediate right of the Ready status indicator), and the View tab of the Ribbon contains a Macros command button with a drop-down menu containing a Record Macro option.

When you turn on the Excel macro recorder in the Record Macro dialog box — opened by clicking the Record Macro button on the Status bar (automatically added once you record your first macro), the Record Macro option on the Macros button's drop-down menu (Alt+WMR), or even the Record Macro button on the Developer tab (Alt+LR) — the macro recorder records all your actions in the active worksheet or chart sheet when you make them.

The Excel macro recorder doesn't record the keystrokes or mouse actions that you take to accomplish an action — only the VBA code required to perform the action itself. This means that mistakes that you make while taking an action that you rectify won't be recorded as part of the macro; for example, if you make a typing error and then edit it while the macro recorder is on, only the corrected entry shows up in the macro without the original mistakes and steps taken to remedy them.

The Excel macros that you create with the macro recorder can be stored as part of the current workbook, in a new workbook, or in a special, globally available Personal Macro Workbook named PERSONAL.XLSB that's stored in a folder called XLSTART on your hard drive. When you record an Excel macro as part of your Personal Macro Workbook, you can run that macro from any workbook that you have open. (This is because the PERSONAL.XLSB workbook is secretly opened whenever you launch Excel, and although it remains hidden, its macros are always available.) When you record macros as part of the current workbook or a new workbook, you can run those macros only when the workbook in which they were recorded is open in Excel.

When you create a macro with the macro recorder, you decide not only the workbook in which to store the macro but also what name and shortcut keystrokes to assign to the macro that you are creating. When assigning a name for your macro, use the same guidelines that you use when you assign a standard range name to a cell range in your worksheet. When assigning a shortcut keystroke to run the macro, you can assign

• The Ctrl key plus a letter from A to Z, as in Ctrl+Q
• Ctrl+Shift and a letter from A to Z, as in Ctrl+Shift+Q

You can't, however, assign the Ctrl key plus a punctuation or number key (such as Ctrl+1 or Ctrl+/) to your macro.

To see how easy it is to create a macro with the macro recorder, follow these steps for creating a macro that enters the company name in 12-point, bold type and centers the company name across rows A through E with the Merge and Center feature:

1. Open the Excel workbook that contains the worksheet data or chart you want your macro to work with.
   If you're building a macro that adds new data to a worksheet (as in this example), open a worksheet with plenty of blank cells in which to add the data. If you're building a macro that needs to be in a particular cell when its steps are played back, put the cell pointer in that cell.
2. Click Record Macro button on the Status bar or Alt+WMR or Alt+LR if you have added the Developer tab to the Ribbon.
   The Record Macro dialog box opens where you enter the macro name, define any keystroke shortcut, select the workbook in which to store the macro, and enter a description of the macro's function.
3. Replace the Macro1 temporary macro name by entering your name for the macro in the Macro Name text box.

   Remember that when naming a macro, you must not use spaces in the macro name and it must begin with a letter and not some number or punctuation symbol. For this example macro, you replace Macro1 in the Macro Name text box with the name Company_Name.

   Next, you can enter a letter between A and Z that acts like a shortcut key for running the macro when you press Ctrl followed by that letter key. Just remember that Excel has already assigned a number of Ctrl+letter keystroke shortcuts for doing common tasks, such as Ctrl+C for copying an item to the Clipboard and Ctrl+V for pasting an item from the Clipboard into the worksheet (see the Cheat Sheet for a complete list). If you assign the same keystrokes to the macro you're building, your macro's shortcut keys override and, therefore, disable Excel's ready-made shortcut keystrokes.

4. (Optional) Click the Shortcut key text box and then enter the letter of the alphabet that you want to assign to the macro.

   For this example macro, press Shift+C to assign Ctrl+Shift+C as the shortcut keystroke (so as not to disable the ready-made Ctrl+C shortcut).

   Next, you need to decide where to save the new macro that you're building. Select Personal Macro Workbook on the Store Macro In drop-down list box to be able to run the macro anytime you like. Select This Workbook (the default) when you need to run the macro only when the current workbook is open. Select New Workbook if you want to open a new workbook in which to record and save the new macro.

5. Click the Personal Macro Workbook, New Workbook, or This Workbook option on the Store Macro In drop-down list to indicate where to store the new macro.

   For this example macro, select the Personal Macro Workbook so that you can use it to enter the company name in any Excel workbook that you create or edit.

   Next, you should document the purpose and function of your macro in the Description list box. Although this step is purely optional, it is a good idea to get in the habit of recording this information every time you build a new macro so that you and your coworkers can always know what to expect from the macro when it's run.

6. (Optional) Click the Description list box and then insert a brief description of the macro's purpose in front of the information indicating the date and who recorded the macro.

   Now you're ready to close the Record Macro dialog box and start recording your macro.

7. Click OK to close the Record Macro dialog box.

   The Record Macro dialog box closes, the square Stop Recording button appears on the Status bar, and the Record Macro option becomes Stop Recording on the Macros button's drop-down menu and in the Code group on the Developer tab.

   On the Macros button's drop-down menu on the Ribbon's View tab and Code group on the Developer tab, you find a Use Relative References option. You click this drop-down menu item or command button when you want the macro recorder to record the Excel macro relative to the position of the current cell. For this example macro, which enters the company name and formats it in the worksheet, you definitely need to click the Use Relative References button before you start recording commands. Otherwise, you can use the macro only to enter the company name starting in cell A1 of a worksheet.

8. (Optional) Click the Use Relative References option on the Macros button's drop-down menu on the View tab or click the Use Relative References button on the Developer tab if you want to be able to play back the macro anywhere in the Excel sheet.
9. Select the cells, enter the data, and choose the Excel commands required to perform the tasks that you want recorded just as you normally would in creating or editing the current worksheet, using the keyboard, the mouse, or a combination of the two.

   For the example macro, type the company name and click the Enter button on the Formula bar to complete the entry in the current cell. Next, click the Bold button and then click 12 on the Font Size drop-down list in the Font group on the Home tab. Finally, drag through cells A1:E1 to select this range and then click the Merge and Center command button, again on the Home tab.

   After you finish taking all the actions in Excel that you want recorded, you're ready to shut off the macro recorder.

10. Click the Stop Recording button on the Status bar or select Stop Recording option on the View or Developer tab on the Ribbon.

    The square Stop Recording button on the Status bar turns into a Record Macro button (with an icon showing a tiny worksheet with a circle in the left corner). This lets you know that the macro recorder is now turned off and no further actions will be recorded.

After you finish recording your first macro in Excel 2019, the Record Macro button continues to appear on the Status bar whenever you use the program. This means that you can click or tap this button to open the Record Macro dialog box whenever you need to create new macros rather than having to select the Record Macro option on the View or Developer tab of the Ribbon, as described in the previous steps.

Assigning Excel macros to the Ribbon and the Quick Access toolbar

If you prefer, instead of running a macro by selecting it in the Macro dialog box or by pressing shortcut keys you assign to it, you can assign it to a custom tab on the Ribbon or a custom button on the Quick Access toolbar and then run it by clicking that custom button.

To assign an Excel macro to a custom group on a custom Ribbon tab, you follow these steps:

1. Click File → Options and then click the Customize Ribbon tab in the Excel Options dialog box (or press Alt+FTC).

   Excel displays the Customize Ribbon pane in the Excel Options dialog box.

2. Click Macros in the Choose Commands From drop-down list box on the left.
   Excel lists the names of all the macros created, both those in the current workbook and those that are saved in the PERSONAL.XLSB workbook, in the Choose Commands From list box.
3. Click the name of the custom group on the custom tab to which you want to add the macro in the Main Tabs list box on the right.

   Need for speed underground 2 mac free. If you haven't already created a custom tab and group for the macro or need to create a new one, follow these steps:

   1. Click the New Tab button at the bottom of the Main Tabs list.
      Excel adds both a New Tab (Custom) and New Group (Custom) item to the Main Tabs list while at the same time selecting the New Group (Custom) item.
   2. Click the New Tab (Custom) item you just added to the Main Tabs.
   3. Click the Rename button at the bottom of the Main Tabs list box and then type a display name for the new custom tab before you click OK.
   4. Click the New Group (Custom) item right below the custom tab you just renamed.
   5. Click the Rename button and then type a display name for the new custom group before you click OK.
4. In the Choose Commands From list box on the left, click the name of the macro you want to add to the custom group now selected in the Main Tabs list box on the right.
5. Click the Add button to add the selected Excel macro to the selected custom group on your custom tab. If you want to rename the macro and/or assign it a new icon, click the Rename button and make these changes in the Rename dialog box before you click the OK button to close the Excel Options dialog box.

   After you add a macro to the custom group of a custom tab, the name of the macro appears on a button on the custom tab of the Ribbon. Then, all you have to do to run the macro is click this command button.

To assign an Excel macro to a custom button on the Quick Access toolbar, follow these steps:

1. Click the Customize Quick Access Toolbar button at the end of the Quick Access toolbar and then click More Commands on its drop-down menu.
   Excel opens the Excel Options dialog box with the Quick Access Toolbar tab selected.
2. Click Macros in the Choose Commands From drop-down list box.

   Excel lists the names of all the macros you created, both those in the current Excel workbook and those that are saved in the PERSONAL.XLSB workbook, in the Choose Commands From list box.

3. Click the name of the macro to add to a custom button on the Quick Access toolbar in the Choose Commands From list box and then click the Add button.
4. Click the Modify button to open the Modify Button dialog box if you want to change the display name and assign a different icon to the macro button.
5. Click OK to close the Excel Options dialog box.

After you close the Excel Options dialog box, a custom button sporting its associated macro icon (the default with a standard command flowchart unless you changed it) appears on the Quick Access toolbar. To see the name of the Excel macro assigned to this custom macro button as a ScreenTip, position the mouse pointer over the button. To run the macro, click the button.

Earlier this fall, Microsoft announced the release to the general public of its Office 2019 suite. The 2019 version of Excel contains a wide assortment of new and improved features and capabilities. Here's a look at 12 of those upgrades, all of which I have downloaded, installed, and tested:

1. Data import tool improvements: The Power Query data import tool in Excel 2013 was renamed Get & Transform in Excel 2016, but the name has reverted to Power Query in Excel 2019, bringing it in line with the name conventions used by the related Microsoft products Power Pivot, Power Map, and Power BI. The improved Power Query tool (pictured below) provides the ability to import data from external data sources (such as your accounting system) and then scrub and clean the data (referred to as transforming the data) before placing them in Excel. Some of the transforming capabilities include the ability to group data, rename column headings, transpose data, reverse rows, detect data types, replace values, split columns, merge columns, unpivot columns, invoke custom functions, create conditional columns, and parse data.

This tool makes it faster, easier, and more accurate to import data from external sources for manipulation and analysis in Excel.

2. Automated workflow: Excel 2019 now connects better to Microsoft Flow, which allows you to create automated workflows in which data are retrieved from other applications and then stored and/or manipulated in Excel. The dataflow can be further programmed to automatically send to or share those data with other people or third-party applications. For example, Flow might be used to collect favorable customer tweets about your goods or services on your Twitter account, and then store them in your Excel workbook (on your OneDrive or SharePoint platform). These Twitter data could then be pushed periodically (every Monday morning, for example) to selected recipients through email or text messages, or published directly to websites or other data destinations.

Flow can retrieve your data from practically anywhere — your accounting system, ERP system, CRM system, stock price databases, weather forecast databases, email messages, reminder notices, Salesforce.com, etc. As examples, you could use this technology to track your hours worked, travel locations, Facebook messages, Instagram posts, travel expenses, accounts receivable, etc. To create a new data flow, start at the My Flows webpage at login.microsoftonline.com, sign in to your account using your Microsoft ID, and click the Get started button.

Click Create a flow from blank, as pictured below in the bottom right corner, and then select one of more than 200 triggers and specify the event you want to launch your automatic flow process. For example, the receipt of an email with a specific attachment may trigger an automated flow process. Continue by specifying the action(s) you want to take, such as opening the email attachment in Excel and running a specific macro to produce a PivotTable or PivotChart, then specify a connector for sharing the results through other Microsoft and third-party apps such as Outlook or SharePoint. Learn more about Flow at click.linksynergy.com.

3. 3D images: Excel 2019 now includes new 3D imaging capability in which you can rotate a 3D model of an object. While it's difficult to convey the concept in a picture, the screenshot below contains three copies of the same butterfly image, which I have rotated to suggest the effect you might achieve.

Microsoft Excel 2019 Torrent

Excel now includes hundreds of 3D images, which are available from the Inserttab's 3D Models option. Image categories include animals, electronics, gadgets, dinosaurs, geology, space, dioramas, letters, biology, and more. A few examples of 3D graphic images are displayed in the screenshot below.

You can view my brief video demonstrating this functionality at youtu.be/VLzglo1WBZ0. http://xnvlmt.xtgem.com/Blog/__xtblog_entry/19357506-audacity-mac-catalina#xt_blog.

4. Custom functions: Excel 2019 now enables users to create their own custom functions using JavaScript. Previous editions of Excel already enabled users to create user-defined functions using Excel's built-in Visual Basic for Applications programming language; however, since JavaScript has emerged as a commonly used platform for such purposes, Microsoft has added this new capability to allow for greater compatibility with third-party solutions.

5. New functions: Excel includes six new or improved functions, as follows: IFS, SWITCH, ­TEXTJOIN, CONCAT, MAXIFS, and MINIFS. IFS and SWITCH are simplified versions of the nested IF function, which eliminates the need for more complicated nested functions. For example, the screenshot below depicts both the nested IF approach (in red text) and the IFS approach (in blue text) for creating the formula in cell C16 that returns the proper tax base for income calculation purposes. While both approaches work, the IFS approach requires only one function while the IF approach requires three IF functions. Note that in this example the IFS approach produces a slightly longer formula because the IFS approach requires you to spell out each criterion, while the IF approach does not require you to spell out the last criteria.

The TEXTJOIN function is a simplified version of the CONCATENATE function in which inserted text need not be encapsulated by quotation marks. The CONCAT function allows you to combine text from multiple cells without specifying a delimiter. The MAXIFS and MINIFS functions work like the SUMIF or COUNTIF functions in that they calculate only the maximum or minimum for those data that meet the criteria you specify. For example, an auditor might use these functions to find the lowest and highest invoice amounts between $50 and $100, as part of statistical sampling procedures.

6. Custom visuals: To provide more visual ways to display and present your data, Microsoft has incorporated its Power BI suite of apps into Excel. To access these new custom visuals, from Excel's Add-ins tab select Get Add-ins to display the Office Add-ins dialog box pictured below.

Scroll through the apps, select the one you want to use, and then set up the app to link it to your desired data. For example, I selected the free Microsoft People Graph app to create the chart below as linked from the data displayed in cells A1:B5.

Other available visual add-in apps include Word Cloud charts, Bullet charts, Speedometer charts, the Prevedere Forecasting Tools, Lucidchart Diagrams for Excel, and Supermetrics, to name a few.

The Excel macro recorder doesn't record the keystrokes or mouse actions that you take to accomplish an action — only the VBA code required to perform the action itself. This means that mistakes that you make while taking an action that you rectify won't be recorded as part of the macro; for example, if you make a typing error and then edit it while the macro recorder is on, only the corrected entry shows up in the macro without the original mistakes and steps taken to remedy them.

The Excel macros that you create with the macro recorder can be stored as part of the current workbook, in a new workbook, or in a special, globally available Personal Macro Workbook named PERSONAL.XLSB that's stored in a folder called XLSTART on your hard drive. When you record an Excel macro as part of your Personal Macro Workbook, you can run that macro from any workbook that you have open. (This is because the PERSONAL.XLSB workbook is secretly opened whenever you launch Excel, and although it remains hidden, its macros are always available.) When you record macros as part of the current workbook or a new workbook, you can run those macros only when the workbook in which they were recorded is open in Excel.

When you create a macro with the macro recorder, you decide not only the workbook in which to store the macro but also what name and shortcut keystrokes to assign to the macro that you are creating. When assigning a name for your macro, use the same guidelines that you use when you assign a standard range name to a cell range in your worksheet. When assigning a shortcut keystroke to run the macro, you can assign

• The Ctrl key plus a letter from A to Z, as in Ctrl+Q
• Ctrl+Shift and a letter from A to Z, as in Ctrl+Shift+Q

You can't, however, assign the Ctrl key plus a punctuation or number key (such as Ctrl+1 or Ctrl+/) to your macro.

To see how easy it is to create a macro with the macro recorder, follow these steps for creating a macro that enters the company name in 12-point, bold type and centers the company name across rows A through E with the Merge and Center feature:

1. Open the Excel workbook that contains the worksheet data or chart you want your macro to work with.
   If you're building a macro that adds new data to a worksheet (as in this example), open a worksheet with plenty of blank cells in which to add the data. If you're building a macro that needs to be in a particular cell when its steps are played back, put the cell pointer in that cell.
2. Click Record Macro button on the Status bar or Alt+WMR or Alt+LR if you have added the Developer tab to the Ribbon.
   The Record Macro dialog box opens where you enter the macro name, define any keystroke shortcut, select the workbook in which to store the macro, and enter a description of the macro's function.
3. Replace the Macro1 temporary macro name by entering your name for the macro in the Macro Name text box.

   Remember that when naming a macro, you must not use spaces in the macro name and it must begin with a letter and not some number or punctuation symbol. For this example macro, you replace Macro1 in the Macro Name text box with the name Company_Name.

   Next, you can enter a letter between A and Z that acts like a shortcut key for running the macro when you press Ctrl followed by that letter key. Just remember that Excel has already assigned a number of Ctrl+letter keystroke shortcuts for doing common tasks, such as Ctrl+C for copying an item to the Clipboard and Ctrl+V for pasting an item from the Clipboard into the worksheet (see the Cheat Sheet for a complete list). If you assign the same keystrokes to the macro you're building, your macro's shortcut keys override and, therefore, disable Excel's ready-made shortcut keystrokes.

4. (Optional) Click the Shortcut key text box and then enter the letter of the alphabet that you want to assign to the macro.

   For this example macro, press Shift+C to assign Ctrl+Shift+C as the shortcut keystroke (so as not to disable the ready-made Ctrl+C shortcut).

   Next, you need to decide where to save the new macro that you're building. Select Personal Macro Workbook on the Store Macro In drop-down list box to be able to run the macro anytime you like. Select This Workbook (the default) when you need to run the macro only when the current workbook is open. Select New Workbook if you want to open a new workbook in which to record and save the new macro.

5. Click the Personal Macro Workbook, New Workbook, or This Workbook option on the Store Macro In drop-down list to indicate where to store the new macro.

   For this example macro, select the Personal Macro Workbook so that you can use it to enter the company name in any Excel workbook that you create or edit.

   Next, you should document the purpose and function of your macro in the Description list box. Although this step is purely optional, it is a good idea to get in the habit of recording this information every time you build a new macro so that you and your coworkers can always know what to expect from the macro when it's run.

6. (Optional) Click the Description list box and then insert a brief description of the macro's purpose in front of the information indicating the date and who recorded the macro.

   Now you're ready to close the Record Macro dialog box and start recording your macro.

7. Click OK to close the Record Macro dialog box.

   The Record Macro dialog box closes, the square Stop Recording button appears on the Status bar, and the Record Macro option becomes Stop Recording on the Macros button's drop-down menu and in the Code group on the Developer tab.

   On the Macros button's drop-down menu on the Ribbon's View tab and Code group on the Developer tab, you find a Use Relative References option. You click this drop-down menu item or command button when you want the macro recorder to record the Excel macro relative to the position of the current cell. For this example macro, which enters the company name and formats it in the worksheet, you definitely need to click the Use Relative References button before you start recording commands. Otherwise, you can use the macro only to enter the company name starting in cell A1 of a worksheet.

8. (Optional) Click the Use Relative References option on the Macros button's drop-down menu on the View tab or click the Use Relative References button on the Developer tab if you want to be able to play back the macro anywhere in the Excel sheet.
9. Select the cells, enter the data, and choose the Excel commands required to perform the tasks that you want recorded just as you normally would in creating or editing the current worksheet, using the keyboard, the mouse, or a combination of the two.

   For the example macro, type the company name and click the Enter button on the Formula bar to complete the entry in the current cell. Next, click the Bold button and then click 12 on the Font Size drop-down list in the Font group on the Home tab. Finally, drag through cells A1:E1 to select this range and then click the Merge and Center command button, again on the Home tab.

   After you finish taking all the actions in Excel that you want recorded, you're ready to shut off the macro recorder.

10. Click the Stop Recording button on the Status bar or select Stop Recording option on the View or Developer tab on the Ribbon.

    The square Stop Recording button on the Status bar turns into a Record Macro button (with an icon showing a tiny worksheet with a circle in the left corner). This lets you know that the macro recorder is now turned off and no further actions will be recorded.

After you finish recording your first macro in Excel 2019, the Record Macro button continues to appear on the Status bar whenever you use the program. This means that you can click or tap this button to open the Record Macro dialog box whenever you need to create new macros rather than having to select the Record Macro option on the View or Developer tab of the Ribbon, as described in the previous steps.

Assigning Excel macros to the Ribbon and the Quick Access toolbar

If you prefer, instead of running a macro by selecting it in the Macro dialog box or by pressing shortcut keys you assign to it, you can assign it to a custom tab on the Ribbon or a custom button on the Quick Access toolbar and then run it by clicking that custom button.

To assign an Excel macro to a custom group on a custom Ribbon tab, you follow these steps:

1. Click File → Options and then click the Customize Ribbon tab in the Excel Options dialog box (or press Alt+FTC).

   Excel displays the Customize Ribbon pane in the Excel Options dialog box.

2. Click Macros in the Choose Commands From drop-down list box on the left.
   Excel lists the names of all the macros created, both those in the current workbook and those that are saved in the PERSONAL.XLSB workbook, in the Choose Commands From list box.
3. Click the name of the custom group on the custom tab to which you want to add the macro in the Main Tabs list box on the right.

   Need for speed underground 2 mac free. If you haven't already created a custom tab and group for the macro or need to create a new one, follow these steps:

   1. Click the New Tab button at the bottom of the Main Tabs list.
      Excel adds both a New Tab (Custom) and New Group (Custom) item to the Main Tabs list while at the same time selecting the New Group (Custom) item.
   2. Click the New Tab (Custom) item you just added to the Main Tabs.
   3. Click the Rename button at the bottom of the Main Tabs list box and then type a display name for the new custom tab before you click OK.
   4. Click the New Group (Custom) item right below the custom tab you just renamed.
   5. Click the Rename button and then type a display name for the new custom group before you click OK.
4. In the Choose Commands From list box on the left, click the name of the macro you want to add to the custom group now selected in the Main Tabs list box on the right.
5. Click the Add button to add the selected Excel macro to the selected custom group on your custom tab. If you want to rename the macro and/or assign it a new icon, click the Rename button and make these changes in the Rename dialog box before you click the OK button to close the Excel Options dialog box.

   After you add a macro to the custom group of a custom tab, the name of the macro appears on a button on the custom tab of the Ribbon. Then, all you have to do to run the macro is click this command button.

To assign an Excel macro to a custom button on the Quick Access toolbar, follow these steps:

1. Click the Customize Quick Access Toolbar button at the end of the Quick Access toolbar and then click More Commands on its drop-down menu.
   Excel opens the Excel Options dialog box with the Quick Access Toolbar tab selected.
2. Click Macros in the Choose Commands From drop-down list box.

   Excel lists the names of all the macros you created, both those in the current Excel workbook and those that are saved in the PERSONAL.XLSB workbook, in the Choose Commands From list box.

3. Click the name of the macro to add to a custom button on the Quick Access toolbar in the Choose Commands From list box and then click the Add button.
4. Click the Modify button to open the Modify Button dialog box if you want to change the display name and assign a different icon to the macro button.
5. Click OK to close the Excel Options dialog box.

After you close the Excel Options dialog box, a custom button sporting its associated macro icon (the default with a standard command flowchart unless you changed it) appears on the Quick Access toolbar. To see the name of the Excel macro assigned to this custom macro button as a ScreenTip, position the mouse pointer over the button. To run the macro, click the button.

Earlier this fall, Microsoft announced the release to the general public of its Office 2019 suite. The 2019 version of Excel contains a wide assortment of new and improved features and capabilities. Here's a look at 12 of those upgrades, all of which I have downloaded, installed, and tested:

1. Data import tool improvements: The Power Query data import tool in Excel 2013 was renamed Get & Transform in Excel 2016, but the name has reverted to Power Query in Excel 2019, bringing it in line with the name conventions used by the related Microsoft products Power Pivot, Power Map, and Power BI. The improved Power Query tool (pictured below) provides the ability to import data from external data sources (such as your accounting system) and then scrub and clean the data (referred to as transforming the data) before placing them in Excel. Some of the transforming capabilities include the ability to group data, rename column headings, transpose data, reverse rows, detect data types, replace values, split columns, merge columns, unpivot columns, invoke custom functions, create conditional columns, and parse data.

This tool makes it faster, easier, and more accurate to import data from external sources for manipulation and analysis in Excel.

2. Automated workflow: Excel 2019 now connects better to Microsoft Flow, which allows you to create automated workflows in which data are retrieved from other applications and then stored and/or manipulated in Excel. The dataflow can be further programmed to automatically send to or share those data with other people or third-party applications. For example, Flow might be used to collect favorable customer tweets about your goods or services on your Twitter account, and then store them in your Excel workbook (on your OneDrive or SharePoint platform). These Twitter data could then be pushed periodically (every Monday morning, for example) to selected recipients through email or text messages, or published directly to websites or other data destinations.

Flow can retrieve your data from practically anywhere — your accounting system, ERP system, CRM system, stock price databases, weather forecast databases, email messages, reminder notices, Salesforce.com, etc. As examples, you could use this technology to track your hours worked, travel locations, Facebook messages, Instagram posts, travel expenses, accounts receivable, etc. To create a new data flow, start at the My Flows webpage at login.microsoftonline.com, sign in to your account using your Microsoft ID, and click the Get started button.

Click Create a flow from blank, as pictured below in the bottom right corner, and then select one of more than 200 triggers and specify the event you want to launch your automatic flow process. For example, the receipt of an email with a specific attachment may trigger an automated flow process. Continue by specifying the action(s) you want to take, such as opening the email attachment in Excel and running a specific macro to produce a PivotTable or PivotChart, then specify a connector for sharing the results through other Microsoft and third-party apps such as Outlook or SharePoint. Learn more about Flow at click.linksynergy.com.

3. 3D images: Excel 2019 now includes new 3D imaging capability in which you can rotate a 3D model of an object. While it's difficult to convey the concept in a picture, the screenshot below contains three copies of the same butterfly image, which I have rotated to suggest the effect you might achieve.

Microsoft Excel 2019 Torrent

Excel now includes hundreds of 3D images, which are available from the Inserttab's 3D Models option. Image categories include animals, electronics, gadgets, dinosaurs, geology, space, dioramas, letters, biology, and more. A few examples of 3D graphic images are displayed in the screenshot below.

You can view my brief video demonstrating this functionality at youtu.be/VLzglo1WBZ0. http://xnvlmt.xtgem.com/Blog/__xtblog_entry/19357506-audacity-mac-catalina#xt_blog.

4. Custom functions: Excel 2019 now enables users to create their own custom functions using JavaScript. Previous editions of Excel already enabled users to create user-defined functions using Excel's built-in Visual Basic for Applications programming language; however, since JavaScript has emerged as a commonly used platform for such purposes, Microsoft has added this new capability to allow for greater compatibility with third-party solutions.

5. New functions: Excel includes six new or improved functions, as follows: IFS, SWITCH, ­TEXTJOIN, CONCAT, MAXIFS, and MINIFS. IFS and SWITCH are simplified versions of the nested IF function, which eliminates the need for more complicated nested functions. For example, the screenshot below depicts both the nested IF approach (in red text) and the IFS approach (in blue text) for creating the formula in cell C16 that returns the proper tax base for income calculation purposes. While both approaches work, the IFS approach requires only one function while the IF approach requires three IF functions. Note that in this example the IFS approach produces a slightly longer formula because the IFS approach requires you to spell out each criterion, while the IF approach does not require you to spell out the last criteria.

The TEXTJOIN function is a simplified version of the CONCATENATE function in which inserted text need not be encapsulated by quotation marks. The CONCAT function allows you to combine text from multiple cells without specifying a delimiter. The MAXIFS and MINIFS functions work like the SUMIF or COUNTIF functions in that they calculate only the maximum or minimum for those data that meet the criteria you specify. For example, an auditor might use these functions to find the lowest and highest invoice amounts between $50 and $100, as part of statistical sampling procedures.

6. Custom visuals: To provide more visual ways to display and present your data, Microsoft has incorporated its Power BI suite of apps into Excel. To access these new custom visuals, from Excel's Add-ins tab select Get Add-ins to display the Office Add-ins dialog box pictured below.

Scroll through the apps, select the one you want to use, and then set up the app to link it to your desired data. For example, I selected the free Microsoft People Graph app to create the chart below as linked from the data displayed in cells A1:B5.

Other available visual add-in apps include Word Cloud charts, Bullet charts, Speedometer charts, the Prevedere Forecasting Tools, Lucidchart Diagrams for Excel, and Supermetrics, to name a few.

Microsoft Excel 2019 New Features

Note: I counted more than 350 available Excel add-in apps as of September 2018; more apps may be added. (Most of these add-in apps are available for free, while some are priced from $1.49 to $13.99, and others have subscription prices ranging from $1.49 to $5.99 per month.)

7. Full SVG graphics support: Excel 2019 now supports scalable vector graphics (SVG), which means your graphic images won't pixelate when you increase the image size, as illustrated by the small and larger hiker image in the screenshot below. (Note that this technology applies only to drawings and graphic images; it does not apply to photos, videos, or animations.)

8. 500+ new built-in icons: Excel offers 500+ new built-in SVG-compliant icons for creating dashboards and infographics; examples of the new hiker and mountain icons are displayed above.

Microsoft Excel 2019 For Mac

9. New forms capabilities:Excel 2019 now works in unison with Microsoft Forms to produce better looking documents to solicit responses to questions such as those included in surveys, polls, and quizzes. For example, using this new technology, you can produce survey forms and share them via links within Excel. To get started creating a new Form, visit forms.office.com, sign in if necessary, and click the New form button (if this is your first visit, you may see an overlay screen with a ­Create a new form button).

As you collect automated responses, you can open the survey results in Excel for further analysis or charting of the collected data.

10. Map chart improvements: New options allow you to project your maps in Albers, Mercator, or Miller layouts (which basically means you can display your map charts as flat or curved). There are also new controls for selecting the map area to be displayed. For example, you might display a world map, even though the data span only the United States.

11. Chart improvements: New options in Excel 2019 allow you to better control axis information on your funnel charts, such as tick marks and number formats, and you can now also produce color-coded heat maps.

12. Co-authoring: New co-authoring capabilities enable you to share your workbooks with others so multiple users can edit the same workbook at the same time when your file is stored on either the SharePoint or OneDrive platform. The sharing tool also allows you to set permissions for collaborators, and workbooks can be shared with individuals or groups of users (see the screenshot below).

When a workbook is shared in this manner, the names of all active collaborators are displayed in the upper right corner. Also displayed are the worksheet and cell addresses where collaborators are actively editing. All changes are shared almost immediately with other collaborators, so there is little lag time between user updates (previously all changes made between shared workbooks were updated for all collaborators every 15 minutes by default). Workbooks can be shared in this manner to other computers, tablets, and smartphones running Excel. If a collaborator doesn't have Excel loaded on his or her device, then Excel Online launches automatically in a browser environment to display the shared workbook.

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Microsoft Excel 2019 Free Download

Submit a question

Download Microsoft Excel 2019

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.