Одну секунду
Что-то сучилось. Попробуйте еще раз.
Chandoo.org смотреть последние обновления за сегодня на .
Are you new to Excel and not sure where to begin or how to know all the basics in one place? You have come to the right place. In this concise yet in-depth video, learn: 1) What is Excel and how to use it? 2) How to enter and format data in Excel? 3) Understanding Excel's ribbon UI 4) How to set up filters & sort data? 5) How to add totals or averages with formulas? 6) How to create a chart from your data 7) How to highlight values below a certain number, automatically? 8) Example file & homework problems for you Video topics & timestamps ⏱👉 0:00 - Introduction to Excel (Tanvi's tracking troubles) 1:15 - Starting Excel 1:38 - Understanding the Excel Screen (ribbon, formula bar, grid and status bar) 4:09 - Setting up the sales tracker 7:35 - Exploring Excel Ribbons 8:21 - Formatting the data so it looks nice 11:37 - Using filters to understand data (which customers paid by cash)? 13:05 - Formatting currency values 13:57 - Sorting data so highest amount shows on top 15:46 - Writing formulas to add up values 21:01 - Clearing away things in your spreadsheet 21:29 - Calculating average of values with formulas 22:39 - Visually representing data with Excel charts 24:08 - Formatting and adjusting Excel charts 27:27 - Special charting tip: Showing just selected data in the graph 28:26 - Highlighting values that are below 1200 (conditional formatting) 29:57 - Homework problems & closing remarks Sample file 📗👇 = You can download the sample file for this course from here: 🤍 FREE Excel Tips Book 📖💥 = Download your copy of 50 Excel Tips book from here - 🤍 Learn more 💻⏩ = Now that you finished the basic Excel course, here are the next learning stops for you. 1️⃣ Beginner to PRO Data Analysis course - 45 minute video - 🤍 2️⃣ Create your first pivot table and 7 more in 10 minutes - 🤍 3️⃣ How to use Excel's cell references to write better formulas - 🤍 4️⃣ Excel Basic Skills - Article - 🤍 5️⃣ Complete Excel Course (Paid program by me) - 🤍 Happy learning 🌼🌞😀 #ExcelCourse
Excel has 400+ FUNCTIONS, and most of these are a WASTE of time. If you want to get good with Excel in a short time, focus on these 10 instead. Once you know how to use and combine them, you can learn more. So, what are the 10? SUMIFS XLOOKUP FILTER COUNTIFS INDEX EDATE UNIQUE TEXTJOIN SORT IFERROR Let's dive in. ⏱ VIDEO TOPICS: = 0:00 - Most Excel functions are useless 0:42 - Number 1 function - SUMIFS 1:52 - XLOOKUP function 2:40 - How to get multiple values with lookup? (FILTER function) 3:43 - COUNTIFS Function 5:49 - INDEX Function 6:40 - The most important function 6:57 - EDATE Function 7:50 - TEXTJOIN Function 8:25 - Using TEXTJOIN in a FUN way 9:07 - UNIQUE Function 9:57 - SORT Function 11:05 - IFERROR Function 11:52 - What if you don't like FUNCTIONS? 📁 SAMPLE FILE Refer to this page for more on this topic + free example workbook to practice - 🤍 💡 LEARN MORE ▶ Pivot Tables for Data Analysis with 8 quick examples - 🤍 ▶ Power Query & Data Cleansing for Beginners (10 examples) - 🤍 ▶ Power Pivot for Beginners (20+ examples) - 🤍 ▶ Only 15 Functions you need - 🤍 🧰 Specific Functions: ▶ XLOOKUP - 🤍 ▶ FILTER - 🤍 ▶ SUMIFS - 🤍 ▶ INDEX - 🤍 ▶ DATE formulas - 🤍 ▶ Dynamic Array functions - 🤍 👩💻 Courses: If you want to learn more than these 10, consider my Excel School program. This comprehensive course can help you navigate Excel data analysis situations with ease and grace. You will learn how to use and combine various Excel functions to solve work problems quickly. You will also learn how to apply pivot tables, charts, power query and dashboards to elevate your performance. Check out Excel School and join here - 🤍 ~ What does A1 say to SUM()? You add value to me 😍 #excel
You asked for it. Here is my free course to help you kick start your data analytics journey. In this comprehensive video, learn: 1) How to approach a data analysis project 2) A real-world example data with 10 problems 3) Step by step walk thru 4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count) 5) Exploratory data analysis in Excel 6) Analysis with formulas vs. pivots (necessary techniques) 7) Top / bottom performing items 8) Anomaly detection 9) Best in class analysis 10) Complete report preparation 11) Combining data in different tables (spreadsheets) 12) Answering open ended questions 13) Preparing and using Excel charts 14) Challenges & homework assignment You will also learn below Excel features: 1) Using Tables 2) Formulas 3) Pivot Tables & Power Pivot measures 4) Conditional formatting 5) Charts 6) Data Validation 7) Keyboard Shortcuts & tricks ⏱ Video Timestamps: 0:00 - Introduction 2:12 - Descriptive statistics in Excel 8:05 - Exploratory Data Analysis (EDA) with conditional formatting 13:20 - Sales by Country report with formulas 19:01 - Sales by Country report with Pivots 23:43 - Top 5 products with $ per unit 27:13 - Anomaly detection in your data 31:24 - Best in category analysis 33:36 - Profit analysis (combining two tables) 37:26 - Dynamic country level sales report 41:55 - Which products to discontinue (Open ended questions) 💥📁 Sample files: Blank data file (perfect for following along) - 🤍 Completed workbook - 🤍 ⛔⚠ Got an ERROR - Can't Change Array? Here is the fix - 🤍 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: 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
Learn how to develop VBA code to solve practical problems in this Masterclass. Code samples will be provided. 📁 Sample file (from the stream): 🤍 Timestamps: = 0:00 - Welcome message & hellos (skip this if you want) 12:00 - What is covered in this video (VBA intro, practical example, VBA vs. Python vs. Office Scripts) 16:20 - Introduction to VBA - What is it and when / where to use it? 26:54 - Using "Macro Recorder" and creating your first VBA macro - simple example 33:50 - Understanding the recorded macro 37:52 - Customizing the recorded macro by adding your own code 39:45 - Adding a button to run the macro 41:40 - Adding the macro to Excel ribbon 50:04 - ChatGPT and VBA... my thoughts 53:06 - VBA Object model - explained 57:55 - Creating a simple "TO DO List" App with VBA 1:12:40 - IF condition in VBA 1:15:03 - Adding time stamp (with variables in VBA) 1:20:35 - Showing a message with msgbox() 1:32:38 - Highlighting done activities (with conditional formatting) 1:33:46 - Python vs. Excel 1:39:30 - Highlighting done activities (with VBA) 1:42:30 - Writing a loop in VBA (For Each) 1:51:00 - Discussion about VBA vs. other technologies, Q&A and random musings (watch if you have time) #vba #excel ~ sub LikeAndShare() debug.print("Like and share this video. Thank you 🙏") end sub
Learn the most important Excel functions and how to use them for business data analysis. Formulas & Techniques covered in this video: SUMIFS COUNTIFS AVERAGEIFS XLOOKUP MAXIFS INDEX + MATCH FILTER MAX LARGE ~ How and when to use each formula Working with wildcards & patterns Using date ranges in your criteria Multiple criteria with formulas How to combine formulas to solve a problem Download the Sample Workbooks: ✅ Completed Workbook: 🤍 🟩 Blank Workbook (to practice): 🤍 ⏱Topics in the video:👇 = 0:00 - Introduction to the data & 15 Formulas 1:20 - Q1 Total Downloads of SugarRush App (SUMIFS) 3:17 - Q2 Total downloads for C apps (wildcards) 5:04 - Q3 Uninstalls in December 2021 (Using Dates) 7:00 - Q4 Downloads in Oct, Nov, Dec 2021 (Date Ranges) 9:21 - Q5 How many times we had more than 8000 downloads per app month? (COUNTIFS) 10:52 - Q6 5 star rating % for Sugar Rush (Complex Problem) 12:31 - Q7 Average uninstalls for Subway Wafers (AVERAGEIFS) 13:10 - Q8 Which month has highest uninstall ratio? (MAX & XLOOKUP) 16:23 - Q9 Average monthly downloads (AVERAGEIFS) 17:06 - Q10 Most downloads in any month / app? 2nd and 3rd places also? (MAX, LARGE) 18:18 - Q11 Which month and app was that? (XLOOKUP, INDEX+MATCH) 20:02 - Q12 In October 2021, which app has most 1star ratings? (XLOOKUP vs. FILTER) 23:35 - Q13 Does it change by December 2021? (XLOOKUP vs. FILTER) 24:50 - Q14 What are the best download figures for each app? (MAXIFS) 26:00 - What is the least downloaded app in each month? (FILTER) 28:03 - How to learn more? 👋 ALTERNATIVE FORMULAS FOR OLDER EXCEL VERSIONS: XLOOKUP alternative = Use INDEX MATCH. Instead of =XLOOKUP(F61,F53:F59,C53:C59) use = INDEX(C53:C59, MATCH(F61, F53:F59,0)) MAXIFS alternative = Use MAX(IF()) Array formula. Instead of =MAXIFS(data[Downloads],data[App],C99) Use =MAX(IF(data[App] = C99, data[Downloads])) and press CTRL+Shift+Enter to get the correct result. NEXT STEPS FOR YOU 👌 💥💥💥 Do you want to learn how & when to use various Excel formulas, how they compare with other ways of analysing data in Excel? Consider going for Excel School program. In this online class, I teach how to use Excel and how to do your work better. Visit 🤍 for full info & to enrol. 💥💥💥 Additional videos on the formulas: = IF formula & Advanced IF formulas - 🤍 SUMIFS formula (10 examples) - 🤍 INDEX MATCH in detail - 🤍 XLOOKUP - 🤍 VLOOKUP - 🤍 FILTER - 🤍 ~ Don't forget to be AWESOME 😎 #Excel #DataAnalysis
You don't need a guitar to make your data sing 🎶🎵 You just need XLOOKUP. In this video, I present 10 advanced tricks to master the XLOOKUP function. Dive in and thank me later :) ~ In this video: 0:00 - XLOOKUP Rockstar - 10 advanced examples 0:50 - Setting up data in a table format 1:15 - XLOOKUP Syntax and basic usage (TRICK 0) 2:30 - Get all columns of data with XLOOKUP (Trick 1) 3:35 - Get all columns, but vertically (Trick 2) 4:18 - Lookup values that begins with (wild card match, Trick 3) 5:42 - Equal to or higher than lookup (Trick 4) 7:02 - Multiple conditions with XLOOKUP (Trick 5) 9:44 - Lookup between two dates (Trick 6) 11:52 - Lookup highest value (Trick 7) 14:34 - Advanced Lookup of highest value (Trick 8) 15:38 - Second matching value (Trick 9) 18:13 - Get all matching values with XLOOKUP (Trick 10) 18:44 - Bonus: XLOOKUP but get two different columns. 20:21 - Other important Excel functions for your success 📂 Download the sample file to practice: = Get the sample file and practice these 10 tricks today: 🤍 Even more examples here: 🤍 📺 Watch next: = Advanced Excel Functions - Play List 🤍 Top 10 Excel Functions for Data Analysis 🤍 Top 10 Excel Functions for Finance People 🤍 Top 10 Excel Functions for Data Cleaning 🤍 Top 10 Advanced Examples of SUMIFS 🤍 How to use XLOOKUP 🤍 How to use FILTER 🤍 How to use VLOOKUP 🤍 How to use IF formula 🤍 📚 FULL Excel Course I run a complete Excel course to make you a rockstar at work. Please check out the program herE: 🤍 ~ Why can't we add guitars? 🎸+ 🎸 Because they are STRING instruments. 😂 #vlookup #xlookup
At awesome chocolates, we have a boss who is not so good with Excel. So, the other day, I caught him doing this... and I had to show him a better option. ⏱ In this video: = 0:00 - He was adding blanks rows like this 0:32 - He was adding tracking numbers like this 1:26 - He was getting "dates" like this 2:07 - He was checking duplicates like this 2:45 - He was comparing two lists like this 3:26 - He was doing something UNBELIEVABLE 3:38 - He was setting up monthly sheets like this 4:28 - He was checking values like this 5:27 - He was making pivots like this 6:10 - He was adjusting charts like this 6:54 - He was combining data like this 😎 Be a BOSS with Excel with these videos = Don't be silly. Up your Excel game and impress the boss today. Check out these quick videos and learn something new. Combine sheets with this trick - 🤍 Combine files with this trick - 🤍 Combine tables with this trick - 🤍 10 Copy Paste tricks in Excel - 🤍 10 Data Cleaning tricks in Excel - 🤍 10 Formatting tricks in Excel - 🤍 Want more? Why not join my Excel School program? As the REDBULL says, it will give you WINGS!!! Soar here - 🤍 ~ CONNECT WITH ME 🔗 📺 2nd channel (in Telugu) - 🤍 📷 Instagram (for tips & behind scenes) - 🤍 🐥 Twitter (fresh updates) - 🤍 🌐 Website (1000+ articles, files) - 🤍 💡 Classes - 🤍 ~ No, I don't really have an identical twin as my boss. I am my own boss as I work for myself. Also, Jo is my boss as I married her. #BosswithExcel
💥 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() 🤣
💥Check out Connecteam 👉 🤍 ~ Do you run your own business? Then you need these 4 Excel Skills to SAVE TIME and do things IN STYLE. These are, 1) Setting up Tables 2) Using with Templates 3) Working with your Data 4) Using Pivots ⏱ Video topics: 0:00 - 4 Essential Excel Skills for Every Entrepreneur 1:04 - Setting up a check list with Excel 3:53 - Using built-in templates to save time 5:25 - Making your OWN templates in Excel 6:07 - Filtering data you need 7:40 - Basic Excel formulas 8:57 - Work faster with Connecteam 10:00 - Using Pivot Reports to answer business questions. 12:08 - But what if Dwight wants a bit more? ~ LEARN MORE 💥 CONNECTEAM for Managing your Small Business - 🤍 Top 10 Excel formulas - 🤍 Top 8 Excel Pivots - 🤍 How to use Excel in 30 minutes - 🤍 Create a beautiful tracker with Excel - 🤍 Create a project plan with Excel - 🤍 Full Excel Course - 🤍 ~ Have a beautiful day 🌞🌼😀
Do you need to learn Excel Quickly? May be you have a job interview or need to transition to a role where Excel skills are mandatory. In this video, I share 8 tactics & mindset that worked REALLY well for me when I had to learn Excel / Power BI and other technical tools. The tactics: 💡 1) Pick "a" problem 2) Go W I D E before going DEEP 3) Connect the dots 4) Play to learn 5) Stop nit-picking 6) Share what you learn 7) Reflect & Revise 8) Knockout the H 9) Bonus: Go for a course Timestamps: ⏱ = 0:00 - Pick a problem (1) 1:19 - Go wide before going deep (2) 2:54 - Connecting the dots (3) 3:45 - Having a play with Excel (4) 4:54 - Stop worrying about small details (5) 5:39 - Share what you learn (6) 7:17 - Reflect and Revise (7) 8:35 - Knockout the H (8) 9:07 - Join a course Playlists & videos for learning Excel: 📚 FREE beginner Excel Course - 🤍 Top 10 Excel Formulas - 🤍 FREE Data Analysis Course - 🤍 Getting started with Pivot Tables - 🤍 🔥🔥🔥 Excel School online classes - 🤍 Happy Learning 🌼🌞😀 #ExcelTips #learnexcel
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
That is right! I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video, let me show you what Power Pivot is and how to use it with Excel. Plus, you get to meet Chan2 again 😂 ⏱ VIDEO TOPICS: = 0:00 - What is Power Pivot and how to create one in Excel? 1:12 - Why use Power Pivot instead of regular Pivot Tables? 3:25 - Practical example of Power Pivot & DAX 📺 LEARN MORE ABOUT POWER PIVOT & DAX: = Beginner to PRO DAX Lesson with 20+ examples - 🤍 How to write measures in Excel (another example) - 🤍 My Power Pivot playlist - 🤍 Advanced Pivot Table tips & tricks playlist - 🤍 👩💻 LEARN MORE ABOUT REGULAR PIVOT TABLES: Introduction to Pivot Tables - Complete Tutorial - 🤍 Introduction to Pivot Tables with 8 examples - 🤍 Pivot Table mistakes you shouldn't make - 🤍 6 Pivot Table Tricks to Impress Everyone - 🤍 Creating Pivot Tables when you have lots of data - 🤍 How to use Slicers in Excel - 🤍 📁 SAMPLE FILE: = Here is an Excel workbook with data for you to practice Power Pivot concepts - 🤍 ~ I made a pivot with average sales per day. It was a mean report 😂 ~ #pivottables #excel
Do you know that we can automatically calculate the critical path of a project using Excel formulas? In this video, let me explain the theory and calculation logic for figuring out the CRITICAL PATH using Excel. Bring your hardhats, it's going to be MINDBLOWINGLY AWESOME!!! For a free Critical Path template & more explanation, visit 👇 🤍 ~ ⏱In this video 0:00 - What is Critical Path and why it is relevant in Project Management? 1:00 - Demo of Critical Path calculator workbook 1:42 - What is Critical Path Analysis and how to do it? (with a demo) 5:46 - Slack / Float explained. 6:10 - Forward vs. Backward Pass explained. 7:09 - Critical Path Calculations in Excel 8:36 - Formulas for Earliest Start (ES) and Earliest Finish (EF) 11:00 - Formulas for Latest Start (LS) and Latest Finish (LF) 12:08 - Calculating Float (Slack) per activity and what it means? 13:38 - Using Excel for other Project Management Stuff 📁 Critical Path Calculator Workbook = For a free Critical Path template & more explanation, visit 👇 🤍 📺 More on Project Management using Excel = Gantt chart with Excel 🤍 Project Dashboard with Excel 🤍 Team calendar with Excel 🤍 To-do list with Excel 🤍 Ready to use Excel Project Management Templates 🤍 ~ #projectmanagement #criticalpath
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
SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks. You will learn: ◈ How to use SELECT statement to answer business questions ◈ Working with WHERE clause ◈ Using AND, OR, NOT and combining them to create complex queries. ◈ Sorting query results using ORDER BY ◈ Combining data from two or more tables using JOINS ◈ Creating reports with GROUP BY ◈ More than 50 example queries, tips and ideas 🚨 PRE-REQUISITES: You need any SQL console (I am using the FREE MySQL Community Edition and you can download it from 🤍 ) You also need the Awesome Chocolates Dataset. See 🤍 for the sample files, instructions on data import and other SQL resources for you. 😃 Basic intro: If you want a simple introduction to SQL (for an interview or to brush up), see this video instead - 🤍 ⏱ IN THE VIDEO: 0:00 - Introduction 0:43 - Data setup, explanation & basic queries 6:24 - Adding calculated columns in SELECT 8:39 - Our first WHERE clause 10:28 - Ordering query results with ORDER BY 13:24 - More Where clause examples 16:42 - Between conditions 19:06 - Working with Dates 21:50 - Using other tables 23:47 - IN clause 24:36 - Pattern matching in SQL 26:30 - CASE operator and branching logic 30:30 - JOINS 36:32 - LEFT Join vs. RIGHT Join ~ EXPLAINED 38:28 - More Join examples 42:10 - Adding conditions to Joins 47:30 - GROUP BY and creating reports with SQL 54:50 - Showing Top 10 Products by Amount 57:12 - Closing remarks & next steps for you 📚 RESOURCES TO LEARN MORE SQL: 1) Practice the problems and scenarios discussed in the video with the awesome chocolates dataset. 2) Solve homework problems listed here - 🤍 3) Get one or two SQL books. My recommendations are here - 🤍 4) Consider going for an SQL course. Check the same page for my course suggestions. 5) PRACTICE, PRACTICE, PRACTICE! 🙄SQL ALTERNATIVES: If you don't want to learn SQL but still wish to work with data, then consider learning POWER QUERY, which offers similar capabilities as SQL. See this video 👉🤍 😎WATCH NEXT: Now that you know a bit of SQL, why not use it with Power BI to do visual data analysis? If you are new to Power BI, see my Power BI video to get started with that. 👇 🤍 ~ 😍FOLLLOW ME Apart from YouTube, I regularly share content on below places. Feel free to check them out and give a follow. 💻 WEBSITE - 🤍 📃 WEEKLY DATA TIPS NEWSLETTER - 🤍 📷 INSTAGRAM - 🤍 🐤 TWITTER - 🤍 ~ Select "good day" from days where person = "you" 😃 #sql #tutorial
Make your Power BI reports engaging and binge-worthy with these 5 simple but effective rules. 1) Design charts for readability 2) Write better titles 3) Formatting each chart for the message 4) Use card tricks 5) Create a wireframe ⏱ Video Timestamps: = 0:00 - "Before" & "After" Power BI Reports - Quick demo 0:19 - Rule #1 - Design charts for readability 1:43 - Rule #2 - Write better titles 3:00 - Rule #3 - Formatting each chart for the message 4:10 - Rule #4 - Card tricks to improve your dashboards 6:04 - Rule #5 - Layouts and Wireframes for your Power BI Reports 6:55 - Creating wireframes using Power Point 👩💻 Want to try this? Use the blank Power BI workbook to apply the concepts. 🤍 💡 Learn More Power BI: Getting Started with Power BI in 10 minutes 🤍 Power BI Beginner to PRO Masterclass 🤍 How to use Power Query in 15 minutes 🤍 How to write DAX / Power Pivot Measures 🤍 How to set up tooltips with Power BI 🤍 Power BI Terminology Explained 🤍 Data Modelling + Star Schema Explained 🤍 Power BI Visuals - When to use each of them? 🤍 + Full Power BI Course with 6 projects 🤍 ~ #powerbi #dashboard ~
DAX (Data Analysis Expressions) is the language used by Power Pivot (and Power BI) to build calculations and to analyze data. If you want to be good in Power BI, then you must learn DAX. In this comprehensive video, learn how to get started and use DAX for many practical scenarios with 20+ examples. What is covered? 1️⃣ What is DAX & Power Pivot? 2️⃣ How to create and edit measures in Power BI? 3️⃣ Evaluation Context explained 4️⃣ Customizing the DAX measure display settings 5️⃣ Reusing DAX measures to build complex calculations 6️⃣ How to use CALCULATE() to change the "FILTER" criteria 7️⃣ DAX Measures vs. Columns 8️⃣ Using Variables in DAX 9️⃣ OR conditions, IN operator in DAX 🔟 DAX tips & guidance to improve your skills SAMPLE WORKBOOKS 📂 = Blank Power BI File (with data model) to follow along - 🤍 Completed Power BI File (with 20 DAX examples) - 🤍 Raw Data file (Excel workbook) - 🤍 ⏱ Video Topics 👇 0:00 - What is DAX & Power Pivot? 2:10 - Our first DAX measure 4:46 - Understanding the Power Pivot Calculation Engine & Evaluation Context 7:10 - Formatting the DAX measures 11:32 - Reusability of DAX measures 18:29 - IF Condition in DAX 25:27 - DISTINCTCOUNT in DAX 31:05 - MIN / MAX / AVERAGE 31:42 - CALCULATE in DAX 41:11 - Adding columns with DAX 45:03 - Alternate syntax for CALCULATE() 46:10 - Variables in DAX 48:36 - OR Conditions in DAX (with CALCULATE) 49:45 - 20 DAX measures (recap) 51:48 - How to learn more DAX? LEARN MORE about DAX 💻💡 My Power BI Course - 🤍 BOOK RECOMMENDATIONS 📚 Supercharge Power BI with DAX by Matt Allington - 🤍 Definitive Guide to DAX by Marco Russo & Alberto Ferrari - 🤍 More videos on Power BI & DAX 📺 = Introduction to Power BI (45 minutes, 100k+ views) - 🤍 Introduction to Power Query (80 minutes, 240k+ views) - 🤍 Another video on DAX (live stream, 50k+ views) - 🤍 My Power BI Videos (playlist) - 🤍 ~ What song do Data Analysts dance for? DAX the way... aha aha I Iike it... aha aha 😂 #PowerBI #dax
Ever want to VLOOKUP but show multiple matching results? The standard Excel VLOOKUP formula has a limitation and it will only show the first matching result. But what if you need to see all matches in one place? In this video, let me present you a simple formula to get all matches in a list format. Sample file here - 🤍 More on VLOOKUP & Other functions (My Skillshare course): Check out the Skillshare course on "Excel LOOKUPS for data analysis" and master these functions in just one hour. Here is your sign up link - 🤍 Learn more about FILTER function: FILTER function basics and beyond - 🤍 Other ways to get multiple results with VLOOKUP: 🤍 Excel VLOOKUP basics: 🤍 XLOOKUP basics: 🤍 Thank you for watching & reading. Have a beautiful day 😀🌞🌼 #VLOOKUP
Power Query (Get & Transform data in Excel) is a true game changer 💥. It can simplify and automate various data activities. In this in-depth video tutorial, learn all about this powerful time-saving technology. You will learn: * What is Power Query and how to launch it from Excel or Power BI? * How to connect and load data from any type of sources - excel files, CSVs, text files, web pages, PDF, folders etc. * How to perform common data cleansing activities with Power Query * Adding columns using rules * Automating data collection, clean-up and publishing processes with Power Query * Web scraping with Power Query * SQL style Joins, merges, appends and unions with Power Query * Consolidating data in a folder * Data load, save & publish process * Tips & tricks on using Power Query efficiently For sample datasets, completed workbook and mind-map PDF, visit: = 🤍 Timestamps: 0:00 - Introduction to Power Query 3:34 - Power Query as a mind-map 24:10 - Example 1 - Employee data load, clean-up and analysis 47:09 - Example 2 - Web scraping with Power Query 58:48 - Example 3 - Consolidating a folder of files with Power Query 1:09:08 - Example 4 - Merging, joining and appending datasets with Power Query 1:22:43 - Closing remarks - how to learn more, books & website recommendations Recommended book: Combine, collect & transform data with Power Query by Gil Raviv - 🤍 Recommended course: Excel School program - data cleansing, analysis and visualization course by Chandoo - 🤍 #PowerQuery #Excel #PowerBI
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
Some really awesome Power Query tips and questions from our viewers. 📁 Sample data file: 🤍 #powerquery #excel #powerbi Thumbnail credit: original poster from How I met your mother show, altered with AI
Power BI is the most popular and in-demand "DATA" skill these days. In this succinct and practical video, let me show you how to get started and use Power BI to create an impressive business report, all in 10 minutes! Ready? Set your clocks and GO!!! 📗 Data file: Use this sample data file to practice the concepts covered in the video. 🤍 ✅ Completed workbook: Download this if you need to cross-check or refer 🤍 ⌚Video chapters: = 0:00 - What is Power BI and how to download it? 1:09 - Sample data file & loading it 2:22 - Power BI Desktop screen explained 3:24 - Making our first chart in Power BI and customizing it 5:05 - Adding another chart & seeing the "interactions" 6:52 - Seeing the trends with line charts (and working with hierarchies) 8:24 - Using "AI" insights in Power BI! 9:28 - Saving and publishing your work 10:37 - Learning more about Power BI (2 resources for you) 📚 Power BI Resources for you = 📺 VIDEOS Power BI Deep dive - 45-minute video (150k+ views) - 🤍 Make a sales dashboard in one hour - Live stream replay (90k+ views) - 🤍 Excel vs. Power BI - what is the difference? (150k+ views)- 🤍 🎶 PLAY LIST Power BI Playlist - 🤍 👩💻 COURSES Power BI Playdate by Chandoo - 🤍 📙 BOOKS My recommendations for Power BI books - 🤍 📰 ARTICLES Introduction to Power BI with practical tutorial, examples and demos - 🤍 ~ CONNECT WITH ME 🔗 📺 2nd channel (in Telugu) - 🤍 📷 Instagram (for tips & behind scenes) - 🤍 🐥 Twitter (fresh updates) - 🤍 🌐 Website (1000+ articles, files) - 🤍 ~ May the power ⚡be with you 😀 #powerbi
For the last 15 years, I have been using my Excel + data skills to make a living. In this video, let me share 6 of the most effective and proven tactics to make money using your Excel or data skills with clear examples and action items. I have been using these exact tactics to make over $100k+ for the last 15 years. These 6 tactics are: 1) Freelancing 2) Consulting 3) Excel products 4) Teaching Excel 5) Writing about Excel 6) Website or Blog 🧰 Resources & Links for you For FREELANCING: Upwork - 🤍 Fiverr - 🤍 For BUSINESS CONSULTING: Upwork - 🤍 LinkedIn - 🤍 Set up YOUR WEBSITE: I recommend using SquareSpace as the process is easy and straightforward. Visit 🤍 to create your website with them. Alternatively, you can also use Bluehost - 🤍 Set up your ONLINE STORE: You can use your own website for this. I recommend using SquareSpace or Bluehost to make the website and adding a shopping cart module for best results. Visit 🤍 or 🤍 Alternatively, you can also use services like Shopify - 🤍 Teach EXCEL CLASSES: I suggest creating your class thru teachable. This takes away the hassle of classroom LMS and let's you focus on the course. Visit 🤍 to create your first course with them. Alternatively, you can also create courses thru udemy, skillshare or on your website. How to CREATE VIDEOS: I use Camtasia from Techsmith to make and edit all my videos. It is the best and most powerful software for doing this sort of thing. Visit 🤍 to purchase Camtasia. Other TECHNOLOGY GEAR: My recommendations for camera, mic, hardware and other stuff can be found on my Amazon page here - 🤍 Note: I use affiliate links for some of the resources mentioned here. I receive a small commission if you purchase the service or product. More on Freelancing with Excel = Watch my "how I made $100k freelancing with Excel" for some tips & ideas: 🤍 ~ In the video ⏱ 0:00 - Introduction to the 6 ways 0:45 - One: Freelancing 4:39 - Two: Business Consulting 6:57 - Three: Excel Products 10:08 - Four: Teaching Excel 13:43 - Five: Writing about Excel 15:10 - Six: Websites & Blogs 16:56 - How to get the clients? ~ I wish you all the best in your journey. 🌞🌼😀
I have been freelancing in the Excel & data analysis field since late 2008. In this video, I share 4 stories from my freelancing journey and give you 4 practical tips to be a successful freelancer in the data space. 🧰 RESOURCES FOR FREELANCERS Check out this page for a list of resources, tips & ideas for freelancers - 🤍 Upwork: 🤍 Fiverr: 🤍 PS: I am using affiliate links for upwork & fiverr. 📘 FREE EXCEL TIPS BOOK Get my free excel tips book when you join the weekly newsletter - 🤍 ~ ⏱ Video topics 👇 = 0:00 - My freelance earnings report 2:30 - My freelance origin story 3:31 - The hourly rate problem 5:20 - Staring again (when I moved to NZ) 7:02 - How I became a HR Specialist 8:46: 4 Tips for Freelancers 9:48 - Figure out your TRUE hourly rate 11:35 - Get paid to LEARN 13:13 - How to get higher rates? 😎 Watch next = 8 Strategies I used to become REALLY good in Excel - 🤍 5 Skills to be a GREAT data analyst - 🤍 Excel vs. Power BI - What to learn - 🤍 Top 5 skills to focus on to become a better data analyst in 2022 - 🤍 How I make videos - 🤍 Like this topic 🤔? = Let me know in the comments if you want me talk more about my freelancing experiences and share life hacks. 😎 SAY HELLO 👋 = Apart from YouTube, I frequently post on, my blog - 🤍 twitter - 🤍 Instagram - 🤍 ~ All the best with your freelancing journey 👍 #freelancing #excel
💥 Want more? Join my full Power BI course: 🤍 ~ Learn how to analyze HR (Human Resources) data and create stunning dashboards using Power BI with this complete masterclass. You are going to learn: ◈ Loading data into Power BI and cleaning it with Power Query ◈ Creating HR metrics like headcount, avg. leave balance, avg. salary etc. with Power Pivot ◈ Adding columns to the data (like Employee's first name, age group etc.) ◈ Finding relationships between salary and education qualification ◈ Using visual filters to see top / bottom paid staff in each job ◈ Customizing visuals in Power BI (changing colours, axis, labels and legend) ◈ Advanced DAX calculations like cumulative headcount, leave balance more than 20 days ◈ Designing a monthly HR dashboard with Power BI ◈ Working with "NEW" card visual in Power BI 📃 HR Data Analysis Themes: We are going to do these 10 things in the video. Use sample data to re-create the same. 1) How many people are in each job? 2) Gender break-down of the staff 3) Age spread of the staff 4) Which jobs pay more? 5) Top earners in each job 6) Qualification vs. Salary 7) Staff growth trend over time 8) Employee filter by starting letter 9) Leave balance analysis 10) Quick HR Dashboard 📁 Sample Dataset & Final Output: 💿Sample Data: 🤍 📊Final Output: 🤍 💥Want more? Join my full Power BI course: 🤍 ⏱ Video Topics: 0:00 - Introduction to HR Data Analysis with Power BI 0:50 - Loading HR data into Power BI and cleaning it 1:37 - How many people are in each job (Q1) 2:53 - Gender breakdown of the staff (Q2) 3:57 - Age spread of the staff - with histograms (Q3) 5:26 - Using Small Multiples to enhance your charts 6:11 - Which jobs pay more (Q4) 8:32 - Top earners in each job (Q5) 10:26 - Quick homework break... 11:11 - Qualification vs. Salary (Q6) 12:50 - Turning Qualification into number column 15:51 - Staff growth trend over time with DAX (Q7) 19:10 - Employee filter by first letter (Q8) 20:23 - Adding conditional formatting bars to Power BI tables 21:36 - Leave balance analysis (Q9) 23:55 - HR Dashboard using Power BI (Q10) 27:00 - Closing remarks and next steps 💡 MORE POWER BI VIDEOS = FULL Power BI, Power Query, Power Pivot Course 🤍 Getting started with Power BI in 10 minutes 🤍 Learn Power Query in 15 minutes 🤍 Full Power BI Lesson 🤍 How to use DAX & Power Pivot 🤍 5 Tips to make better Card Visuals 🤍 Excel vs. Power BI - Which is better? 🤍 Data modeling and Star Schema in Power BI 🤍 When and how to use various Power BI charts? 🤍 Power Query - Full Lesson 🤍 ~ #powerbi #humanresources #HRDataAnalytics ~ I have a hilarious HR joke. To hear it, you must make 3 copies of this form, sign it at the 16 marked places, get it notarized by a talking giraffe and bring it back before 4PM. Oh, you also need to stand on one leg while doing it.
If you have time to learn just one skill in 2023, make it POWER QUERY. This single technical skill can help you make massive gains in your data analysis work. 💥 Get my Power Query mini-course - 🤍 WHAT IS POWER QUERY? Power Query is a data pre-processing engine built into Excel and Power BI. You can use it to bring data from anywhere and do pre-processing or clean-up activities with ease. It lets you automate common data tasks like removing duplicates, combining files, merging (joining) datasets, adding derived columns, splitting or extracting data and changing the shape / size of your data. HOW TO GET POWER QUERY? It is already there in Excel and Power BI. In Excel - Go to DATA Ribbon and use the "Get & Transform Data" options. In Power BI - use the "Get data" or "Transform" buttons. IS POWER QUERY BETTER THAN SQL? Power Query and SQL have largely similar capabilities. But Power Query gives you more freedom and options. Plus, it is easier to learn (in my opinion). ~ IN THIS VIDEO ⏱️👇🏼 = 0:00 - One skill you should learn in 2023 - Power Query, what is it? 2:02 - How to activate & use Power Query? 4:43 - STEP 0: Pre-cleaning the data 6:31 - STEP 1: Dealing with Blank data points 7:48 - STEP 2: Removing the duplicates 8:30 - STEP 3: Generating ID values 11:05 - STEP 4: Calculating Course Date from Registration Date 13:25 - STEP 5: Figuring out the Fee Status 15:39 - How to load the cleaned data back to Excel? 16:19 - Analyzing the Power Query data and Refreshing 📂 DOWNLOAD PRACTICE FILES = Sample raw data file - 🤍 Completed workbook (with Power Query steps) - 🤍 💻 LEARN MORE about POWER QUERY Check out below videos, playlists & articles for more on Power Query. ▶ COURSES: ▶ ▶ Get my Power Query mini-course and learn all you need in one place quickly - 🤍 ▶ ▶ Join Excel School program to learn Power Query, Power Pivot, Formulas, charting & Dashboards in one place - 🤍 ▶ VIDEOS: ▶ ▶ Data cleaning in Excel - 10 tips (Power Query, Formulas & Flashfill) - 🤍 ▶ ▶ Power Query in Excel (Beginner to ADVANCED) - 🤍 ▶ ▶ How to combine data from files (using Power Query) - 🤍 ▶ PLAYLIST: My Power Query videos playlist - 🤍 ▶ READ: What is Power Query and how to use it (with 4 examples, sample files) - 🤍 ~ Happy learning. I wish you more POWER ⚡ in 2023 #PowerQuery #excel
There is a lot of hype around ChatGPT, but do you know that Excel has really powerful AI built-into it? YES!!! In this video, let me share of 5 of my favourite AI features (plus a bonus one) in Excel that really save time & make you more productive! Learn all about the AI features in Excel like Flash Fill, Column from examples (Power Query), AI automatic analysis of data, Recommendations, AI formula writer & Automatic forecast with real world examples. 0:00 - Forget ChatGPT 0:34 - Feature 1 - Flash Fill 🦸♂️ 2:19 - Feature 2 - Let Excel write the formulas 🧪 6:00 - Feature 3 - AI Automatic Analysis of Data 🤖 10:01 - Feature 4 - Recommendations in Excel 🆘 12:26 - Bonus - Formula writer in Excel ⌨ 15:03 - Feature 5 - Forecasting in Excel 📈📈📈 17:59 - More AI 😎 ~ 📂 Download Sample File Learn more about these concepts here 👉 🤍 Need to practice these concepts in Excel? Try with my sample data file here 👇 🤍 🚨 COMPATIBILITY While the AI features are exciting, they don't work in all versions of Excel. See below for compatibility information. Feature 1 - Flashfill - Excel 2013 or above, Excel 365 Feature 2 - Column from Examples - Excel 2106 or above, Excel 365 Feature 3 - AI Analysis of Data - Excel 365 Feature 4 - Recommendations - Excel 365, Excel 2016 (?) Feature 5 - Forecasting - Excel 2103 or above, Excel 365 Bonus feature - Formula Writer - Excel Online ~ 💻💡 LEARN MORE New to Excel and want to level up quick? Check out below curated playlists to upskill fast. Free Excel Crash Course - 🤍 Data Analysis with Excel - 🤍 30 Advanced Excel tips - 🤍 Essential Excel Keyboard Shortcuts - 🤍 FULL Excel Course - 🤍 ~ Why can't AI get a permanent driving license? 🚗 Because it is always learning 🤓🤣 #chatgpt #excel
ChatGPT can change the way you look at data and analyze it. Recently, I asked ChatGPT to help me build an Excel dashboard and the result was AMAZING. In this video I explain the process and show case the results. 💬 See the ChatGPT prompts & conversation here 👇 🤍 📂Sample Data Here is the sample data I used for this example. 🤍 ⏱ In this video = 0:00 - ChatGPT + Excel intro 0:30 - Asking ChatGPT how to analyze the data 2:16 - Sales by Quarter Pivot Table & Chart 4:34 - Making the dashboard "interactive" 6:30 - Creating "Top 10" instead of all 8:07 - Taking it to NEXT Level 🚀 🤖More AI with Data Videos Check out the AI + Data Playlist. - 🤍 If you have some topic suggestions on AI + Data, leave a comment. The ChatGPT Pivot Jokes 😂 = 1) Why did the pivot table join a gym? Because it wanted to stay in shape and keep its columns and rows well-toned! 2) How did the pivot table solve its problems? It simply pivoted them away! 3) Why did the pivot table bring a ladder to the party? Because it wanted to get a higher perspective on the data and rise above the rest! ~ #chatgpt #excel
Join me for a Live Masterclass on Power Query, Power Pivot & Power BI. We are going to look at a real-life dataset and analyze it using Power BI to answer 5 business questions. Sample data will be provided. 📁 Sample Data File: Grab the sample data file here 🤍 if you want to follow-along. ⏱ Video Topics: 0:00: Welcome, hellos & stream formalities 14:23: What we are going to learn (topics and quick demo) 23:34: Data load and EDA with Power Query 28:50: Power BI internal architecture and how it works 33:25: Data Cleansing and EDA in Power Query (contd.) 50:33: Writing measures with DAX and using Power Pivot 1:02:45: How to use Power BI themes to speed up your workflow 1:08:00: Creating maps in Power BI 1:14:30: Creating MEDIAN in Power BI DAX 1:16:30: Using visual filters 1:22:28: Using CALCULATE to get Apartment % 1:30:00: Average distance measure 1:32:00: Demo of the final workbook 1:34:40: Tricks to make your Power BI Tables BEAUTIFUL 💄 1:43:00: Q&A with lots of little Power BI / Power Query / Power Pivot tricks 📺 WATCH other Power BI videos 💥 My Power BI Course - Full length course on Power BI + Power Query + Power Pivot - 🤍 Power BI Playlist on my channel 🤍 Previous live streams and 1+hr videos 🤍 ~ #powerbi
Dashboards are a highly sought after skill in business analytics. In this comprehensive and detailed video, learn how to create a beautiful & functional business KPI (metric) dashboard using Microsoft Excel in less than 30 minutes. Prior skills needed: Basic familiarity with Excel (watch this tutorial: 🤍 ) How to create a pivot table (watch this tutorial: 🤍 ) How to create slicers (watch this tutorial: 🤍 ) 📁 Sample Files: Please download the blank data & outline file here: 🤍 💥 Download completed workbook: The full dashboard is now part of my Excel School Dashboards program. If you join the course, you will unlock this + 50 more Excel workbooks and 32+hours of videos on all things Excel. Visit 🤍 to sign up. 📈📊 More Videos on Dashboards: Project Dashboard with Excel - 🤍 Website Metrics Dashboard with Excel - 🤍 Beautiful Sales Dashboard with Excel - 🤍 HR Dashboard with Excel - 🤍 Dashboards Playlist - 🤍 ~ Video Timestamps: 0:00 - Introduction to the Dynamic Business Dashboard 1:07 - The Blank Data File & our data 1:52 - How to design the dashboard? 3:50 - Setting up the Pivot Tables & DAX 7:35 - Preparing the Dashboard 10:40 - Adding the Bar chart with Top 5 Products 15:01 - Adding the trends 19:22 - Sales Person Table Report 23:48 - Adding conditional formats 25:00 - Tidying up the formatting 26:46 - More things you can add ~ #excel #dashboard
Excel's IF() is one of the most used and fundamental functions. In this video, learn how to use IF function and 5 advanced tips. We are going to learn ✔ IF formula syntax ✔ Nested IF formulas ✔ IFS() function to replace nested if formulas ✔ AND conditions in IF formulas ✔ Choose function ✔ Index function ✔ Using IF with lookups For more advanced tips on IF, see this video - 🤍 📑Video topics⏱ = 0:00 - IF formula syntax and simple example 1:05 - Calculating GRADE using nested IF function 2:40 - Using IFS() function 3:46 - Checking for two or more conditions 4:45 - CHOOSE function 6:34 - BONUS trick - Using INDEX instead of CHOOSE 7:39 - Using IF with Lookups to switch between two tables 9:02 - Learning more about IF function 📗 Download Sample File & Practice 👇 = Visit 🤍 to download the example file for this video. 📺 WATCH NEXT😎 = If you want to learn more about Excel functions, do check out below useful videos. 1) IF formula with 10 advanced tips - 🤍 2) SUMIFS formula with 10 advanced tips - 🤍 3) Top 10 Excel functions for Data analysts - 🤍 4) 15 Essential formulas for everyone using Excel - 🤍 🤩 Excel formulas for Data Analysis - PLAYLIST - 🤍 Learn EXCEL step by step 💻 = If you want to learn all the essential bits of Excel in one handy place, please consider my Excel School program. This top-rated Excel course has been the secret of more than 20,000 people all over the world for their professional success. Visit 🤍 for enrolment. ~ Have a beautiful day 🌼🌞😀 #if #excel
Dirty data on your mind? Just spray the amazing "data cleaner" on it. In this video, learn how you can use 5 Excel features to clean data with 10 examples. You will learn about: 1) Flash Fill 2) Text to Columns 3) Remove Duplicates 4) Formulas 5) Power Query Video Topics ⏱👇 = 0:00 - Data Clean-up - the challenge 1:17 - Extracting the first name (Flash Fill) 2:10 - Get the city from location (Flash Fill) 3:12 - Get the city from location (Text to Columns) 4:20 - Splitting cost centre & ID number (Text to Columns) 5:35 - Duplicate Valvalues (Remove Duplicates) 6:33 - But there is a problem!!! 7:16 - Remove extra spaces from name (Formulas) 8:01 - Full time or Part time (Formulas) 8:49 - Power Query!!! 10:04 - Splitting Cost Centre & ID with Power Query 10:57 - Fixing inconsistent dates with Power Query 11:40 - Adding a Full / Part column with Power Query 12:30 - Bonus Example - Fixing or Removing incomplete data 13:50 - Loading Cleaned up data to Excel & Data Updates (Refresh) Download the sample file 🟩 = Here is a blank data file. Use it to practice these data clean-up tasks: 🤍 Watch next 💻👍 🧹10 Quick and Smart Data Cleaning Tricks - 🤍 👩💻 Detailed Video on Power Query - 🤍 🎶 Power Query Playlist - 🤍 🤷♂️ How to _ in Excel - Playlist - 🤍 ~ #Excel #powerquery May your data be clean and your days be serene 😀
💥 Check out Power BI Weekend'23 - 🤍 ~ Got a Power BI interview coming up. Make sure you know answers to these 10 questions. 0:00 - Top 10 Power BI Interview Questions 0:46 - Explain the difference between a measure and a calculated column. 2:05 - Describe the process of publishing a Power BI report to the service? 3:21 - How would you handle missing data? 5:30 - What is DAX and give us an example of recent DAX formula you've used? 7:22 - How do you connect multiple data sources to a Power BI Report? 8:12 - What are the main differences b/w Power BI Desktop and Power BI Service? 9:13 - How do you optimize the performance of a Power BI report? 12:09 - Explain RLS (Row Level Security) in Power BI and how do you implement it? 13:03 - What do the 1, * and arrow mean in the data model diagram? 14:47 - What is a Slowly Changing Dimension (SCD) and how do you handle it in Power BI? 16:52 - Power BI Weekend is happening again!!! ~ See the questions & answers here - 🤍 💻 LEARN Power BI: = 📆 POWER BI WEEKEND - 🤍 📚 Full length Power BI Course - 🤍 📺 Power BI Playlist on my channel - 🤍 ~ All the best with your interview. #Powerbi #interview
🚀 Free Excel & Power BI templates: 🤍 👉 Register for my workshop, "How to Build a Business Performance Excel Dashboard with ChatGPT": 🤍 ~ Join me for this amazing masterclass on how to create and present visuals for compelling story-telling for c-level audience. We are going to talk about 5 concepts and how to implement them using Microsoft Excel. Sample data files will be provided. The session will be for 60 minutes. Get the sample data file here - 🤍
Remove Duplicates in Excel - 15 Second Tutorials on using Microsoft Excel 🤍
Do you want to find out if there are any outliers in your data? You can use simple Excel formulas to calculate z-scores and identify the outliers. ~ To identify the outliers, we need to first calculate the z-scores of every data point. To do this, you need to calculate the average and standard deviation of the data first. Z-score of a data point is defined as (data point value - average)/standard deviation. Once all the z-scores are calculated, we then consider any data point with absolute z-score higher than 3 as an outlier. We can further enhance the z-score analysis by calculating segment level z-scores. For example, to identify which product sales are outliers, we can calculate the z-scores by finding the average and standard deviation of product sales for that product category alone (instead of all data points) and then use the values to identify the outliers (segment-level z-score higher than 3). This will help you identify the correct outliers for business datasets. 📁 Download the sample file with calculations here - 🤍 ❓ Alternative Standard Deviation formula for older Excel: =STDEV.P(IF($C$7:$C$229=C7,$E$7:$E$229)) and press CTRL SHIFT Enter. ~ ⌚ Topics in this video: = 0:00 - Using z-scores to find the outliers in your data in Excel 0:28 - Calculating the average and standard deviation of the data 1:39 - What is z-score? 1:53 - Calculating Z-score in Excel 2:19 - Definition of an outlier (in normal data) 3:06 - Identifying outliers in the data 4:05 - Problem with z-scores and how to fix that? 5:08 - Average and Standard deviation at product level 7:13 - Z-scores at product level 8:33 - Highlighting outlier values with conditional formatting rule 10:01 - Predicting (forecasting) future values with Excel 📈 Forecasting with Excel = Article: 🤍 Video: 🤍 💻💡 Data Analysis with Excel (more videos) = Check out below videos for more data analysis tips, examples and explanations with Excel 5 Key skills you need to be a data analyst - 🤍 Excel Data Analysis - Beginner to PRO video - 🤍 Budget vs. actual analysis with Excel - 🤍 Clean, analyze and present business data - 🤍 Full Data Analysis with Excel Course - 🤍 ~ Knock, knock... Who's there? Outlier... Ok, you stay there 😂 #excel #statisticas #zscore
Ready to use Excel Dashboard Templates from Chandoo.org - Official Trailer | ExcelTutorials Introducing ready to use Excel dashboard templates from Chandoo.org. Create awesome, informative & easy to understand reports in few minutes. Releasing on November 13th. Here is a sneak-peek. Do Subscribe, Like & Share my video if you like!! Click The Below Link To SUBSCRIBE: 🤍
Ever wanted to create an organizational chart or hierarchy graph in Excel? In this quick tutorial, learn how to make org. charts with-in Excel from your own data. You can easily update them when your data changes and email the output graph (or image) to a client or your boss. SAMPLE FILE 📂: Download the sample file and make organizational charts with your data. 🤍 🧰 More Charts & Templates for work: = Check out below videos & resources for more charts & templates for work use: WATERFALL CHART IN EXCEL - 🤍 VARIANCE CHART IN EXCEL - 🤍 BUDGET SPREADSHEET (fully dynamic) - 🤍 ANY YEAR CALENDAR + PLANNER - 🤍 PROJECT PLAN TEMPLATE - 🤍 100s of FREE Excel Templates - 🤍 PLAYLIST - Excel Charts for Data Analysis & Story-telling - 🤍 ~ #orgchart
Do you want to learn Tableau? In this video, learn all the basics you need to start using Tableau straightaway. We are going to understand how to load some data, analyse it, create some charts and prepare a dashboard with Tableau. ⬇ DOWNLOAD TABLEAU PUBLIC SOFTWARE: = Get the FREE Tableau public software from here - 🤍 📁Sample Data to Pratice: The sample data I've used in the video is here 👉 🤍 ⏱ In this video = 0:00 - Introduction and how to download Tableau 1:08 - Loading data into Tableau 2:07 - Creating your first visual / chart / sheet in Tableau 5:00 - Making a Top 10 salesperson chart 6:51 - How to make a dashboard with Tableau 9:32 - How to use one visual as a "filter" for other visuals in tableau? 10:29 - Adding business summary section to the dashboard (calculated fields) 13:31 - Formatting the charts & text in Tableau 14:29 - Saving and publishing your work 💻 Business Intelligence Analysis - Other Tutorials: INTRODUCTIONS: Introduction to Power BI - 🤍 Introduction to Excel - 🤍 Introduction to SQL - 🤍 DEEP DIVES: Power BI - 🤍 Excel - 🤍 DAX - 🤍 SQL - 🤍 Python - 🤍 FULL COURSES: Power BI - 🤍 Excel - 🤍 ~ #tableau #dataanalytics
We all know that pivot tables are great for working with numbers. But what if you have a large text and want to convert / extracts bits of it in to a table? See this video to learn how to use Power Query for Excel to turn text in to a table. Visit 🤍 for example workbook and discussion
.svg){kind=small}
![How to Pivot text values in Excel [Simple Trick]](https://i.ytimg.com/vi/iZo5k_L8_RI/mqdefault.jpg "How to Pivot text values in Excel [Simple Trick]")