Link to this headingExcel

Shortcuts:

• Alt + =: Auto Sum
• Alt + O + A: Auto format table
• Ctrl + Space: Select the full column
• Alt + A + E: Convert Text to columns (like for CSVs)
• Alt + H + O + I: Autofix cell sizes
• Ctrl + T: Create a Table from selection

Helpful Functions:

• =IMAGE("http://URL"): Render Image from URL

Link to this headingBar Charts

1. REPT("|", A3)
2. Change Font to Playbill

Link to this headingLine Graph

1. Select Cells
2. Insert Tab -> Line Button
3. Select Data Range

Link to this headingBarcodes

1. Use "*"&B2&"*"
2. Change font to Lebre Barcode 39

Link to this headingBetter Merge and Center

1. Select rows
2. Ctrl + 1
3. Alignment Tab -> Center Across Selection

Link to this headingEasy Find replace

1. Select all
2. Ctrl + G
3. Click Special Button

Link to this headingImport tables from the Web

1. Data Tab -> From Web
2. Paste the URL
3. Select Advanced
4. Select the table

Link to this headingRemove Duplicates

1. Data Tab -> Remove Duplicates

Link to this headingSheets

Generate formulas from a AI prompt

Shortcuts:

• Ctrl + Y: Repeat Last action at current location

Helpful Functions:

• =QUERY(A:F, "SELECT A, F WHERE B = 'test' and D = 'data' "): SQL Like

Link to this headingData Validation

Use Date Picker

1. Data Toolbar -> Data Validation
2. Add Rule Button -> Change Criteria Dropdown to is valid date.

Select from an Option

1. Data Toolbar -> Data Validation
2. Add Rule Button -> Change Criteria Dropdown to Dropdown.
3. Enter selections

Link to this headingCSV to Table

1. Highlight the data
2. Data Menubar -> Split text to columns

Link to this headingCustom Functions

1. Data Menubar -> Named Functions