Excel

Career Data

What is the FASTEST Way to Become a Data Analyst and ACTUALLY Get a Job

For those looking to break into Data Analysis quickly and how to get your first full-time Data Analyst job – step by step, then this video is for you. As a self taught Data Analyst, if you want to learn data analysis to get a job at FAANG, this video is for you. This video […]

Read More
Data

How to Build Interactive Excel Dashboards

In this Microsoft Excel 2021/Excel 365 training tutorial video, learn how to create an Excel Interactive Dashboard. We’ll go over what a dashboard is and discuss in-depth how to assemble an interactive dashboard for your data visualization including adding calculations, charts and graphs, formatting, and more! We finish off with an exercise to test what […]

Read More
Data

Data Analytics In Excel Full Course

This video on Data Analytics In Excel Full Course will help you will understand the various crucial functions available in Excel, such as lookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations. So, let’s begin. Dataset Link: https://drive.google.com/drive/folders/1U8CF0Xx3NivXdfrQvXJ_462tEb26oPuX

Read More
Microsoft

Microsoft Excel PivotTables Explained

In this Microsoft Excel 2021/Excel 365 training tutorial video, learn all about Excel PivotTables. We’ll go over creating a PivotTable from scratch and discuss the different elements of a PivotTable! Learn how to pivot a field, add totals, format numbers and errors, choose a report layout, apply formatting styles, and more! We finish off with […]

Read More
Microsoft

How to Create an Excel Dashboard for Schools with changing students images dynamically

Here’s an interesting video on creating a dashboard in Excel. Chapters: 0:00, Dashboard Features & contents Overview 1:25, workbook contents 1:50, 1st Dashboard background 2:27, 2nd Dashboard background 3:43, Left side buttons 5:47, Values & charts background 7:05, Main title and KPIs 10:06, Side menu background image 11:21, Students per educational stage column chart 16:12, […]

Read More
Data Microsoft

How to Make Named Ranges in Excel

Learn how to maker Named Ranges in Excel today.

Read More
Data Visualization

How to Build Excel Interactive Dashboards

In this step-by-step tutorial by Kevin Stratvert, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. Best of all, you only need is out of the box Microsoft Excel – no plug-ins, etc.

Read More