You can now send prompts to AI directly in Excel to 10x your productivity.
Here are the top 7 new AI driven functions you need to know:
1. AI.ASK
Meet your new built-in Excel assistant: AI.ASK. AI.ASK allows you to ask AI questions by sending a prompt to AI directly from the grid. Just enter the question you want to ask as the prompt argument and send it off to AI!
May 15 • 12 tweets • 4 min read
10 must-know Excel shortcuts:
1. CTRL E
CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.
Sep 21, 2023 • 12 tweets • 4 min read
Formatting is key to creating professional-looking spreadsheets. Here are the top 10 Excel formatting shortcuts:
1. ALT H O I
Have you ever opened a workbook and not been able to see the data? Instead of manually adjusting the column widths in the header, try ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
Sep 14, 2023 • 7 tweets • 3 min read
5 Excel mouse shortcuts you don't know but should:
1. Copying Data
99% of Excel users copy and paste data daily, so why not do it as efficiently as possible? Just select the data you want to copy, hold CTRL, and drag the data to where you want it to be pasted.
Sep 7, 2023 • 8 tweets • 3 min read
If you use Microsoft Excel, you need to know these 6 text formatting hacks:
1. Split Cell
Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
Aug 24, 2023 • 7 tweets • 2 min read
Utilizing keyboard shortcuts will save you hours when working in Excel. Here are the top 50 Excel shortcuts to maximize productivity:
CTRL N ➡️ Open New Workbook
CTRL S ➡️ Save Workbook
F12 ➡️ Save As
CTRL W ➡️ Close Workbook
CTRL Z ➡️ Undo
CTRL Y ➡️ Redo
CTRL F ➡️ Find
CTRL H ➡️ Find & Replace
CTRL ; ➡️ Insert Current Date
CTRL SHIFT ; ➡️ Insert Current Time
Aug 15, 2023 • 12 tweets • 5 min read
10 Excel shortcuts that will save you hours: 🕝
1. ALT H O I
Have you ever opened a workbook and not been able to see the data? Instead of manually adjusting the column widths in the header, use ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
Mar 23, 2023 • 6 tweets • 2 min read
5 must-know formula shortcuts: 🤓
1. F4
We’ve all accidentally forgotten to lock a cell reference in a formula. Well, at least I know I have. To ensure this mistake never happens again, just use the F4 shortcut. F4 cycles through absolute and relative cell references.
Mar 16, 2023 • 10 tweets • 3 min read
8 shortcuts that will save you hours when formatting cells:
1. CTRL U
CTRL U underlines text without having to touch your mouse! To remove underline formatting, hit CTRL U again.
Mar 8, 2023 • 5 tweets • 2 min read
3 case functions all Excel users should know:
1. UPPER
Instead of using the caps lock key to manually type out text in uppercase format, try the UPPER function. The UPPER function automatically converts all characters in the text string to uppercase.
Mar 1, 2023 • 8 tweets • 3 min read
6 text formatting hacks all Excel user should know: ✍️
1. Split Cell
Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
Feb 24, 2023 • 6 tweets • 3 min read
4 text functions to learn in less than 5 minutes:
1. TEXTSPLIT
Need to break up data in a text string into multiple rows or columns? Use the TEXTSPLIT function to split up text at a specified delimiter. For example, this function can split full names into first, middle, and last name columns by defining the col_delimiter.
Feb 22, 2023 • 13 tweets • 5 min read
10 most-used Excel shortcuts:
1. CTRL SHIFT F3
CTRL SHIFT F3 creates a named range named after the row/column header that can be referenced directly in formulas. Now, you can simply type the name of the column you want to reference in your formula instead of manually selecting it!
Feb 16, 2023 • 8 tweets • 3 min read
5 ways to let Excel analyze your data for you:
1. Running Total
Calculating data metrics like running total can be tricky, but Excel's got you! Select the data you want to calculate > Quick Analysis > Totals tab > Running Total. As you can see, Excel auto-calculated the running total and inserted all the formulas for us!
Feb 9, 2023 • 6 tweets • 2 min read
4 Excel shortcuts that use the mouse (yes, the mouse):
1. Copying Data
Instead of using CTRL C CTRL V to copy data, try out this shortcut instead. Just select the data you want to copy, hold CTRL, and drag the data to where you want it to be pasted.
Feb 7, 2023 • 6 tweets • 2 min read
Work smarter, not harder, with these top 3 time-saving Excel tools:
1. AutoFit
Automatically fit all column widths to the size of the data by hitting ALT H O I.
Feb 2, 2023 • 9 tweets • 4 min read
6 must-know text formatting Excel tips: ✍️
1. Center Across Selection
CAS cleans up data by centering text across cells without the issues that merged cells cause. Select the text followed by the cells you want to center the text across > Home tab > Alignment Settings > Center Across Selection under horizontal > OK.
Jan 31, 2023 • 6 tweets • 2 min read
Last day of the month = Budget Tracker time. 🤑Here's how you can get your financial *sheet* in two simple steps using my Budget Tracker:
Step 1. Enter your monthly money goals on the 'Monthly Goals' tab.
Jan 27, 2023 • 13 tweets • 5 min read
Save hours and your sanity using these 10 Excel shortcuts:
1. ALT H O I
Nothing is worse than passed along messy data. Instead of manually adjusting the column widths in the header to clean it up, try ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
Jan 25, 2023 • 8 tweets • 3 min read
5 array functions you need to know:
1. TRANSPOSE
Need to flip the rows and columns in your data table? Instead of manually interchanging each row and column, try the TRANSPOSE function. Just select the data you want to transpose as the array argument, and Excel will automatically flip your data.
Creating scannable barcodes may seem like a difficult task, but Excel actually makes it easy. First, add an “*” before and after each product code using the ampersand symbol. Then just update the font to “libre barcode 128” to create the barcodes! Easy.
11 subscribed
