In this MS Excel tutorial, the instructor introduces the newly added group by function to create a live search engine without using macros, coding, or add-ins. The tutorial begins by setting up the data in a sheet named “data” with product details. The process involves renaming sheets, adding freeze panes, and formatting. The instructor then…
In this Power BI tutorial, we welcome you to explore new features in Power BI Desktop. The tutorial covers the creation of a dashboard using these features, beginning with loading data into Power BI Desktop using the “Get Excel Workbook” button. The presenter demonstrates the addition of a title to the dashboard, utilizing rounded corners…
Welcome back, everyone! In this unique tutorial, we’ll guide you through creating a dynamic dashboard in Microsoft Excel using Python. Specifically tailored for those keen on mastering Python visualizations, we’ll delve into the world of Excel charts powered by Python’s Matplotlib library. Notably, unlike Excel’s native charts, Python charts seamlessly integrate within cells, providing a…
In this instructional session, finance professionals are guided through the process of managing assets and presenting financial data in charts. The focus is on calculating depreciation, accumulated depreciation, and net book value using two methods: straight line and declining balance. The tutorial demonstrates how to incorporate these calculations into a Power BI dashboard, emphasizing their…
In this tutorial, we explore the use of Copilot in Power BI Desktop, a new feature leveraging AI to convert text-based commands into DAX measures. Available in preview mode, enabling Copilot involves accessing the Options menu and activating Quick Measure Suggestions under Preview Features. The tutorial guides users through the setup process, including steps for…
In this Power BI Dashboard tutorial, you will learn to create a comprehensive dashboard using e-commerce data depicting customer purchases and interactions. The tutorial begins by guiding you to download the provided CSV file from Kaggle, which contains the necessary data. After uploading the data into Power BI Desktop, you are instructed on creating a…
In this tutorial, we explore the newly introduced Pivot By and Group By functions in Microsoft Excel. Learn how to dynamically summarize and modify your data with these powerful tools. Whether you’re an Excel novice or an advanced user, these functions can enhance your data analysis capabilities. #groupby #pivotby #ExcelTips #DataAnalysis #MicrosoftExcel #PivotTables #ExcelFunctions #DataVisualization…
Unlock the power of data analysis with our latest tutorial! In this step-by-step guide, we’ll show you how to leverage Power BI Desktop to transform a CSV file containing monthly sales, expenses, profitability, and customer count into an insightful dashboard for yearly comparisons. Learn to create pivot tables using Power Query, combine them into a…
In this tutorial, the presenter welcomes the audience back and introduces the creation of a customer insight dashboard using data available on Kaggle. The process involves creating age and rating buckets using Data Analysis Expression, exporting icons from PowerPoint, and incorporating them into the dashboard. The tutorial covers turning on map visuals, adjusting canvas size,…
Welcome to another tutorial on real-time data in MS Excel! In our previous sessions, we explored building add-ins in VBA to display real-time information. Today, we’re diving into the world of Python, leveraging Real-Time Data Server technology to showcase real-time data in MS Excel. Unlike traditional methods, we’ll create our own functions in Python to…
