The ONLY Excel Training You’ll Ever Need (Seriously) | Complete Excel Course

Download files and exercises here 👉 https://datatraining.io/powerbi-how-to -------------------------------- 📊 TRAININGS 📊 --------------------------------- Power BI Design 4 Weeks Transformation Program https://datatraining.io/powerbidesigntransformation Power BI PL-300 Certification Training https://datatraining.io/powerbi-pl300 For Custom Trainings and Consulting email directly [email protected] --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 1️⃣ Getting started with Excel I Excel Bootcamp Part 1 0:00:00 Intro Getting started with Excel 0:00:48 Shortcuts for selecting data and moving around the workbook 0:06:09 What you need to know about text, values, and dates 0:14:28 So what options do we have for sheets, columns & rows, and cells 0:19:08 Copy pasting data - clipboard tasks 0:23:19 Making everything pretty with formatting 0:30:09 Getting everything ready for printing 2️⃣ Formulas & Functions I Excel Bootcamp Part 2 0:33:28 Intro Formulas & Functions 0:33:48 Creating a simple formula 0:38:54 Formulas for logical comparisons 0:45:02 Cell references: what's up with those dollar signs 0:52:02 Exercise: where to put the $ signs? 0:55:37 Aggregation functions: get more done more quickly with functions 0:59:09 Logical functions: how to handle more complex logical conditions 1:05:26 IF function + nesting functions: If within an if, within another if 1:13:09 More practice with the IF function 1:20:01 IFS function: maybe easier? 1:23:25 Exercise: cell references, IF function, and returning blanks 1:27:17 Conditional calculations: COUNTIF(S) 1:34:46 Conditional calculations: SUMIF(S), AVERAGEIF(S) 3️⃣ Charts and Data Visualization I Excel Bootcamp Part 3 1:42:59 Intro Charts and Data Visualization 1:43:20 Creating charts - where it all starts 1:54:49 Dealing with missing data and filters 2:02:17 How to customize any chart in any way you like 2:15:28 Best practices: making charts pretty and easier to read 2:29:12 Saving time with chart templates 4️⃣ Pivot Tables I Excel Bootcamp Part 4 2:32:58 Intro Pivot Tables 2:33:10 Why pivot tables? 2:42:15 Preparing the data 2:56:27 Pivot tables 101 3:23:56 Customizing pivot tables 3:41:11 Grouping sorting and filtering 3:58:53 Custom calculations 4:12:46 Pivot charts 4:22:39 Creating a dashboard 5️⃣ Lookup Functions I Excel Bootcamp Part 5 4:45:03 Intro Lookup Functions 4:45:22 VLOOKUP | The basics 4:56:27 HLOOKUP | Same logic, just the other way around 5:03:45 XLOOKUP | New and improved version 5:09:38 Matching data with lookup functions 5:20:02 Approximate vs exact match 5:28:10 Wildcards for more flexibility 5:34:26 INDEX MATCH | How it works 5:41:31 Row and column lookup 5:47:42 Multiple column lookup 6️⃣ Visualisation Tools | Excel Bootcamp Part 6 5:54:00 Intro Visualisation Tools 5:54:14 The basics of conditional formatting 5:59:36 What happens if two rules apply to the same cells? 6:05:59 Exploring formatting rules 6:13:32 Writing your own custom rules 6:21:59 Data bars with icons 6:25:17 Custom formatting strings 6:30:04 Display values in thousands or millions 6:42:30 Custom formatting strings in charts 6:48:50 Sparklines to quickly see the trend 6:57:14 KPI cards with sparklines and custom formatting --------------------------------- 😍 JOIN 😍 ---------------------------------- Join https://bit.ly/4b453bi Subscribe https://bit.ly/31MnQGO​ Insta https://www.instagram.com/howtopowerbi/ LinkedIn https://www.linkedin.com/in/basdohmen/ TikTok https://www.tiktok.com/@how.to.power.bi X https://twitter.com/HowToPowerBI fb https://www.facebook.com/groups/howtopowerbi Threads https://www.threads.net/@howtopowerbi Newsletter https://datatraining.io/newsletter --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://amzn.to/47F21Yc 📚 Power BI books MUST READ! https://amzn.to/3tUfFcj 💡 General books I recommend https://amzn.to/48YNo33 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://amzn.to/3HqfMQ2 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX