Top videos
Excel for Finance and Accounting Full Course Tutorial (3+ 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/rxvb4utb
Who it's for: Professionals using Excel to tackle practical tasks around financial data.
What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.
What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.
Start 0:00
Introduction 0:09
Introduction to Excel 1:38
Data Entry Basics 4:14
Rows and Columns 7:12
Open, Save, and Print 9:34
Formatting Basics 12:37
Formatting in Cells 16:35
Conditional Formatting 20:17
Freeze Panes and Split Screen 23:38
Quick Access Toolbar and Keyboard Shortcuts 27:16
Basic Functions 31:31
IF Statements 37:03
SUMIF and AVERAGEIF 41:06
LEFT, RIGHT, MID, and Flash Fill 46:26
COUNTIF and COUNTIFS 51:31
Conclusion 56:07
Introduction 56:46
Date and Time Functions 57:59
Data Validation 1:01:35
VLOOKUP 1:05:52
INDEX and MATCH 1:10:42
XLOOKUP 1:17:03
Goal Seek and Scenario Manager 1:20:58
PV and FV 1:26:33
NPV 1:31:26
XNOV 1:33:01
IRR 1:35:12
Loan Schedule with PMT 1:38:01
PPMT 1:40:27
IPMT 1:43:21
CUMIPMT 1:46:32
Loan Schedule Templates 1:50:17
Conclusion 1:53:57
Introduction 1:54:58
Bar Charts 1:55:47
Area Charts 1:58:38
Pie and Donut Charts 2:01:38
Combo Charts 2:04:02
Waterfall Charts 2:06:20
Football Field Charts 2:08:43
Sparklines 2:18:00
Pivot Tables 2:21:17
Pivot Charts 2:27:40
Sorting and Filtering 2:31:26
Regression Analysis 2:36:30
Analyze Data 2:44:03
Stock Charts 2:46:54
Purchase Price Variance 2:49:31
Conclusion 2:51:39
Introduction 2:52:25
Building Data Rates 2:53:06
Calculating HPR Rates of Return 2:56:10
Statement Model 3:02:26
Income Statements 3:04:16
Operating Costs 3:12:53
Operating Expenses and Interest 3:16:44
Taxes 3:18:34
Net Income 3:20:34
Capital Expenditure and Depreciation Schedule 3:23:14
Setting Up Balance Sheets 3:28:58
Balance Sheet Forecasts 3:32:20
Cash Flow Statements 3:46:02
Statement Model Check 3:56:08
Conclusion 3:58:09
#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 2019 Pivot Tables 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/42t7ae2s
Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.
What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.
What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.
Start 0:00
Introduction 0:03
Data Mining 2:40
Adding Related Data Using VLOOKUP 13:35
Inserting Pivot Tables 26:23
Setting Up Pivot Tables 30:51
Building Pivot Tables 36:56
Filtering and Slicing Pivot Table Data 42:21
Changing Source Data and Refreshing Pivot Tables 48:23
Inserting Pivot Charts 55:17
Using Tables to Build Pivot Tables 59:28
Finding Correct Layouts for Reports 1:05:37
Setting Default Layouts for Reports 1:11:03
Using Pivot Table Styles 1:14:25
Subtotals and Grand Totals 1:18:03
Creating Report Pages 1:20:31
Adding the Power Pivot Tab to Excel 1:27:13
Creating Tables for the Data Model 1:30:36
Adding Relationships with Power Pivot 1:34:32
Using DAX Expressions with Power Pivot 1:40:18
Creating Pivot Tables with Power Pivot 1:42:21
When to Use Power Pivot 1:46:03
Conclusion 1:47:33
#excel
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 2019 VBA Intermediate Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u
Exercise Files: https://tinyurl.com/yvfmez5e
Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.
What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.
What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Start 0:00
Introduction 0:03
Introduction to Expressions, Variables, and Intrinsic Functions 2:06
Variables - Overview, Naming Rules, and Conventions 3:48
Variable Declaration Methods and Scope5:35
VBA Data Types 7:40
Option Explicit Statement and Removing Variables from Memory 9:26
Concise Ways to Declare Variables 13:43
Declaring Procedure Level String Variables and Reviewing Intrinsic Functions and VIN Characters 17:19
Assigning Values to Variables Using Intrinsic Functions and the Line Editor 21:14
Testing the Sub Procedure and Introduction to the With-End With Structure and the Offset Property 28:26
Creating a With-End With Structure that References the Offset Property and Testing the Procedure 33:40
Troubleshooting the Procedure and Re-Testing It 37:44
Saving Files as Macro-Enabled 40:50
Overview of MsgBox and InputBox Functions 41:24
Modifying an Event Procedure to Include a Message Box 46:56
Testing the Message Box Function 51:44
Modifying a Sub Procedure to Include an Input Box 52:56
Testing the Input Box Function 59:45
Overview of Object Variables 1:01:03
Using Object Variables in a Sub Procedure 1:02:38
Testing a Sub Procedure by Stepping Into It 1:10:33
Expressions, Variables, and Intrinsic Functions Recap 1:15:04
Introduction to Controlling Program Execution 1:18:24
Controlling Program Execution and Control of Flow Structures 1:19:02
Boolean Expressions, Logical Operators, and Comparison Operators 1:21:10
Overview of the If-Then Constructs 1:24:40
Using the If-Then-End If Construct 1:27:01
Creating a Function Procedure Using the If-Then-Else-End If Construct 1:30:32
Calling a Function Procedure from a Sub Procedure 1:34:47
Testing the Function Procedure and Modifying the Code 1:37:54
Creating a Function Procedure to Extract the Year from the VIN 1:39:55
Testing the Year Extraction Function 1:43:30
Creating a Function Procedure Using the If-Then-ElseIf-End If Construct 1:44:14
Creating a With-End With Structure for Concise Code - Testing Procedure 1:47:47
Select Case Overview - End Select Construct 1:50:29
Creating Functions Using the Select Case - End Select Construct 1:51:20
Creating Functions by Using a Text File 1:55:13
On Your Own - Creating a Function to Extract the Make 1:58:24
Testing Final Three Function Procedures for Extraction 2:00:11
Overview of Looping Constructs 2:00:56
Using a Do While Loop to Populate the Spreadsheet 2:04:14
Creating Procedures to Append and Clear Info on Sheets 2:08:20
Testing the Append and Clear Sheet Procedures 2:14:19
Avoiding Errors by Using an If-Then-Else Construct 2:15:01
Using the For-Each-Next Loop 2:22:58
Controlling Program Execution Recap 2:27:46
Conclusion 2:28:51
#excel #exceltutorial #exceltips #vba #excelvba
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.
PowerPoint 2021 Full Course Tutorial (3+ 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/797x4r4e
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 2021 is the latest version of Microsoft’s legendary presentation tool. It’s jam-packed with enhancements to old, trusty features, along with a few new advancements. Heighten the quality of your presentations with PowerPoint 2021.
What you'll learn: In this course, we’ll take a deep dive into some of PowerPoint’s most useful features, like shape editing, SmartArt design, and grouping. Once the basics are covered, we’ll explore the slide master and learn how to save a ton of time with templates. 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 0:09
Start Screen 0:38
PowerPoint Interface 6:41
Search and Help 13:28
Creating Slides 17:10
Shortcuts 22:54
Text Editing 27:43
Graphics 36:48
Eyedropper 50:58
Modifying Objects 56:00
Tables 1:05:39
Inserting Tables from Excel 1:14:25
Charts 1:21:51
Morph Transition 1:30:58
Reviewing Presentations 1:41:15
Conclusion 1:50:21
Introduction 1:51:18
Toolbar Customization 1:51:48
Options 1:55:01
Slide Master 2:00:19
Custom Layouts 2:07:17
Creating SmartArt 2:12:04
Modifying SmartArt 2:21:20
Animating SmartArt 2:27:54
Equations and Symbols 2:32:08
Implementing Audio 2:41:54
Implementing Video 2:48:31
Screen Recorder 2:57:28
Outlines 3:02:18
Custom Animation 3:08:12
Collaboration 3:15:51
Custom Slideshows 3:24:00
Setting Up and Annotating Slideshows 3:27:36
Zoom 3:33:31
Recording Presentations 3:43:40
Conclusion 3:57:04
#powerpoint #powerpoint365 #powerpointtutorial
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 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
Exercise Files: https://tinyurl.com/3ffzsds3
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: Beginners will learn the kind of basics that all computer users should know. If you're already working with Microsoft Word, this course also offers a deeper look at the features and functionality of the program.
Start 0:00
Introduction 0:09
Start Screen: 2:22
Word Ribbon and Interface: 5:18
Help and Views: 10:15
Font Commands: 13:47
Paragraph Commands: 21:14
Word Styles: 28:15
Lists: 34:57
Managing Lists: 41:27
Proofing and Saving: 47:09
Intro to Module 2: 55:41
Contextual Tabs and Text Boxes: 56:33
Integrating Shapes: 1:05:07
Online Image Library Basics: 1:11:53
Resizing and Restyling Pictures: 1:19:22
Cropping and Editing Pictures: 1:25:39
Page Layout Commands: 1:32:16
Headers Footers and Converting to PDF: 1:38:35
Conclusion: 1:49:17
#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.
Google Sheets 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/449mzrsf
Who it's for: This Google Sheets course is designed for anyone new to spreadsheets or transitioning to cloud-based tools. Whether you're a complete beginner or someone who wants to brush up on foundational skills, this course caters to students, professionals, educators, and small business owners seeking a solid grasp of Google Sheets for everyday tasks such as tracking data, organizing lists, or analyzing basic information.
What it is: Google Sheets is a cloud-based spreadsheet application within Google Workspace that lets users create, edit, and collaborate on data in real time from any device with an internet connection. It offers familiar spreadsheet functionality—such as formulas, functions, formatting, and charting—while uniquely enabling seamless sharing, simultaneous multi-user editing, automatic version history, and integration with other Google services like Forms and Drive. With built-in tools like Smart Fill, conditional formatting, and add-ons, Google Sheets empowers individuals and teams to organize, analyze, and visualize data efficiently without installing any software locally
What you'll learn: Students will learn how to navigate the Google Sheets interface, enter and format data, and perform essential calculations using formulas and functions. The course covers autofill techniques, Smart Fill, absolute vs. relative cell references, formatting with themes and styles, sorting and filtering data, creating visualizations with charts, using checkboxes, and applying conditional formatting. By the end, students will be able to confidently organize, analyze, and present data in Google Sheets.
Start 0:00
Introduction 0:09
Google Sheet Interface 1:09
Adding Headers and Adjusting Column Widths 9:49
Using Smart Fill 16:30
Entering Data 20:58
Calculations, Formulas, and Functions 23:55
Using Average Function 33:15
IF Function with Absolute Cell Reference 36:42
Formatting Our Worksheet 43:14
Checkboxes 48:18
Google Sheets Beginner Conclusion 54:08
Google Sheets Intermediate Introduction 54:56
Creating a Table 55:24
Sorting Data 1:04:28
Filtering Our Data 1:09:54
Visualizing Data with Charts 1:15:18
Sparklines 1:25:21
Working with Pivot Tables 1:32:24
Data Validation 1:43:17
Conditional Formatting 1:52:34
Linking Data 2:01:53
Inserting Comments 2:05:25
Google Sheets Intermediate 2:08:54
Google Sheets Advanced Introduction 2:09:18
Creating Named Ranges 2:09:59
Naming Multiple Ranges 2:15:13
Accessing Name Ranges Manager 2:16:42
XLOOKUP Function 2:17:50
XLOOKUP Approximate Match 2:24:13
Data Mining with XLOOKUP 2:28:31
IF & IFS Function 2:36:55
Database Functions 2:46:12
PMT Function 2:54:18
Smart Chips 3:03:11
Google Sheets Advanced Conclusion 3:10:25
#sheets #tutorial #googleworkspace
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.
Python Course By Saumya Singh ( Project - 02 - Personal Chat Assistant )
Download Python Course Certificate for Free - https://gsjqmh.courses.store/766185
Download Internship + Job Ready Kit (paid) - https://gsjqmh.courses.store/758133
I’m Saumya Singh, a Software Engineer with 5+ years of industry experience and a passion for teaching. Alongside my job, I’ve been creating educational content to help students and professionals grow in tech.
In this complete Python course, we’ll learn Beginner to Advanced concepts along with AI & Machine Learning to make you job-ready in 2026 and beyond.
This is just the beginning - we’ll continue bringing more tutorials, projects, and career-focused guidance for our amazing subscribers! 💙
Important Links & Notes - https://whatsapp.com/channel/0....029VbAnnzw6hENpACnPo
✨Share Your Progress & Learnings on✨
Instagram: https://insta.openinapp.co/2xour
LinkedIn: https://linkedin.openinapp.co/oj87l
Twitter: https://twtr.openinapp.co/bo6dj
✨Android App Development Playlist | 30 Days of Coding Challenge✨
youtube.com/playlist?list=PLTV_nsuD2lf4UCTV6xwvNPvFdmCNKyhc8
✨Mission Placement - Land Your Dream Job With Saumya Singh. ✨
https://youtube.com/playlist?list=PLTV_nsuD2lf4hfQvqKRToCXtVB7-6rZnz&si=Dtm9oPUzooYAkA2c
video covers:-
python project, python real life project, python project ideas, python course 2026, saumya singh chapter 7 python course, free python course with certificate, python course certificate 2026, loop in python concept, beginner to advance python course,python course for beginners,Python Tutorial For Beginners in Hindi,complete python course, python course from beginner to advanced, python course in hindi, free python course,
python course 2026, python course for beginners,Python Tutorial For Beginners in Hindi,complete python course, python course from beginner to advanced, python course in hindi, free python course, how to install python, how to install code editor, how to install vs code, python course 2026 beginner to advance , how to learn python, How to learn python 2026, features of python, python course for first year college student, saumya singh python course
#python #programming #pythoncourseinhindi #coding #ai #ml #softwareengineer #saumyasingh
python Tutorial For Beginners in Hindi | Complete Python Course
Python Full Course for Beginners [2026]
Python Full Course 2026 (Beginner to Advanced) + AI & Machine Learning | Free Tutorial
Python Tutorial 2026 | AI + Machine Learning | Beginner to Pro | Saumya Singh
Python Beginner to Advanced With AI & ML (Full Course 2026) | Step-By-Step
Learn Python in 2026 | Complete AI & Machine Learning Course for Beginners
Python Full Roadmap 2026 | Beginner to Advanced | AI, ML, Projects & Tips
in this course we will launch some chapters. all chapters are totally free of cost for students. keep sharing your feedbacks on comments & love you all 🙈
Excel 2019 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
Exercise Files: https://tinyurl.com/k7acppwc
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
Start 0:00
Introduction 0:03
Start Screen & Templates 0:59
Ribbon & Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup & Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting & Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving & Copying Data 1:09:15
Inserting Rows & Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58
#excel
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.
Trello 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: No Exercise Files for this Course
Who it's for: This course is designed for individuals and teams at any skill level who want to manage tasks, workflows, and projects more efficiently using Trello. It's ideal for professionals, project managers, students, freelancers, and anyone looking to enhance personal or team productivity through a flexible and visual project management tool.
What it is: Trello is a visual project management tool based on the Kanban system, designed to help individuals and teams organize tasks and workflows. It uses boards to represent projects, lists to indicate stages of progress, and cards to represent individual tasks. Users can customize boards to fit any type of project, from personal goals to team-based initiatives. Trello makes it easy to track progress, prioritize tasks, collaborate with others, and add elements like due dates, labels, attachments, and checklists, all within a simple and intuitive interface.
What you'll learn: You'll begin by mastering the basics of Trello, including creating boards, lists, and cards. As the course progresses, you'll explore advanced features like labels, checklists, attachments, calendar integration, card relationships, and collaboration tools. You'll also learn to automate workflows, apply filters, use Power-Ups, enable Google Calendar sync, and integrate with external tools like Google Drive. Additionally, you'll discover how to send tasks to Trello via email, navigate using keyboard shortcuts, utilize Chrome extensions, and manage Trello via the mobile and desktop apps—making you a confident and efficient Trello user.
Start 0:00
Introduction 0:09
Kanban Board - A new way of organizing stuff 1:04
Overview of what is a board 3:08
How to create boards and lists 6:00
How to create and move Cards 9:04
How to rename a board 11:45
Different ways to Attach stuff 12:16
Adding new users to board 15:15
How to set Due Dates 17:20
Done 19:31
How to create and add Labels 21:06
How to create and assign checklists 13:52
Beginner Conclusion 26:23
Trello Intermediate Introduction 26:50
How to copy existing cards 28:02
Why would you want to subscribe to cards 30:14
Archiving is the new deleting 31:44
How to change backgrounds 34:16
Only see the stuff you want to see - Card Filtering 35:59
Add fun Stickers to your cards 38:02
How to comment on cards 40:18
How to leave a board 43:19
How to change Board Visibility (Private Vs. Public) 44:16
How to find out what cards are assigned to you 46:31
How to start your most used boards 48:19
How to copy and paste checklists 49:47
How to create a card by copy and pasting 52:25
Experience the magic of cloud 53:17
How to link to other Trello Card 54:30
How to Sync Trello with your Google Calendar 58:49
Board Creation from Scratch 01:01:59
Intermediate Conclusion 1:04:47
Trello advanced introduction 01:05:18
Send an Email directly in to Trello 01:06:12
Send an email to your Board 01:12:11
What are links to cards and boards 01:17:16
Try out some time saving Shortcuts 01:20:53
Take your Trello board to the next level with Power ups 01:24:59
Update to Power-ups 01:30:37
How to format your text 01:32:14
Chrome extensions that work with Trello 01:34:52
Demo of Trello App 01:39:36
Advanced Conclusion 01:40:53
#trello #tutorial #fullcourse
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.
Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video
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/y2n7rkc6
Learn Microsoft 2016 from the pro's. In this FREE beginners tutorial for Microsoft 2016 you will learn the basics of Excel 2016, and Tips and Tricks so that you can get the most out of your Excel experience. Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
Some of the other topics in the Microsoft Excel 2016 tutorial include:
Start Screen & Templates, Ribbon & QA Toolbar - Part 1, Ribbon & QA Toolbar - Part 2, Backstage View, Interface, Share Pane, Tell Me, Smart Lookup, Navigating, Keyboard Shortcuts, Entering Text
Formatting Numbers, Deleting & Formatting, AutoSum, Simple Formulas, Simple Functions, Absolute Referencing, Inserting Rows
Inserting Columns, Moving & Copying Data, Autofill, Cell Styles, Worksheet Themes, Excel Templates, Grouping Worksheets, Freeze Panes, Custom Views, Spell Check, Printing, Flash Fill, List Design & Single Level Sorting, Multi-Level Sorting, Custom Sorting, Filtering, Multi-Level Filtering, Search Filtering, Format as Table, Table Style Options, Remove Duplicates, Convert to Range, Subtotal, Multi-Level, Subtotaling, Remove Subtotals, Quick Analysis Charts, Inserting Data Charts, Formatting Data Charts, Chart, Templates, Spark lines, Printing Charts, Importing From Web, MS Query, Exporting Overview, Pivot Tables, Multiple-Field Pivot Tables, Drill Down Reports, Pivot Charts & Grouping Fields, Slicer Tool, Data Validation - Part 1, Data Validation - Part 2, Cell & Sheet Protection, File Encryption, Conditional Formatting, Linking Data, Inserting Comments.. and more
Please subscribe to Learn iT! and check out our website (http://learnit.com) to browse other Microsoft Courses, Project Management, and IT Training courses.
#excel
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 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.
Excel 2021 XLOOKUP 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/ye233pnt
Who it's for: All Excel users, especially those looking for the next best feature.
What it is: XLOOKUP is a powerful new lookup function in Excel, letting users search for and find items in a table faster than ever before.
What you'll learn: First, you'll learn about VLOOKUP and Index and Match, the precursors to XLOOKUP. We'll talk about what makes those functions fantastic and what makes them lacking in certain areas. Then, we'll explain why XLOOKUP is a huge improvement and how to properly use it to level up your Excel performance.
Start 0:00
Introduction 0:03
VLOOKUP Refresher 3:59
XLOOKUP Basics 11:42
INDEX and MATCH 17:03
XLOOKUP - Approx Match Results 20:36
XLOOKUP - Returning Multiple Values 23:39
XLOOKUP - Two Way Search 26:14
Conclusion 29:12
#excel #exceltutorial #exceltips #xlookup
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.
