Канал: Excel Scholar

How to join text in Excel with the TEXTJOIN function

How to join text in Excel with the TEXTJOIN function

Use the TOCOL function to put data into a column in Excel #shorts #excel

Use the TOCOL function to put data into a column in Excel #shorts #excel

How to convert kilometers to miles in Excel with the CONVERT function

How to convert kilometers to miles in Excel with the CONVERT function

🤯 Did you know you could do this in Excel? [Geography data]

🤯 Did you know you could do this in Excel? [Geography data]

Learn these keyboard shortcuts to tidy up messy formatting in Excel!

Learn these keyboard shortcuts to tidy up messy formatting in Excel!

Learn this function if you work with text in Excel! [TEXTBEFORE]

Learn this function if you work with text in Excel! [TEXTBEFORE]

How to import images from URLs into Google Sheets

How to import images from URLs into Google Sheets

Learn the TEXTSPLIT function today! #excel #exceltips

Learn the TEXTSPLIT function today! #excel #exceltips

Use conditional formatting and the LEN function to easily check character lengths in Excel

Use conditional formatting and the LEN function to easily check character lengths in Excel

How to use Flash Fill in Excel with CTRL + E

How to use Flash Fill in Excel with CTRL + E

Import data from the web into Excel the quick and tidy way!

Import data from the web into Excel the quick and tidy way!

Using the "Replace All" feature in Excel to save time 🙂

Using the "Replace All" feature in Excel to save time 🙂

How to use TRIM and PROPER in Excel to tidy text

How to use TRIM and PROPER in Excel to tidy text

AutoFit row heights and column widths in Excel with shortcuts (ALT H O A and ALT H O I)

AutoFit row heights and column widths in Excel with shortcuts (ALT H O A and ALT H O I)

How to import PDF files into Excel quickly and easily!

How to import PDF files into Excel quickly and easily!

How to get info about films in Excel with the movies data type 🎥

How to get info about films in Excel with the movies data type 🎥

How to make a simple drop down list in Excel

How to make a simple drop down list in Excel

Tidy messy formatting in Excel in seconds with ALT, H, J, Enter

Tidy messy formatting in Excel in seconds with ALT, H, J, Enter

Use the XLOOKUP function to find things in Excel!

Use the XLOOKUP function to find things in Excel!

How to rotate data in Excel with the Transpose feature 😎

How to rotate data in Excel with the Transpose feature 😎

Get information about places by using the Geography data type in Excel 🌍

Get information about places by using the Geography data type in Excel 🌍

How to use the CONVERT function in Excel to convert numbers!

How to use the CONVERT function in Excel to convert numbers!

Turn names into emails with Flash Fill in Excel

Turn names into emails with Flash Fill in Excel

Excel chart mistakes you MUST avoid!

Excel chart mistakes you MUST avoid!

How to use the NETWORKDAYS.INTL function in Excel

How to use the NETWORKDAYS.INTL function in Excel

Quickly remove bad formatting in Excel by reverting to the "Normal" style

Quickly remove bad formatting in Excel by reverting to the "Normal" style

Create a table with CTRL + T in Excel #excel #exceltips

Create a table with CTRL + T in Excel #excel #exceltips

How to move rows in Excel by dragging them whilst holding shift

How to move rows in Excel by dragging them whilst holding shift

How to add leading zeros in Excel (use "0"# for variable length numbers) #excel

How to add leading zeros in Excel (use "0"# for variable length numbers) #excel

How to start a new line in the same cell in Excel #excel #exceltips #exceltricks

How to start a new line in the same cell in Excel #excel #exceltips #exceltricks

How to add data bars in Excel #excel #exceltips #exceltutorial #microsoftexcel

How to add data bars in Excel #excel #exceltips #exceltutorial #microsoftexcel

How to fill blank cells in Excel the quick way! #excel #exceltips #exceltricks

How to fill blank cells in Excel the quick way! #excel #exceltips #exceltricks

How to make sparklines (mini charts) in Excel

How to make sparklines (mini charts) in Excel

Calculate the number of working days between two dates with the NETWORKDAYS function in Excel

Calculate the number of working days between two dates with the NETWORKDAYS function in Excel

Turn dates into days with the TEXT function in Excel

Turn dates into days with the TEXT function in Excel

Using the YEARFRAC and TODAY functions together in Excel

Using the YEARFRAC and TODAY functions together in Excel

How to use the TEXTBEFORE function in Excel

How to use the TEXTBEFORE function in Excel

Using the UPPER and TRIM functions together in Excel

Using the UPPER and TRIM functions together in Excel

How to make dummy data in Excel using the RANDBETWEEN function #excel #shorts

How to make dummy data in Excel using the RANDBETWEEN function #excel #shorts

How to remove backgrounds from images in Excel #excel #exceltutorial #exceltips #shorts

How to remove backgrounds from images in Excel #excel #exceltutorial #exceltips #shorts

Translate text in Google Sheets with the GOOGLETRANSLATE function

Translate text in Google Sheets with the GOOGLETRANSLATE function

VLOOKUP vs XLOOKUP: a quick comparison

VLOOKUP vs XLOOKUP: a quick comparison

Terrain data type in Excel ⛰️

Terrain data type in Excel ⛰️

How to make barcodes in Excel 😲

How to make barcodes in Excel 😲

How to use TEXTAFTER in Excel #shorts

How to use TEXTAFTER in Excel #shorts

🤯 Did you know you could do this in Excel? #shorts

🤯 Did you know you could do this in Excel? #shorts

Let Excel do the maths for you with Goal Seek! #shorts

Let Excel do the maths for you with Goal Seek! #shorts

Learn TEXTJOIN in Excel #shorts

Learn TEXTJOIN in Excel #shorts

The power of the LOOKUP function in Excel 😲

The power of the LOOKUP function in Excel 😲

Drop-down lists in Excel: not as complicated as you might think!

Drop-down lists in Excel: not as complicated as you might think!

Find out a country's national anthem in Excel

Find out a country's national anthem in Excel

Have you used the IMAGE function in Google Sheets before? #shorts

Have you used the IMAGE function in Google Sheets before? #shorts

How to use the VSTACK function in Excel

How to use the VSTACK function in Excel

Learn Excel shortcuts #shorts

Learn Excel shortcuts #shorts

Highlight cells greater than X in Excel #shorts

Highlight cells greater than X in Excel #shorts

Excel trick: ALT H O I, ALT H O A #shorts

Excel trick: ALT H O I, ALT H O A #shorts

Check stock prices in Google Sheets #shorts

Check stock prices in Google Sheets #shorts

The TOROW function in Excel #shorts

The TOROW function in Excel #shorts

Did you know about the UNIQUE function in Excel? #shorts

Did you know about the UNIQUE function in Excel? #shorts

Create mini charts in Google Sheets #shorts

Create mini charts in Google Sheets #shorts

NEW Excel function! TOCOL #shorts

NEW Excel function! TOCOL #shorts

Excel tip: LEN and Conditional Formatting #shorts

Excel tip: LEN and Conditional Formatting #shorts

Don't be the person that doesn't use Flash Fill #shorts

Don't be the person that doesn't use Flash Fill #shorts

Make your job easier with conditional formatting #shorts

Make your job easier with conditional formatting #shorts

You should learn XLOOKUP #shorts

You should learn XLOOKUP #shorts

If you don't know this Excel shortcut you're missing out #shorts

If you don't know this Excel shortcut you're missing out #shorts

Make big lists of numbers in Excel without dragging your mouse #shorts

Make big lists of numbers in Excel without dragging your mouse #shorts

The bad way and the good way #shorts

The bad way and the good way #shorts

If you use Excel, you need to know about the PROPER function #shorts

If you use Excel, you need to know about the PROPER function #shorts

It doesn't take much time to get good at Excel #shorts

It doesn't take much time to get good at Excel #shorts

Make sure you know this Excel shortcut! #shorts

Make sure you know this Excel shortcut! #shorts

When your boss asks you to do a big manual task in Excel... #shorts

When your boss asks you to do a big manual task in Excel... #shorts

Learn these two Excel functions! #shorts #excel

Learn these two Excel functions! #shorts #excel

Did you know about Transpose in Excel? #shorts

Did you know about Transpose in Excel? #shorts

Learn Conditional Formatting in Excel #shorts #excel

Learn Conditional Formatting in Excel #shorts #excel

DON'T make these Excel chart mistakes! #shorts

DON'T make these Excel chart mistakes! #shorts

Learn this Excel feature! #shorts

Learn this Excel feature! #shorts

PROPER and LOWER in Excel #shorts #excel

PROPER and LOWER in Excel #shorts #excel

Easily Split Data in Excel #shorts #excel

Easily Split Data in Excel #shorts #excel

Who knew you could do this in Excel? 😲 #shorts #excel

Who knew you could do this in Excel? 😲 #shorts #excel

Get faster at Excel #shorts #excel #exceltips

Get faster at Excel #shorts #excel #exceltips

Break out data #shorts #excel #exceltips

Break out data #shorts #excel #exceltips

How to Make Random Numbers in Excel: RANDBETWEEN

How to Make Random Numbers in Excel: RANDBETWEEN

Less than 40 #shorts #excel #exceltips #exceltutorial

Less than 40 #shorts #excel #exceltips #exceltutorial

Highlight below average numbers #shorts #excel #exceltips #exceltutorial

Highlight below average numbers #shorts #excel #exceltips #exceltutorial

How to Use the UNIQUE Function in Excel - 3 Minute Tutorial

How to Use the UNIQUE Function in Excel - 3 Minute Tutorial

Above average #shorts #excel #exceltips

Above average #shorts #excel #exceltips

Make Your Excel Data Look Better with the Quick Analysis Tool

Make Your Excel Data Look Better with the Quick Analysis Tool

Fill lists of data in Excel the quick way! #shorts

Fill lists of data in Excel the quick way! #shorts

Remove unwanted characters in Excel #shorts

Remove unwanted characters in Excel #shorts

Did You Know You Could Do This With AutoSum in Excel?

Did You Know You Could Do This With AutoSum in Excel?

The COUNTIF Function #shorts

The COUNTIF Function #shorts

The Excel Feature You Probably Didn't Know About: Sparklines

The Excel Feature You Probably Didn't Know About: Sparklines

14 Second XLOOKUP Tutorial #shorts

14 Second XLOOKUP Tutorial #shorts

How to flip data in Excel ⤴️⤵️ #shorts

How to flip data in Excel ⤴️⤵️ #shorts

My favourite keyboard shortcut combo #shorts

My favourite keyboard shortcut combo #shorts

Learn this function if you want to practice Excel with dummy data! #shorts

Learn this function if you want to practice Excel with dummy data! #shorts

Learn this Excel trick in 5 seconds #shorts

Learn this Excel trick in 5 seconds #shorts

Such a cool Excel function! #shorts

Such a cool Excel function! #shorts

The QUICK way to make lists of numbers in Excel #shorts

The QUICK way to make lists of numbers in Excel #shorts

Flash Fill ⚡⚡ #shorts

Flash Fill ⚡⚡ #shorts

Did you know about this? #shorts #excel

Did you know about this? #shorts #excel

Did you know about this shortcut? #shorts

Did you know about this shortcut? #shorts

Brilliant Text Functions ♥️ #shorts

Brilliant Text Functions ♥️ #shorts

How to Hide and Unhide Columns in Excel

How to Hide and Unhide Columns in Excel

Jobs that require Excel skills #shorts

Jobs that require Excel skills #shorts

The QUICK way for making lists of numbers in Excel #shorts

The QUICK way for making lists of numbers in Excel #shorts

Did you know about the Quick Analysis tool in Excel?! #shorts #excel #exceltips

Did you know about the Quick Analysis tool in Excel?! #shorts #excel #exceltips

Create dummy data in Excel! #shorts

Create dummy data in Excel! #shorts

Turn names into emails #shorts

Turn names into emails #shorts

Turn emails into names #shorts

Turn emails into names #shorts

The power of Excel #shorts

The power of Excel #shorts

See what CTRL + Shift + L in Excel does... #shorts

See what CTRL + Shift + L in Excel does... #shorts

I ♥️ Text Functions #shorts

I ♥️ Text Functions #shorts

Don't be the person that does this manually... #shorts

Don't be the person that does this manually... #shorts

Learn these beginner Excel skills #shorts

Learn these beginner Excel skills #shorts

How to Insert Columns in Excel

How to Insert Columns in Excel

You Need to Know Custom Date Formatting in Excel #shorts

You Need to Know Custom Date Formatting in Excel #shorts

You need to know about this Excel function #shorts

You need to know about this Excel function #shorts

How to highlight above average values in Excel #shorts

How to highlight above average values in Excel #shorts

Add Totals the Quick Way #shorts

Add Totals the Quick Way #shorts

How COUNTIF works in Excel #shorts

How COUNTIF works in Excel #shorts

Remove the [] with SUBSTITUTE #shorts

Remove the [] with SUBSTITUTE #shorts

Flash Fill time #shorts

Flash Fill time #shorts

Use the TEXT function to turn dates into days in Excel #shorts

Use the TEXT function to turn dates into days in Excel #shorts

Have you used the Data tab like this before? #shorts

Have you used the Data tab like this before? #shorts

How to Hide and Unhide Rows in Excel

How to Hide and Unhide Rows in Excel

Pay attention to this quick Excel tip! #shorts

Pay attention to this quick Excel tip! #shorts

How to make your data more exciting! #shorts

How to make your data more exciting! #shorts

Watch this Excel time saver! #shorts

Watch this Excel time saver! #shorts

No problem boss #shorts

No problem boss #shorts

What?! How?! #shorts

What?! How?! #shorts

You need to see this Excel formatting trick #shorts

You need to see this Excel formatting trick #shorts

Did you know about the DAYS function? #shorts

Did you know about the DAYS function? #shorts

A quick Excel trick #shorts

A quick Excel trick #shorts

Clean up your data with flash fill! #shorts

Clean up your data with flash fill! #shorts

Such a simple but useful function! #shorts

Such a simple but useful function! #shorts

Largest to smallest #shorts #excel #exceltutorial #exceltips

Largest to smallest #shorts #excel #exceltutorial #exceltips

Convert Kilometers to Miles in Excel! #shorts

Convert Kilometers to Miles in Excel! #shorts

How to Freeze the First Column in Excel

How to Freeze the First Column in Excel

Don't be that person #shorts

Don't be that person #shorts

Check how soon your deadlines are! #shorts

Check how soon your deadlines are! #shorts

YEARFRAC - Did you know about this Excel function? #shorts

YEARFRAC - Did you know about this Excel function? #shorts

How to Delete Columns in Excel

How to Delete Columns in Excel

Mini charts in Excel #shorts

Mini charts in Excel #shorts

Will this take a while? 😟 #shorts

Will this take a while? 😟 #shorts

Import Website Page Titles into Google Sheets | IMPORTXML Function

Import Website Page Titles into Google Sheets | IMPORTXML Function

You're missing out if you use Excel and don't know about this... #shorts

You're missing out if you use Excel and don't know about this... #shorts

Have you seen this Excel function before?! #shorts

Have you seen this Excel function before?! #shorts

You need to know this super simple but useful Excel function! #shorts

You need to know this super simple but useful Excel function! #shorts

You NEED to know about this Excel function #shorts

You NEED to know about this Excel function #shorts

Excel Flash Fill - Save HUGE Amounts of Time (4 Minute Tutorial!)

Excel Flash Fill - Save HUGE Amounts of Time (4 Minute Tutorial!)

Learn Excel Pivot Tables in 6 Minutes! [BEGINNER TUTORIAL!]

Learn Excel Pivot Tables in 6 Minutes! [BEGINNER TUTORIAL!]

You will be SHOCKED at this Excel feature! #shorts

You will be SHOCKED at this Excel feature! #shorts

Did you know about this Excel function? #shorts

Did you know about this Excel function? #shorts

5 Excel Mistakes You DON'T Want to Make!

5 Excel Mistakes You DON'T Want to Make!

Pay attention to this date function! #shorts

Pay attention to this date function! #shorts

How to Sum Rows and Columns in Excel

How to Sum Rows and Columns in Excel

Did you know about this Excel function for removing unwanted blank spaces? #shorts

Did you know about this Excel function for removing unwanted blank spaces? #shorts

A technique for quickly tidying data in Excel #shorts

A technique for quickly tidying data in Excel #shorts

Did you know about this function in Excel? #shorts

Did you know about this function in Excel? #shorts

How to Show or Hide the Ribbon in Excel

How to Show or Hide the Ribbon in Excel

Don't worry if you need to fix this in Excel 😌 #shorts

Don't worry if you need to fix this in Excel 😌 #shorts

Watch this Excel trick #shorts

Watch this Excel trick #shorts

How to Unhide Columns in Excel (Two Methods)

How to Unhide Columns in Excel (Two Methods)

Pay attention to this Excel tip #shorts

Pay attention to this Excel tip #shorts

How to Unhide Rows in Excel (Two Methods)

How to Unhide Rows in Excel (Two Methods)

How to Delete Rows and Columns in Excel (Four Ways)

How to Delete Rows and Columns in Excel (Four Ways)

Bet you didn't know you could do this in Excel... #shorts

Bet you didn't know you could do this in Excel... #shorts

How to combine first name and last name in Excel

How to combine first name and last name in Excel

How to change the number of decimal places showing in Excel

How to change the number of decimal places showing in Excel

How to Multiply Numbers in Excel

How to Multiply Numbers in Excel

How to Merge and Center in Excel (and what it is)

How to Merge and Center in Excel (and what it is)

How to quickly check for duplicates in Excel #shorts

How to quickly check for duplicates in Excel #shorts

Make sure you take the second approach! #shorts

Make sure you take the second approach! #shorts

The Super Quick Way to Remove Blank Rows in Excel #shorts

The Super Quick Way to Remove Blank Rows in Excel #shorts

How to Make Borders in Excel [Complete Guide]

How to Make Borders in Excel [Complete Guide]

Wait till you see this shortcut! #shorts

Wait till you see this shortcut! #shorts

How to impress your boss in Excel #shorts

How to impress your boss in Excel #shorts

A great Excel tip when working with dates #shorts

A great Excel tip when working with dates #shorts

Three formulas, three case types :) #shorts

Three formulas, three case types :) #shorts

Such a time saver! #shorts

Such a time saver! #shorts

Excel's UNIQUE function - how to check for duplicates! #shorts

Excel's UNIQUE function - how to check for duplicates! #shorts

You won't believe this shortcut! #shorts

You won't believe this shortcut! #shorts

How to fill a series of numbers in Excel #shorts

How to fill a series of numbers in Excel #shorts

How to quickly make sense of data in Excel with Color Scales #shorts

How to quickly make sense of data in Excel with Color Scales #shorts

Be careful which approach you take in Excel! #shorts

Be careful which approach you take in Excel! #shorts

How to Hide and Unhide Rows and Columns in Excel

How to Hide and Unhide Rows and Columns in Excel

Turn dates into months in Excel with the TEXT function! #shorts

Turn dates into months in Excel with the TEXT function! #shorts

A trick to make Excel spreadsheets look more exciting #shorts

A trick to make Excel spreadsheets look more exciting #shorts

NEVER use the calculator when using Excel 😂 #shorts

NEVER use the calculator when using Excel 😂 #shorts

How to adjust all column and row widths and heights in Excel (the quick way!)

How to adjust all column and row widths and heights in Excel (the quick way!)

How to use the RANDBETWEEN function in Excel!

How to use the RANDBETWEEN function in Excel!

Google Translate in Google Sheets - You Need to See this!

Google Translate in Google Sheets - You Need to See this!

How to use Flash Fill in Excel to save yourself time!

How to use Flash Fill in Excel to save yourself time!

Why You Need to Lock Cells in Excel - Absolute Cell Reference with F4

Why You Need to Lock Cells in Excel - Absolute Cell Reference with F4

Generate QR Codes in Excel (Super Easy!)

Generate QR Codes in Excel (Super Easy!)

Join up text the quick way in Excel #shorts

Join up text the quick way in Excel #shorts

NETWORKDAYS in Excel - How to Calculate The Number of Working days in Excel #shorts

NETWORKDAYS in Excel - How to Calculate The Number of Working days in Excel #shorts

TRIM and PROPER in Excel #shorts

TRIM and PROPER in Excel #shorts