EXCEL смотреть последние обновления за сегодня на .
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 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: 🤍 - All the Excel shortcut keys: 🤍 ⌚ TIMESTAMPS 00:00 Introduction 0:26 Get Excel 1:01 Start page 1:30 Cells, columns, and rows 2:08 Adjust zoom 2:23 Enter data 3:41 Format cells 4:36 Auto fit contents 5:20 Hide and unhide 5:55 Move columns and rows 6:32 Tables 7:19 Insert columns and rows 7:46 Conditional formatting 8:25 Status bar 8:45 Analyze data 9:15 Formulas 9: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: 🤍 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: 🤍 🔽 CONNECT WITH ME - Official web site: 🤍 - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: 🤍 🙏 REQUEST VIDEOS 🤍 🔔 SUBSCRIBE ON YOUTUBE 🤍 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: 🤍 (Purchasing through this link gives me a small commission to support videos on this channel the price to you is the same) #stratvert #excel
Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well. You will learn how to - enter data, - navigate through a spreadsheet, - create formulas to solve problems, - create charts and graphs, - understand relative vs absolute references, - import and export data, - implement VLOOKUP, - use pivot tables, - split and concatenate text, - and more. ✏️ Course developed by Shad Sluiter. Check out his YouTube channel: 🤍 ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:04:14) Payroll ⌨️ (0:39:35) Gradebook ⌨️ (0:57:22) Decision Factors ⌨️ (1:04:40) Sales Database ⌨️ (1:23:13) Car Inventory ⌨️ (1:59:29) Problem Solving Templates ⭐️ Special thanks to our Champion supporters! ⭐️ 🏆 Loc Do 🏆 Joseph C 🏆 DeezMaster Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍
Join 400,000+ professionals in our courses: 🤍 You can use Python INSIDE Excel now 😱 In this video I'll introduce this game changing new functionality of working with Python inside Excel. Is Python in Excel for non-programmers? Can everyday data analysts make use of it? I'll answer these in the video. Plus checkout the announcement from Microsoft: 🤍 If you have this feature which is currently free to use in Microsoft 365 Insiders, you will find Python in the Insert tab in the Excel Ribbon. You get a few Python libraries already ready for you to use in Excel. These are the pandas, matplotlib, seaborn, statsmodels and NumPy. You can import other libraries as you need using the import statement - for example import re module for REGEX calculations. How can you use Python in Excel in practical terms? I share a few ideas in the videos. You can use the pandas library and turn your data into a dataframe which you can then use for more complex tasks, like query the data, unpivot the data with python, create charts using matplotlib - make a line, area or even small multiples. You can grab URLs from long text by using the regex library. You can also use python together with Power Query. We'll only scratch the surface and even that is pretty awesome. 🌍 My Online Courses ► 🤍 00:00 Python in Excel 00:40 Enter Python Mode 01:32 Send Excel Data to Python - Create Data Frame 03:19 pandas Python Library 03:43 Python Describe Data 05:11 Assign Name to DataFrame 05:51 Referencing Headers Shortcut 06:26 Examples of pandas Functionalities 07:29 Create Series Python Object 09:35 Plot a Chart in an Excel Cell 10:51 pandas Documentation 11:16 Calculation Logic of Python Cells 12:07 Examples from Default Libraries 13:35 Plot Multiple Charts As Single Object 14:49 Importing Libraries & Referencing Tables 18:10 Python to Excel Power Query 18:35 Wrap Up ➡️ Join this channel to get access to perks: 🤍 🎬 LINKS to related videos: Introduction to Office Scripts: ► 🤍 How to Create & Use Excel Macros: ► 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 🎥 RESOURCES I recommend: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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! #python #excel
Join 400,000+ professionals in our courses: 🤍 Here is my list of the best new features and improvements in Microsoft Excel that can really make a difference for you. This includes the new Search the menus feature, the new navigation pane for large workbooks, how to check your formula with the value preview tooltip, dynamic arrays and more. 🌍 My Online Courses ► 🤍 00:00 Best New Excel Features You Need to Know About 00:17 Easy Search in Excel 01:39 Navigation Pane in Excel 03:02 New Excel Keyboard Shortcuts 03:54 Automate Tab 05:56 Value Preview Tooltip 06:41 Dynamic Arrays in Power Query 08:23 Dynamic Arrays as Charts Source 08:51 Wrap Up ➡️ Join this channel to get access to perks: 🤍 🎬 LINKS to related videos: Introduction to Office Scripts ► 🤍 Automatically Move Completed Tasks to an Archive ► 🤍 Do You Need to SWITCH from Excel VBA Macros to Office Scripts? ► 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 🎥 RESOURCES I recommend: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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
Want more Excel videos? Here’s my Excel playlist: 🤍 This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel. Intermediate Microsoft Excel Lesson 1: 🤍 Dive deeper into formulas and functions in excel with this playlist: 🤍 Creating Charts in Excel: 🤍 0:00 Start 1:07 Starting up 1:27 Recent documents and pinning documents 1:54 Templates 2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel 3:48 Rows, Columns, Cells and Ranges 5:49 Worksheets in Microsoft Excel 6:52 View and zooming 7:30 Inputting Data 10:56 Formatting Data 13:38 Wrapping Text 14:22 Insert Row/ Merge & Center cells 15:41 Currency formatting 16:20 Print view 17:02 Add cell borders and colors 18:18 Basic formulas in Microsoft Excel 21:17 Copy formula 23:45 Freeze Pane 24:52 Basic Microsoft Excel functions 28:59 “Tell Me” in Microsoft Excel 29:43 Inserting charts in Microsoft Excel Excel for Beginners Tutorial - Level 2: 🤍 Excel for Beginners Tuotiral - Level 3: 🤍 Excel for Beginners Tutorial - Level 4: 🤍 Microsoft Excel for Beginners - Level 5: 🤍 VLOOKUP Function for Excel: 🤍 Learn Pivot Tables for Beginners: 🤍 10 Best Excel Beginners Tips: 🤍 Make a Line Graph in Excel: 🤍 I use Camtasia to create my video tutorials: 🤍 DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
8TURN(에잇턴) ‘EXCEL’ Music Video 8TURN - The 2nd Mini Album [UNCHARTED DRIFT] 반복된 일상생활 속에서의 일탈에 대한 소망을 풀어낸 8TURN의 한 여름밤의 소동! The commotion on a midsummer night of 8TURN unravels the desire for deviation from the repeated daily life! "Only doing big things and X-EXCEL" 🎧 🤍 - 8TURN Official - Fancafe: 🤍 - YouTube: 🤍 - Twitter: 🤍 - Twitter JP: 🤍 - Instagram: 🤍 - TikTok: 🤍 - Facebook: 🤍 - Mnet Plus: 🤍 - Weibo: 🤍 - Xiaohongshu: 🤍 - #8TURN #EIGHT_TURN #에잇턴 #UNCHARTED_DRIFT #언차티드_드리프트 #EXCEL #엑셀 #명호 #재윤 #민호 #윤성 #해민 #경민 #윤규 #승헌 #MYUNGHO #JAEYUN #MINHO #YOONSUNG #HAEMIN #KYUNGMIN #YUNGYU #SEUNGHEON
✅ Download the free course files to follow along ➡️🤍 We've combined some of our very best Excel tutorials in this training video to take you from beginner to Excel expert in under 6 hours! We've split this tutorial into 6 comprehensive topics to make sure we got you covered. We start off with the basics with Excel Formulas for Beginners, where we teach you some of the common functions used in Excel such as VLOOKUP, COUNT, SUM, and IF and how calculations work in Excel, and Data Cleaning in Excel, where we share 10 data cleaning tips and tricks like Clear Formatting, Removing Duplicates, and using Find & Replace and how to perform basic cleaning in Power Query. We then move on to intermediate concepts such as Pivot Tables and Dynamic Array Functions, where we discuss 8 functions that use dynamic arrays to solve problems like XLOOKUP and XMATCH. We wrap it up by covering Advanced Formulas in Excel, where we dive deeper into Logical Functions and other advanced Excel functions such as INDEX, MATCH, SUMPRODUCT, SUMIFS, and COUNTIFS and finally VBA Macros for Beginners, where we explain what Macros and VBA are and show you how to Record, Save, and Run Macros in Excel. You will also learn how to edit VBA code and assign Macro shortcuts. We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master MS Excel. ✅ 🤍 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 0:00:00 - Excel Formulas for Beginners 1:07:19 - Cleaning Data in Excel 2:12:55 - Pivot Tables Excel Tutorial 3:03:44 - Dynamic Array Functions 3:45:20 - Advanced Formulas in Excel 4:41:15 - Macros and Basic VBA in Excel 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 Learn how to use PivotTables in Excel with this step-by-step tutorial for beginners. Find out how to insert pivot tables and how to use recommended pivot tables. Learn what filter, column, row, and value mean. See how to use calculated fields to quickly analyze data in a pivot table. See how to summarize and show your values in different ways. Lastly, learn how to insert pivot charts, what defer layout update means, and how to access Excel for free online using office.com. In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003. 📚 RESOURCES - Access the sample data: 🤍 ⌚ TIMESTAMPS 00:00 Introduction 02:19 Insert Pivot Table 03:22 Main Pivot Table view 05:24 Calculated fields 06:55 Sorting 07:12 Value field settings 08:10 Show values as 09:27 Insert Pivot Chart 10:23 Defer layout update 11:13 Pivot Table on the web 12:24 Wrap up 📺 RELATED VIDEOS - Playlist with all my Excel videos: 🤍 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: 🤍 (Purchasing through this link gives me a small commission to support videos on this channel the price to you is the same) 🔽 CONNECT WITH ME - Official web site: 🤍 - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🎒 MY COURSES - Excel for Beginners in under 2 hours: 🤍 🙏 REQUEST VIDEOS 🤍 🔔 SUBSCRIBE ON YOUTUBE 🤍 #stratvert
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. Excel Tutorial Playlist: 🤍 YouTube Channel Growth Accelerator: 🤍 Algebra For Beginners: 🤍 Excel Tutorial For Beginners: 🤍 Top 30 Excel Tips & Shortcuts: 🤍 How To Calculate Loan Payments In Excel: 🤍 How To Create an Amortization Table: 🤍 How To Make a Line Chart In Excel: 🤍 Split Text Into Multiple Columns In Excel: 🤍 Lock Cells and Protect Sheets In Excel: 🤍 Excel Interactive Checklist: 🤍 Excel Solver Tool - System of Equations: 🤍 Excel Map Charts: 🤍 Excel Pivot Tables: 🤍 Calculate The Total Hours Worked In Excel: 🤍 How To Make a Time-Sheet In Excel: 🤍 Excel - Business Account Ledger: 🤍 Excel Calendars: 🤍 Merge Data From Multiple Columns In Excel: 🤍 Excel Find and Replace Tutorial: 🤍 Resize Multiple Rows and Columns: 🤍 Excel Conditional Formatting: 🤍 How To Move Columns: 🤍 Solving Polynomial Equations - Goal Seek: 🤍 Multiple Dependent Drop Down Lists: 🤍 How To Create a Data Entry Form In Excel: 🤍 Excel Scatter Charts: 🤍 Excel Vlookup Function: 🤍 Excel - Statistics: 🤍 Basic Math Operations In Excel: 🤍 How To Freeze Rows and Columns: 🤍 How To Show & Hide Formulas: 🤍 Excel Pie Charts: 🤍 Excel Bar Graphs: 🤍 How To Use Hyperlinks In Excel: 🤍 Relative & Absolute Cell References: 🤍 Excel Flash Fill: 🤍 Excel Auto Fill: 🤍 Excel Tutors: 🤍 Useful Textbooks: 🤍 Access Premium Videos: 🤍 Organic Chemistry Tutor - Playlists: 🤍 Subscribe To My YouTube Channel: 🤍 E-Book & E-mail Newsletter: 🤍 Affiliate Marketing Disclaimer: Some of the links associated with this video may generate affiliate commissions on my behalf. As an amazon associate, I earn from qualifying purchases that you may make through such affiliate links.
Want more Excel videos? Here’s my Excel playlist: 🤍 This video tutorial will show you how to use Microsoft Excel for beginners level 2. Click here to go to level 1 for beginners 🤍 Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel Intermediate Microsoft Excel Lesson 1: 🤍 Dive deeper into formulas and functions in excel with this playlist: 🤍 Creating Charts in Excel: 🤍 Subscribe to Teacher's Tech: 🤍 0:00 Start 0:52 AutoFilling cells in Excel 4:18 Add your own autofill 5:49 Sorting data in Excel 8:56 Using filters in Microsoft Excel 12:45 Round functions in Excel 15:40 Relative Relative cell references 17:14 Absolute Relative cell references 18:55 Absolute Absolute cell references 20:17 Relative Absolute cell references *More Videos on Microsoft Excel* Dive deeper into formulas and functions: 🤍 Microsoft Excel for Beginners - Level 1: 🤍 Microsoft Excel Tutorial - Level 3: 🤍 Microsoft Excel Tutorial - Level 4: 🤍 Microsoft Excel for Beginners - Level 5: 🤍 VLOOKUP Function for Excel: 🤍 Learn Pivot Tables for Beginners: 🤍 10 Best Excel Tips for Beginners: 🤍 How to Make a Line Graph in Excel: 🤍 I use Camtasia to create my videos: Use this coupon code: TEACHCAM10 Camtasia purchase with 10% OFF code applied: 🤍 Camtasia EDU 10% OFF with code applied: 🤍 Camtasia Download page: 🤍 DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video. You'll learn spreadsheet terminology and the modern Excel layout, how to create and save workbooks, entering values into Excel, Excel formulas and functions, formatting, creating and editing Excel charts, printing options, and publishing options. After watching and mastering this video, you will be able to use Excel effectively in almost any professional setting. Table of Contents: 00:00 - Intro 00:26 - Creating Workbooks, The Anatomy of a Spreadsheet / Spreadsheet Terminology 07:16 - Entering Cell Values and Data in Excel 20:18 - Formulas 30:21 - Functions: SUM, AVERAGE, MAX, MIN, COUNT 38:45 - Formatting Numbers, Text, Cells, Rows, and Columns 44:20 - Creating and Editing Charts 46:46 - Print Options and Publishing Options *Support Technology for Teachers and Students on Patreon*: 🤍 Here's my entire playlist of Excel tutorials: 🤍 Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: 🤍 #excel #exceltutorials #microsoft365
Join 300,000+ professionals in our courses: 🤍 This tutorial is a step by step deep dive into understanding how to use the Excel TAKE function. With the new TAKE function in Microsoft Excel you can extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction and calculations in combination with other Excel functions. For example, you can combine TAKE with the FILTER function. This way you can filter your dataset by certain criteria and then return the top/bottom rows. Or combine TAKE with SORTBY to sort your data by a certain column and then return the top/bottom N results. We'll also cover how you can combine TAKE with another new function: VSTACK. If you're wondering what the difference between TAKE and CHOOSECOLS or CHOOSEROWS functions are, I cover that in the tutorial. Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions. 🌍 My Online Courses ► 🤍 00:00 How to Use TAKE Function to Extract Data in Excel 01:12 How Excel TAKE Function Works 02:13 Difference between TAKE & CHOOSECOLS or CHOOSEROWS 02:58 TAKE & Average of Last Rows 04:12 Combine Excel FILTER and TAKE Function 05:13 Combine SORTBY and TAKE Function 07:32 Combine VSTACK and TAKE Function 09:55 Wrap Up ➡️ Join this channel to get access to perks: 🤍 🎬 LINKS to related videos: Excel VSTACK: Quickly Combine Data from Multiple Sheets: 🤍 How To Use Excel FILTER Function With Multiple Criteria: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 🎥 RESOURCES I recommend: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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
Join 400,000+ professionals in our courses: 🤍 Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. Learn formatting in Excel to display your data better. This basic tutorial is for all versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365). Looking for more Excel basics videos? Check out this playlist: 🤍 Time Stamps 00:00 Learn the Basics of Microsoft Excel 00:27 Anatomy of a spreadsheet in Microsoft Excel 01:20 What is a Cell in Microsoft Excel 03:50 What is a Range in Microsoft Excel 04:41 Excel Cursor and Mouse Pointer Shapes 05:48 How to Change Size of Rows and Columns in Excel 07:26 How to Use the Ribbon in Microsoft Excel 09:25 How to Enter Data in Microsoft Excel 11:47 How to Format Data in Microsoft Excel * Complete Excel Essentials course for beginners: 🤍 ⯆ The full article to Excel for beginners: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two. 📚 RESOURCES - Excel Workbook without formulas to follow along: 🤍 - Completed Workbook with all formulas and Functions: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 ⌚ TIMESTAMPS 00:00 Introduction 00:45 Status bar metrics 02:03 Enter formula to add 02:50 Edit formulas 03:06 Relative references 05:29 Fill handle 06:13 Subtract 06:57 Multiply 07:40 Absolute reference 09:46 Reference cells on other sheets 10:45 Name manager 12:03 Divide 12:44 Order of operations 14:40 Basic functions 15:04 Sum function 17:46 Formula text function 18:13 Discovering functions 18:37 Auto sum 19:37 Max function 20:15 Min function 20:48 Large function 21:54 Small function 22:35 Count function 23:00 Counta function 23:49 Countblank function 24:08 Average function 24:44 Median function 25:00 Mode function 25:23 Sumif function 27:29 Wildcards 28:36 Sumifs function 31:26 Proper function 32:00 Trim function 32:25 Concat function 33:39 & function 34:05 Textjoin function 34:52 Right, left and mid functions 35:27 Len function 35:46 Find and search functions 36:40 Left together with find 38:23 Logical functions 39:21 And function 39:53 Or function 40:14 If function 41:27 If together with and 42:23 If together with or 43:00 Nested if 44:41 Ifs function 45:32 Vlookup function 47:18 Xlookup function 49:24 Today and now functions 49:51 Bonus 52:04 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Excel: 🤍 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: 🤍 (Purchasing through this link gives me a small commission to support videos on this channel the price to you is the same) 🔽 CONNECT WITH ME - Official web site: 🤍 - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🎒 MY COURSES - Excel for Beginners in under 2 hours: 🤍 🙏 REQUEST VIDEOS 🤍 🔔 SUBSCRIBE ON YOUTUBE 🤍 #stratvert #MicrosoftAmbassador
AD: Sign up to enroll for a 7-day free trial with Coursera now! 🤍 Learn all the fundamentals of Data Analysis on Excel in 10 minutes! 🆓 DOWNLOAD Free Excel file for this video: 🤍 #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: 🤍 👉 Excel for Business & Finance Course: 🤍 🚀 All our courses: 🤍 SOCIALS: 🎬 My Company YouTube Channel: 🤍 📸 Instagram - 🤍 🤳 TikTok - 🤍 🧑💻 LinkedIn - 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 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.
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. 👋 Additional resources: - Sample file to follow along: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 ⌚ Timestamps 0:00 Introduction 1:47 Organize data properly for VLOOKUP 5:38 VLOOKUP Exact match 9:34 Improve error message with IFERROR 11:10 VLOOKUP Closest match 14:48 VLOOKUP Across sheets 15:43 HLOOKUP 18:21 XLOOKUP Simple example 22:53 XLOOKUP Combined with other functions 24:54 XLOOKUP Returns an array 26:42 XLOOKUP Match modes 28:30 XLOOKUP Search modes 31:24 Wrap up 📃 Watch related playlists and videos - Playlist with all my videos on Excel: 🤍 🚩 Connect with me on social: - LinkedIn: 🤍 - Twitter: 🤍 - Facebook: 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍 🛍 Support me with your Amazon purchases: 🤍 ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same. #stratvert
🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 Advanced Excel Full Course 2023 by Simplilearn is complete Excel tutorial that helps aspiring data analysts with excel data analytics fundamentals. This Microsoft Excel Tutorial For Beginners will cover basic topics of excel like data validation, conditional formatting, spreadsheet fundamentals to advanced excel topics like time series analysis, filters, slicers, excel dashboarding, data visualization, and much more. This Excel Full Course will cover the following topics: 00:00:00 introduction to Microsoft Excel Full Course 00:01:52 Excel Basic Knowledge 00:18:45 How To Change Lower Case To Upper Case In Excel? 00:19:58 How To Add Rows In Excel? 00:21:32 How To Add Columns In Excel? 00:24:29 How To Select Entire Column In Excel? 00:27:16 How to Compare Two Columns In Excel? 00:34:36 How To Convert Rows To Columns In Excel? 00:36:13 How to Group Rows in Excel? 00:37:55 How To Remove Blank Rows In Excel? 00:41:44 How To Freeze Row In Excel Tutorial 00:44:12 How to Convert Numbers to Words in Excel? 00:46:59 Combining Data From Multiple Cells In Excel 00:49:27 How To Merge Cells In Excel 00:54:12 How to Add Date in Excel? 00:55:48 How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy) 00:59:55 How To Calculate Age In Excel From A Date Of Birth? 01:01:37 How To Calculate Time Difference in Excel? 01:03:15 DAX In Excel Explained 01:08:20 Checkboxes In Excel 01:12:31 How to Insert Excel in PPT? 01:14:40 How To Insert Image In Excel? 01:18:05 How To Insert PDF in Excel Sheet? 01:21:40 How To Convert PDF To Excel 01:26:05 How to Insert Tick Mark in Excel? 01:29:05 How to add Watermark in Excel? 01:32:00 How to Increase Cell Size in Excel? 01:34:50 How to create Barcode In Excel 01:38:08 Excel Flash Fill 01:43:00 How to Add Hyperlink In Excel 01:55:44 Excel Round-Off Formula 01:58:18 How To Calculate Standard Deviation In Excel? 02:04:50 Index Match In Excel 02:09:10 How to Sort by Date in Excel? 02:10:40 How to Use AutoSum In Excel 02:13:47 How To Sort Data In Excel? 02:23:56 Slicer and Filter in Excel 02:27:49 How to Add Filters in Excel 02:29:20 Goal Seek In Excel How to Create Drop-Down List In Excel? 02:44:46 Data Validation In Excel 02:44:50 How To Lock(Protect) Cells In Excel 03:17:55 How To Calculate Average In Excel? 03:18:43 Excel Print Page Setup 03:36:47 Page Break In Excel For Beginners 03:08:53 Conditional Formatting In Excel 03:41:56 How to Count Colored Cells in Excel? 03:47:54 DateDif In Excel Explained 03:51:08 Remove Duplicates In Excel 03:55:05 SUMIFS Formula in Excel 04:02:40 How To Create Pivot Tables In Excel 04:07:00 Autofill In Excel Explained 04:10:22 How to Calculate Percentage In Excel 04:12:08 How To Highlight Duplicates In Excel? 04:16:04 Charts In Excel 04:21:56 Progress Tracker In Excel 04:25:50 Excel Gantt Chart Tutorial 04:28:48 Pivot Tables In Excel 04:57 Pivot Charts in Excel and How to Create a Pivot Table Using Multiple Sheets in Excel 06:45:02 Time Series Analysis in Excel 07:37:00 Excel Dashboard Design 08:47:00 Excel Power Query Tutorial For Beginners 09:44:44 Excel Budget Template 09:51:37 Excel Interview Questions And Answers ⏩ Check out the Excel tutorial videos: 🤍 #HowtoGroupRowsinExcel #ExcelTutorial #ExcelGrouping #ExcelTips #MSExcel #Excel #ExcelTraining #LearnMSExcel #ExcelBasics #ExcelTutorialForBeginners #simplilearn ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. 👉 Learn More at: 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
[BE ORIGINAL] 8TURN 'EXCEL' [비 오리지널] 에잇턴 '엑셀' 에잇턴 넋놓고 보다가 배터리 방전됐습니다.. (1:55) 하루 종일 틀어두고 싶은 파트ㅠㅠㅠ #8TURN #에잇턴 #BEORIGINAL Stream various performance video on #STUDIOCHOOM! 👉SUBSCRIBE👈 YouTube: 🤍 Facebook: 🤍 Instagram: 🤍 Naver TV: 🤍
You asked for it. Here is my free course on advanced data analytics. 💥Want more... get my Excel School program 👉 🤍 In this comprehensive video, learn: 1) How to approach a data analysis project 2) How to systematically clean data 3) Doing EDA with Excel formulas & tables 4) How to use Power Query to combine two datasets 5) Statistical Analysis of data 6) Using formulas like COUNTIFS, SUMIFS, XLOOKUP 7) Making an information finder with your data 8) Male vs. Female Analysis with Pivot tables 9) Calculating Bonus based on business rules 10) Visual analytics of data with 4 topics 11) Analysing the salary spread (Histograms & Box plots) 12) Relationship between Salary & Rating 13) Staff growth over time - trend analysis 14) Regional Scorecard to compare NZ with India You will also learn below Excel features: 1) Using Tables 2) Working with Power Query 3) Formulas 4) Pivot Tables 5) Conditional formatting 6) Charts 7) Data Validation 8) Keyboard Shortcuts & tricks 9) Dashboard Design 💥📁 Sample files: Blank data file (perfect for following along) - 🤍 Completed workbook - 🤍 ⏱ Video Timestamps: 0:00 - Introduction & Topic Coverage 1:50 - Data Cleaning with Excel 6:17 - Ad-hoc Analysis of Data 10:23 - Using Power Query to combine & clean data in one go 21:25 - 5 Business Questions for Data Analysis 23:12 - Quick Analysis of Data - Summaries & Statistics 31:17 - Building an information finder using Lookup Formulas 36:59 - Information Finder v2.0 41:43 - Male vs. Female Comparison with Pivots 48:15 - Calculating Bonus based on Business Rules 51:03 - 4 Data Visualization Themes 52:46 - Understanding the salary spread with histograms & box plots 59:50 - Salary vs. Employee Rating Correlation 1:08:50 - Employee Trend over time 1:19:19 - Creating a Report Card to compare NZ vs. India What to watch next? = I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest these videos: Beginner to PRO Data Analysis Excel Course - 🤍 5 key skills you need to be a GREAT data analyst - 🤍 5 Excel Skills you need to focus on - 🤍 15 Excel functions you should know - 🤍 My playlist on data analysis - 🤍 Want to learn more? Join my Excel School 👉 = If you want more step-by-step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles. Visit 🤍 to sign up today. My Recommended Excel Books 📚👌: = 🤍 😎 SAY HELLO 👋 = Apart from YouTube, I frequently post on, my blog - 🤍 twitter - 🤍 Instagram - 🤍 Have a beautiful day 🌼🌞😀 #DataAnalysis #Excel
These functions fundamentally change the way we write formulas that calculate across columns and down rows. The BYCOL and BYROW functions enable us to write a formula once and have it automatically applied to all rows or columns in the range we specify. Improving productivity and accuracy. *Available in Microsoft 365. ⬇️DOWNLOAD the example file here: 🤍 LAMBDA Function: 🤍 LEARN MORE = 🏫 LEARN MORE in my Excel courses: 🤍 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all! 🎯 FOLLOW me on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍 ⏲ TIMESTAMPS 0:00 The old way to copy formulas 0:41 Formulas that automatically copy down columns 3:47 Formulas that automatically copy across rows
*Note: 1+ Years of Work Experience Recommended to Sign up for Below Programs⬇️ 🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 This video on complete excel course - beginner to expert by Simplilearn is complete Excel tutorial that helps aspiring data analysts with excel data analytics fundamentals. This Microsoft Excel Tutorial For Beginners will cover basic topics of excel like data validation, conditional formatting, spreadsheet fundamentals to advanced excel topics like time series analysis, filters, slicers, excel dashboarding, data visualization, and much more. 00:00:00 Introduction to Microsoft Excel Full Course Excel Basic Knowledge How To Change Lower Case To Upper Case In Excel? How To Add Rows In Excel? How To Add Columns In Excel? How To Select Entire Column In Excel? How to Compare Two Columns In Excel? How To Convert Rows To Columns In Excel? How to Group Rows in Excel? How To Remove Blank Rows In Excel? How To Freeze Row In Excel Tutorial How to Convert Numbers to Words in Excel? Combining Data From Multiple Cells In Excel How To Merge Cells In Excel How to Add Date in Excel? How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy) How To Calculate Age In Excel From A Date Of Birth? How To Calculate Time Difference in Excel? Checkboxes In Excel How to Insert Excel in PPT? How To Insert Image In Excel? How To Insert PDF in Excel Sheet? How To Convert PDF To Excel How to Insert Tick Mark in Excel? How to add Watermark in Excel? How to Increase Cell Size in Excel? How to create Barcode In Excel Excel Flash Fill How to Add Hyperlink In Excel Index Match In Excel How to Sort by Date in Excel? How to Use AutoSum In Excel How To Sort Data In Excel? Slicer and Filter in Excel How to Add Filters in Excel How to Create Drop-Down List In Excel? Data Validation In Excel How To Lock(Protect) Cells In Excel How To Calculate Average In Excel? Excel Print Page Setup Page Break In Excel For Beginners Conditional Formatting In Excel How to Count Colored Cells in Excel? DateDif In Excel Explained Remove Duplicates In Excel SUMIFS Formula in Excel How To Create Pivot Tables In Excel Autofill In Excel Explained ✅ Subscribe to our Channel to learn more about the top Technologies: 🤍 ⏩ Check out the Data Analytics Training Videos: 🤍 #ExcelCourse #CompleteExcelCourse #AdvancedExcelTutorial #ExcelTraining #MSExcel #ExcelForBeginners #ExcelFullCourse #LearnExcel #2023 #Simplilearn ➡️ Data Analytics Bootcamp The Caltech Data Analytics Bootcamp is ideal for working professionals from all backgrounds. Develop core skills such as mastering excel, creating data-driven presentations, data manipulation with SQL, analyzing data with Python, and data visualization with Tableau. Learn data analysis with tools such as AWS. ✅ Key features - Simplilearn Career Service helps you get noticed by top hiring companies - Data Analytics Bootcamp Certificate from Caltech CTME - Caltech CTME Circle Membership - Online Convocation by Caltech CTME Program Director - Access to integrated Data Analytics Labs ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analytics using Python - Data Visualization with Tableau - Linear and Logistic Regression - Data Manipulation - Data Analysis in AWS ✅ Enroll Course Now: 🤍 🔥🔥 *Interested in Attending Live Classes? Call Us:* IN - 18002127688 / US - +18445327688 👉 Listen to what millions of users say about our courses! 🤍 🔥 Enroll for Free Courses by Simplilearn: 🤍
* Download this Practice Workbook HERE: 🤍 Welcome to the second video of the Complete MS Excel Course for Beginners! 1. In the first video, we have learnt about the various job opportunities that require MS Excel as a skill, along with how you can access MS Excel for free. 2. The second video (which is this one!) is a Complete MS Excel Tutorial for Beginners. I have also created a practice excel workbook for you, that you can download and practise those features along with me while watching the video. (Scroll down for link!) 3. And in the third video, we are going to cover 10 most commonly asked MS Excel Interview Questions along with their answers. (Link to download this Interview practice sheet is in the description of Video 3) Today’s Agenda: 1. Basics of a Workbook 2. What are Flash-Fill and Auto-Fill 3. What is an MS Excel Ribbon? 4. The Home tab features .. including find, search and replace. 5. View tab features… Split and Freeze Pane 6. What are Functions and Formulas? What is the difference between Function and Formulas? 7. What is Absolute and Relative Referencing 8. Logical Functions 9. Text Functions 10. LookUp function 11. Tables and Charts 12. Pivot Tables 13. And last but not the least, how to handle the most commonly encountered errors in MS Excel. So it doesn’t matter if you are a beginner or someone looking to brush up their basics right before an interview, I promise, by the end of these 3 videos you’ll excel at your excel skills. Don’t forget to comment and tell me what job role you are learning Excel for. It will help me decide what career videos to make next for you. Let’s start learning! :) * TIMESTAMPS: 0:00 - Introduction 2:18 - Workbook Basics 2:58 - Cell Name/Cell Address and Cell Range 5:09 - Insert/Delete and Hide Rows/Columns 7:06 - Introduction to the MS Excel Ribbon 8:21 - Autofill and Flashfill 14:22 - Home Tab Features 14:44 - Formatting Options 15:52 - Wrap Text 16:15 - Merge and Centre 16:50 - Number Formats 17:33 - Conditional Formatting (Highlight Cell Rules, Data Bars, Icon Sets, Colour Scales, Clear Rules..) 19:50 - Auto-fit Column Width 20:11 - Find, Select and Replace 22:22 - Sort & Filter 25:50 - Split and Freeze Pane (View Tab Features) 28:59 - Difference Between Split and Freeze Pane 29:38 - Functions and Formulas 29:49 - Sum, Average, Max, Min 31:50 - Count, CountA, CountBlank 32:45 - Difference between Formula and Function 33:54 - Relative and Absolute References 38:38 - Mixed References 42:12 - Logical Functions 42:29 - IF Function 44:14 - Nested IF 45:09 - AND Function 46:22 - OR Function 47:40 - SumIF Function 49:44 - CountIF Function 50:30 - Text Functions 50:52 - Left, Right, Mid 51:40 - Upper, Lower, Proper 52:05 - Len and Trim 52:55 - Concat and TextJoin 54:15 - VLOOKUP 57:42 - VLOOKUP Limitation 59:57 - MS Excel Tables (Creation and Features) 1:04:14 - Slicers 1:06:30 - Charts 1:10:20 - Different Chart Types 1:12:04 - Pivot Tables (Cleaning Data, Create Pivot Table and Analyse Data Option) 1:21:27 - MS Excel Errors 1:25:25 - IFError Function * LINKS TO OUR MS EXCEL COURSE: 1) Get MS Excel for FREE (Video 1): 🤍 2) Complete MS Excel Tutorial for Beginners (Video 2): 🤍 3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3): 🤍 Our Interview Preparation Course (12+ Videos): 🤍 * OUR OTHER VIDEOS YOU MIGHT LIKE: 1) Stock Market for Beginners: 🤍 2) Zerodha Trading Tutorial for Beginners: 🤍 * #MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel
Thanks to Mine for Sponsoring: Find out which companies have your data and reclaim it 😤 by visiting ⇨ 🤍 ▼ Time Stamps: ▼ 0:00 - Intro 0:25 - Camera 1:27 - Importing Web Data 2:32 - 3D References 3:14 - Go To Special 3:49 - A Very Excellent Thing 5:36 - Circular References 6:17 - Autosave Interval 6:32 - Custom Lists 7:03 - Developer Tab 7:32 - Advanced File Properties 7:53 - INDIRECT Formula 8:49 - Cell Dropdown Lists 9:26 - Part 2: Features Hidden in Plain Sight 9:34 - Named Ranges 10:11 - Quick Analysis 10:30 - Forecast 10:53 - Watch Window 11:12 - Formula Auditing 12:39 - Conditional Formatting 13:46 - Sparklines 14:29 - Change Multiple Sheets ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Merch ⇨ 🤍 ⇨ 🤍 ⇨ 🤍 ⇨ 🤍 My Gear & Equipment ⇨ 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Download to follow along and complete the exercises ➡️🤍 In this Excel 2021 Beginner to Intermediate training course, go from zero to hero as we cover the basics and expand to intermediate Excel skills. We'll go over Excel logical IF functions, Excel lookup functions such as VLOOKUP and XLOOKUP, importing data into Excel, formatting, and so much more! We've even included downloadable exercise files from our paid-for course, which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught. ✅🤍 📝Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 00:00:00 - Introduction 00:00:22 - Course Intro 00:02:42 - Excel 2021 vs Excel 365 00:08:21 - Launching Excel 00:12:00 - The Start Screen 00:22:12 - Exploring the Interface 00:33:51 - Ribbons, Tabs and Menus 00:42:20 - Backstage Area 00:47:00 - Quick Access Toolbar 00:56:45 - Useful Keyboard Shortcuts 01:06:27 - Getting Help 01:13:04 - Exercise 01 01:15:27 - Working with Templates 01:24:30 - Workbooks and Worksheets 01:32:04 - Saving Workbooks 01:40:50 - Entering and Editing Data 01:50:43 - Navigating and Selecting Cells, Rows and Columns 01:58:02 - Exercise 02 02:03:22 - Formulas and Functions Explained 02:15:06 - SUM Function 02:22:44 - COUNT Function 02:30:10 - AVERAGE Function 02:34:27 - MIN and MAX Function 02:36:52 - Handling Errors in Calculations 02:45:34 - Absolute vs Relative Referencing 02:52:29 - Autosum and Autofill Options 03:02:12 - Flash Fill 03:07:15 - Exercise 03 03:12:26 - What are Named Ranges 03:21:33 - Managing Named Ranges 03:25:22 - Using Named Ranges 03:30:42 - Exercise 04 03:35:00 - Applying Number Formats 03:45:03 - Applying Date and Time Formats 03:50:41 - Formatting Cells, Rows and Columns 03:59:20 - Format Painter 04:04:00 - Exercise 05 04:08:11 - Working with Rows and Columns 04:16:36 - Deleting and Clearing Cells 04:23:02 - Aligning Text and Numbers 04:34:15 - Applying Themes and Styles 04:42:13 - Course Introduction 04:48:31 - Improve Readability with Cell Styles 04:53:30 - Controlling Data Input 05:01:49 - Adding Navigation Buttons 05:10:36 - Logical Functions 05:23:56 - The IF Function 05:29:25 - Nested IFs 05:37:24 - The IFs Function 05:43:27 - Conditional IFs 05:50:13 - Multiple Criteria 05:57:25 - Error Handling 06:03:27 - Exercise 01 06:10:56 - VLookup (Exact Match) 06:21:36 - VLookup (Approximate Match) 06:26:02 - HLookup 06:31:40 - INDEX and MATCH 06:42:09 - XLookup and XMatch 06:52:18 - OFFSET Function 07:03:10 - INDIRECT Function 07:12:17 - Exercise 02 07:17:19 - Sorting on Multiple Columns 07:24:25 - Soring Using a Custom List 07:28:00 - SORT and SORTBY Functions 07:37:49 - Advanced Filter 07:44:52 - UNIQUE Function 07:50:10 - FILTER Function 07:49:40 - Exercise 03 08:05:20 - How Date and Times are Stored 08:09:32 - Custom Data and Time Formats 08:16:42 - Time and Date Functions 08:25:26 - WORKDAY and WORKDAY.INTL Functions 08:29:16 - NETWORKDAYS and NETWORKDAYS.INTL Functions 08:32:13 - DATEDIF 08:38:28 - EDATE and EOMONTH 08:45:52 - Exercise 04 08:50:45 - Importing Data into Excel 09:00:40 - Removing Blank Rows, Cells and Duplicate Entries 09:06:02 - Changing Case and Removing Spaces 09:15:07 - Splitting Up Data Using Text to Columns 09:22:08 - Splitting Up Data Using Text Functions 09:30:13 - Flash Fill 09:35:13 - CONCAT 09:42:44 - Formatting Data as Table 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
💥 Get ready to be surprised and amazed. 👉 FREE Excel + Power BI tips newsletter - 🤍 Here are the 50 things you didn't know Excel can do. 0:00 - 50 Advanced Excel Tips & Tricks 0:34 - Duplicate file quickly 0:54 - Adding buttons to QAT 1:31 - Move QAT below 1:40 - Make your own list in Excel 2:39 - GPS in Excel 3:12 - Clipboard Tool 3:50 - Pin files to quickly access them 4:13 - Excel defaults to one sheet 4:45 - Change Excel color 5:14 - One shortcut to rule them all 5:53 - Top 10 filter 6:08 - Sort by more than one column 6:43 - Screenshots / screencaps in Excel 7:44 - Hide things with ;;; 8:34 - Rotate text in cells 8:49 - Select just numbers 9:22 - New line in a cell 9:42 - Find and highlight all matching values in one go 10:37 - Navigator (birds eye view of Excel workbook) 11:31 - Data from picture 12:52 - TAKE function (Excel 365) 13:32 - Edit formula ranges quickly 14:07 - Move help text away 14:19 - Unique function (Excel 365) 14:50 - Image in cell (Excel 365) 16:32 - Formulatext function 16:50 - Debug formulas with F9 17:26 - Formula result tooltip (Excel 365) 17:40 - Reverse formula with goalseek 18:26 - Excel.new for new files 19:07 - Recommended pivots 19:27 - Move pivot fields / row labels 19:40 - Hide the + buttons in pivot tables 19:54 - Multiple pivots with one click 20:30 - Slice those pivots 20:53 - Sort pivot table field list 21:12 - Distinct count in pivots 21:41 - Median in Pivots (with DAX) 22:25 - Set your own Pivot Table defaults 23:10 - Hide items in chart easily 23:33 - Filters & charts 24:02 - Dynamic chart titles 24:32 - Emoji 😍😅😻 in Charts 25:04 - Tiny charts with sparklines 26:09 - Images in charts 🖼 26:49 - Negative values in a different color chart 27:38 - Combo charts 28:16 - Adjust chart range with mouse 28:54 - Recommended charts 29:26 - 50 is a lot!!! 📺 MORE TIP COLLECTIONS Like this video? You are going to LOVE these videos too. 30 Advanced Excel Tips & Tricks - 🤍 (300k+ views) 5 Amazing Conditional Formatting Tricks - 🤍 (140k views) 5 Advanced Tips on IF formula - 🤍 (140k views) 10 things my boss was doing in Excel - 🤍 (2.3 mn views, that is right, 2.3 mn!) 10 things you thought Excel couldn't do - 🤍 (100k views) 10 Copy Paste Tricks - 🤍 (200k views) Data Cleaning - 10 tips - 🤍 (300k views) 10 More Data Cleaning tricks - 🤍 (450k views) AI in Excel - 5 AWESOME Features - 🤍 (380k views) ~ #excel #exceltips #doyouknow ~ Why can't Excel ever marry? It is waiting for the exact MATCH() 🤣
Dive into 8 OFFICIAL Microsoft AI tools that'll skyrocket your productivity by 10x! No third-party add-ins, just pure Excel magic. ⬇️DOWNLOAD the example file here: 🤍 With just a click: 🧹 Make your data spotless 🧮 Craft formulas effortlessly ⁉️ Analyze data like a pro 📊 Visualize data in dazzling ways TOPICS IN MORE DETAIL: = Flash Fill: 🤍 Excel Labs: 🤍 Forecasting: 🤍 Formula by Example: 🤍 ❓Which Excel AI tool is your favourite? Please let me know in the COMMENTS. 📰 EXCEL NEWSLETTER - join here: 🤍 🎓 LEARN MORE in my Excel courses: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all! 🎯 CONNECT with me on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍 ⏲ TIMESTAMPS 0:00 Excel AI Tools 0:27 Data Cleaning 1:08 Add Calculated Columns 3:46 AI PivotTables 5:02 AI Charts 5:34 AI Analyzes your Data 7:21 Forecasting 8:09 Write Formulas 10:42 AI Suggested Formulas
Try this Excel Interview test to see your level! 👉 Take our Excel for Business & Finance Course: 🤍 🆓 DOWNLOAD Free Excel file for this video: 🤍 This Excel Interview Test has a total of 4 questions going from easy to hard. First we use conditional formatting to find the bottom 10 values. Second, we use a combination of an IF and an AND statement to accept or reject a project based on two criteria. Third, we use the goal seek tool on Excel under what if analysis to reach 5000 in profit. Finally, we use 2 different formulas to find the revenue in France for each month. For this we first use a SUMIFS with relative references. Second we use the XLOOKUP combined with the ampersand (&) so we can filter using multiple criteria. LEARN: 👉 Excel for Business & Finance Course: 🤍 🔥Power BI for Business Analytics: 🤍 📈 The Complete Finance & Valuation Course: 🤍 🚀 All our courses: 🤍 SOCIALS: 🎬 My Company YouTube Channel: 🤍 📸 Instagram - 🤍 🤳 TikTok - 🤍 🧑💻 LinkedIn - 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Question 1 (Easy) 1:17 - Question 2 (Intermediate) 4:15 - Question 3 (Advanced) 6:30 -Question 4 (Expert) Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
So the bossman wanted some Excel help. Here we go again 💥 0:00 - Combine data without copy pasting 0:44 - Fill the blank cell with value from above 1:27 - Running totals 2:00 - Filter Top 10 values 2:28 - How to highlight the top 10 values? 3:11 - Autofit in a jiffy 3:33 - Format Painter Magic 4:12 - Many totals in one click 4:43 - Rounding labels to 1000s 5:23 - Get everything in line with a click 5:57 - 19 powerful Excel shortcuts 📺 WATCH NEXT 19 Excel Shortcuts you must know - 🤍 Boss vs me - the playlist - 🤍 👑 Be an Excel BOSS with my advanced Excel course 🤍 #bossvsExcel
Learn how to use formulas in Excel, including the following functions & formulas: ⌚ Timestamps 0:00 Introduction 0:55 Add 1:55 Subtract 2:18 Multiply 2:50 Divide 3:20 Sum 4:46 Min 5:05 Max 5:30 Count 6:15 Counta 6:48 Average 7:20 Median 7:54 Concatenate 8:29 If 9:10 Countif 9:40 Vlookup 10:58 Sumif 11:46 Current Time 📃 Watch related playlists and videos - Excel: 🤍 - Pivot Tables: 🤍 - Vlookup & hlookup: 🤍 - Mail Merge: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 Thinking about subscribing to Office 365? You get the Word, Excel, and PowerPoint desktop apps and up to 6 TB cloud storage. Check the latest pricing on Amazon: 🤍 (as a disclaimer, purchasing through this link gives me a small commission to support videos on this channel the price to you is the same). Let me know if you have any questions. Also, let me know if there are other topics that you would like to see videos on. 🚩 Connect with me on social - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🙏 Request How To Tutorial Videos 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍 🛍 Support me with your Amazon purchases: 🤍 ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same. #stratvert #excel
Learn 8 awesome new formulas in Excel to boost your productivity in 2023. 🔥 Take our Excel Course: 🤍 🆓 DOWNLOAD Free Excel file for this video: 🤍 In this video, we'll go over new excel functions that you can use in 2023. These formulas include the Vstack, Hstack, textsplit, textbefore, textafter, image function, converting images to tables, TOCOL, TOROW, Take, Drop, and Expand functions. Knowing these new excel functions for 2023 will boost your productivity, especially when dealing with data cleaning on Excel. LEARN: 🔥Power BI for Business Analytics: 🤍 📈 The Complete Finance & Valuation Course: 🤍 👉 Excel for Business & Finance Course: 🤍 🚀 All our courses: 🤍 SOCIALS: 🎬 My Company YouTube Channel: 🤍 📸 Instagram - 🤍 🤳 TikTok - 🤍 🧑💻 LinkedIn - 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - vstack & hstack 1:18 - TextSplit 2:32 - TextBefore & TextAfter 3:43 - Image Function 5:40 - Image to Text 6:32 - ToCol & ToRow 7:20 - Take & Drop Functions 9:45 - Expand Function Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
► Kanal abonnieren: 🤍 Kennst du schon meinen umfangreichen Excel Online Kurs? 😎 🤍 ► Datei: 🤍 Wie viele Funktionen kennst du in Excel? Bist du ein Excel Profi? In diesem Video erarbeiten wir 5 Praxisbeispiele, welche direkt aus einem Vorstellungsgespräch stammen könnten. Kennst du die Funktionen, um die Beispiele zu lösen? Falls du die Aufgaben selbst versucht, schreibe unten in den Kommentaren wie viel Stufen du geschafft hast, bevor du Hilfe benötigt hast. ▬ Weitere Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Datenbank in Excel erstellen 🤍 ► Professionelle Dashboards in Excel 🤍 ► Die wichtigsten Excel Funktionen 🤍 ▬ Mehr Jakob ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Excel Kurs: 🤍 ► Abonniere meinen Kanal: 🤍 ▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 Intro 00:26 Stufe 1 01:23 Stufe 2 03:09 Stufe 3 05:05 Stufe 4 07:16 Stufe 5 10:22 Neugewinn 11:22 Stufe 1 (besser)
📈 Aprenda em 7 Minutos Dicas Rápidas e Produtivas de Excel. Aprenda EXCEL de forma RÁPIDA e sem termos técnicos! Clique aqui! 🤍 📌 Vou trazer para você 10 dicas rápidas de excel para aumentar sua produtividade com o uso de planilhas, você aprenderá em 7 minutos, isso mesmo, vamos conferir as dicas? 🏫 Conheça o nosso trabalho com Cursos, E-books e Aulas Online! Clique Aqui: 🤍 📱 Fique por dentro do que rola de novidades do canal no TELEGRAM: 🤍 📜Curso com certificado reconhecido, faça já sua formação conosco! 🤍 💙Me siga nas redes sociais para conteúdos exclusivos: Facebook.: 🤍 Instagram: 🤍 Site: 🤍 #excel #cursodeexcel #cursodeexceloficial
Finally, a dedicated video to MS Excel! In almost every video I make about Personal Finance, I figure out a way to include MS Excel in it!! This video is not going to give a 100% understanding of Excel, so here is my recommended course on Udemy which I have taken personally, and go back to it whenever I need some help. You can check it out here: 🤍 So why not give you a dedicated video on MS Excel? MS Excel, in my opinion, is the most powerful software ever made! I use it for everything - budgeting, my video ideas, all my personal finance, and whatnot! In this video, I will explain to you the basic and most important thing about Excel, that if you understand this one thing, you are done with 80% of fundamentals! Click here to subscribe to my YouTube channel: 🤍 Ankur Warikoo is an entrepreneur, an angel investor, a mentor and an active public speaker. For the past 4 years, Warikoo has been actively sharing content on YouTube, LinkedIn, Instagram, Facebook and Twitter amassing a following of 3 Million+ people. He posts 3 Hindi and English videos every week on his YouTube channel, where he talks about entrepreneurship, how to grow in life, personal finance and failure. Warikoo started his entrepreneurial journey in 2008. His most recent startup is nearbuy.com where he was the founder and CEO from 2015 until 2019. Prior to that, Ankur started Groupon’s India business in 2011 and acted as the Country CEO from 2011-15, and Head of Groupon APAC from 2013-15. An alumnus of the Indian School of Business, Ankur is an active Angel investor and mentor to several startups. Ankur has been part of Fortune Magazine’s 40 under 40 List for India, LinkedIn India’s PowerProfiles List, LinkedIn India’s Spotlight List and India’s Top Executives under 40 list. - My bestselling books: ‘GET EPIC SHIT DONE’: 🤍 ‘Do Epic Shit’: 🤍 My gear for shooting this video: 🎥 Sony a7III camera: 🤍 🎬 Sony FE 24-70 f2.8 Lens: 🤍 🎙️ Shure SM7B Microphone: 🤍 🔆 Fill Light 60W: 🤍 💡 Key Light 150W: 🤍 📽️ Benro IT15 Tripod for Sony a7III camera: 🤍 Useful links: 20 books for your 20s: 🤍 20 online courses for your 20s: 🤍 Gadgets that I use: 🤍 The above links are on Amazon. If you buy any of these using the above links, I stand to make affiliate income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L and in 2022 we contributed 53L. Let’s connect online: 🎙️ My weekly podcast Woice with warikoo (Spotify): 🤍 📩 My weekly newsletter warikoo Wanderings: 🤍 📱 Instagram: 🤍 🐦 Twitter: 🤍 👨🏻💻 LinkedIn: 🤍 😄 Facebook: 🤍 🖋️ Daily Blog: 🤍
Ever wanted to make a pivot table, but your data is scattered across multiple worksheets? Like Jan, Feb, Mar...? In this video, learn an AMAZING Excel trick to solve the problem easily. Note: This works in Excel 2016 or above (or with Power Query add-in in Excel 2013) Step by step instructions and sample file 👉🤍 ⏱ Video Topics: 0:00 - Many sheets, One Pivot - the problem 0:42 - Combining the data (using Power Query) 2:08 - Data cleansing with Power Query 4:00 - Creating the pivots 6:00 - How to add new data and update the pivots 7:00 - What if your data is not structured correctly? 📁sample data = Try it yourself using the sample dataset here 👇 🤍 📺 Watch next = How to combine data when the headers / structure is not matching? 🤍 Combine multiple sheets of data using Power Query 🤍 Have data in a folder instead? Use this method: 🤍 How to create Pivot Tables? (8 examples): 🤍 Full Advanced Excel Course by Chandoo: 🤍 📗💻 LEARN EXCEL - FULL COURSE by Chandoo Want to learn how to use Excel for Data Analysis, MIS, Reporting or Project Management roles? Check out my Excel School program and sign-up today. 🤍 ~ #excel #dataanalytics
One of the downsides of PivotTables is they have a very distinctive look. Some might even say they’re ugly. In this video I cover 12 PivotTable formatting tricks that will transform their look and feel. 🔖RELATED TUTORIALS: Conditional Formatting: 🤍 Original PivotTable Profit & Loss Report tutorial and file: 🤍 🎓 LEARN MORE in my Excel courses: 🤍 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all! 🎯 CONNECT with me on LinkedIn: 🤍 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: 🤍 ⏲ TIMESTAMPS 0:00 How to Format PivotTables 0:23 Custom Sort Order 1:24 Column Labels 2:19 Inserting Blank Rows 2:42 Subtotal Position 3:14 Custom Styles 5:08 Expand/Collapse Buttons 5:30 Conditional Formatting 7:58 Repeating Item Labels 8:48 Report Layouts 9:20 Hiding (blank)s 10:08 Preserving Formatting 10:37 Default PivotTable Layout
🟢 EL CURSO MAS COMPLETO DE LA RED con más de 200 ejercicios para practicar. Tienes que probar este curso gratis 2023 de Excel en sus 3 niveles básico , intermedio y avanzado. En este MEGA PROYECTO encontrarás los 3 niveles de Excel con más de 200 ejercicios para practicar y volverte todo un experto sin gastar nada. No te pierdas esta oportunidad donde aprenderás todo lo relacionado con Excel en un solo video. 👇 DESCARGA LIBRO MAESTRO DEL CURSO 👇 🤍 00:00 Introducción al curso completo Excel 03:26 Recomendaciones del curso 👉Primeros Pasos: 07:15 Conociendo el entorno de Excel 19:21 Configuraciones Básicas 23:33 Guardar, Exportar e imprimir 25:37 Manejo de las Hojas de Excel 31:09 Formatos de celda 👉Fundamentos Básicos: 47:35 Protección de libro, hoja y celda 54:36 Manejo de filas, columnas, celdas, rangos y tablas 01:04:20 Operadores aritméticos en excel 01:09:53 Referencia de celdas: relativas, absolutas y mixtas. 👉Funciones Básicas: 01:19:51 Función Sumar, contar, contara, max, min y promedio. 01:26:30 Condicionales: Sumar.si, contar.si, promedio.si, max.si, min.si. 01:34:30 Texto: concatenar, izquierda, derecha, extrae, 01:39:50 Separar texto en Columnas, quitar duplicados. 👉Funciones Avanzadas: 01:46:10 Funciones anidadas (Si Anidada) 02:00:40 Funciones Lógicas: SI, Y, O 02:05:00 Funciones de búsqueda: buscarV, buscarH, 02:14:20 Funciones de referencia: indice y coincidir 👉Formato tabla: 02:24:56 Crear una tabla 02:30:27 Sub Totales 02:32:20 Autofiltro y filtro avanzado 02:38:40 Ordenar Datos 02:39:25 Validación de datos 👉Creación de gráficos: 02:45:23 Columnas, barras, líneas, dispersión etc. 02:53:09 Editar Elementos 👉Tablas dinámicas y gráficos dinámicos 03:19:04 Crear tablas dinámicas 03:26:50 Editar tablas dinámicas: estilos, agrupar datos, ordenar 03:31:50 Configuración de campo y opciones 03:35:50 Campos calculados 03:39:20 Crear gráficos dinámicos 03:42:00 Segmentación de datos Escala de tiempo 👉Filtros Avanzados: 03:50:28 Filtrar por un criterio 03:55:25 Filtrar por dos criterios 03:57:09 Filtrar por tres Criterios 03:59:10 Filtrar valores que comiencen por la primera letra 04:03:48 Filtrar valores que terminen en una letra 👉Creación de Macros 04:11:50 Que es una macros y para que sirve 04:15:09 Macro para alimentar Base de Datos 04:30:10 Macro con filtros avanzados 04:34:00 Crear Macro Absoluta y relativa 👉04:39:40 Creación Dashboard 🔴04:40:40 🤍 Configuración tablas dinámicas Configuración Formas Creación del Dashboard VISITA NUESTRAS PÁGINAS WEB: 🔵 🤍 🔵 🤍 SÍGUENOS EN NUESTRAS REDES SOCIALES 🔴 TikTok: 🤍 🔴 Instagram: 🤍 🔴 Facebook: 🤍 CONSULTA NUESTROS GRUPOS DE AYUDA 🟢Ayuda en Excel: 🤍 🔵 Ayuda en Word: 🤍
Join 400,000+ professionals in our courses: 🤍 ⯆ Get the files Here: 🤍 OpenAI inside Excel? How can you use an API key to connect to an AI model from Excel? This video shows you how. You can download the files from the GitHub link above. Wouldn't it be great to have a search box in Excel you can use to ask any question? Like to create dummy data, create a formula or ask about the cast of the The Sopranos. And then artificial intelligence provides the information directly in Excel - without any copy and pasting! In this video you'll learn how to setup an API connection from Microsoft Excel to Open AI's ChatGPT (GPT-3) by using Office Scripts. As a bonus I'll show you how you can parse the result if the answer from GPT-3 is in more than 1 line. This makes it easier to use the information in Excel. 🌍 My Online Courses ► 🤍 00:00 How to Connect Excel to Open AI ChatGPT 01:18 Answer Any Question in Excel 02:16 Use ChatBot to Write Excel Formulas 04:16 Analyze Financial Statements with AI GPT 05:21 Use AI to Create Dummy Data in Excel 07:26 How to Build Your Own AI ChatBot in Excel 08:54 Create Office Script to Connect to GPT-3 11:13 Wrap Up 🎬 LINKS to related videos: How ChatGPT Can Help With Your Complex Excel Spreadsheets: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 RESOURCES I Recommend: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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 #chatgpt #ai
Excel Interview Question Day Month Year in Excel #excel #exceltips #exceltutorial #msexcel #shorts YEARFRAC Formula in excel WEEKNUM Formula in excel REPLACE Formula in excel MOD Functoin in Excel SQRT formula in excel SQRT function in excel Consolidate in excel 3D Sum in excel Running Total in Excel SMALL formula in excel SMALL function in excel LARGE formula in excel LARGE function in excel Rank formula in excel How use rank formula in excel how use rank function in excel rank function in excel SUMIF formula in excel SUMIF function in excel REPT formula in excel REPT function in excel Char formula in excel Char function in excel Date function in excel Date formula in excel Time formula in excel Time function in Excel Filter formula in excel Advanced Filter formula in excel MAX formula in excel MAX function in excel MIN formula in excel MIN function in excel XLOOKUP formula in excel XLOOKUP function in excel Filter in excel Advanced Filter in excel ISTEXT formula in excel ISTEXT function in excel Random formula in excel Random function in excel Randbetween formula in excel Randbetween function in excel Choose formula in excel Choose function in excel MATCH formula in excel MATCH function inexcel TRUE formula in excel TRUE function in excel ISNUMBER function in excel ISNUMBER in formula in excel INDEX formula in excel INDEX function in excel Paste Special in Excel Paste Special in ms Excel IFERROR Formula in excel IFERROR Function in excel LEN formula in excel Substitute formula in excel SUMPRODUCT formula in excel LEN function in excel Substitute function in excel SUMPRODUCT function in excel LEN formula in ms excel Substitute formula in ms excel SUMPRODUCT formula in ms excel LEN function in ms excel Substitute function in ms excel SUMPRODUCT function in ms excel count formula in excel count function in ms excel excel excel shorts excel tutoring excel formula ms excel vlookup in excel excel formula for job interview ms excel number format excel tricks developer excel excel tips and tricks data entry sparklines in excel data entry work in excel excel data entry work in hindi excel shortcuts and tricks excel for fresher excel shortcut keys hlookup in excel ms excel full course in hindi paste special in excel advanced excel formula freeze in excel ms excel shorts advance excel excel formula hacks excel tutorial excel vlookup print titles in excel short excel conditional formatting in excxel countif formula in excel data entry interview questions data tab drop down list in excel excel formulas excel shortcut excel tricks and tips excel vlookup formula excel tricks and tips shorts excel vlookup formula excel world format painter in excel google sheet index formula in excel learn more pivot table excel in hindi shortcut key for excel use of excel in computer computer class vlook up vlookup vlookup formula in excel xlookup in excel advanced excel advanced excel course advanced excel full course advanced excel jobs advanced filter excel basic computer computer excel computer knowledge computer shortcut keys computer xl work concatenate excel data clearing data entry operator ky hota hai data manipulation data representation data tab in excel data table data validation in excel data visualization in excel excel all formulas and functions in hindi excel border formatting excel calendar 2022 excel chart excel column formatting excel count excel data model excel formula number excel formulas and functions excel full playlist in hindi excel function excel header and footer excel hlookup excel in English excel keyboard shortcuts excel me home tab excel multiply formula excel paste special excel print page setup excel series number tricks excel short video excel shortcut keys in mobile excel shortcuts excel sum formula excel sumif formula excel video exel flash fill flash fill in excel forecast in excel freeze panes in excel column and row google sheets tutorial how to calculate time in excel Microsoft excel microsoft office word ms excel formula ms excel full course ms excel eme marksheet banana ms excel tricks pivot pivot table excel data entry work excel full course in hindi excel me salary sheet kaise banaya excel me table kaise banaye excel row and column functions excel test for job interview 2022 excel working excel world hindi
Join 300,000+ professionals in our courses: 🤍 In this video I'll share my Excel Pivot Table pro tips to make the best use of Pivot Tables in Microsoft Excel. You'll discover hidden productivity tips as well as pivot table hidden tricks for example using a hidden pivot table so you can use Slicers on formulas as well. There is a lot of Excel tips and tricks that many Excel experts don't know yet. 00:00 10 Best Pro Tipps for Pivot Tables in Excel 00:23 No 1: Fast PivotTable 01:06 No 2: Adjust Field Settings 01:59 No 3: Timeline slicer 03:17 No 4: Pivot Table Without Using a PivotTable 🤔 04:56 No 5: Top N Analysis 06:36 No 6: Type Over Sorting 07:12 No 7: Repeating VS Centering Labels 08:15 No 8: Custom Sorting Pivot Table Fields 08:54 No 9: Easy %-Change Calculations in Pivot Tables 10:31 No 10: Disable Double-Click for Details 🌍 My Online Courses ► 🤍 ⬇️ Download the file I use in the video from here: 🤍 🎬 LINKS to related videos: Excel Pivot Tables EXPLAINED in 10 Minutes: 🤍 Advanced Pivot Table Techniques: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 🎥 RESOURCES I recommend: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 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 #pivottable
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too. *Consider supporting Technology for Teachers and Students on Patreon*: 🤍 Consider saying "Thanks" by clicking the Thanks button below the video. If you like this video, here's my entire playlist of Excel tutorials: 🤍 Click below for more information about some of the movies mentioned in this tutorial: Dirty Rotten Scoundrels: 🤍 Ladyhawke: 🤍 Stardust: 🤍 Young Sherlock Holmes: 🤍