30 Awesome Excel Tips and Tricks for 2023

Показать описание

We combine 30 Excel tutorials into one step-by-step Microsoft Excel training tutorial for beginners. This Excel tips and tricks are ideal for beginners, but also for intermediate Excel users. Use these tutorials for maximize your productivity!

📝 Table of Contents/Timestamps

0:10 How to Use Excel Dark Mode
3:00 Using the Accounting Number Format Excel
7:55 How to Split Cells in Excel
11:29 How to Group Worksheets in Excel
14:01 How to Add Error Bars in Excel
18:07 How to Indent in Excel
21:38 Excel Format Painter - How to Use it
26:12 How to Insert Checkboxes in Excel
34:37 How to Fix the Spill Error in Excel
38:37 How to Lock Cells in Excel
43:37 How to Record a Macro in Excel
50:07 How to Delete a Named Range in Excel
54:19 How to Insert a Page Break in Excel
57:32 How to Fix Missing Scrollbar in Excel
1:01:04 How to Insert a Heat Map in Excel
1:04:47 How to Fix the Name Error in Excel
1:10:01 How to Move Rows & Columns in Excel
1:14:23 How to Remove Spaces in Excel
1:17:57 How to Add Bullet Points in Excel
1:21:03 How to Make a Pie Chart in Excel
1:24:16 Freeze Rows in Excel
1:26:31 How to Convert Microsoft Excel to Word
1:30:04 How to Stop Excel rom Rounding
1:33:02 How to Calculate SUBTOTAL in Excel
1:37:09 How to Create an Excel Slicer
1:40:08 How to Graph a Function in Excel
1:44:08 How to Convert Text to Number in Excel
1:48:12 How to Copy Visible Cells Only
1:53:29 How to add a Secondary Axis in Excel
1:56:44 How to Select Non-Adjacent Cells in Excel

Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:

🔥Check out our FREE 300+ hour training course playlist here 👉

💻Watch additional popular Microsoft Office tutorials from Simon Sez IT:

💬Stay in touch!

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

#SimonSezIT #Excel

Рекомендации по теме

Комментарии

🚀 Boost your Excel skills with these free Excel playlists 👉🏼

🔥Check out our FREE 300+ hour training course playlist here ➡

SimonSezIT

For someone who suffered from Computer vision syndrome last month, that dark mode technique is a helper. Thank you.

Goddibaba

Brilliant and very informative. Would appreciate to receive link to download spreadsheets.

rajeevgosavi

Thank you for sharing these great tips and tricks. Really useful. Please can you share the formula for the % of tasks completed? I don't know if I'm missing something. I'm not satisfied with the % I'm getting. Once again, thank you all.

mariamagandi

thanks for your excel skills exp tutorial

mukthizcreation

For text extraction of 1st and last names, once you have the first name, you can extract the last name using TRIM(SUBSTITUTE(FirstLastNameCell, FirstNameCell, "")). This replaces the first name with nothing, leaving the last name, and then trims off any extra spaces at the ends of the result.
Trim() can also be used in to removed extraneous spaces fomr around the first name
.

JStephs

Please provide a link to download practice sheets to follow along.

rajeevgosavi

what if I would like to split a cell to the first, middle and last name?

azalove

Hi, can you tell me how copy to formula to another sheet without changing the cell reference from the first sheet?

akshitshetty

I try the bar dark mode not working on my pc

musiliuloyaberry

Hello sir...i am from Pakistan i am regularly watching your videos.
I am facing a problem in excel
I have PDF files in Urdu (Arabic) like so i want to convert these files into excel file. I used Power query but it doesn't work for me

azizurrehman

What to do if I don't want to remove VLOOKUP formula but I need to read the long multi-line text in some cell? If i click that cell, instead of displaying the text in the formula bar, it shows the VLOOKUP formula. I want an option where I can temporarily view/read the results in the formula bar without hiding/protecting/copy pasting the worksheet/cells

shyamadasgupta