Queens College Service Desk

Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques. Select the cell with the formatting ...

Create a watermark Select Insert >Text > Header & Footer.Insert Header and Footer Tap on the header and on the Header & Foo...

Hide or display all zero values on a worksheet Go to File > Options > Advanced. Options Under Display options for this worksheet, sel...

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format cod...

Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Create a formula that refers to values in oth...

Use VLOOKUP when you need to find things in a table or a range by row. For example, find an employee email based on their employee name. VLOOKUP Synta...

Use the SUM function to sum numbers in a range Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and...

The COUNTIF function in Excel is used to count the number of cells that meet a condition (criteria). COUNTIF Syntax: =COUNTIF(range, crit...

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF...

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of ...