Excel Training

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com Are you looking to upskill your Excel game? Look no farther than this step-by-step tutorial! Learn the essentials of how to use Microsoft Excel, starting with the absolute basics like entering data and formatting. From there, we cover conditional formatting, sorting, filtering, and advance to charts and pivot tables. By the end of this video, you'll have a strong understanding of the fundamentals of Excel. 📚 RESOURCES - My Excel course that will teach you the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com/ - All the Excel shortcut keys: https://bit.ly/excelhotkeys ⌚ TIMESTAMPS 00:00 Introduction 00:26 Get Excel 01:01 Start page 01:30 Cells, columns, and rows 02:08 Adjust zoom 02:23 Enter data 03:41 Format cells 04:36 Auto fit contents 05:20 Hide and unhide 05:55 Move columns and rows 06:32 Tables 07:19 Insert columns and rows 07:46 Conditional formatting 08:25 Status bar 08:45 Analyze data 09:15 Formulas 09:49 Functions 10:39 Sorting and filtering 11:37 Charts 12:18 Pivot tables 15:02 Collaborate with others 15:26 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ 🔽 CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry ✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert #excel

Join the Pivot Table Essentials course 👉 https://www.xelplus.com/course/excel-pivot-tables/ Discover how to create a pivot table in Excel. Ideal for anyone looking to quickly analyze data, create reports, or gain insights without complex formulas. Pivot Tables make data analysis accessible and efficient. ⬇️ Download the file I used in the video from here: https://pages.xelplus.com/pivot-tables-basics-file Learn hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST. What You'll Learn: ▪️ Setting Up Data for Pivot Tables: Learn how to prepare your data for Pivot Tables, including organizing it in a tabular format and converting it into an official Excel table. ▪️ Creating Pivot Tables: Understand the basics of inserting Pivot Tables, including using the 'Recommended PivotTables' feature for a quick start. ▪️ Customizing Pivot Tables: Dive into sorting values, changing number formats, adding filters, and adjusting the design and layout of your Pivot Tables. ▪️ Advanced Pivot Table Features: Explore how to show values as percentages of grand totals, connect slicers to multiple Pivot Tables, and ensure automatic updates with new data. We'll also cover how to add Pivot Slicers to get a professional visual to apply filters to our Pivot Table. 00:00 How to Create Pivot Table in Excel? 01:35 Convert Data to Excel Tables 02:46 Create Pivot Table 04:08 Change aggregation in Pivot Table to average or count 04:40 Adjust number format in Pivot Table 05:10 Add filter to Pivot Table 05:28 Add column fields to Pivot Table 05:50 Removing Grand Totals and Sub Totals in Pivot Table 06:27 Update Pivot Table layout and design 07:14 How to bring back Pivot Table Fields dialog box 07:42 Update Pivot Table column header without errors (pivot table field name not valid) 08:33 Sort values in Pivot Table 08:41 Lock column width on Pivot Table refresh 09:00 Add Value as percentage of grand total in Pivot Table 10:22 Add Pivot Table Slicers to Filter Data 11:10 Connect Slicer to multiple Pivot Tables 11:50 Refresh Pivot Tables 12:40 Benefits of Pivot Tables ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel

AD: Sign up to enroll for a 7-day free trial with Coursera now! https://imp.i384100.net/c/4021125/1347618/14726?u=https%3A%2F%2Fwww.coursera.org%2Fprofessional-certificates%2Fgoogle-data-analytics Learn all the fundamentals of Data Analysis on Excel in 10 minutes! 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/63f8abed3e1e4ad28342d08f #coursera #courserapartner @coursera This video will teach you all the fundamentals of data analysis in just 10 minutes. First, we'll go over how to transform or clean up a raw set of data on Excel. This will include using features like the trim formula, data types, removing duplicates, and more. Then, we'll look at descriptive statistics using the data analysis feature on Excel. This will give us important numbers like the average, min, max, quartiles etc. We'll also create a box and whisker chart for analysing outliers. Third, we'll analyze the data using pivot tables. Finally, we'll create a small report using conditional formatting, xlookups, sumifs and more. LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/courses SOCIALS: 🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Intro 0:30 - Transforming Data 4:41​ - Descriptive Statistics 8:10​ - Data Analysis 10:43​ - Dashboard for showing your findings Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

In this video, we'll guide you through creating a simple and effective Excel table from scratch. Learn how to set up your data, insert and manage columns and rows, and apply basic formatting to improve the table's readability. We'll also cover essential Excel functions and formulas for various calculations, and demonstrate how to use conditional formatting to easily highlight important information. By the end of this tutorial, you'll be equipped with the knowledge to create your own custom Excel table for any purpose. Be sure to like, subscribe, and leave any questions in the comments. Thanks for watching! #excel #exceltutorial #tableexcel #microsoftoffice #excelforbeginners #excelspreadsheet To support the author financially - https://www.donationalerts.com/r/semyon_solomin

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses Learn the art of creating dynamic drop-down lists and implementing advanced data validation. Whether you're managing projects, handling company data, or just looking to improve your Excel skills, this video is packed with valuable insights. 🔍 What You'll Learn: ▪️Dynamic Drop-Down Lists: Discover how to create drop-down lists that update automatically with new entries. ▪️Data Validation Techniques: Learn to validate dates, numbers, text length, and more, ensuring data accuracy and consistency. ▪️Practical Examples: Follow along with real-world scenarios, like managing project details across different divisions of a company. ▪️Expert Tips: Gain tips on using cell references, Excel tables, and custom functions for robust data validation. Full Article: https://www.xelplus.com/data-validation-in-excel/ ★★ Links to related videos: ★★ Indirect Function: https://youtu.be/GUClkvJ7Gag Dependent data validation lists: https://youtu.be/w7cHgsFirLk ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel

This is my opinion on the 3 key Excel skills a data analyst requires. Understanding the use of Power Query, Tables and Pivot Tables/Power Pivot is the starting point on your learning journey. Once you get comfortable with these concepts you will easily migrate to Power BI Want to learn more about Power Query, DAX and Power BI? Check out my book: "Power BI for the Excel Analyst"? Australia: https://pbi.guide/book/ Amazon: https://www.amazon.com/Power-BI-Excel-Analyst-essential/dp/161547076X 00:00 Intro 00:41 Tables 05:15 Power Query 12:05 Pivot Tables 13:50 Power Pivot and the Data Model Here's the file if you want to practice https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EveO1tKC_N5FkufC2Wd84A0BS0YVd-lQf-UgQkOdJ8b0Pw?e=yK91Qg Connect with me: https://wyn.bio.link/ Access Analytic Training https://accessanalytic.com.au/training

Make a Full Data Analysis Project in Excel! 👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/it4shpjirr In this video tutorial, we'll go over a full data analysis project in Excel. This will cover the 3 essential parts which are data cleaning, data analysis, and data visualization. To make this as realistic as possible, we'll be using a real dataset on billionaires, which you can download in the description below. The data cleaning part will include key features such as removing duplicates, creating backups, changing text formatting and much more. The data analysis will begin with descriptive statistics to find the average, min, max, and much more. Then, we'll use pivot tables to analyze our data further. Finally, in data visualization, we'll use slicers and dynamic charts to visualize our data interactively. LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Intro 0:28​ - Data Cleaning 6:07​ - Data Analysis Descriptive Statistics 7:44​ - Data Analysis Pivot Tables 11:04​ - Data Visualization

This video provides a basic introduction into the top 10 most important formulas used in excel. These include the average function, autosum, Sum If, Count, Counta, Count If function, Concantenate, If logical function, Vlookup, and Drop Down Lists. Full-Length Math & Science Videos: https://www.patreon.com/mathsciencetutor/collections Excel Tutorial For Beginners: https://www.youtube.com/watch?v=nK-uNYuvcag Top 30 Excel Tips & Shortcuts: https://www.youtube.com/watch?v=UMad9_-4rOU _________________________________________ Excel - Statistics - Mean, Median, Mode: https://www.youtube.com/watch?v=aRR86imVsxM Excel Scatter Charts: https://www.youtube.com/watch?v=hwqq0HYrers Excel - Finding Slope & Y-Intercept: https://www.youtube.com/watch?v=KwQsV77bYDY Solving Polynomial Equations - Goal Seek: https://www.youtube.com/watch?v=lomAl6XB_SM __________________________________________ How To Calculate Loan Payments In Excel: https://www.youtube.com/watch?v=ifbNN2SoKlk How To Create an Amortization Table: https://www.youtube.com/watch?v=QZfMW203v4U How To Look Up Customer Data In Excel: https://www.youtube.com/watch?v=HDda6ny40ZM How To Create a Data Entry Form In Excel: https://www.youtube.com/watch?v=_tZLGBgQCYo _________________________________________ YouTube Channel Growth Accelerator: https://www.patreon.com/YouTubeChannelGrowthAccelerator Algebra For Beginners: https://www.video-tutor.net/algebra-for-beginners-basic-introduction.html Final Exams and Video Playlists: https://www.video-tutor.net/ Full-Length Math & Science Videos: https://www.patreon.com/mathsciencetutor/collections