![Ian Littlejohn Tutorials](/img/default-banner.jpg)
- 38
- 14 161
Ian Littlejohn Tutorials
United Kingdom
Приєднався 25 чер 2007
Welcome to the channel! My goal is to help you learn the most powerful and quickest ways to work, understand and analyze your data. These tutorials are primarily designed for spreadsheet users who want to learn different methods, techniques and tools for transforming your data into insight and intelligence.
Please subscribe to keep up to date with the latest content.
Enjoy the tutorials!
Please subscribe to keep up to date with the latest content.
Enjoy the tutorials!
Learn Excel Power Pivot: Tutorial 9 - Dashboards
📊 About This Tutorial
Welcome to our latest tutorial in the Excel Power Pivot series! In this session, we will dive into creating a dynamic four-chart dashboard. Utilizing the human resource data from previous tutorials, we'll demonstrate how to effectively use relationships between tables to create interactive visualizations directly in Excel. By the end of this tutorial, you'll be equipped to build comprehensive dashboards that enhance your data analysis capabilities.
🔍 What You'll Learn:
In this tutorial, you will learn:
-How to create a four-chart dashboard using Excel Power Pivot.
-Techniques for integrating multiple data sources and relationships in your charts.
-Steps to customize and format pivot charts for better visualization.
-How to use slicers to create interactive and filterable dashboards.
🚀 Tutorial Highlights:
-Four-Chart Dashboard Creation: Learn how to quickly set up a four-chart dashboard using human resource data.
-Chart Customization: Discover how to customize and format different chart types, including column, line, pie, and bar charts.
-Interactive Slicers: Understand how to add and use slicers to make your dashboard interactive, allowing for real-time data filtering.
-Practical Examples: Follow along with practical examples, such as visualizing training costs by department and year, employee distribution by gender, and total training costs by course name.
Remember to like and subscribe to our channel for more in-depth tutorials. Let's jump into the tutorial and start building your interactive dashboard!
👨 Instructor: Ian
Ian brings his expertise in analytics to show you how you can easily simplify your data analysis tasks, making your reports both informative and easy to understand.
📝 Please Note:
Ensure you have the appropriate licensing from Microsoft to use Excel Power Pivot. This tutorial is suitable for users of the desktop version of Excel that has Power Pivot included on Windows.
✅ Subscribe and Like:
Don't forget to subscribe and like the channel to stay updated with our latest tutorials on data analysis and more!
🔗 Watch Next:
Stay tuned for further tutorials that delve deeper into the capabilities of Excel Power Pivot and explore additional features.
Join us in this tutorial and start transforming your data into actionable insights today!
Welcome to our latest tutorial in the Excel Power Pivot series! In this session, we will dive into creating a dynamic four-chart dashboard. Utilizing the human resource data from previous tutorials, we'll demonstrate how to effectively use relationships between tables to create interactive visualizations directly in Excel. By the end of this tutorial, you'll be equipped to build comprehensive dashboards that enhance your data analysis capabilities.
🔍 What You'll Learn:
In this tutorial, you will learn:
-How to create a four-chart dashboard using Excel Power Pivot.
-Techniques for integrating multiple data sources and relationships in your charts.
-Steps to customize and format pivot charts for better visualization.
-How to use slicers to create interactive and filterable dashboards.
🚀 Tutorial Highlights:
-Four-Chart Dashboard Creation: Learn how to quickly set up a four-chart dashboard using human resource data.
-Chart Customization: Discover how to customize and format different chart types, including column, line, pie, and bar charts.
-Interactive Slicers: Understand how to add and use slicers to make your dashboard interactive, allowing for real-time data filtering.
-Practical Examples: Follow along with practical examples, such as visualizing training costs by department and year, employee distribution by gender, and total training costs by course name.
Remember to like and subscribe to our channel for more in-depth tutorials. Let's jump into the tutorial and start building your interactive dashboard!
👨 Instructor: Ian
Ian brings his expertise in analytics to show you how you can easily simplify your data analysis tasks, making your reports both informative and easy to understand.
📝 Please Note:
Ensure you have the appropriate licensing from Microsoft to use Excel Power Pivot. This tutorial is suitable for users of the desktop version of Excel that has Power Pivot included on Windows.
✅ Subscribe and Like:
Don't forget to subscribe and like the channel to stay updated with our latest tutorials on data analysis and more!
🔗 Watch Next:
Stay tuned for further tutorials that delve deeper into the capabilities of Excel Power Pivot and explore additional features.
Join us in this tutorial and start transforming your data into actionable insights today!
Переглядів: 122
Відео
Learn Excel Power Pivot: Tutorial 8 - Create Relationships
Переглядів 1292 місяці тому
📊 About This Tutorial Welcome to this tutorial! In this session, we continue our series on Excel Power Pivot by focusing on how to create relationships between tables. We will be using a human resource data source with two tables: an employee master list and a training list. This tutorial will guide you through the process of establishing relationships within Power Pivot, enabling you to seamle...
Learn Excel Power Pivot: Tutorial 7 - SWITCH Function
Переглядів 1092 місяці тому
📊 About This Tutorial Welcome to our Excel Power Pivot tutorial series! In this session, we focus on the SWITCH function, an incredibly useful tool for handling complex if-then conditions in your data analysis. This tutorial is perfect for those who have already grasped the basics of measures and are looking to enhance their skills in managing complex criteria within PivotTables. 🔍 What You'll ...
Learn Excel Power Pivot: Tutorial 6 - Measures
Переглядів 1992 місяці тому
📊 About This Tutorial Welcome to our comprehensive tutorial on measures in Excel Power Pivot. In this session, we delve into the concept of measures, an essential calculation tool that enhances your data analysis. Unlike calculated columns, measures provide a dynamic way to compute values that are not directly visible in your data tables but are crucial for effective data visualization and inte...
Learn Excel Power Pivot: Tutorial 5 - Date Functions
Переглядів 2092 місяці тому
📊 About This Tutorial Welcome to our continuing series on Excel Power Pivot! In this tutorial, we will dive into using functions within Power Pivot formulas, allowing you to perform advanced data analysis with ease. We'll explore how to extract specific information from your data, such as year, month, and weekday, and how to utilize these new fields in your analysis. 🔍 What You'll Learn: In thi...
Learn Excel Power Pivot: Tutorial 4 - Pivot Tables and Pivot Charts
Переглядів 1172 місяці тому
📊 About This Tutorial Welcome to our ongoing series on Excel Power Pivot! In this tutorial, we will explore how to use pivot tables and pivot charts to analyze and present data effectively. Building on our previous tutorials, we will show you how to transform your raw data into meaningful insights using these powerful tools. 🔍 What You'll Learn: In this tutorial, you will learn: -How to create ...
Learn Excel Power Pivot: Tutorial 3 - Calculated Columns
Переглядів 1872 місяці тому
📊 About This Tutorial Welcome to our series of tutorials on Excel Power Pivot! In this tutorial, we will delve into how to add simple calculations to your tables in Power Pivot. This session is perfect for users looking to enhance their data analysis by integrating new fields and performing calculations within their Power Pivot tables. 🔍 What You'll Learn: In this tutorial, you will learn: -How...
Learn Excel Power Pivot: Tutorial 2 - Load Data
Переглядів 922 місяці тому
📊 About This Tutorial Welcome to this tutorial series on Excel Power Pivot! In this video, we will guide you through the process of loading data into Power Pivot, an essential skill for managing large datasets efficiently within Excel. Whether you're importing data from various databases, CSV files, or existing Excel tables, this tutorial will show you how to get started. 🔍 What You'll Learn: I...
Learn Excel Power Pivot: Tutorial 1 - Overview
Переглядів 1002 місяці тому
📊 About This Tutorial Welcome to our comprehensive series on Excel Power Pivot! In this series, we will explore the powerful capabilities of Power Pivot, a feature introduced in Excel 2010 that enhances data handling by integrating a database within Excel. This tutorial is perfect for those who want to learn how to efficiently manage and analyze large datasets directly in Excel. 🔍 What You'll L...
Analyzing Data with ChatGPT: Tutorial 13 - Omni Release
Переглядів 1,3 тис.3 місяці тому
In this tutorial, we'll explore the new features introduced in the latest ChatGPT release, Omni Update, specifically focusing on data analysis enhancements. This tutorial will guide you through connecting to Google Drive and Microsoft OneDrive, working with interactive tables, and utilizing new graphing capabilities. Make sure to subscribe and hit the bell icon to stay updated with our latest c...
You Tube Channel Introduction
Переглядів 1693 місяці тому
Are you looking for quick, simply, easy tutorials and short courses to improve the way you work and help you to understand and analyse your data? Then look no further! This channel has been designed so that you can either pick and choose the individual videos on the topic or skill you're interested in learning about, or each playlist makes up a full short course which can be completed at your o...
Analyzing Data with ChatGPT: Tutorial 12 - Group Data
Переглядів 3353 місяці тому
Explore sophisticated data grouping techniques to enhance human resource data analysis using ChatGPT. This tutorial will focus on creating meaningful groupings or "bins" for employee data, such as age ranges and salary bands, which can provide insightful visualizations and reports. Perfect for HR professionals and data analysts looking to leverage AI for more efficient data processing and decis...
Analyzing Data with ChatGPT: Tutorial 11 - Pareto Analysis
Переглядів 2193 місяці тому
Delve into the fascinating world of Pareto Analysis using ChatGPT. This tutorial is designed to demonstrate how a small percentage of factors often contribute disproportionately to major outcomes, a principle known as the 80/20 rule. By focusing on Pareto Analysis, we'll explore how to identify the most influential factors in your data, from sales contributions by key customers to profit distri...
Analyzing Data with ChatGPT: Tutorial 10 - Advanced Calculations
Переглядів 1983 місяці тому
In this detailed tutorial we explore how to use ChatGPT for complex data calculations, such as calculating percentages, differences between months, running totals, and rankings. These calculations, often challenging in traditional data analysis tools, are simplified using ChatGPT's powerful language capabilities. This session is ideal for analysts looking to deepen their understanding of dynami...
Analyzing Data with ChatGPT: Tutorial 9 - Trends and Date Calculations
Переглядів 2013 місяці тому
Continue exploring the advanced capabilities of ChatGPT in the realm of data analysis. This tutorial delves into trend analysis and dynamic date calculations, showing you how to manipulate and analyze temporal data effortlessly. Whether you're interested in understanding sales trends over time or performing complex date-related calculations, this session is designed to enhance your analytical s...
Analyzing Data with ChatGPT: Tutorial 8 - Advanced Graphs
Переглядів 2423 місяці тому
Analyzing Data with ChatGPT: Tutorial 8 - Advanced Graphs
Analyzing Data with ChatGPT: Tutorial 7 - Graphs
Переглядів 2973 місяці тому
Analyzing Data with ChatGPT: Tutorial 7 - Graphs
Analyzing Data withChatGPT: Tutorial 6 - Filter Data
Переглядів 2043 місяці тому
Analyzing Data withChatGPT: Tutorial 6 - Filter Data
Analyzing Data with ChatGPT: Tutorial 5 - Methods of Aggregation
Переглядів 2873 місяці тому
Analyzing Data with ChatGPT: Tutorial 5 - Methods of Aggregation
Analyzing Data with ChatGPT: Tutorial 4 - Summary Tables
Переглядів 5133 місяці тому
Analyzing Data with ChatGPT: Tutorial 4 - Summary Tables
Analyzing Data with ChatGPT: Tutorial 3 - Descriptive Analytics
Переглядів 2,7 тис.3 місяці тому
Analyzing Data with ChatGPT: Tutorial 3 - Descriptive Analytics
Analyzing Data with ChatGPT: Tutorial 2 - Exploratory Data Analytics
Переглядів 3,5 тис.3 місяці тому
Analyzing Data with ChatGPT: Tutorial 2 - Exploratory Data Analytics
Analyzing Data with ChatGPT: Tutorial 1 - Introduction
Переглядів 1,5 тис.3 місяці тому
Analyzing Data with ChatGPT: Tutorial 1 - Introduction
Excel Copilot: Tutorial 4 - Highlighting
Переглядів 1343 місяці тому
Excel Copilot: Tutorial 4 - Highlighting
Excel Copilot: Tutorial 3 - Sort and Filter
Переглядів 1673 місяці тому
Excel Copilot: Tutorial 3 - Sort and Filter
Excel Copilot: Tutorial 1- Introduction
Переглядів 1593 місяці тому
Excel Copilot: Tutorial 1- Introduction
Pivot Tables in Excel Online: Tutorial 9 - Formatting
Переглядів 524 місяці тому
Pivot Tables in Excel Online: Tutorial 9 - Formatting
Hello, how to detect exception or anomaly in a data set with ChatGpt ? thnx.
This series is excellent, it’s a great help! Thank you very much!
Why not just use Power Query rather than the wizard?
Good channel. But please give all the files for power pivot
From the beginning how have you managed to have gone to the ChatGPT
Not sure what you're asking? You're welcome to contact me via LinkedIn or my website.
Nice video.from these l am learning new knowledge from you
Thanks for watching! Glad you're finding the videos helpful.
Thank you very much for you explanation. I've been using the online version and there are some nuances hard to find on the internet
Glad it was helpful!
Nice 👌🏽
Thanks! 😃
Wat is need to continue. Learning data anatyitcs
amazing how quickly this is proceeding, thankyou for this demo
Glad you like it!
Great to see you on Ian on UA-cam... Subscribed your channel.. all the best..
Awesome, thank you!
can you export in .pbix format ?
Unfortunately not at the moment
This is great stuff it has really changed how I view data analysis
Thank you, it's evolving so quickly!
This is really interesting
Thank you
Gr8.. Thanks for this..😊
Most welcome 😊
May I get the Excel file to follow your instruction?
Yes, I've put the link on my website, you can go to www.ianlittlejohn.com/sales-data-download