Excel tutorial resources

Data Source: DataPig Technologies

New! Excel Recorded Webinars

10 Must Have VBA Skills

Excel Basics

Using "Paste Special"

Using Text to Columns

Tips on Filtering with "AutoFilter"

Using Goal Seek

Data Validation in Excel

About Conditional Formatting

Basics of Protecting a Worksheet

Basics of Using Subtotals

Basics of Print Setup Options

Formatting Tricks

Grouping Tabs to Save Time

Conditional Format with Four Conditions

Adding Tool Tips to Cells

Pivot Tables

Create a Basic Pivot Table

Sorting in a Pivot Table

Create a Drill Down Effect with a Pivot Table

Adding a Calculated Field in a Pivot Table

Grouping in a Pivot Table

Creating Pivot Charts

Using Pivot Table Advanced Options

Convert Pivot Tables Into Hard Data

Synchronize 2 Pivot Tables with a Combo Box

Tie a Chart to a Pivot Table

All About Multiple Consolidation Ranges

Pivot Table Based Conditional Chart

Add Dynamic Icons to Pivot Table Reports

Pivot Tables and Spreadsheet Bloat

Excel Charting Techniques

Combo Charts and Formatting Data Points

Create Dynamic Chart Labels

Create a Histogram Chart

Using the Bar to Pie Chart

Add Average Line to a Chart

Invert Negatives in a Chart

Create a Scrolling Chart (With Dynamic Ranges)

Create a Basic Speedometer Chart

Create a Thermometer Effect in you Column Charts

Creating a Delta Chart

Creating a Benchmark Chart

Use Excel Charts in PowerPoint Without Bloat

Creating Bullet Graphs in Excel

Excel Functions Explained

Matrix Lookup Formula (Index and Match)

Cell Information Functions

Text and String Functions

Formula to Convert Trailing Minus Signs

Using IF(AND()) & IF(OR()

Using the SumProduct() Function

Basics of Nested Formulas

Conditional Sums and Array Formulas

Using the SUBTOTALS Function

Dynamic Ranges Finally Explained

Excel Tips and Tricks

Increase Available Undo Actions

Using the COUNTIF() to Find Duplicates

Set Duplicates Warning with Data Validation

Formula to convert your dates to quarters

Sort by Color without an Add-in

Turn a Row Oriented Dataset into a Column Oriented Dataset

Sort by Capitalization

Using Excel Macros

All About Recording Macros

Cleaning up your Macro generated VBA

Using Spreadsheet Form Controls

Using Macros to create a user interface

Send Emails with SENDEMAIL method

Create your First User Form (Create a Splash Screen)

Calling up Excel Dialog Boxes

Force Users to Enable Macros

VBA Basics

Quick overview of VBA

Understanding Reference Libraries

Declaring Variables

Using If Statements

Using Select Case Statements

The Basics of the Do Loops

Using For Next Loops

Looping with For Each Statements

What are the contents of test plan?

Quality Assurance Test Plan (QATP) is an evolving document which will guide you what to do and when to do. The Test Plan depend on your test strategy for the project and model you are using such as Waterfall, Agile, etc.

QATP will consist of the following but not restricted to and available for all your QA Team members and any external / internal stakeholders to understand your test approach.

1. Product Overview
Briefly explain the product that you are considering for the testing.

2. Scope Of Testing
• Functional Requirements
• Non-Functional Requirements
• Out of Scope

3. Assumptions, Dependencies & Risk

4. Testing Approach ( Important section of your QATP)
• Here you will explain what sort of approach you are considering based on the product risk and if it is Agile then for each sprint what are the functionalities you are considering and how are you going to go about it.
• The different type of testing that you are considering and its entry and exit criteria’s (Smoke, Regression, etc)

5. Acceptance Criteria / Quality Gate
This is your exit criteria with your customer. Be careful when you define this
• 0 Critical & Showstopper
• 0 High Defects
• Less than 5 medium defects, etc
• 100% Test coverage

6. Test Environment
Software / Hardware requirement, Tools required, Any diagram for test environment if applicable, etc

7. Test Management
• Test Design, Execution and Reporting you briefly touch upon as to how you going to manage
• Test Metrics – Measurements to indicate your quality such as Defect density, defect severity index, etc
• Defect management

8. Any other details you think required for your audience

How to upgrade QC9.2 to QC10?

Here is a brief summary of QC upgrade from v9.2 to v10: (my suggestion is to perform the upgrade in a test server first and then production)

1.Backup DB schemas and File System repository. Note: it is recommended to stop QC Service during backup
2.Install Patch 32 to move existing DB projects to the File system prior to uninstalling QC9.2. Again, perform a backup of DB schemas and File System repository.
3.Uninstall QC9.2 patches and then uninstall the software. Also, verify that the Remove Project > Restore Project (new QC repository). Then select project > Verify Project (Backup projects prior to running repair and save a copy of the exported log).
12. Repair Project > Upgrade Project > Ping Project and connection string
13. Activate Project and then Login to "testproject" in QC10. Note: I received this error when login to the project: "License Error: Business Components you're exceeding your licenses." To fix: Login to the project and go the project Customization window > Module Access. Double-click on Business components to disable it. Note: if your current license doesn't include the business components module or some other module you may get a similar error when log in to the project. >> I had to do this for all projects.
14. Last - verify group permissions, workflow, and so on.

Server specs: Win2003 SP2, JBOSS Appl, IIS Web server, Oracle 9i DB.

QC Error :Invalid Sever response

Error :Invalid Server Response

Ans: Restart the App server of QC by logging into the Windows server machine with credentials

Normally machine is : ceu-srk2-app81

and restart the service for HP Quality Center. Also check with DBAs that the DB Server for QC : EUCOP1(Production DB Server) and EUCOT1(Test DB Server) are up and running

If both are up and running, the issue should resolve itself.

Thanks

Admin

useful Metrics in Testing

ttribute	Description	Metrics /Measure
Correctness	The degree to which the software performs the required functions accurately	Defects / KLOC or Defects / Function points
Maintainability	Maintainability is the ease with which a program can be correct if an error occurs.	MTTC (Mean time to change) -- Once error is found, how much time it takes to fix it in production.
Integrity	This measure the system’s ability to with stand attacks to its security	Integrity = Summation [(1 - threat) X (1 - security)]
Usability	How usable is your Software program	* -Skill required to learn the system * -Time required to be productive on new system * -Net increase in productivity by use of the new system. * User questionnaire survey results
Defect Removal Efficiency	Defect Removal Efficiency (DRE) is a measure of the efficacy of your SQA activities..Ideal value of DRE should be 1 which means no defects found.	DRE = E / ( E + D ) Where E = No. of Errors found before delivery of the software and D = No. of Errors found after delivery of the software.
Test Coverage		Number of units (KLOC/FP) tested / total size of the system
Quality of Testing =		No. of defects found during Testing/(No. of defects found during testing + No of acceptance defects found after delivery) *100
Customer satisfaction index		Number of system enhancement/Maintainence requests per year Call volume to customer service hotline
Reliability		Availability (percentage of time a system is available, versus the time the system is needed to be available) - Mean time between failure (MTBF) - Mean time to repair (MTTR) - Reliability ratio (MTBF / MTTR) - Number of product recalls or fix releases - Number of production re-runs as a ratio of production runs

Compare the values of two database queries using QTP

Test case ID
Database1 Database2
------------------------------------------------------------------------------------------------------------------------
1 select count(*) TotalRecords
from select count(*) TotalRecords from
TableA where
abc='12' TableA where abc='12'
------------------------------------------------------------------------------------------------------------------------
2 select count(*) TotalRecords
from select count(*) TotalRecords from
TableB where
abc='12' TableB where
abc='12'
------------------------------------------------------------------------------------------------------------------------
3 select count(*) TotalRecords
from select count(*) TotalRecords from
TableC where
abc='12' TableC where
abc='12'
------------------------------------------------------------------------------------------------------------------------
Hi All,

I have 1 excel template like above containing 3 columns namely
TestcaseID, Database1,Database2 as shown above. col2 and col3 contains
queries from tables for each database resp.
What I want is to execute each queries in the sheet corresponding to
each testcaseID and then compare the result of two queries... i.e
queries contains Count(*) function so I want to compare the value of
the two queries for each testcase ID.
Similarly there are many testcases for which i need to perform the same operation.







Call RowCountValidation "RowCount"



Function RowCountValidation(strRowCountFile)
''Initialize Database Objects
Dim adoRecordSet1,adoRecordSet2
Dim adoConnection
Dim adoCommand
Dim conString
conString="Provider=SQLOLEDB.1;Password=1234;Persist Security Info=True;User ID=sa;Initial Catalog=AdventureWorks;Data Source=SHALABHDIXIT-PC"

'Set Database Objects
Set adoConnection=CreateObject("ADODB.Connection")
Set adoRecordSet1=CreateObject("ADODB.RecordSet")
Set adoRecordSet2=CreateObject("ADODB.RecordSet")

adoConnection.Open(conString)

DataTable.ImportSheet "C:\Test\"&strRowCountFile&".xls","Rowcount","Global"

strFileRowCount=DataTable.GlobalSheet.GetRowCount
MsgBox strFileRowCount

val1 = DataTable.Value("Database1",dtGlobalSheet)
val2= DataTable.Value("Database2",dtGlobalSheet)

Set adoRecordSet1=adoConnection.Execute(val1)
Set adoRecordSet2=adoConnection.Execute(val2)

fieldsCount1=adoRecordSet1.Fields.Count
fieldsCount2=adoRecordSet2.Fields.Count
MsgBox query &"fieldsCount1= " &fieldsCount1 &" fieldsCount2 = " &fieldsCount2

Do
For i=0 to fieldsCount1-1
Print adoRecordSet1.Fields(i).value & adoRecordSet1.Fields(i).Name
valueSet1=adoRecordSet1.Fields(i).Value
MsgBox valueSet1

adoRecordSet1.MoveNext

For j=0 to fieldsCount2-1
Print adoRecordSet2.Fields(j).value & adoRecordSet2.Fields(j).Name
valueSet2=adoRecordSet2.Fields(j).Value
MsgBox valueSet2
If valueSet1=valueSet2 Then
Reporter.ReportEvent micDone, "Data match success","Database matched successfully"
Else
Reporter.ReportEvent micDone, "Data match failure","Database NOT matched"
End If
Next
adoRecordSet2.MoveNext
Next

Loop until adoRecordSet1.EOF and adoRecordSet2.EOF

adoConnection.Close
Set adoConnection=nothing

End Function

Conventional Black box testing techniques

CONVENTIONAL TECHNIQUE OF BLACK BOX TESTING ARE
1)EQUIVALENCE PARTITIONING.(NO INFORMATION REQUIRED FROM DEVELOPER)
2)BOUNDARY VALUE ANALYZE.(NO INFORMATION REQUIRED FROM DEVELOPER)
3)ERROR GUESSING.(NO INFORMATION REQUIRED FROM DEVELOPER)
I AM PUTTING ONE MORE TECHNIQUE.
"FLAG BASED TESTING ANALYZE"(FBTA)
WHEN I WAS A DEVELOPER I FOUND THAT MANY ERRORS HAPPENED DURING USAGE OF "FLAGS" IN CODING.
THIS INSPIRED ME TO CREATE ONE MORE TESTING TECHNIQUE BASED ON USAGE OF "FLAGS".
LET FBTA BE BASED ON CORDINATION BETWEEN DEVELOPER AND TESTER.
LET FBTA BE BASED ON INFORMATION FROM DEVELOPER RELATING TO THE TEST SCENARIO OR TEST ITEM TO BE TESTED BY TEST ENGINEER.
INFORMATION TO BE GOT FROM DEVELOPER TO USE FBTA ON TEST SCENARIO OR TEST ITEM TO BE TESTED IS:-
A)HAS DEVELOPER USED "FLAG"(FLAG USED-FU) ANSWER "YES";"NO"
B)DEVELOPER USED FOLLOWING FLAG CONTENT (FLAG CONTENT-FC) ANSWER "BINARY"(PASS OR FAIL;1 OR 0;TRUE OR FALSE);TRINARY(0 OR 1

OR 2);INTEGER(0;1;2;3-----N)
BASED ON THE INFORMATION GOT FROM FU AND FC WE CAN USE FBTA TECHNIQUE TO DRAFT TEST CASES FOR ITEM TO BE TESTED OR RESPECTIVE TEST SCENARIO.

Excel Short Cuts

It's been a while I am collecting the Excel short cuts...and now I am posting them for you.

ctlr + space = selecting the column

shift + space = selecting the row

Cntl+D & Cntrl+R. These allow a user to duplicate an entire column or row, a great time saver

Data Entry / Copies selected cells / CTRL + C
Data Entry / Fill selected cell range with current entry / CTRL + ENTER
Data Entry / Copies value from the cell above / CTRL + SHIFT + '
Data Entry / Paste selected cells rows, column / CTRL + V
Data Entry / Copies formula from the cell above / CTRL+ '
Data Entry / Fill Down / CTRL+ D
Data Entry / Fill Right / CTRL+ R
Data Entry / Enters current time / CTRL+ SHIFT + COLON
Data Entry / Complete cell entry and select below cell / ENTER
Data Entry / Cancel a cell entry / ESC
Data Entry / Positions cursor at the end of the cell contents / F2
Data Entry / Pastes defined name into a formula / F3
Data Entry / Complete cell entry and select above cell / SHIFT + ENTER
Data Entry / Complete cell entry and select left cell / SHIFT + TAB
Data Entry / Complete cell entry and select right cell / TAB

Format / Start new line in same cell / ALT + ENTER
Format / Insert column / ALT + I , C
Format / Insert row / ALT + I , R
Format / Insert worksheet / ALT + SHIFT + F1
Format / Move or copy worksheet / ALT+ E, M
Format / Rename worksheet / ALT+ O, H, R
Format / Hide column / CTRL + 0
Format / Hide row / CTRL + 9
Format / Define a name / CTRL + F3
Format / Delete selected row or column / CTRL + MINUS SIGN
Format / Applies Number format / CTRL + SHIFT + 1
Format / Applies Time format / CTRL + SHIFT + 2
Format / Applies Date format / CTRL + SHIFT + 3
Format / Applies Currency format / CTRL + SHIFT + 4
Format / Applies Percentage format / CTRL + SHIFT + 5
Format / Applies Exponential number format / CTRL + SHIFT + 6
Format / Applies outline border to selected cells / CTRL + SHIFT + 7
Format / Removes outline border to selected cells / CTRL + SHIFT + MINUS SIGN
Format / Insert selected row / CTRL + SHIFT + PLUS SIGN
Format / Insert selected column / CTRL + SHIFT + PLUS SIGN
Format / Cut selected cells, rows, columns / CTRL + X
Format / Applies or removes bold formatting / CTRL+ 2
Format / Applies or removes italic formatting / CTRL+ 3
Format / Applies or removes underlining / CTRL+ 4
Format / Applies or removes strikethrough / CTRL+ 5
Format / Applies or removes bold formatting / CTRL+ B
Format / Applies or removes italic formatting / CTRL+ I
Format / Unhide selected hidden columns / CTRL+ SHIFT + 0
Format / Unhide selected hidden rows / CTRL+ SHIFT + 9
Format / Applies or removes underlining / CTRL+ U
Format / Delete comment / SHIFT + F10, M
Format / Insert worksheet / SHIFT + F11
Format / Insert or edit cell comment / SHIFT + F2

Function / Display Style dialog box / ALT + '
Function / Display drop down list / ALT + DOWN ARROW
Function / Delete worksheet / ALT + E, L
Function / Creates chart of data in current range / ALT + F1
Function / Opens Visual Basic (Macros) Editor / ALT + F11
Function / Displays Macro dialog box / ALT + F8
Function / Displays smart tag menu/message / ALT + SHIFT + F10
Function / Opens Microsoft Script Editor / ALT + SHIFT + F11
Function / Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation / CTRL + ALT + F9
Function / Rechecks dependent formulas and calculates all cells in all open workbooks / CTRL + ALT + SHIFT + F9
Function / Closes and reopens current task pane / CTRL + F1
Function / Close selected workbook / CTRL + F4
Function / Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula / CTRL + SHIFT + A
Function / Create names / CTRL + SHIFT + F3
Function / Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed / CTRL + SHIFT + Z
Function / Close selected workbook / CTRL + W
Function / Repeat last action / CTRL + Y
Function / Repeats last command or action / CTRL + Y
Function / Undo last action / CTRL + Z
Function / Displays Format Cells dialog box / CTRL+ 1
Function / Displays or hides the Standard toolbar / CTRL+ 7
Function / Displays or hides the outline symbols / CTRL+ 8
Function / Displays Microsoft Office Clipboard / CTRL+ C, C
Function / Enters current date / CTRL+ COLON
Function / Display the Windows Start menu / CTRL+ ESC
Function / Displays Find dialog box / CTRL+ F
Function / Displays Go To dialog box / CTRL+ G
Function / Displays Find/Replace dialog box / CTRL+ H
Function / Displays Insert/Edit Hyperlink dialog box / CTRL+ K
Function / Displays Create List dialog box / CTRL+ L
Function / Displays Delete dialog box / CTRL+ MINUS SIGN
Function / Creates new, blank file / CTRL+ N
Function / Displays Open dialog box / CTRL+ O
Function / Displays Print dialog box / CTRL+ P
Function / Saves active file / CTRL+ S
Function / Displays Insert dialog box / CTRL+ SHIFT + PLUS SIGN
Function / Displays Help task pane / F1
Function / Selects or closes menu bar / F10
Function / Creates chart of data in current range / F11
Function / Displays Save As dialog box / F12
Function / Repeat last action / F4
Function / Display Go To dialog box / F5
Function / Displays Spelling Check dialog box for active cell / F7
Function / Calculates all worksheets in all open workbooks / F9
Function / Calculates selected portion of formula and replaces the selected portion with the calculated value / F9 followed by ENTER (or followed by CTRL + SHIFT + ENTER for array formulas)
Function / Shortcut menu / SHIFT + F10
Function / Displays Insert Function dialog box / SHIFT + F3
Function / Repeat last Find action / SHIFT + F4
Function / Display Find dialog box / SHIFT + F5
Function / Calculates active worksheet / SHIFT + F9

Selection / Select visible cells in current selection / ALT + ;
Selection / Select array / CTRL + /
Selection / Select all cells directly referenced by formulas in selection / CTRL + [
Selection / Select cells that don't match formula or static value in active cell / CTRL + \
Selection / Select cells that contain formulas that directly reference active cell / CTRL + ]
Selection / Select populated cells / CTRL + A
Selection / Select all cells / CTRL + A, A
Selection / Select all cells directly or indirectly referenced by formulas in selection / CTRL + SHIFT + {
Selection / Select the cells that don't match formula or static value in active cell / CTRL + SHIFT + |
Selection / Select cells that contain formulas that directly or indirectly reference active cell / CTRL + SHIFT + }
Selection / Extend selection to last nonblank cell / CTRL + SHIFT + ARROW KEY
Selection / Extend selection to last used lower-right cell / CTRL + SHIFT + END
Selection / Extend selection to beginning of worksheet / CTRL + SHIFT + HOME
Selection / Select populated cells / CTRL + SHIFT + SPACE
Selection / Select all cells / CTRL + SHIFT + SPACE, SPACE
Selection / Select column / CTRL + SPACE
Selection / Selects current region around active cell / CTRL+ SHIFT + 8
Selection / Selects all cells that contain comments / CTRL+ SHIFT+ O
Selection / Select current and next or previous sheet / CTRL+ SHIFT+ PAGE UP, PAGE DOWN
Selection / Extend selection to last nonblank cell in the same column or row as active cell / END + SHIFT + ARROW KEY
Selection / Extend selection to last cell in current row / END + SHIFT + ENTER
Selection / Extend selection to last used cell on worksheet (lower-right corner) / END + SHIFT + HOME
Selection / Turn extend selection mode on or off / F8
Selection / Extend selection to the cell in lower-right corner of window / SCROLL LOCK + SHIFT + END
Selection / Extend selection to cell in the upper-left corner of window / SCROLL LOCK + SHIFT + HOME
Selection / Extend selection by one cell / SHIFT + ARROW KEY
Selection / Select only active cell of multiple selection / SHIFT + BACKSPACE
Selection / Add another range of cells to selection / SHIFT + F8
Selection / Extend selection to beginning of row / SHIFT + HOME
Selection / Extend selection down one screen / SHIFT + PAGE DOWN
Selection / Extend selection up one screen / SHIFT + PAGE UP
Selection / Select row / SHIFT + SPACE

View / Move one screen to right / ALT + PAGE DOWN
View / Move one screen to left / ALT + PAGE UP
View / Switch to previous program / ALT+ SHIFT+ TAB
View / Switch next program / ALT+ TAB
View / Move one character up, down, left, or right / Arrow keys
View / Alternate between hiding and displaying objects / CTRL + 6
View / Move to edge of current data region / CTRL + ARROW KEY
View / Scroll to display active cell / CTRL + BACKSPACE
View / Move bottom most last used cell / CTRL + END
View / Maximize window size of worksheet / CTRL + F10
View / Minimize window size of worksheet / CTRL + F5
View / Switches to next workbook window / CTRL + F6
View / Moves workbook window when not maximized / CTRL + F7
View / Sizes workbook when not maximized / CTRL + F8
View / Move to beginning of worksheet / CTRL + HOME
View / Move to beginning of worksheet / CTRL + HOME
View / Switch to previous workbook window / CTRL + SHIFT + F6
View / Alternates between displaying cell values and displaying formulas in the worksheet / CTRL+ `
View / Alternates between hiding objects, displaying objects, and displaying placeholders for objects / CTRL+ 6
View / Move to next worksheet / CTRL+ PAGE DOWN
View / Move to previous worksheet / CTRL+ PAGE UP
View / Switch to next pane in split worksheet / F6
View / Move to beginning of row / HOME
View / Move down one screen / PAGE DOWN
View / Move up one screen / PAGE UP
View / Switches to previous pane in split worksheet / SHIFT + F6

ALT+E S T to paste Format..

F1 Displays the Excel Help task pane.
CTRL+F1 displays or hides the ribbon.
ALT+F1 creates an embedded chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 adds or edits a cell comment.
CTRL+F2 displays the print preview area on the Print tab in the Backstage view.
F3 Displays the Paste Name dialog box. Available only if there are existing names in the workbook.
SHIFT+F3 displays the Insert Function dialog box.
F4 Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
ALT+F4 closes Excel.
F5 Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6 Switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the ribbon area.
SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and ribbon.
CTRL+F6 switches to the next workbook window when more than one workbook window is open.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8 Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9 Calculates all worksheets in all open workbooks.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10 Turns key tips on or off. (Pressing ALT does the same thing.)
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for an Error Checking button.
CTRL+F10 maximizes or restores the selected workbook window.
F11 Creates a chart of the data in the current range in a separate Chart sheet.
SHIFT+F11 inserts a new worksheet.
ALT+F11 opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12 Displays the Save As dialog box.