@marbles5590
DAY 1: 1:23:00 (I enjoyed the course. Thank you for this video!) DAY 2: 3:44:40
@Kim-lb5ef
This is so helpful for someone like me who wants to learn but doesn't have money to pay for online courses. Thank you so much for this!
@haretztj4682
Start 0:00 Introduction - Excel Intro to Data Analysis 0:09 List Design Basics 1:25 Inserting Tables for Analysis 4:59 Filtering Data in Tables 9:57 Using the Total Row 15:10 Conditional Formatting 18:57 IF Function 25:23 SUMIF and AVERAGEIF 31:52 SUMIFS 39:22 Inserting Recommended Charts 42:37 Adjusting Charts 48:24 Sparklines 50:41 Inserting Pivot Tables 57:25 Displaying Data as Count 1:05:18 Filtering Pivot Tables 1:09:06 Inserting Pivot Charts 1:17:47 Conclusion - Intro to Data Analysis 1:22:04 Introduction - Excel Pivot Tables 1:22:59 What are Pivot Tables? 1:24:05 Preparing Data for Analysis 1:29:39 Pivot Table Components 1:34:12 Building Pivot Tables to Show Different Values 1:40:30 Adding Fields to Pivot Tables 1:45:45 Using Built-In Filters 1:52:34 Filtering Data with Slicers 1:58:24 Displaying New Values from Data Sources 2:05:14 Inserting Pivot Charts 2:11:45 XLOOKUP 2:18:37 Joining Data Sets with XLOOKUP 2:26:48 Introduction to Advanced Pivot Tables 2:34:41 Inserting Pivot Tables from Tables 2:36:07 Calculated Fields 2:43:53 Using the Timeline Tool 2:49:43 Report Filter Pages 2:54:59 Pivot Table Layouts 3:01:42 Creating Pivot Table Designs 3:08:06 Adding Power Pivot Tabs to the Ribbon 3:15:32 Adding Tables to Power Pivot Data Model 3:18:15 Creating Table Relationships 3:23:17 Creating Columns with DAX Expressions 3:27:28 Displaying New Source Data in Power Pivot Tables 3:34:54 Data Mining with Flash Fill 3:37:45 Conclusion - Excel Pivot Tables 3:43:48 Introduction - Excel Copilot 3:44:39 What is Copilot? 3:45:04 Setting Up Copilot in Excel 3:49:05 Copilot Pane and Insights 3:51:54 Visualizing Data with Copilot 3:58:08 Sorting, Highlighting, and Filtering 4:06:16 Adding Formulas with Copilot 4:14:52 Asking Copilot Questions 4:20:37 Accessing Copilot Lab 4:29:44 Copilot Lab 4:30:58 Copilot with Excel Web Version 4:37:47 Conclusion - Excel Copilot 4:41:20 Introduction - Excel Power User 4:41:32 IF Function Basics 4:43:04 IF Functions with Calculations 4:49:20 Nesting AND with IF 4:53:43 Naming Ranges and COUNTIF 5:00:02 SUMIF and AVERAGEIF 5:05:59 SUMIFS 5:10:54 XLOOKUP 5:14:56 Populating Forms with XLOOKUP 5:23:21 Displaying Pivot Table Fields with COUNT Function 5:31:57 Calculated Fields 5:36:47 Slicers 5:43:33 Using the Timeline 5:49:42 Inserting Report Filter Pages 5:54:57 Flash Fill for Text Functions 5:59:38 Introduction to Advanced Conditional Formatting and Macros 6:05:55 Array Formula Basics 6:06:42 Looking Up Multiple Values with XLOOKUP 6:13:00 Array Functions 6:18:01 Advanced Conditional Formatting 6:25:08 Combo Charts 6:32:36 Developer Tab 6:40:18 Macro Basics 6:44:31 Relative Reference Macros 6:51:07 VBA Basics 6:55:07 Cleaning Up Macros 7:01:51 Conclusion - Excel Power User 7:10:22
@morgancrous3021
I wish all YouTube tutorials were this easy to follow along. Thank you a million times. This has helped me so much. Thanks Mo Jones for your way of explaining thoroughly.
@raquelsilvagorbea
⚠If you're practicing with Excel web version, here's what's not included: 1. Adding Sparkline to cell 2. Data Analysis Button 3. Pivot Table Analyze > Pivot Chart 4. Calculated Field 5. Show Report Filter Pages 6. Report Layout 7. Themes for Presentation 8. Add to Data Model 9. Analyze Data button 10. Cannot create pivot table to existing worksheet 11. Report Page Filters 12. Customize Ribbon > developer mode to make Macros (I was excited to try it) 13. Creating Table Relationships 💡If anyone was able to find any of these on the web version, please share! 💖Other than that, I learned so, so much even with the web version! I'm really grateful for this course! Don't let the lack of features stop you from learning, when you get the paid Excel version you can always go over these.
@sohannotes
Successfully complete this course Alhamdulillah. Thanks MO JONES for your good job.
@waleedgalal
Great video I'll use this comment to record the time of my studying sessions 1- 0:42:37 2- 1:09:07 3- 1:52:00 4- 2:26:46 5- 3:01:42
@fayazahamadS
2:08:24 while changing the pivot table data source it's not showing the row that i have added in the end but when i open present this sheet it's there. Can anyone please help me out with that?
@ajalajessica3601
completed the course and I’ve come right back to say thank you 🙏, waiting for a tutorial on SQL from our instructor Mo Jones
@Jay.Bambhaniya
6:12:26 gross pay apply only for one cell, link row range give error and link column range only for one cell. Plz help what change i have to do with my excel.
@n3llyusm
You are the BEST excel teacher for data analyst i have ever come across on Youtube. Others here on youtube will just push you to hate the course. I don't mind sharing this page to promote your great job .All i will say is that you have a good spirit and i want to say a very BIG THANKS Please is it possible to have tutorial on SQL,PYTHON from you?
@codemass
day 1: 25:44
@la9753
I came across this channel and video 3 days ago and I am loving the richness, the simplicity and clarify of the delivery. It is so detailed, informative and so so educative. THANKS A MILLION. 🙏🏾🙏🏾
@engineerduraid7517
min. 7:00 we can use (drop down list) instead of re-writing address of each category frequently... don't you think so?
@Ranjit_Rajak075
Instead of writing category and division name every time, in order to change. Can we use filter and drop lists things as it requires. Can you show the process. (42:00) Database Functions sheet.
@hasanferoz2364
47:42 They don't offer all that visual options or colors of charts or Recommended Charts tab in Excel Online?
@maddiemei3505
Just finished 7 hours in 4 days. What a great course to brush up on your skills and also learn new short cuts!
@Yrfather1PUBG
3:37:40
@ananda9736
4:41:00
@LearnitTraining