Excel 101 Crash Course: Learn Excel (6 HOURS!) | Zero To Mastery скачать в хорошем качестве

Excel 101 Crash Course: Learn Excel (6 HOURS!) | Zero To Mastery

Full Excel 101 Crash Course for Beginners! In this 6+ hour course, you'll learn Excel fundamentals, functions, and formulas, and even start building your own budgeting tool! This Excel Crash Course includes the first 4 of 13 major sections from Travis Cuzick's Complete Excel Bootcamp Course. So if you liked this video, you'll love his full course where you'll learn advanced topics like data visualization, pivot tables, VBA macros, and much more! Once you finish this crash course, come take the rest of Travis's Excel Bootcamp (and other courses) where you'll go even deeper and be able to get hired as a Data Analyst👇 🔥 Complete Excel Bootcamp Course: https://zerotomastery.io/courses/exce... 👨‍💻 VBA Programming Bootcamp Course: https://zerotomastery.io/courses/lear... 👀 Power Bi Bootcamp Course: https://zerotomastery.io/courses/lear... 😱 Python in Excel? Is this the real deal?:    • Python in Excel? Is this the real deal 🤯?   🎁 Use code: YTEXCEL10 to get 10% OFF (limited time only) 👍 Subscribe for more free tutorials and exclusive content: https://links.zerotomastery.io/youtube ========== 🗂 Starter & Exercise Files: https://drive.google.com/drive/folder... 🆓 Bonus Resources: 💻 Excel Cheat Sheet: https://zerotomastery.io/cheatsheets/... 🧠 Why YOU should learn Excel: https://zerotomastery.io/blog/how-dev... ========== ⏲ Timestamps: 00:00 Excel Crash Course Intro 02:01 Hello Excel Part I 12:10 Hello Excel Part II 24:31 Data Entry Part I 36:36 Data Entry Part II 47:24 Autofill 58:29 Working with Ranges 1:10:07 Working with Rows and Columns 1:19:57 Resizing Rows and Columns 1:29:42 Freezing Rows and Columns 1:39:40 Working with Multiple Worksheets 1:50:24 Find and Replace 2:04:36 Working with Multiple Workbooks 2:15:09 Intro to Formatting 2:19:54 Formatting Numbers 2:31:10 Formatting Dates and Times 2:42:48 Font Styles 2:54:28 Text Wrapping and Alignment 3:05:16 Cell Borders and Merging 3:14:46 Exercise: Excel 101 3:15:04 Intro to Filtering 3:23:24 Advanced Filtering 3:39:35 Sorting in Excel 3:54:10 Exercise: Filtering and Sorting Data 3:54:25 Intro to Formulas 4:03:03 Arithmetic Formulas 4:13:02 Arithmetic Formulas to Text 4:21:01 Applying Formulas to Dates 4:30:15 Copying and Cutting Formulas 4:42:45 Cell References 4:56:31 Hiding Rows and Columns 4:59:31 Exercise: Formula’s 101 4:59:46 Budget Project: Introduction 5:06:18 Budget Project: Formulas 101 5:08:21 Intro to Excel Functions 5:19:16 Arithmetic Functions 5:34:02 Counting Functions 5:40:16 The Status Bar 5:42:49 Rounding and Truncation 5:52:10 Median 6:00:43 Standard Deviation 6:08:46 Exercise: Crunching Numbers With Excel Functions 6:09:03 Budget Project: Crunching Numbers With Excel Fu nctions 6:14:44 Where to Keep Learning Excel? ========== 💥 Why take the rest of Travis's Excel Bootcamp? 1️⃣ We guarantee you that it's the best and most up-to-date Excel Bootcamp that you can find. You will learn Excel from scratch, build your own professional spreadsheets and charts, and get a step-by-step career path to getting hired as a Data Analyst in 2025! 2️⃣ This course is not about making you just watch along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial... No! There are exercises all along the way so you can practice yourself, and the Budget Project will allow you to apply your skills and solidify your knowledge in a way that will help you track & save money in your daily life! Pretty nifty, eh? 3️⃣ You also won't be learning alone. By enrolling today, you’ll also get to join our exclusive live online community classroom to learn alongside thousands of students, alumni, mentors, TAs and Instructors 👋 ========== Graduates of Zero To Mastery are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top tech companies. Many are also working as top-rated Freelancers getting paid $1,000s while working remotely around the world. 🎓 Here are just a few of them: https://zerotomastery.io/testimonials This could be you 👆 ========== Start learning now 👉 https://zerotomastery.io/courses/exce... #zerotomastery #excel