Канал: Excel Quick Tips

How to Freeze Cells in Excel! Follow for daily tips!

How to Freeze Cells in Excel! Follow for daily tips!

Creating a custom number format with emojis to help visualize your data

Creating a custom number format with emojis to help visualize your data

Hide sensitive information with this custom format! ⬇️

Hide sensitive information with this custom format! ⬇️

Data Entry Clerks this tip was made for you!

Data Entry Clerks this tip was made for you!

Excel’s UNIQUE function is a unique way to remove duplicate values from an array 1

Excel’s UNIQUE function is a unique way to remove duplicate values from an array 1

Import data from the web using web query to avoid having to copy and paste long

Import data from the web using web query to avoid having to copy and paste long

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE 1

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE 1

Combine each tab’s data into one tab with a 3D VSTACK function 🔥 A 3D Excel for 1

Combine each tab’s data into one tab with a 3D VSTACK function 🔥 A 3D Excel for 1

Convert PDFs to Excel quickly using Power Query 🤯 Do not manually enter data fr

Convert PDFs to Excel quickly using Power Query 🤯 Do not manually enter data fr

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Auto fill information into adjacent cells by converting text values into linked 1

Auto fill information into adjacent cells by converting text values into linked 1

Convert formulas to values in just a few keys

Convert formulas to values in just a few keys

♥️ and follow

♥️ and follow

Calculate running totals quickly by using the SUM function and locking the first 1

Calculate running totals quickly by using the SUM function and locking the first 1

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Use the CONCAT function to combine cells and text values together into one value

Use the CONCAT function to combine cells and text values together into one value

Use this symbol to combine first and last names

Use this symbol to combine first and last names

Visualize your data with Custom @ formats! ⬇️ 001

Visualize your data with Custom @ formats! ⬇️ 001

Auto fill information into adjacent cells by converting text values into linked 1

Auto fill information into adjacent cells by converting text values into linked 1

♥️ and follow

♥️ and follow

Forget everything you already know and learn this instead

Forget everything you already know and learn this instead

Why was my co worker translating these anyway

Why was my co worker translating these anyway

You can convert almost anything in Excel! ⬇️

You can convert almost anything in Excel! ⬇️

Automate tedious Excel tasks with the these two shortcuts! Press CTRL A to selec 1

Automate tedious Excel tasks with the these two shortcuts! Press CTRL A to selec 1

Auto fill information into adjacent cells by converting text values into linked 1

Auto fill information into adjacent cells by converting text values into linked 1

When flash fill can’t find a pattern in the data, try using the new text functio 1

When flash fill can’t find a pattern in the data, try using the new text functio 1

TWO NEW TEXT FUNCTIONS 1

TWO NEW TEXT FUNCTIONS 1

Translate text to another language using Google Sheet’s GOOGLETRANSLATE function 1

Translate text to another language using Google Sheet’s GOOGLETRANSLATE function 1

Translate numbers to words with the NUMBERTEXT function in Google Sheets! If you 1

Translate numbers to words with the NUMBERTEXT function in Google Sheets! If you 1

The LOOKUP function looks up a value in an array and returns the corresponding v 1

The LOOKUP function looks up a value in an array and returns the corresponding v 1

Taking a few extra seconds to add conditional formatting to your spreadsheet is 1

Taking a few extra seconds to add conditional formatting to your spreadsheet is 1

Separate a text string into columns using Google Sheet’s split text to columns f 1

Separate a text string into columns using Google Sheet’s split text to columns f 1

Say goodbye to having to go back and forth from Quickbooks to view transactions!

Say goodbye to having to go back and forth from Quickbooks to view transactions!

Say goodbye to copying and pasting the table into your PowerPoint

Say goodbye to copying and pasting the table into your PowerPoint

Separate a text string into columns using Google Sheet’s split text to columns f 1

Separate a text string into columns using Google Sheet’s split text to columns f 1

Say goodbye to having to go back and forth from Quickbooks to view transactions!

Say goodbye to having to go back and forth from Quickbooks to view transactions!

Say goodbye to copying and pasting the table into your PowerPoint 1

Say goodbye to copying and pasting the table into your PowerPoint 1

Save time by deleting all blank rows at once with this Google Sheets trick 🤯 1

Save time by deleting all blank rows at once with this Google Sheets trick 🤯 1

real time data into your worksheet by converting text values to linked data type 1

real time data into your worksheet by converting text values to linked data type 1

Red flag They use the mouse in Excel 1

Red flag They use the mouse in Excel 1

Quickly customize and crank out calendar arrays using Excel’s SEQUENCE function 1

Quickly customize and crank out calendar arrays using Excel’s SEQUENCE function 1

Look like a spreadsheet wizard with Google Sheet’s SPARKLINE function! SPARKLINE 1

Look like a spreadsheet wizard with Google Sheet’s SPARKLINE function! SPARKLINE 1

If summing the same cell on multiple different Excel tabs, use a 3D formula! A 1

If summing the same cell on multiple different Excel tabs, use a 3D formula! A 1

How to replace errors using Go To Special 1

How to replace errors using Go To Special 1

How to quickly sort data by cell color using the sort dialog box 🎨 Who has tri 1

How to quickly sort data by cell color using the sort dialog box 🎨 Who has tri 1

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE 1

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE 1

Hot take If you are adjusting your rows and columns with a mouse you’re doing 1

Hot take If you are adjusting your rows and columns with a mouse you’re doing 1

Here’s a quick tutorial on how to return a cell’s formula using Excel’s FORMULAT 1

Here’s a quick tutorial on how to return a cell’s formula using Excel’s FORMULAT 1

Flash Fill is a life saver when it comes to reformatting data! 😅 1

Flash Fill is a life saver when it comes to reformatting data! 😅 1

Extract the month, day, or year from a date using these three date functions! Wh

Extract the month, day, or year from a date using these three date functions! Wh

Extract first and last name from emails using Excel’s 1

Extract first and last name from emails using Excel’s 1

Excel’s UNIQUE function is a unique way to remove duplicate values from an array 1

Excel’s UNIQUE function is a unique way to remove duplicate values from an array 1

Drop down menus are a great way to simplify data entry in Excel 🤓 1

Drop down menus are a great way to simplify data entry in Excel 🤓 1

Count blank cells in your data with Excel’s COUNTBLANK function 😶 1

Count blank cells in your data with Excel’s COUNTBLANK function 😶 1

Convert PDFs to Excel quickly using Power Query 🤯 Do not manually enter data fr

Convert PDFs to Excel quickly using Power Query 🤯 Do not manually enter data fr

Combine each tab’s data into one tab with a 3D VSTACK function 🔥 A 3D Excel for 1

Combine each tab’s data into one tab with a 3D VSTACK function 🔥 A 3D Excel for 1

Calculate the number of days between two dates using Excel’s DAYS function 1

Calculate the number of days between two dates using Excel’s DAYS function 1

Calculate running totals quickly by using the SUM function and locking the first 1

Calculate running totals quickly by using the SUM function and locking the first 1

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Automate tedious Excel tasks with the these two shortcuts! Press CTRL A to selec 1

Automate tedious Excel tasks with the these two shortcuts! Press CTRL A to selec 1

Auto fill information into adjacent cells by converting text values into linked 1

Auto fill information into adjacent cells by converting text values into linked 1

If summing the same cell on multiple different Excel tabs, use a 3D formula! A 1

If summing the same cell on multiple different Excel tabs, use a 3D formula! A 1

My co worker is never going to make another spreadsheet

My co worker is never going to make another spreadsheet

Forget everything you already know and learn this instead

Forget everything you already know and learn this instead

♥️ and follow

♥️ and follow

You can convert almost anything in Excel! ⬇️

You can convert almost anything in Excel! ⬇️

Why was my co worker translating these anyway

Why was my co worker translating these anyway

Visualize your data with Custom @ formats! ⬇️ 001

Visualize your data with Custom @ formats! ⬇️ 001

Use this symbol to combine first and last names

Use this symbol to combine first and last names

Use the CONCAT function to combine cells and text values together into one value

Use the CONCAT function to combine cells and text values together into one value

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Unhide all hidden rows in Excel with this keyboard shortcut! CTRL A selects all

Unhide all hidden rows in Excel with this keyboard shortcut! CTRL A selects all

Unhide all columns and rows using AutoFit! So much faster than manually unhiding

Unhide all columns and rows using AutoFit! So much faster than manually unhiding

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

Translation IF the student was absent OR scored less than 70 , then the student

Translation IF the student was absent OR scored less than 70 , then the student

This shortcut gives you a sequence of consecutive days

This shortcut gives you a sequence of consecutive days

This is why you should change the way you merge

This is why you should change the way you merge

This is the best possible way to seamlessly switch columns

This is the best possible way to seamlessly switch columns

Split text in seconds using just two keys 🤯 Flash Fill can split text, combine

Split text in seconds using just two keys 🤯 Flash Fill can split text, combine

Teacher wanted to see me after class 😳

Teacher wanted to see me after class 😳

The easiest way to visualize your data

The easiest way to visualize your data

Say goodbye to copying and pasting the table into your PowerPoint after every up

Say goodbye to copying and pasting the table into your PowerPoint after every up

Save tons of time hiding rows with these two keys! 😎

Save tons of time hiding rows with these two keys! 😎

Save time using the F4 shortcut to repeat the last action 🔁

Save time using the F4 shortcut to repeat the last action 🔁

Remove thousands of blank rows in less than 15 seconds using the Go To dialog bo

Remove thousands of blank rows in less than 15 seconds using the Go To dialog bo

Remove duplicate values using advanced filters 🤯

Remove duplicate values using advanced filters 🤯

Reformat thousands of names to any format you want using just two keys 🤯

Reformat thousands of names to any format you want using just two keys 🤯

Quickly get the logo for any company using this easy formula

Quickly create and customize a geographic map chart using these keys! You can al

Quickly create and customize a geographic map chart using these keys! You can al

Quickly create a chart with just two keys

Quickly create a chart with just two keys

Please don’t tell my boss

Please don’t tell my boss

NOW my co worker has too much extra time!

NOW my co worker has too much extra time!

My co worker was left speechless

My co worker was left speechless

My co worker spent the rest of the day watching tv

My co worker spent the rest of the day watching tv

My co worker spent the rest of the day snacking

My co worker spent the rest of the day snacking

My co worker spent the rest of the day playing minesweeper

My co worker spent the rest of the day playing minesweeper

My co worker spent the rest of the day playing Solitaire

My co worker spent the rest of the day playing Solitaire

My co worker spent the rest of the day napping in the back room

My co worker spent the rest of the day napping in the back room

My co worker is never going to make another spreadsheet

My co worker is never going to make another spreadsheet

My co worker is low key really good at math though

My co worker is low key really good at math though

My boss loved the advice

My boss loved the advice

My boss let me go home early

My boss let me go home early

My boss gave us both a raise after this

My boss gave us both a raise after this

My boss couldn’t believe it was that easy

My boss couldn’t believe it was that easy

Meet the Siri of Excel National Language Query! Simply type in how you want to

Meet the Siri of Excel National Language Query! Simply type in how you want to

Inserting rows using the keyboard shortcut is way more efficient than using the

Inserting rows using the keyboard shortcut is way more efficient than using the

Impress your boss with this TRANSPOSE function ⬇️

Impress your boss with this TRANSPOSE function ⬇️

Impress anyone by creating a simple mini line chart to summarize data 🤩

Impress anyone by creating a simple mini line chart to summarize data 🤩

Import printed out data into Excel by taking a picture of it 📸

Import printed out data into Excel by taking a picture of it 📸

Import data from the web using web query to avoid having to copy and paste long

Import data from the web using web query to avoid having to copy and paste long

If you manually combine files this one’s for you! Save tons of time combining 001

If you manually combine files this one’s for you! Save tons of time combining 001

I became an Excel Wizard

I became an Excel Wizard

How to use Drop Down Lists in Excel

How to use Drop Down Lists in Excel

How to use =HYPERLINK in Excel! 001 001

How to use =HYPERLINK in Excel! 001 001

How to Freeze Cells in Excel! Follow for daily tips!

How to Freeze Cells in Excel! Follow for daily tips!

How to CREATE TABLES in Excel!

How to CREATE TABLES in Excel!

How to CREATE TABLES in Excel! Copy

How to CREATE TABLES in Excel! Copy

Highly recommend taking an extra couple seconds to add data bars to your data ta

Highly recommend taking an extra couple seconds to add data bars to your data ta

Hide sensitive information with this custom format! ⬇️

Hide sensitive information with this custom format! ⬇️

He couldn’t believe it

He couldn’t believe it

Format thousands of numbers as percentages in seconds using this custom format

Format thousands of numbers as percentages in seconds using this custom format

Extract data from the left and the right of a text string using the LEFT and RIG

Extract data from the left and the right of a text string using the LEFT and RIG

Data Entry Clerks this tip was made for you!

Data Entry Clerks this tip was made for you!

Creating a custom number format with emojis to help visualize your data

Creating a custom number format with emojis to help visualize your data

Convert formulas to values in just a few keys

Convert formulas to values in just a few keys

Combine first and last names insanely fast!

Combine first and last names insanely fast!

Clean up your data in seconds with the Flash Fill data tool⚡️

Clean up your data in seconds with the Flash Fill data tool⚡️

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

♥️ and follow

♥️ and follow

You can convert almost anything in Excel! ⬇️

You can convert almost anything in Excel! ⬇️

13 April 2022

13 April 2022

Why was my co worker translating these anyway

Why was my co worker translating these anyway

Visualize your data with Custom @ formats! ⬇️ 001

Visualize your data with Custom @ formats! ⬇️ 001

Use this symbol to combine first and last names

Use this symbol to combine first and last names

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Unsure of what the Roman numeral of a number is Not a problem! Convert any numb

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

Transpose the orientation of an array in a few seconds with the TRANSPOSE functi

This is why you should change the way you merge

This is why you should change the way you merge

This shortcut gives you a sequence of consecutive days

This shortcut gives you a sequence of consecutive days

The easiest way to visualize your data

The easiest way to visualize your data

7 April 2022

7 April 2022

Teacher wanted to see me after class 😳

Teacher wanted to see me after class 😳

Say goodbye to copying and pasting the table into your PowerPoint after every up

Say goodbye to copying and pasting the table into your PowerPoint after every up

Quickly get the logo for any company using this easy formula

Quickly create a chart with just two keys

Quickly create a chart with just two keys

Please don’t tell my boss

Please don’t tell my boss

NOW my co worker has too much extra time!

NOW my co worker has too much extra time!

My co worker was left speechless

My co worker was left speechless

My co worker spent the rest of the day watching tv

My co worker spent the rest of the day watching tv

My co worker spent the rest of the day watching Sunny

My co worker spent the rest of the day watching Sunny

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE function

How to convert from one currency to another using Google Sheet’s GOOGLEFINANCE function

My co worker spent the rest of the day snacking

My co worker spent the rest of the day snacking

My co worker spent the rest of the day playing Solitaire

My co worker spent the rest of the day playing Solitaire

My co worker spent the rest of the day playing minesweeper

My co worker spent the rest of the day playing minesweeper

My co worker spent the rest of the day napping in the back room

My co worker spent the rest of the day napping in the back room

My co worker is never going to make another spreadsheet

My co worker is never going to make another spreadsheet

My co worker is low key really good at math though

My co worker is low key really good at math though

My boss loved the advice

My boss loved the advice

My boss let me go home early

My boss let me go home early

Hide sensitive information with this custom format! ⬇️

Hide sensitive information with this custom format! ⬇️

My boss gave us both a raise after this

My boss gave us both a raise after this

My boss couldn’t believe it was that easy

My boss couldn’t believe it was that easy

Impress your boss with this TRANSPOSE function ⬇️

Impress your boss with this TRANSPOSE function ⬇️

If you manually combine files this one’s for you! Save tons of time combining 001

If you manually combine files this one’s for you! Save tons of time combining 001

I became an Excel Wizard

I became an Excel Wizard

How to use Drop Down Lists in Excel 001

How to use Drop Down Lists in Excel 001

How to use =HYPERLINK in Excel! 001 001

How to use =HYPERLINK in Excel! 001 001

How to Freeze Cells in Excel! Follow for daily tips!

How to Freeze Cells in Excel! Follow for daily tips!

How to CREATE TABLES in Excel!

How to CREATE TABLES in Excel!

Hide sensitive information with this custom format! ⬇️

Hide sensitive information with this custom format! ⬇️

He couldn’t believe it

He couldn’t believe it

Forget everything you already know and learn this instead

Forget everything you already know and learn this instead

Data Entry Clerks this tip was made for you!

Data Entry Clerks this tip was made for you!

Creating a custom number format with emojis to help visualize your data

Creating a custom number format with emojis to help visualize your data

Convert formulas to values in just a few keys

Convert formulas to values in just a few keys

Combine first and last names insanely fast!

Combine first and last names insanely fast!

Clean up your data in seconds with the Flash Fill data tool⚡️

Clean up your data in seconds with the Flash Fill data tool⚡️

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

Calculate age easily using Excel’s hidden DATEDIF function! DATEDIF is used to c

♥️ and follow

♥️ and follow

Unhide all hidden rows in Excel with this keyboard shortcut! CTRL A selects all

Unhide all hidden rows in Excel with this keyboard shortcut! CTRL A selects all

Unhide all columns and rows using AutoFit! So much faster than manually unhiding

Unhide all columns and rows using AutoFit! So much faster than manually unhiding

Translation IF the student was absent OR scored less than 70 , then the student

Translation IF the student was absent OR scored less than 70 , then the student

Split text in seconds using just two keys 🤯 Flash Fill can split text, combine

Split text in seconds using just two keys 🤯 Flash Fill can split text, combine

Save tons of time hiding rows with these two keys! 😎

Save tons of time hiding rows with these two keys! 😎

Save time using the F4 shortcut to repeat the last action 🔁

Save time using the F4 shortcut to repeat the last action 🔁

Remove thousands of blank rows in less than 15 seconds using the Go To dialog bo

Remove thousands of blank rows in less than 15 seconds using the Go To dialog bo

Remove duplicate values using advanced filters 🤯

Remove duplicate values using advanced filters 🤯

Reformat thousands of names to any format you want using just two keys 🤯

Reformat thousands of names to any format you want using just two keys 🤯

Use the CONCAT function to combine cells and text values together into one value

Use the CONCAT function to combine cells and text values together into one value

Reformat thousands of names to any format you want using just two keys 🤯

Reformat thousands of names to any format you want using just two keys 🤯

Quickly create and customize a geographic map chart using these keys! You can al

Quickly create and customize a geographic map chart using these keys! You can al

Meet the Siri of Excel National Language Query! Simply type in how you want to

Meet the Siri of Excel National Language Query! Simply type in how you want to

Inserting rows using the keyboard shortcut is way more efficient than using the

Inserting rows using the keyboard shortcut is way more efficient than using the

Impress anyone by creating a simple mini line chart to summarize data 🤩

Impress anyone by creating a simple mini line chart to summarize data 🤩

Import printed out data into Excel by taking a picture of it 📸

Import printed out data into Excel by taking a picture of it 📸

Import data from the web using web query to avoid having to copy and paste long

Import data from the web using web query to avoid having to copy and paste long

Highly recommend taking an extra couple seconds to add data bars to your data ta

Highly recommend taking an extra couple seconds to add data bars to your data ta

Format thousands of numbers as percentages in seconds using this custom format

Format thousands of numbers as percentages in seconds using this custom format

Excel formula or magic trick Alt = detects data around a cell and sums it! It e

Excel formula or magic trick Alt = detects data around a cell and sums it! It e

Extract data from the left and the right of a text string using the LEFT and RIG

Extract data from the left and the right of a text string using the LEFT and RIG