Excel

AI Microsoft

The Future of Work With AI – Microsoft March 2023 Event

Microsoft recently held a special event with Satya Nadella and Jared Spataro focused on how AI will power a whole new way of working for everyone.

Read More
AI

How to use AI in Excel – data analysis made easy

In this step-by-step tutorial, learn from Kevin Stratvert how to use Artificial Intelligence or A.I. in Microsoft Excel to easily and to quickly analyze your data.

Read More
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