Microsoft Excel Full Tutorial - 2 Hour Complete Course to Learn and Master Excel

This is the beginner Excel course you have been looking for! Learn everything you need to become proficient in Excel whether as a student or in the workplace. You will learn Excel concepts related to Excel formulas and calculations, creating Excel charts, Excel Pivot tables, Excel integration with Word and a lot more. After watching this video, you will be able to use Excel in effectively in the workplace or for professional development. This Excel course is also ideal for teachers to teach Excel and for anyone who wants to become proficient in using Excel for personal use or in professional settings. Data file to follow along: https://kaceli.com/a/excel-2016-data-file/ 👉 Chapters: 00:00 - Welcome 00:28 - Getting Started with Excel, the Basics 06:22 - Using Functions and Formulas for Basic Calculations 13:10 - Using Autofill 14:23 - Conditional Formatting in Excel 17:05 - Calculating Max, Min, Average, Count 20:15 - Mathematical and Accounting Related Calculations in Excel 24:40 - Quick Analysis Tools: Formatting, Charts, Pivot Tables 27:58 - Relative, Absolute and Mixed References 35:13 - Data Filtering and Sorting 40:37 - Charts 46:56 - Modern Charts 49:31 - Flash Fill Data Feature 51:40 - Calculations Across Sheets Using Formulas 57:36 - Calculating Percentages in Excel 01:05:26 - Conditional Functions: IF statement 01:11:02 - Pivot Tables and Pivot Charts 01:17:08 - VLOOKUP: 3 scenarios 01:41:23 - Freeze Panes to Navigate Data 01:43:03 - Setting the Print Area 01:44:47 - Live Reports in Word from Excel 01:48:34 - Importing and Exporting Data .csv Files 01:52:20 - Mail Merge Using Excel Data Files 02:01:09 - Financial Calculations: PMT, IPMT, PPMT ✅ Complete Tutorials on Excel, Word, Access, PowerPoint, Outlook etc.: https://youtube.com/playlist?list=PLyy-LLqj7iSZ6SdBBcGnMeba23H6Lj5MD&feature=shared 👍 If you found this guide helpful, don't forget to give it a thumbs up, subscribe for more Mac tips, and hit the notification bell to stay updated with our latest content! ➡️ Keep in touch: For a listing of other tutorials and guides please check my website: http://kaceli.com ➡️The link to the YouTube Channel is: http://youtube.com/KaceliTechTraining. #exceltips #exceltutorial #kacelitutorials