- Видео 249
- Просмотров 82 989
Change tips and tools
Великобритания
Добавлен 14 июл 2023
If you want to build technical skills to save yourself hours of work - then this is the channel for you!
MASTER Your Finances with Excel's Power Query and Power Pivot!
Take your financial analysis to the next level with Excel's powerful tools! In this video, you'll learn how to master your finances using Excel's Power Query and Power Pivot. Discover how to manage data, transform, and analyze your financials, create stunning reports, and make data-driven decisions. Whether you're a financial analyst, accountant, or business owner, or just trying to take back control of your money, this video will show you how to unlock the full potential of Excel and take control of your finances. Get ready to boost your productivity, reduce errors, and make informed financial decisions with Excel's Power Query and Power Pivot. #excel #pmo #powerpivot #powerquery #person...
Просмотров: 63
Видео
Power Query Hacks to Create Dynamic Column Names!
Просмотров 23021 день назад
Learn advanced Data Validation and Power Query tricks in Excel to supercharge your Resource Capacity Planning! In this video, we'll dive into the world of data validation and Power Query to uncover hidden gems that will take your Excel skills to the next level. From creating dynamic data validation to automating custom columns in Power Query without breaking your data model, we'll cover it all....
Resource Capacity Planning Template How to on settings and headings
Просмотров 122Месяц назад
Welcome to this follow up video to the popular Excel training series on Resource Capacity Planning. In this series of tutorials, I have showcased how to create a resource capacity planning template using Excel tables, Power Query, Power Pivot, and VBA. This is a follow up video where I show you how deal with security warnings, how change headings e.g. 'Programme' to 'Business' and also how to m...
How to generate Lottery Numbers in less than 10 mins
Просмотров 162Месяц назад
Welcome to another Excel video! In less than 10 minutes, I will show you some tips and tricks on how to create a lot of data to support a Lotto number generator. Learn how to efficiently use Excel for data creation and boost your chances of hitting the jackpot! 🎱💻 Don't miss out on these quick and easy Excel hacks to enhance your lottery number picking skills. Watch now and become a pro at gene...
I Mastered GROUPBY and PIVOTBY in Excel and You Can Too!
Просмотров 251Месяц назад
Learn how to take your Excel skills to the next level by mastering the GROUPBY and PIVOTBY functions! In this tutorial, we'll dive deep into the world of data analysis and show you how to use these powerful functions to summarize and transform your data with ease. From grouping and aggregating data to creating custom pivot tables, we'll cover it all. By the end of this video, you'll be able to ...
Turn EXCEL into a UK BINGO Game - Part 4 | With some Visual Basic step-by-step guides
Просмотров 502 месяца назад
This is Part four and the final video of this series on how to turn Microsoft Excel into a UK Bingo game in this fun and creative set of tutorials! If you're looking for a unique way to engage with Excel or create an interactive game for a party or event, this video is for you. We'll show you how to use Excel's built-in features to create a fully functional UK Bingo game, complete with random n...
Turn EXCEL into a UK BINGO Game - Part 3
Просмотров 952 месяца назад
This is Part three of this series on how to turn Microsoft Excel into a UK Bingo game in this fun and creative set of tutorials! If you're looking for a unique way to engage with Excel or create an interactive game for a party or event, this video is for you. We'll show you how to use Excel's built-in features to create a fully functional UK Bingo game, complete with random number generation an...
Turn EXCEL into a UK BINGO Game - Part 2
Просмотров 682 месяца назад
This is Part two of this series on how to turn Microsoft Excel into a UK Bingo game in this fun and creative set of tutorials! If you're looking for a unique way to engage with Excel or create an interactive game for a party or event, this video is for you. We'll show you how to use Excel's built-in features to create a fully functional UK Bingo game, complete with random number generation and ...
Turn EXCEL into a UK BINGO Game - Part 1
Просмотров 1392 месяца назад
This is Part one of this series on how to turn Microsoft Excel into a UK Bingo game in this fun and creative set of tutorials! If you're looking for a unique way to engage with Excel or create an interactive game for a party or event, this video is for you. We'll show you how to use Excel's built-in features to create a fully functional UK Bingo game, complete with random number generation and ...
Turn Boring Spreadsheets into EXCITING UK BINGO Nights!
Просмотров 732 месяца назад
Learn how to turn Microsoft Excel into a UK Bingo game in this fun and creative tutorial! If you're looking for a unique way to engage with Excel or create an interactive game for a party or event, this video is for you. We'll show you how to use Excel's built-in features to create a fully functional UK Bingo game, complete with random number generation and interactive gameplay. Whether you're ...
Why I DITCHED Pivot Tables for Array Formulas in Excel!
Просмотров 6122 месяца назад
Are you tired of using Pivot Tables in Excel? In this video, I'm sharing my personal experience of ditching Pivot Tables for Array Formulas and how it revolutionized my data analysis workflow. From increased flexibility to improved performance, I'll show you the benefits of making the switch and provide you with practical examples to get you started. Whether you're an Excel beginner or a season...
Create a dynamic Calendar in Power Query - Easy
Просмотров 2473 месяца назад
Create a dynamic Calendar in Power Query - Easy
Power Query and the IF Function tutorial - Made EASY!
Просмотров 1523 месяца назад
Power Query and the IF Function tutorial - Made EASY!
Combining Multiple Columns and Rows into one cell - Easy and Fast!
Просмотров 4964 месяца назад
Combining Multiple Columns and Rows into one cell - Easy and Fast!
Resource capacity modelling so easy with Power Query and Power Pivot
Просмотров 3714 месяца назад
Resource capacity modelling so easy with Power Query and Power Pivot
Create a Pyramid Chart in Excel for Beginners - Quick & Easy!
Просмотров 6444 месяца назад
Create a Pyramid Chart in Excel for Beginners - Quick & Easy!
Create a Speedo Dial in Excel | Add Wow Factor to Dashboards | Doughnut & Pie Charts
Просмотров 1104 месяца назад
Create a Speedo Dial in Excel | Add Wow Factor to Dashboards | Doughnut & Pie Charts
Excel Chart Mastery: Budget vs Actuals Head-to-Head
Просмотров 1305 месяцев назад
Excel Chart Mastery: Budget vs Actuals Head-to-Head
Date perfection with Excel tips and tricks - Bonus Video
Просмотров 625 месяцев назад
Date perfection with Excel tips and tricks - Bonus Video
Date perfection with Excel tips and tricks - Step 7
Просмотров 1145 месяцев назад
Date perfection with Excel tips and tricks - Step 7
Date perfection with Excel tips and tricks - Step 6
Просмотров 2655 месяцев назад
Date perfection with Excel tips and tricks - Step 6
Date perfection with Excel tips and tricks - Step 5
Просмотров 765 месяцев назад
Date perfection with Excel tips and tricks - Step 5
Date perfection with Excel tips and tricks - Step 4
Просмотров 2005 месяцев назад
Date perfection with Excel tips and tricks - Step 4
Date perfection with Excel tips and tricks - Step 3
Просмотров 1075 месяцев назад
Date perfection with Excel tips and tricks - Step 3
Date perfection with Excel tips and tricks - Step 2
Просмотров 985 месяцев назад
Date perfection with Excel tips and tricks - Step 2
Date perfection with Excel tips and tricks - Step 1
Просмотров 1956 месяцев назад
Date perfection with Excel tips and tricks - Step 1
Date perfection with Excel tips and tricks
Просмотров 1656 месяцев назад
Date perfection with Excel tips and tricks
XLOOKUP vs VLOOKUP HLOOKUP INDEX & MATCH: Which is EASIER?
Просмотров 3186 месяцев назад
XLOOKUP vs VLOOKUP HLOOKUP INDEX & MATCH: Which is EASIER?
Power BI Secrets: Drill Throughs, Measures, and DAX
Просмотров 1296 месяцев назад
Power BI Secrets: Drill Throughs, Measures, and DAX
Revealing Data Secrets with Power BI Drill Through
Просмотров 1766 месяцев назад
Revealing Data Secrets with Power BI Drill Through