Top data cleaning functions you need to know. 🤓📊 1. UNIQUE

=UNIQUE(array, [by_col], [exactly_once])

The UNIQUE function removes duplicate values by returning a unique list of values in an array.

The future of Excel is officially here. 🤖

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!

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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!

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!

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.

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.

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.

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.

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.

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.