Excel 2019 Complete Tutorial: Microsoft Excel Made Easy

Topics covered along with the Excel 2019 Timeline
00:01:07 Getting Started with Basic Concepts and the User Interface
00:10:47 Spreadsheet concepts for the workplace
00:17:47 Using the Autofill Feature in Excel
00:20:23 Formatting the Worksheet in Excel
00:21:13 Using Conditional Formatting in Excel
00:22:55 Using Basic Functions in Excel: Maximum, Minimum, Average and Count
00:28:00 Performing Financial Calculations Using Simple Functions in Excel: subtraction, multiplication, division using functions
00:32:00 Using the Quick Analysis Tool in Excel for Formatting, Charts, Totals, Tables and Sparklines
00:36:16 Types of References in Excel: Relative, Mixed and Absolute References
00:43:40 Data Sorting and Filtering, Multiple Level Sorting
00:49:26 Using Charts; Modern Charts in Excel
00:58:31 Using Flash Fill in Excel
01:00:45 Cross Sheet Calculations and References
01:06:54 Calculating Percentages
01:14:50 Using Conditional and Logical Functions in Excel
01:20:48 Overview of Pivot Tables in Excel
01:27:16 Using VLOOKUP in Excel
01:49:10 Data Validation in Excel
01:52:31 Using Freeze Panes in Excel
01:54:41 Setting the Print Area in Excel
01:56:35 Linking Data with Word for Live Reports
02:01:27 Working with .csv files
02:05:29 Performing a Mail Merge Using an Excel Data File
02:15:57 Using Financial Functions in Excel: PMT, IPMT, PPMT, rate, per, nper, pv,


If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Keep in touch:

COPYRIGHT NOTICE: No part of this video may be downloaded or distributed without permission from Sali Kaceli. If you have such a need, contact us.

#KaceliTutorials #MicrosoftExcel #ExcelTutorials #Office365

[four-en-tee]

I'm definitely subscribing to this channel. I've got an internship i'm doing in the summer for my Bachelors, and I need a refresher on how to use Excel and Access.

[PulseTrick]

Hello Mr. Kaceli, great presentation! I am fairly advanced with Excel however I skipped through your video and learned a lot of tips, tricks & shortcuts as well as the new features that I previously did not know. I'd like to thank you for that, by the way, I am making full use of your tutorials for Powerpoint and the other Microsoft products. Great job Sir, I will recommend your vids.

[shantoofficialpage]

Your Excel videos are really great and meaningful, i have learnt a lot from it

[mustafabkd]

bona fide content sir... you definitely deserve more subscribers

[melissaoleary]

Thank you for this wonderful tutorial!

[abubakardala]

Hello and good day, I must say I enjoy your tutorials and have learned a lot, Thanks and I remain your student!!

[aseel]

Thank you for the video and for the details on the description box

[LilyLoveDark]

Hello Mr Kaceli, I had reviewed all of your lesson videos of Microsoft Word and Excel of 2019 recently and they are way beyond fantastic! I hope that you will post the same for the Microsoft PowerPoint 2019 lessons as well and I can't wait to learn from them and discover what flaws and mistakes that I have and use those powerful tools effortlessly.

[josestacy]

Mr. Kaceli - your tutorials are amazing. I just finished the Microsoft Windows one and I feel like a pro! The calm and slow way that you describe things is perfect for me. I am wondering if you have or are going to have a tutorial for the Excel version of Microsoft 365. I started the Excel 2019 tutorial and there are some items there - such as the "ask me what you want to do" and "Power Pivot" options -missing in the MS 365 Excel version that I am using. Thank you again so much for these tutorials.

[farzanafaez]

thank you dear from your presentation👌🙏

[sarahconner]

I was interested in learning how to add properties to the file. For the purpose of being able to locate the document in the computer. And how to keep track of who is making changes to the file by having a code in order to make changes to the file. How to make it a read only file and how to create a file within a file. Or how to combine information from two or more files into a chart
Or as for billing purposes. How to know who made what changes to the file, and when. How to create a bill from the SS. And how to do detailed billing

[akshitshetty]

In which part of the video charts and diagrams are covered?

[sumantabiswas]

In my Excel 2019 the search bar is not showing and auto save option is not showing, how to get back the new look, how it is gone I don't know, Help me its urgent

[mohrmm]

How to delete sheet excel sharing in excel 365

[noblekasondebwembya]

Sir I managed to download this video but I need the actual spreadsheet please assist me with the link..