Predefined Activities for Microsoft Excel

The following table lists the default out of the box (OOTB) activities for the Windows English version of Microsoft Excel 2007, 2010, 2013 and 2016, and supports the Office 365 (o365) architecture, like integration with SharePoint.

An activity's definition uses an event to mark its start, like a mouse click or a key press. Usually there are several ways to start the same activity, like mouse clicking a menu, or typing a keyboard shortcut, or using the arrow keys to focus on a GUI entry and then pressing Enter or the space bar to select it. Hence most activities have several possible starting points, but all end with the same result.

Activity Starts after... Ends when...

Create measures the time to create a new spreadsheet.

Select File > New and then mouse click on Blank Worksheet from the list of templates.

Excel opens a new sheet and changes the title of the window to Book#.

Select File > New and then press the space bar when Blank Worksheet is in focus (version 2013 and 2016 only).

Select File > New and then mouse click Blank Worksheet when it is in focus (version 2013 and 2016 only).

Select File > New and then press Enter when Blank Worksheet is in focus.

From the main window, type Ctrl+N.

Select File > New then mouse click on the Create button (2007 and 2010 only).

Select File > New then press Enter when the Create button is in focus (2007 and 2010 only).

Select File > New then press the space bar when the Create button is in focus (2007 and 2010 only).

Launch measures the time to launch Excel.

An application's launch time, which Aternity measures automatically for all Windows applications and monitored mobile apps, starts when the process begins, and ends when it is ready to receive user input. In Windows, this is also when it finishes creating a window with a title bar. If a user double-clicks a document which also launches the app, the launch time would include BOTH opening the application AND the time to open the document, which may be significant if the document is on a slow network or it is a large or complex file.

The Excel main window finishes appearing.

Open measures the time to open an existing Excel document.

Select File > Open > Browse, select a file, then mouse click on the Open button.

The Excel main window appears with a title containing - Excel (2013 or 2016), or Microsoft Excel (2007 or 2010 only).

Select File > Open > Browse, select a file, then press Enter when the Open button is in focus.

Select File > Open > Browse, select a file, then press the space bar when the Open button is in focus.

Select File > Open > Browse, select a file, then type Alt+O.

Select File > Open > Browse, select a file, then double-click it with the mouse.

Select File > Open > Browse, select a file, then press Enter.

Select File > Open > Browse, select a file, then right-click and mouse-click Select.

Select File > Open > Browse, select a file, then click the drop-down menu of the Open button, and mouse click on Open.

Select File > Open > Browse, select a file, then click the drop-down menu of the Open button, and mouse click on Open as Copy.

Select File > Open > Browse, select a file, then click the drop-down menu of the Open button, and mouse click on Open Read Only.

Select File > Open or File > Recent, select a file, then double-click it.

Select File > Open or File > Recent, select a file, then press Enter.

Select File > Open or File > Recent, select a file, then press the space bar.

Save measures the time to save an Excel document.

Mouse click on the save icon in the toolbar.

The Excel sheet has finished saving in the main Excel window, and the status bar at the bottom of the window is refreshed.

Mouse click File > Save.

Select File, when Save is in focus, press Enter.

Select File, when Save is in focus, press the space bar.

In the main window, press Ctrl+S.

Select File > Save As, then use the same or an existing filename, select Save, then in the overwrite dialog box, mouse click on Yes.

Select File > Save As, then use the same or an existing filename, select Save, then in the overwrite dialog box, press Enter on Yes.

Select File > Save As, then use the same or an existing filename, select Save, then in the overwrite dialog box, press the space bar on Yes.

Select File > Save As, then use the same or an existing filename, select Save, then in the overwrite dialog box, press Alt+Y.

Select File > Save As, enter a new filename, then mouse click on Save.

Select File > Save As, enter a new filename, then press Enter when Save is in focus.

Select File > Save As, enter a new filename, then press the space bar when Save is in focus.

In the main window, press Shift+F12.

Incomplete Activities

In Microsoft Excel, Aternity labels an activity as incomplete in the following cases:

  • If you click or type anything or change the app focus while an activity is ongoing.

  • If, during a save, Excel issues a dialog that the file already exists, or the file is read-only, or you navigate to a different drive/folder. Aternity logs the activity properly starting when you dismiss the dialog.

  • Focus returns to Save As dialog.