Microsoft Office & Productivity

Home
Articles

Excel for Finance and Accounting Full Course Tutorial (3+ Hours) Origin Course 25 Views • 27 days ago

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 Data Analysis Full Course Tutorial (7+ Hours) Origin Course 32 Views • 27 days ago

Excel Data Analysis Full Course Tutorial (7+ 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/53hddw2b

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our standard Excel training, or at a minimum already be proficient in the skills referenced in that content.

What it is: Our Excel Data Analysis Full Course Tutorial is a compilation of our Excel Intro to Data Analysis, Excel Pivot Tables, Excel Copilot, and Excel Power User courses.

What you'll learn: At over 7 hours long, our Excel Data Analysis Full Course Tutorial introduces learners to the fundamentals of data analysis, before expanding on that to cover all the top advanced features Excel offers. From advanced functions, Pivot Tables, and Copilot integration to XLOOKUP, VBA, and macros, get the most out of Excel with this comprehensive mega-course.

Start 0:00
Introduction - Excel Intro to Data Analysis 0:09
List Design Basics 1:25
Inserting Tables for Analysis 4:59
Filtering Data in Tables 9:57
Using the Total Row 15:10
Conditional Formatting 18:57
IF Function 25:23
SUMIF and AVERAGEIF 31:52
SUMIFS 39:22
Inserting Recommended Charts 42:37
Adjusting Charts 48:24
Sparklines 50:41
Inserting Pivot Tables 57:25
Displaying Data as Count 1:05:18
Filtering Pivot Tables 1:09:06
Inserting Pivot Charts 1:17:47
Conclusion - Intro to Data Analysis 1:22:04
Introduction - Excel Pivot Tables 1:22:59
What are Pivot Tables? 1:24:05
Preparing Data for Analysis 1:29:39
Pivot Table Components 1:34:12
Building Pivot Tables to Show Different Values 1:40:30
Adding Fields to Pivot Tables 1:45:45
Using Built-In Filters 1:52:34
Filtering Data with Slicers 1:58:24
Displaying New Values from Data Sources 2:05:14
Inserting Pivot Charts 2:11:45
XLOOKUP 2:18:37
Joining Data Sets with XLOOKUP 2:26:48
Introduction to Advanced Pivot Tables 2:34:41
Inserting Pivot Tables from Tables 2:36:07
Calculated Fields 2:43:53
Using the Timeline Tool 2:49:43
Report Filter Pages 2:54:59
Pivot Table Layouts 3:01:42
Creating Pivot Table Designs 3:08:06
Adding Power Pivot Tabs to the Ribbon 3:15:32
Adding Tables to Power Pivot Data Model 3:18:15
Creating Table Relationships 3:23:17
Creating Columns with DAX Expressions 3:27:28
Displaying New Source Data in Power Pivot Tables 3:34:54
Data Mining with Flash Fill 3:37:45
Conclusion - Excel Pivot Tables 3:43:48
Introduction - Excel Copilot 3:44:39
What is Copilot? 3:45:04
Setting Up Copilot in Excel 3:49:05
Copilot Pane and Insights 3:51:54
Visualizing Data with Copilot 3:58:08
Sorting, Highlighting, and Filtering 4:06:16
Adding Formulas with Copilot 4:14:52
Asking Copilot Questions 4:20:37
Accessing Copilot Lab 4:29:44
Copilot Lab 4:30:58
Copilot with Excel Web Version 4:37:47
Conclusion - Excel Copilot 4:41:20
Introduction - Excel Power User 4:41:32
IF Function Basics 4:43:04
IF Functions with Calculations 4:49:20
Nesting AND with IF 4:53:43
Naming Ranges and COUNTIF 5:00:02
SUMIF and AVERAGEIF 5:05:59
SUMIFS 5:10:54
XLOOKUP 5:14:56
Populating Forms with XLOOKUP 5:23:21
Displaying Pivot Table Fields with COUNT Function 5:31:57
Calculated Fields 5:36:47
Slicers 5:43:33
Using the Timeline 5:49:42
Inserting Report Filter Pages 5:54:57
Flash Fill for Text Functions 5:59:38
Introduction to Advanced Conditional Formatting and Macros 6:05:55
Array Formula Basics 6:06:42
Looking Up Multiple Values with XLOOKUP 6:13:00
Array Functions 6:18:01
Advanced Conditional Formatting 6:25:08
Combo Charts 6:32:36
Developer Tab 6:40:18
Macro Basics 6:44:31
Relative Reference Macros 6:51:07
VBA Basics 6:55:07
Cleaning Up Macros 7:01:51
Conclusion - Excel Power User 7:10:22

#excel #exceltutorial #exceltips #exceltricks #dataanalytics #datavisualization
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 Power User Tutorial Origin Course 31 Views • 27 days ago

Excel Power User 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/5e9dh56n

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our standard Excel training, or at a minimum already be proficient in the skills referenced in that content.

What it is: Our Excel Power User course expands on the idea that the tools by themselves are only part of the equation. To say that you’re capable of solving a problem is enough for most users, but participants in this course aren’t most users. The desire to learn and invest time in building resources that solve problems faster and with less effort is a key quality of the power user and something the course maintains a heavy focus on.

What you'll learn: In this series, students will learn how to intermix tools in Excel to accomplish time-intensive tasks. Students will learn to develop a deeper understanding of conditional functions and data mining tools like XLOOKUP, the leveled-up version of VLOOKUP. Throughout the course, users will learn how to expedite data analysis through dynamic ranges and how to push Excel to the edges of what’s possible out of the box with new perspectives on how to think their way through challenging problems.

You’ll learn how to easily create, modify, and update Pivot Tables and charts. In no time, take a very large dataset and create a table that only displays the information you need. Then, learn all the steps to make your Pivot Tables great: data cleanup, manipulation, aggregate functions, pivot charts, big data, and even "Power" features.

Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. Learn all about data analytics in Excel with tools like table formatting, charting, Pivot Tables, and much more.

Finally, we'll explore a wide range of tips and tricks that will help you work smarter, faster, and more efficiently with Excel. Plus, you’ll get a taste of Macros and Excel VBA.

Start 0:00
Introduction 0:09
IF Function Basics 2:10
IF Functions with Calculations 8:26
Nesting AND with IF 12:49
Naming Ranges and COUNTIF 19:08
SUMIF and AVERAGEIF 25:05
SUMIFS 30:00
XLOOKUP 34:01
Populating Forms with XLOOKUP 42:27
Displaying Pivot Table Fields with COUNT Function 51:03
Calculated Fields 55:53
Slicers 1:02:39
Using the Timeline 1:08:48
Inserting Report Filter Pages 1:14:02
Flash Fill for Text Functions 1:18:44
Introduction to Advanced Conditional Formatting and Macros 1:25:00
Array Formula Basics 1:25:47
Looking Up Multiple Values with XLOOKUP 1:32:05
Array Functions 1:37:07
Advanced Conditional Formatting 1:44:14
Combo Charts 1:51:41
Developer Tab 1:59:24
Macro Basics 2:03:37
Relative Reference Macros 2:10:13
VBA Basics 2:14:13
Cleaning Up Macros 2:20:57
Conclusion 2:29:28

#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 Full Course Tutorial (4+ Hours) Origin Course 34 Views • 27 days ago

Excel Full Course Tutorial (4+ 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/5bzwe2p7

Who it's for: Beginners, as well as experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.

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

What you'll learn: We start with the basics, showing you Excel’s interface and the best 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 Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Next, we cover Charts and Sparklines, along with some tips on presenting data in Excel. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with an overview of XLOOKUP, a vital function for modern-day Excel users. After that, we explore complex Database functions, provide you with an introduction to Macros, and demonstrate how to save time by automating common Excel tasks.

Start 0:00
Introduction 0:09
What is Excel? 1:16
Excel Interface Overview 2:40
Search and Help 9:06
Navigating and Selecting Cells 11:48
Entering, Replacing, and Deleting Data 16:05
Adjusting Cells 25:56
Calculations, Formulas, and Functions 30:29
Basic Functions 43:31
AutoFill 50:39
Relative and Absolute Cell Reference 55:05
Saving and Sharing Workbooks 1:01:13
Comments 1:05:11
Inserting Rows and Columns 1:07:39
Cut, Copy, and Paste 1:10:33
Formatting Data with Cell Styles 1:14:35
Managing Worksheets 1:20:28
Hiding Row and Columns 1:25:04
Creating Custom Views 1:26:57
Reviewing Worksheets 1:30:24
Printing Worksheets 1:33:37
Conclusion 1:38:19
Introduction 1:38:27
Creating Tables 1:38:43
Flash Fill 1:45:43
Introduction to Sorting Data 1:49:50
SORT Function 1:56:35
SORTBY Function 1:59:21
UNIQUE Function 2:01:10
Filters 2:03:33
Slicers 2:09:00
Subtotals 2:12:42
Quick Analysis Tool 2:17:51
Inserting Charts 2:19:00
Formatting Charts 2:21:22
Creating Chart Templates 2:27:19
Printing Charts 2:29:04
Using Sparklines 2:30:18
Introduction to Pivot Tables 2:34:17
Pivot Charts 2:42:32
Using Slicers with Pivot Tables 2:45:29
Data Validation 2:49:42
Conditional Formatting 3:01:25
Custom Conditional Formatting 3:05:05
Linking Data 3:09:40
Conclusion 3:11:28
Introduction 3:12:00
Named Ranges 3:12:14
Multiple Named Ranges 3:16:53
XLOOKUP 3:19:23
Data Mining with XLOOKUP 3:27:30
IF Function 3:35:23
Database Functions 3:42:37
Goal Seek 3:51:01
PMT Data Tables 3:55:23
Macros 4:00:24
IF-THEN Statements 4:07:00
Do Until Loops 4:14:48
Creating Games with Excel VBA Code 4:21:12
Conclusion 4:28:04

#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.

Showing 5 out of 5

Please note that if you are under 18, you won't be able to access this site.

Microsoft Office & Productivity

Language