Excel 2021 Expert Tutorial

Рет қаралды 87,123

Күн бұрын

Excel 2021 Expert Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3xZKDiw
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Nesting Functions 4:24
Database Functions 12:16
XLOOKUP 20:47
UNIQUE 28:39
SORT and SORTBY 34:30
FILTER 40:24
LET 46:54
Consolidate 52:19
Introduction to Macros 57:03
Recording and Playing Macros 59:38
Conclusion 1:05:03
#excel #excel2021 #exceltutorial
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Пікірлер: 62

@deepalimahajan88 Жыл бұрын

I passed my MS Excel Skills assessment for hiring all thanks to these 3 tutorials. Excellent work!

@LearnitTraining Жыл бұрын

Excellent!

@mohamedelnaggar4983 Ай бұрын

@@LearnitTraining i'm here for the same reason

@Prasannamahadagde Жыл бұрын

One of the best tutorials for Excel.

@LearnitTraining Жыл бұрын

Thank you for the kind words!

@SeeLight222 5 ай бұрын

Great instructor, Faz. Shine on...

@LearnitTraining 5 ай бұрын

Thanks!

@sakshibansal8881 Жыл бұрын

covered all the excel topics very nicely and making understanding easy.thanks for these videos very helpful.

@LearnitTraining Жыл бұрын

You are very welcome!

@govindalokhande3536 Жыл бұрын

Thank you So much Sir You teach us Very Understandable And You covered every Point Thank you so Much 🙏😊❤

@LearnitTraining Жыл бұрын

It's our pleasure!

@abdulmateen6101 8 ай бұрын

20.47, xlookup function, instead of individually finding the value, use this, =XLOOKUP(A4,A10:A46,CHOOSE({1,2,3,4},B10:B46,C10:C46,D10:D46,I10:I46)). It can solve the issue whether the columns are consective or not.

@LearnitTraining 8 ай бұрын

Thanks for the tip!

@ruwanchamara7078 4 ай бұрын

you are the best

@LearnitTraining 4 ай бұрын

Thanks!

@priyankachourasiya9712 Жыл бұрын

Thanks for the knowledge ☺️☺️

@LearnitTraining Жыл бұрын

Our pleasure 😊

@tourekatinanhpatrick-samso6668 6 ай бұрын

Thanks

@LearnitTraining 5 ай бұрын

Thank you for your continued support!

@OttersHeaven Жыл бұрын

I will type the data from the image into excel such as name, address, email, zip code etc. Is there any software or any way to check spelling mistakes in Excel from these images?

@mateuszborecki6763 4 ай бұрын

1:01:27 - why first value appears in the box where the cursor is located and not in A1 after running macro? What Did I do wrong? The second value 'company' and third 'date' are correct and always in A2 and A3...

@gurum4480 2 жыл бұрын

Good

@LearnitTraining 2 жыл бұрын

Thanks

@abdulmateen6101 8 ай бұрын

52.19 I am afraid that in Consolidated Sheet, approach to get the Totals may not correct as it sums quarter total and also individual division amount, so double counting.

@LearnitTraining 8 ай бұрын

Noted~!

@carlostepedino 2 жыл бұрын

in the Consolidation exercise (55:33), the "Total" column is not adding the correct numbers. The formula in the consolidation cannot be sum(b4:b7) as it was in the file. The total should be $3,700 and I am sure there is a way of adding subtotals or adding values of column C only if column b is different that Excel201. I can't run the formula as a I have an older version of Excel but curious to see what adds up to 5,900. Only if you add from the bottom up to the top sub-total of $1,500 the total is $5,900.

@LearnitTraining Жыл бұрын

Hi Carlos! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@dawnorvis6135 Жыл бұрын

I noticed that, as well. The total in column C should be $3700. The formula should be =SUM(C7,C11,C15,C19). That totals $3700. The same formula needs to be applied to the Totals for columns D, E, and F. Hope that helps.

@fabiomurgia1980 Жыл бұрын

Thank you both @carlostepedino and @dawnorvis6135

@ahmadayanah243 Жыл бұрын

@learnit_training Section "cosolidatedSummary sheet": I noticed a new blank column added (column B in level 1 but not blank in level 2) after doing cosolidation in the "summary division" table?? why or any comment?

@LearnitTraining Жыл бұрын

Hello Ahmad! You can speak directly with our instructors at Offsite, our online community - www.offsitebylearnit.com/

@AljIsHere128 Жыл бұрын

Consolidate segment should have been more detailed in description and explanation. I keep running into error messages of 'Source reference overlaps destination area'. In order to make sure the cell ranges of each table are different is the solution possibly from that and I still ran into issues. I also get this error message of 'Cannot create links to consolidation sheet' occurs when one checks create link to source option and ran into errors for that too. You had this segment be without flaws and errors one can run up against with this. Consolidate isn't as cut and dry as your video made it out to be. Future videos of your course(s) should also perhaps have an addendum of challenges one may encounter of items to learn of segments along the way.

@LearnitTraining Жыл бұрын

Noted!

@abrilgonzalez7892 10 ай бұрын

What`s the differenece between UNIQUE value and FILTER value? My brain can`t disting between these two. Thanks you

@LearnitTraining 10 ай бұрын

Hello Abril Gonzalez! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/

@AljIsHere128 Жыл бұрын

The Without Let makes more sense to me than the With Let. Weird huh? 😂😄

@LearnitTraining Жыл бұрын

As long as it works!

@AljIsHere128 Жыл бұрын

For the Unique for concatenation. What is the meaning of having the & symbol? That wasn't explained.

@LearnitTraining Жыл бұрын

Hello AljHere128! You can get help directly from the instructors at Offsite, our online community - www.offsitebylearnit.com/

@sooshim_90 Жыл бұрын

Instead of sorting like this..... could you just not create a tabell and use the sort tools. Much easier and more efficient...

@rashadganiyev Жыл бұрын

FYI: Office 2019 doesn't have any function after 23:00

@aboibrahim4069 11 ай бұрын

Excel LTSC standard 2021 does not accpet inserting the comma , in the formula to separate agruments instead I have to use semicolon ;

@LearnitTraining 11 ай бұрын

Thank you for the tip!

@aboibrahim4069 11 ай бұрын

@@LearnitTraining you are welcome

@dtalk6871 2 жыл бұрын

How do I save in Excel CSV format with data formatting

@LearnitTraining 2 жыл бұрын

Hi D TALK! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

@bball1777 10 ай бұрын

Thanks, very helpful! Jesus Christ loves you and saves (John 3:16)!

@LearnitTraining 10 ай бұрын

You're welcome!

@Simon_boakye 2 жыл бұрын

Second person here

@AyeshaKhan-gf1cc Жыл бұрын

the sample exercise files are for the advanced workbooks instead of expert. Can you share the files for the expert course

@LearnitTraining Жыл бұрын

The file for the video is Excel 2021 Expert File.xlsx which should be the first file in the directory.

@AyeshaKhan-gf1cc Жыл бұрын

@@LearnitTraining thank you so much!

@yogicreations6505 2 жыл бұрын

can you please say adobe after effects tutorilas

@LearnitTraining 2 жыл бұрын

Hi Yogi Creations! We are working on it!

@yogicreations6505 2 жыл бұрын

@@LearnitTraining TQ sir

@roshanrox9285 Жыл бұрын

Hello There! i want one excel Formula > how to calculate OT1, OT2, Regular hour in excel. if hours fall between 00:00 to 05:00 it is OT2 , if hours fall between 05:00 to 8:30 it is OT1, if hours fall between 8:30 to 18:00 it is regular hour, if hours fall between18:00 to 21:00 it is OT1, if hours fall between 21:00 to 24:00 is OT2. For example if employee starts work at 02:00 and ends at 22:00 then total working hour will be 20:00, Regular Hour will be 09:30, OT1 will 06:30 , OT2 will be 04:00. (OT=OVERTIME)

@LearnitTraining Жыл бұрын

Hello Roshan! You can get help for this directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/