Copilot skills in PowerPoint let you save a repeatable task once and reuse it forever — and you can build your own without writing any code.

In this video I walk through the Skills feature in PowerPoint Copilot end to end: what a skill actually is, where to find the ones Microsoft already gives you, and how to build your own custom skill using one reusable prompt framework that Copilot fills in for you. I demo two built-in skills I use every day (Explain this presentation and Visualize this slide), then build a custom "customer success story slide" skill live and run it on rough notes. At the end, a first look at Microsoft's brand-new Create interactive slides skill rolling out in the Frontier program.

If you have a Microsoft 365 Copilot license, everything except the Frontier feature is available to you today.

In this video you'll learn:
✅ What a Copilot skill is (a reusable playbook, not a macro or add-in)
✅ Where skills live and two ways to run them (Choose skills menu + @mention)
✅ How to manage skills and control which ones Copilot can use
✅ How to build your own custom skill with a reusable prompt — no coding
✅ How to upload a custom skill into PowerPoint and run it

Chapters
00:00 The slide that built itself
00:58 What a Copilot skill really is
02:27 Two skills I use every day
04:47 Why custom skills are the real power
05:47 The reusable prompt to steal
06:34 Upload it into PowerPoint
07:23 The moment of truth
08:17 What's coming: interactive slides (Frontier Preview)
09:14 Your task this week

Resources / Links
• Read the full written breakdown + get every new one free → M365 Copilot Connection on Substack: https://m365copilotconnection.substack.com
• Download the reusable skill-builder prompt (free) → https://1drv.ms/b/c/731A5A66AE....1C3CCB/IQBqXK6WmV_xR
• Copilot in PowerPoint — Skills (Microsoft support) — https://support.microsoft.com/....en-us/powerpoint/cop
• Licensing note: The Skills feature and custom skills shown here require a Microsoft 365 Copilot license. "Create interactive slides" is currently Frontier-program preview only and is not yet available to all users. Copilot Chat used to generate the skill file is available more broadly.
• Subscribe → https://www.youtube.com/@M365CopilotConnection

#microsoft365copilot #powerpoint

PowerPoint Full Course Tutorial (6+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/yc4c88r3

Who it's for: Do you have a big presentation coming up? Increase your PowerPoint skills with our effective, easy-to-follow training. This course is designed for PowerPoint users of all skill levels. Learn tips and tricks, new features, and more to make your next presentation stand out.

What it is: PowerPoint is Microsoft’s legendary presentation tool. The latest version is jam-packed with enhancements to old, trusty features, along with a few new advancements.

What you'll learn: In this course, we’ll start with the basics like slides, images, and transitions. Then, we’ll take a deep dive into some of PowerPoint’s most useful features, like shape editing, SmartArt design, and grouping. Once the essentials are covered, we’ll explore the Slide Master and learn how to save a ton of time with templates. We’ll spend some time talking about charts, tables, and integration with Excel. Finally, we’ll go over some of Microsoft's most powerful PowerPoint features, like recording presentations, collaborating with colleagues, and customizing slideshows, animations, layouts, and more.

Start 0:00
Introduction – PowerPoint Beginner 0:09
PowerPoint Start Screen 01:41
PowerPoint Interface 05:58
Slide Layouts and Components 12:55
Themes 17:34
Designer Tool 21:45
Formatting Text 27:34
Formatting Objects with Contextual Tabs 34:48
Inserting and Formatting Text Boxes 43:12
Inserting and Formatting Images 48:11
Image Cropping and Background Removal 55:40
Eyedropper Tool 1:03:09
Saving and Slide Show 1:09:33
Introduction to Object Management, Tables, and Charts 1:12:37
Grouping Objects 1:14:17
Arranging and Aligning Objects 1:20:34
Animating Objects 1:27:50
Inserting Tables 1:33:13
Formatting Tables 1:39:25
Inserting Tables from Excel 1:44:28
Inserting Charts 1:49:25
Formatting Charts 1:53:29
Inserting Charts from Excel 2:01:05
Applying Transitions and Animations 2:05:23
Morph Transition Basics 2:11:12
Creating Morph Transitions 2:13:41
Print 2:19:36
Conclusion 2:20:40
Introduction - PowerPoint Advanced 2:21:32
Custom Ribbon Tab 2:22:31
Useful Options 2:28:37
Introduction to Slide Master 2:32:38
Custom Slide Layouts 2:40:38
Custom Slides with Content 2:45:14
Saving Designs as Templates 2:54:56
Inserting SmartArt 3:02:12
Modifying SmartArt 03:07:28
Adding Content to SmartArt 3:13:10
Introduction to Media, Collaboration, and Slide Shows 3:21:38
Inserting Local Video 3:22:16
Inserting Online Video 3:28:12
Screen Recording Tool 3:35:11
Collaborating on Presentations 3:41:02
Slide Show Options 3:49:18
Zoom Navigation Feature 3:56:59
Presenting, Annotations, and Subtitles 4:02:55
Rehearsing, Recording, and Exporting 4:08:32
Post-Recording Options 4:17:35
Conclusion 4:19:57
Introduction - Copilot for PowerPoint 4:21:01
What is Copilot 4:21:33
Creating Presentations with Copilot 4:25:35
Using Copilot with Templates 4:32:49
Using Copilot with Designer 4:37:17
Adding and Editing Slides 4:41:52
Transforming Documents into Presentations 4:48:16
Asking Questions and Summarizing Presentations 4:52:54
Navigating to Copilot Lab 4:57:34
Copilot Lab 4:58:38
PowerPoint Copilot Web Version 5:05:26
Conclusion 5:13:38
Introduction - PowerPoint Presentation Skills 5:13:49
Get Started Faster - Converting Outlines into Presentations 5:14:26
Using Designer to Add Engaging Visuals 5:20:17
Storytelling with Presentations 5:23:56
How to Improve Presentation Retention Rates 5:25:08
Using SmartArt Infographics to Easily Boost Retention 5:27:01
Using Whiteboards to Increase Engagement 5:33:38
Using Forms to Encourage Participation 5:36:01
Common PowerPoint Mistakes 5:39:36
Visualizing Data with Animated Excel Charts 5:41:52
Mastering the Presenter View 5:45:03
Creating Custom Themes with Slide Master 5:49:37
Customizing Existing Slide Layouts 5:54:24
Creating New Slide Layouts 5:58:08
Following the Rule of Thirds 6:06:37
Creating Reusable Slides 6:13:05
High Contrast Colors 6:21:38
Check Accessibility 6:24:03
Rehearse with Coach Tool 6:27:20
Valuable PowerPoint Tips 6:31:04
Conclusion 6:32:42

#powerpoint #powerpointtutorial #powerpointtraining #powerpointtips #powerpointtricks learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Word Full Course Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/4zbvy7v5

Who it's for: Microsoft Word is for anyone who writes. It’s used by students, CEO’s, and everyone in between.

What it is: Microsoft Word is THE word processor.

What you'll learn: In this Microsoft Word course, students can expect to learn the essential skills needed to create, format, and manage Word documents effectively. The course covers foundational topics such as navigating the Word interface, adding and formatting text, and creating lists. Students will also explore more advanced features like working with images, text boxes, and shapes, as well as utilizing proofing tools to ensure document quality. The course emphasizes hands-on practice, allowing students to pause, complete tasks, and enhance their skills by following along with interactive lessons.

Start 0:00
Introduction 0:09
Start Screen 2:13
Word Ribbon and Interface 5:09
Help and Views 10:06
Font Commands 13:38
Paragraph Commands 21:04
Word Styles 28:04
Lists 34:46
Managing Lists 41:15
Proofing and Saving 46:57
Intro to Module 2 55:29
Contextual Tabs and Text Boxes 56:20
Integrating Shapes 1:04:55
Online Image Library Basics 1:11:40
Resizing and Restyling Pictures 1:19:09
Cropping and Editing Pictures 1:25:26
Page Layout Commands 1:32:02
Headers Footers and converting to PDF 1:38:20
Word Beginner Conclusion 1:49:01
Word Intermediate Introduction 1:50:14
Creating Text Styles 1:51:15
Table Insertion Options 1:59:41
Managing Rows, Columns, and Cells 2:05:55
Table Layouts and Inserting Excel Tables 2:13:45
Inserting and Managing Chart Data 2:20:13
Customizing Chart Elements 2:27:32
Exploring the Quick Parts Gallery 2:34:41
Creating Reusable Content 2:40:41
Module 4 Intro 2:48:07
Themes 2:49:10
Document Formatting Design 2:54:23
Saving Files as Templates 2:58:58
Defining and Managing Columns 3:09:44
Section Breaks 3:14:49
Cover Pages 3:20:29
Table of Contents 3:25:07
Index 3:31:56
Outline View 3:36:31
Mail Merge with Outlook 3:42:38
Word Intermediate Conclusion 3:52:46
Word Advanced Introduction 3:53:52
Inserting Online Video 3:54:51
Inserting Screenshots 3:58:35
Inserting Local Media 4:01:58
SmartArt 4:04:18
Managing SmartArt 4:11:15
Drawing Tools 4:16:37
Drawing Gestures 4:22:59
Sharing Documents for Collaboration 4:26:48
Track Changes 4:32:00
Table of Figures 4:39:50
Hyperlinks and Bookmarks 4:46:26
Footnotes and Endnotes 4:53:56
Research Tool 4:58:41
Citations 5:01:57
Module 6 Introduction 5:05:23
Introduction to Security 5:06:11
Formatting Restrictions 5:11:37
High-Level Restrictions 5:18:10
Forms and Developer Tab 5:24:02
Inserting Form Controls 5:29:27
Securing Forms 5:35:59
Online Forms App 5:42:50
Recording Macros with Shortcuts 5:52:20
VBA Editor 6:00:12
Word Advanced Conclusion 6:10:45
Word Copilot Introduction 6:11:35
Draft with Copilot 6:11:59
Rewrite with Copilot 6:16:12
Visualizing Text as a Table 6:20:57
Reference a File with Copilot 6:24:37
Using Word Copilot Pane 6:28:46
Creating Content from a Document 6:34:13
Copilot with Editor 6:40:13
Getting to Copilot Lab 6:43:56
Copilot for Word Web Version 6:44:55
Word Copilot Conclusion 6:48:25

#microsoftword #wordtutorial #microsoftwordtutorial learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

This is the beginning Microsoft Word course that you've been waiting for! Learn everything you need to effectively use Word by watching just one video. You'll learn the modern Microsoft Word layout, how to create and save Word documents, how to format paragraphs, creating and editing tables, modifying page layouts, printing and publishing options, and more. After watching and mastering this video, you will be able to use Word effectively in almost any professional setting.
Join this channel to get access to perks:
https://www.youtube.com/channe....l/UCYUPLUCkMiUgiyVul

Table of Contents:
00:00 - Intro
00:28 - The Layout of MS Word and Creating a Document
08:24 - Opening and Editing Existing Word Documents
10:29 - Move and Copy Text, and Find and Replace
15:55 - Formatting Characters and Paragraphs
21:44 - Create and Edit Tables
26:28 - Modifying Page Layout
32:35 - Review Tools: Spellcheck, Thesaurus, etc
37:47 - Printing and Publishing Options

***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/techno....logyforteachersandst Here's my playlist of all Microsoft Word videos: https://bit.ly/2FY6NVT Here's the practice file that goes with the video: https://bit.ly/wordforbeginners #msword #wordtutorial #office365 #microsoftoffice #msoffice #microsoft365 #microsoftword
NOW WATCH THE SEQUEL, Microsoft Word for Intermediate Users - The Complete Course: https://youtu.be/1IFfn-0tqeQ

Master SQL – an essential skill for AI, machine learning, data analysis, and more! 📚 This beginner-friendly course teaches you SQL from scratch.

🚀 Want a complete SQL deep dive?
- Check out my full course: https://mosh.link/sql-course
- Subscribe for more awesome content: https://goo.gl/6PYaGF

✋ Want more? Follow me on:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

📕 Get the FREE goodies:
- SQL cheat sheet: https://mosh.link/sql-cheatsheet
- Scripts to create databases: https://bit.ly/3rvtqdO

📖 TABLE OF CONTENT
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

💡 Why Learn SQL?
- It's the standard language for working with databases.
- In-demand skill for developers, data scientists, and more.
- MySQL is popular, open-source, and easy to learn.

👉 This tutorial is perfect for you if:
- You're completely new to SQL.
- You want a practical, hands-on approach.
- You work (or want to work) with data.

#programming #coding

In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.

SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.

👋 Additional resources
- Download & install Microsoft SQL Server: https://www.microsoft.com/en-u....s/sql-server/sql-ser
- Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
- Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ....-whNsNYa3M9O0USq1WhQ
- Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ....-whNsGOcpx-aZS1RN2yA
- SQL Functions: https://docs.microsoft.com/en-....us/sql/t-sql/functio

⌚ Timestamps
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer
44:09 Wrap up

📃 Watch related playlists
- Playlist with all my videos on SQL: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLJxr

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #sql

Tableau Basics Full Course Tutorial (6+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/5fdyc9n2

Who it's for: Data Analysts, Business Intelligence pros, and anyone who works with Big Data on a regular basis.

What it is: Tableau is a popular tool for analyzing and visualizing data, with powerful tools like interactive dashboards, custom reports, and more.

What you'll learn: In this 4-part series, we start with the basics, giving you an overview of Tableau and showing you how to create your first visualizations and dashboards. Then, we jump into working with data, with row-level, aggregate, and table calculations. Next, we refine our visualizations and dashboards to make them look great and tell effective stories. We take some time to go over trends, distributions, and forecasting, and then end with sharing data stories and some advanced Tableau tips and tricks.

Start 0:00
Tableau Fundamentals 0:09
Working with Data in Tableau 35:05
Moving from Simple to Advanced Visualizations 1:28:21
Row-Level and Aggregate Calculations 1:57:38
Table Calculations 2:47:45
Visualization Formatting 3:24:04
Telling Data Stories with Dashboards 3:46:57
Adding Value to Analysis 4:36:24
Making Data Work for You 5:11:38
Advanced Techniques, Tips, and Tricks 5:31:06
Sharing Your Data Story 6:23:07
Conclusion 6:38:18

#tableau #tableaututorial #tableauclasses
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Power BI Basics Beginner Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Data Web Link: https://www.fdic.gov/bank-fail....ures/failed-bank-lis

Exercise Files: https://tinyurl.com/3d7h6ju4

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In the Power BI Basics Beginner course, you will learn foundational skills for using Power BI, a powerful business intelligence tool. The course introduces you to the Power BI Desktop app, walking through its interface and how it shares similarities with other Microsoft 365 products like Excel. You'll discover how to import data from various sources, shape and transform it using Power Query, and create stunning visuals and reports. By the end of the course, you'll know how to build reports with interactive visualizations, create and edit query steps, combine data from different tables, and establish relationships between them, setting you up for more advanced Power BI skills.

Start 0:00
Introduction 0:09
Navigating the PowerBi Interface 4:10
Importing From Data Sources 15:22
Shape tranform combine w power query 22:51
DAX for Creating Tables 35:05
Producing a Report PT 1 Page Setup 43:28
Producing a Report PT 2 Working w Visuals 51:01
Producing Reports PT 3 Working w Slicers 56:55
Conclusion 1:05:28

#powerbi learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Power BI Full Course Tutorial (8+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/y9f8rue6

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

Start 0:00
Introduction 0:03
Introduction to Data Analytics and Power BI 5:16
Data Shaping 1:35:53
Enhancing Data Structure 1:49:49
Designing Data Model 2:02:01
DAX 2:38:38
Optimizing Model Performance 3:33:18
Reports and Accessibility 4:01:14
Dashboards 5:15:49
Paginated Reports 6:20:21
Performing Advanced Analytics 6:54:54
Managing Workspaces 7:44:48
Managing Datasets 8:03:06
Conclusion 8:18:20

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

#powerbi #powerbitutorial
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Excel For Personal Finance Tutorial Ad Free

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/wnymuu6a

Who it's for: This course is designed for anyone who wants to take control of their personal finances using Microsoft Excel. Whether you’re new to budgeting or already familiar with basic spreadsheets, you’ll benefit if you need a structured way to track income and expenses, build interactive financial tools, or visualize where your money is going—all without switching between multiple apps.

What it is: Microsoft Excel is a powerful spreadsheet application in the Microsoft Office suite that enables users to organize, analyze, and visualize data in tabular form. By leveraging built-in formulas and functions, you can perform everything from simple calculations to complex statistical analyses, while features like conditional formatting and data validation help maintain accuracy and highlight key information. Excel also offers robust charting tools—such as line, bar, and pie graphs—alongside advanced capabilities like pivot tables and Power Query for dynamic reporting and data transformation. Widely used across industries, Excel serves as a versatile platform for budgeting, forecasting, project management, and business intelligence.

What you'll learn: Over the course of this tutorial, you’ll learn to create and format expense and income lists as Excel tables complete with total rows, build interactive dropdown menus for faster data entry, and design a consolidated budget sheet that automatically calculates balances and variances. You’ll also link category-level summaries to detailed tables for high-level reporting, track ongoing transactions on a running balance sheet with built-in debits and credits, and leverage Excel’s Quick Analysis tools to compute spending percentages. Finally, you’ll generate visualizations—such as pie charts, tree maps, and column charts—to illustrate spending patterns, build pivot tables and pivot charts with timelines for ad-hoc analysis, and package your workbook as a reusable template for future months or projects.

Start 0:00
Introduction 0:09
Adding Expense Tables 1:38
Building a Simple Budget List 12:39
Building a Simple Budget Table 20:50
Linking Expense Tables into a Budget Table 29:34
Tracking Expenses with Drop-downs 38:12
Tracking Projected Costs vs Actual Costs 46:59
Track Percentage of Expenses 54:20
Creating Budget Charts 58:35
Visualizing Daily Expenses 1:08:19
Inserting Pivot Tables from Our Expense Tracker 1:14:04
Inserting Pivot Charts from Pivot Tables 1:20:09
Using the Timeline 1:26:57
Save Your Budget as a Template for Future Use 1:30:13
Calculate the Future Value of an Investment 1:35:49
Calculate Total Deposits and Interest 1:41:42
Calculate Monthly Payments for a Loan 1:45:49
Forecast Monthly Payments Based on Conditions 1:50:57
Conclusion 1:57:17

#excel #exceltutorial #personalfinance
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Excel For Personal Finance Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/wnymuu6a

Who it's for: This course is designed for anyone who wants to take control of their personal finances using Microsoft Excel. Whether you’re new to budgeting or already familiar with basic spreadsheets, you’ll benefit if you need a structured way to track income and expenses, build interactive financial tools, or visualize where your money is going—all without switching between multiple apps.

What it is: Microsoft Excel is a powerful spreadsheet application in the Microsoft Office suite that enables users to organize, analyze, and visualize data in tabular form. By leveraging built-in formulas and functions, you can perform everything from simple calculations to complex statistical analyses, while features like conditional formatting and data validation help maintain accuracy and highlight key information. Excel also offers robust charting tools—such as line, bar, and pie graphs—alongside advanced capabilities like pivot tables and Power Query for dynamic reporting and data transformation. Widely used across industries, Excel serves as a versatile platform for budgeting, forecasting, project management, and business intelligence.

What you'll learn: Over the course of this tutorial, you’ll learn to create and format expense and income lists as Excel tables complete with total rows, build interactive dropdown menus for faster data entry, and design a consolidated budget sheet that automatically calculates balances and variances. You’ll also link category-level summaries to detailed tables for high-level reporting, track ongoing transactions on a running balance sheet with built-in debits and credits, and leverage Excel’s Quick Analysis tools to compute spending percentages. Finally, you’ll generate visualizations—such as pie charts, tree maps, and column charts—to illustrate spending patterns, build pivot tables and pivot charts with timelines for ad-hoc analysis, and package your workbook as a reusable template for future months or projects.

Start 0:00
Introduction 0:09
Adding Expense Tables 1:38
Building a Simple Budget List 12:39
Building a Simple Budget Table 20:50
Linking Expense Tables into a Budget Table 29:34
Tracking Expenses with Drop-downs 38:12
Tracking Projected Costs vs Actual Costs 46:59
Track Percentage of Expenses 54:20
Creating Budget Charts 58:35
Visualizing Daily Expenses 1:08:19
Inserting Pivot Tables from Our Expense Tracker 1:14:04
Inserting Pivot Charts from Pivot Tables 1:20:09
Using the Timeline 1:26:57
Save Your Budget as a Template for Future Use 1:30:13
Calculate the Future Value of an Investment 1:35:49
Calculate Total Deposits and Interest 1:41:42
Calculate Monthly Payments for a Loan 1:45:49
Forecast Monthly Payments Based on Conditions 1:50:57
Conclusion 1:57:17

#excel #exceltutorial #personalfinance
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Excel Visualize Your Data Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/mrpbhd44

Who it's for: This course is designed for anyone who wants to improve their ability to analyze and visualize data in Excel. Whether you're a beginner looking to understand the fundamentals of data organization or an experienced professional seeking to streamline your reporting and analysis, this tutorial provides valuable insights. It's ideal for business analysts, students, educators, and anyone who regularly works with Excel to make data-driven decisions.

What it is: Excel data visualization is the process of representing data graphically within Microsoft Excel to make complex information easier to understand and analyze. It includes the use of charts, graphs, pivot tables, and conditional formatting to highlight trends, patterns, and insights. With tools like bar charts, line graphs, scatter plots, and heat maps, users can transform raw data into visually appealing and meaningful representations. Excel’s data visualization features help businesses, analysts, and individuals make data-driven decisions efficiently, improving clarity and communication of key metrics.

What you'll learn: In this course, you'll learn how to prepare and normalize your data to ensure accuracy and reliability in your reports. You'll explore the Quick Analysis tool to quickly summarize and format data and use the Analyze Data tool to generate insights and automate data analysis. Additionally, you'll master the creation of pivot tables and pivot charts to visually represent trends and patterns, allowing you to make informed business decisions with ease.

Start 0:00
Introduction 0:09
Data Normalization Explained 1:38
Data Normalization Exercise 3:18
Quick Analysis Tool Part 1 11:51
Quick Analysis Tool Part 2 20:24
Analyze Data Tool 27:22
Pivot Table Practice Session 33:56
Other Insights 46:26
Conclusion 49:06

#excel #microsoft #exceltutorial
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Excel for HR Full Course Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/2t632m6r

Who it's for: HR professionals seeking to improve their data management skills in Excel, particularly in data cleaning, calculations, chart creation, and consolidation techniques tailored for HR tasks.

What it is: Microsoft’s spreadsheet application used to organize and analyze data.

What you'll learn: Students can expect to learn a comprehensive range of Excel functionalities tailored for human resources applications. Key topics include the use of text functions to clean and organize data, formulas and functions like XLOOKUP and TODAY for calculations, and tools like charts for data visualization. The course also delves into advanced features such as consolidating worksheets into cohesive reports, conditional functions like COUNTIF, SUMIF, and AVERAGEIF for data analysis, and implementing dashboards for interactive data summaries. Additional modules cover formatting tables, filtering data using slicers, and creating dynamic charts and sparklines for trend analysis. Through practical exercises, students gain hands-on experience with real-world HR datasets, enhancing their ability to efficiently manage and analyze HR data in Excel.


Start 0:00
Introduction 00:09
Text to Columns Tool 01:32
Flash Fill 05:30
Calculate Length of Service with Today Function 08:47
Calculate Gross Pay and Days Remaining 13:25
Using a Form to Manage Records 19:13
Overview of the IF Function 23:48
Programs Completed by Employee with Countif 28:37
Cost of Training by Employee with Sumif 32:24
Naming Ranges for Reuse 35:48
Average Cost per Program with Averageif 40:27
Overview of Xlookup 44:25
Return Employee Details Based on Employee Number 50:31
Consolidate Sheets into a Single Report 57:02
Inserting a Chart 01:02:43
Managing an Inserted Chart 01:09:36
Capture Trend Analysis with Sparklines 01:14:39
Introduction to Module 2 01:19:13
Filtering a Converted Table 01:19:49
Table Slicer Tool 01:24:45
Total Row 01:28:32
Conditional Formatting 01:31:23
Subtotal Tool 01:35:59
Restrict Cell Input with Data Validation 01:40:11
Import Data From Other Source 01:44:04
Inserting a Recommended Pivot Table 01:46:56
Show Value as Percent of Grand Total 01:50:59
Drill Down Reports 01:54:16
Report Filter Pages 01:56:43
Inserting a Pivot Chart 02:00:21
Conclusion 02:02:57

#excel #exceltutorial #exceltips #exceltricks
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Excel for HR Advanced Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/2t632m6r

Who it's for: HR professionals seeking to improve their data management skills in Excel, particularly in data cleaning, calculations, chart creation, and consolidation techniques tailored for HR tasks.

What it is: Microsoft’s spreadsheet application used to organize and analyze data.

What you'll learn: Students taking this course will gain a comprehensive understanding of advanced Excel tools tailored for human resource management. They will learn to utilize table tools, conditional formatting, and subtotals to efficiently organize and analyze data. The course delves into creating and managing pivot tables for advanced reporting, including drill-downs and visualizations with pivot charts. Participants will also explore data validation techniques to ensure data integrity and utilize slicers for dynamic filtering. These skills will empower students to handle HR data with precision, enhance decision-making, and create professional, interactive reports.


Start 0:00
Introduction 00:09
Filtering a Converted Table 01:04
Table Slicer Tool 06:00
Total Row 09:47
Conditional Formatting 12:38
Subtotal Tool 17:14
Restrict Cell Input with Data Validation 21:26
Import Data From Other Source 25:19
Inserting a Recommended Pivot Table 28:11
Show Value as Percent of Grand Total 32:14
Drill Down Reports 35:31
Report Filter Pages 37:58
Inserting a Pivot Chart 41:36
Conclusion 44:12

#excel #exceltutorial #exceltips #exceltricks
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

More Online Software Training: http://www.learnitanytime.com/

-Unlimited Excel, Outlook, PowerPoint, Access, MS Office, PhotoShop, Web Design, & lots more!

-17 years teaching software to industry leaders.

-Easy to follow: beginner through advanced.

-Feel secure: Ask a teacher if you have questions.

Learn Excel 2010, How to import data from the Web. To learn more about other Microsoft programs, and to watch more excel training videos subscribe, and visit us at http://learnit.com

-Unlimited Excel, Outlook, PowerPoint, Access, MS Office, PhotoShop, Web Design, & lots more!

-17 years teaching software to industry leaders.

-Easy to follow: beginner through advanced.

-Feel secure: Ask a teacher if you have questions.

Learn how to use Microsoft Excel 2010, and discover how to Data Mine. For more Microsoft Excel 2010 training videos, and to learn how use other Microsoft apps subscribe, and visit us at http://learnit.com


-Unlimited Excel, Outlook, PowerPoint, Access, MS Office, PhotoShop, Web Design, & lots more!

-17 years teaching software to industry leaders.

-Easy to follow: beginner through advanced.

-Feel secure: Ask a teacher if you have questions.