#The cheat sheet free series
#The cheat sheet free download

#The cheat sheet free download

Below you can download two versions of an option strategy cheat sheet. All other company and product names are trademarks of the companies with which they are associated.Options allow investors to choose an almost unlimited number of structures to express different views on what a stock will do. Google, Google Workspace, and related marks and logos are trademarks of Google LLC. Lookup Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Math Returns a conditional sum across a range.ĭate Returns the current date as a date value.

#The cheat sheet free series

Math Returns the sum of a series of numbers and/or cells. Math Rounds a number to a certain number of decimal places according to standard rules. Statistical Returns the minimum value in a numeric dataset.ĭate Returns the current date and time as a date value. Statistical Returns the maximum value in a numeric dataset. Lookup Returns the relative position of an item in a range that matches a specified value. Lookup Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Math Rounds a number down to the nearest integer that’s less than or equal to it. Lookup Returns the content of a cell, specified by row and column offset. Logical Returns one value if a logical expression is true and another if it is false. Text Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Text Returns the position at which a string is first found within text. Statistical Returns a conditional count across a range.ĭate Converts a provided year, month, and day into a date. Statistical Returns the count of the number of numeric values in a dataset.

Lookup Returns an element from a list of choices based on index.

Statistical Returns the average of a range that depends upon multiple criteria. Statistical Returns the numerical average value in a dataset, ignoring text. Your most important Excel functions exist in Sheets, too. Publish to the web-Publish a copy of your spreadsheet as a webpage or embed your spreadsheet in a website. Version history-See all the changes you and others have made to the spreadsheet or revert to earlier versions.

This is a great way to create templates.ĭownload as-Download your spreadsheet in other formats, such as Excel or PDF.Įmail as attachment-Email a copy of your spreadsheet. Make a copy-Create a duplicate of your spreadsheet. Create different versions and copies of your spreadsheet. Collaborate with your team in real time.ĥ. They'll also receive an email notification.Ĥ. Click Share to share your spreadsheet and then choose what collaborators can do. On the menu bar, click View Freeze and choose an option.ģ. Click Data Group rows or Group columns.įreeze header rows and columns: Keep a row or column in the same place as you scroll through your spreadsheet.Point your cursor to the top of the selected cells until a hand appears.Move rows or columns: Select the row number or column letter and drag it to a new location. Right-click the highlighted row, column, or cell Insert choose where to insert the new entry.ĭelete, clear, or hide rows and columns: Right-click the row number or column letter Delete, Clear, or Hide.ĭelete cells: Select the cells and right-click Delete cells Shift left or Shift up.Select the row, column, or cell near where you want to add your new entry.