Excel

Excel¶

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

Bar Charts¶

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

Line Graph¶

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

Barcodes¶

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

Better Merge and Center¶

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

Easy Find replace¶

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

Import tables from the Web¶

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

Remove Duplicates¶

1. Data Tab -> Remove Duplicates

Sheets¶

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

Data 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

CSV to Table¶

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

Custom Functions¶

1. Data Menubar -> Named Functions