Войти
  • 12895Просмотров
  • 2 месяца назадОпубликованоJilson Santana

Excel for Beginners Full Course - Master Excel in One Video

Master Excel from scratch in just 2 hours! Complete beginner-friendly course covering formulas, functions, charts, pivot tables & more. 🎯 📥 Download Practice Files: :u:/p/jilson/ERCYsLovJd9GnTLVIP0Rx88BvFSQjq12BeGdbKTNWkkCyQ?e=eNNqwt&download=1 ⏱️ CHAPTERS 00:00 Course Overview 00:40 Getting Started with Excel 02:39 Exploring the Excel Interface 06:34 Workbooks and Worksheets 09:16 Getting Help in Excel 11:41 Enter and Edit Data 16:39 Use AutoFill 19:14 Work with Dates and Times 22:24 Flash Fill 24:29 Undo and Redo 25:59 Save and Save As 27:53 Create Basic Formulas 33:48 Order of Operations 36:17 Understand Cell References 38:24 Use Named Ranges in formulas 43:45 SUM function 48:11 MAX function 50:33 MIN function 51:18 AVERAGE function 52:06 COUNT functions 55:00 VLOOKUP function 01:00:33 XLOOKUP function 01:05:18 Format Text 01:08:36 Use the Mini Toolbar 01:11:00 Add Cell Background Color 01:12:28 Add Cell Borders 01:15:09 Format Numbers and Dates 01:18:21 Resize Rows and Columns 01:21:51 Insert and Delete Rows/Columns 01:24:19 Hide and Unhide Rows/Columns 01:26:34 Move and Copy Sheets 01:29:11 Rename, Insert, and Delete Sheets 01:30:46 Use Conditional Formatting 01:35:01 Create Charts 01:39:17 Choose and customize chart types 01:44:06 Create and Format Tables 01:47:55 Sort Data 01:51:26 Filter Data 01:54:53 Find and Replace 01:57:01 Create a PivotTable 02:04:09 Create a PivotChart 02:06:53 Freeze and Unfreeze Panes 02:08:47 Split the Worksheet 02:10:31 Use Page Layout View 02:11:19 Adjust Page Breaks 02:12:44 Protect Worksheets and Workbooks 02:14:16 Share a Workbook 02:15:03 Final Considerations 📘 WHAT YOU'LL LEARN This complete Excel course is 100% hands-on and project-based. Follow along with real examples and master Excel in just 2 hours — from absolute beginner to confident user. By the end, you'll know how to use Excel for work, school, or personal projects with professional-level skills. ✅ CORE SKILLS YOU'LL MASTER: 📊 Excel Fundamentals • Navigate workbooks, worksheets, and the Excel interface • Enter, edit, and format data like a pro • Use AutoFill, Flash Fill, and time-saving shortcuts 🧮 Essential Formulas & Functions • SUM, AVERAGE, COUNT, MAX, MIN • VLOOKUP and XLOOKUP for data lookup • Cell references and Named Ranges • Order of operations in formulas 🎨 Professional Formatting • Format numbers, dates, text, and cells • Apply Conditional Formatting for instant insights • Resize, hide, and organize rows/columns/sheets • Add borders, colors, and professional styling 📈 Data Visualization & Analysis • Create and customize charts (bar, line, pie, and more) • Build Excel tables for dynamic data • Master PivotTables and PivotCharts • Sort, filter, and analyze data efficiently 🛠️ Productivity & Sharing • Freeze panes and split worksheets • Set up page layout and adjust page breaks • Protect worksheets and workbooks • Share your work with others 🎯 WHO THIS COURSE IS FOR: ✓ Complete beginners with zero Excel experience ✓ Students preparing for jobs requiring Excel skills ✓ Professionals needing a structured refresher ✓ Anyone wanting to boost productivity and confidence with data No prior knowledge needed — just download the practice files and follow along! 👨‍🏫 ABOUT JILSON SANTANA I teach 100,000+ students worldwide how to master Excel, Power BI, SQL, Python, and Data Analysis. My mission is to help you work smarter, boost productivity, and unlock new career opportunities through high-quality, step-by-step tutorials. 🔔 SUBSCRIBE for more tutorials on: • Advanced Excel techniques • Power BI dashboards • Python for data analysis • SQL and databases • Business Intelligence and AI 💬 What Excel topic should I cover next? Leave your suggestions in the comments! 👍 If this video helped you, please like, share, and subscribe to support the channel! Learn Excel, Excel tutorial, Excel for beginners, Microsoft Excel, Excel course, how to use Excel, Excel formulas, Excel functions, VLOOKUP, XLOOKUP, PivotTable Excel, Excel training, data analysis, spreadsheet tutorial, Excel basics, Excel tips and tricks, complete Excel course, Excel full course. #ExcelForBeginners #ExcelFullCourse #LearnExcel #JilsonSantana #MicrosoftExcel #DataAnalysis #ExcelTutorial #ExcelCourse #PivotTable #VLOOKUP #XLOOKUP #Excel