MyOnlineTrainingHub
INSTANT Forecasts with Built-in Excel Tool - incl. Chart and all Formulas!
updated
With this trick we can use Slicers to control both Python charts and Excel charts at the same time. Suitable for Excel dashboards and more.
⬇️DOWNLOAD the Excel & CSV files here: myonlinetraininghub.com/interactive-python-charts-in-excel
📝 Note: Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join
PQ Learn Power Query: myonlinetraininghub.com/excel-power-query-course
❓ Will you be using Python Charts in Excel? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Interactive Python Charts in Excel
0:28 Connect Python in Excel to Power Pivot
2:18 Create Python Dataframe
4:11 Setting up the Slicer
5:17 Capturing Selections in Slicer
6:33 Filtering the dataframe with Slicer
7:43 Creating the Python Chart in Excel
10:27 Create Pivot Chart Connected to Slicer
12:50 Limitations
1. CTRL+ALT+SHIFT+P Opens the Python editor in the current cell.
2. CTRL+ENTER enters the Python formula.
3. CTRL+F2 toggles between edit mode in the cell and the formula bar.
4. CTRL+SHIFT+U expands/collapses the formula bar.
💡Tip: Shortcuts 3 and 4 work in all cell edit modes.
❓Do you know Python, or will you be using ChatGPT to help you write it? Please let me know in the COMMENTS.
🎁 COMMENT, SHARE & LIKE this video and spread the Excel love.
🎓LEARN Python in Excel with me here: myonlinetraininghub.com/python-in-excel
🔖FOLLOW me on LinkedIn for more tips like this: https://lnkd.in/gSfhwJKk
Don't know Python, don't worry, I'll show you how to use ChatGPT to write the Python code for you and cover the error messages you might experience.
⬇️DOWNLOAD the example file here: myonlinetraininghub.com/python-in-excel
📝 Note: At the time of recording Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join
❓ Are you excited about Python in Excel? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Python in Excel
0:57 Import Python Libraries in Excel
1:57 Defining Dataframes from Excel Data
3:16 Descriptive Statistics in Python
4:05 How to Use ChatGPT to Write Python
6:27 How to Create Python Charts in Excel
9:11 Python Errors in Excel
⬇️DOWNLOAD the example file here: myonlinetraininghub.com/excel-dynamic-named-ranges
📚RELATED LESSONS
- INDEX & MATCH in 4 Minutes: myonlinetraininghub.com/excel-index-and-match-functions
- Relative Named Ranges: myonlinetraininghub.com/relative-named-ranges
- Excel Tables Alternative: myonlinetraininghub.com/excel-tables
❓What do you prefer to use for your dynamic named ranges? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Excel Dynamic Named Ranges
1:13 Dynamic Named Ranges with INDEX
3:32 Defining Names
4:50 Dynamic Named Range for a Row with INDEX
7:35 Dynamic Named Range for a Column with INDEX
10:31 Dynamic Named Ranges with OFFSET
11:59 Dynamic Named Range for a Row with OFFSET
13:21 Dynamic Named Range for a Column with OFFSET
14:58 Dynamic Named Ranges for Charts
17:53 Common Causes of Errors
19:15 Relative Dynamic Named Ranges
19:43 Alternatives to Dynamic Named Ranges
⬇️DOWNLOAD the example file here: myonlinetraininghub.com/excel-functions-for-financial-modeling
📚RELATED LESSONS
- 5 Excel Sum Function Tricks: myonlinetraininghub.com/5-excel-sum-function-tricks
- SUMPRODUCT Function: myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
- IF, Nested IF, IFS Formulas: youtube.com/watch?v=0zTeXujtOZI
- IF Formula Builder Tool: myonlinetraininghub.com/excel-if-and-or-functions-explained
- XLOOKUP Function: youtu.be/2ViMm-wuM3U
- VLOOKUP Function: youtube.com/watch?v=4-5-TBhOP6Q
- INDEX Function - 5 Secret Features: youtube.com/watch?v=pP7AMLJa0Vc
❓What functions do you think are essential to financial modeling? Let me know in the comments.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Excel Functions for Financial Modeling
0:27 Standard Aggregating Functions
1:31 Conditional Aggregating Functions
2:59 Logical Functions
8:41 Lookup Functions
11:47 Financial Functions
15:51 Date Functions
That's why people aren't reading your reports.
Progress Circle Charts are a powerful and interesting way to track milestones and showcase achievements. And they're surprisingly easy to create in Excel.
❓What tricks do you use to make people read your reports? Let me know in the comments.
⬇️DOWNLOAD the example file here: myonlinetraininghub.com/excel-progress-circle-charts
CIRCLE CHART ALTERNATIVES
- Thermometer Charts: myonlinetraininghub.com/excel-actual-vs-target-chart
- Bullet Charts: myonlinetraininghub.com/3-steps-to-easy-bullet-graphs-in-excel
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Why people aren't reading your reports
0:33 Dynamic Circle Charts Set Up
1:31 Calculating the Balance
2:21 Setting up the Segments
3:47 Creating the Circle Progress Chart
6:10 Preparing the Chart for Duplicating
7:03 Updating for Different Data
7:18 Copying Formatting to New Charts
8:01 Dynamic Labels
9:27 Prevent PivotTable Autofitting
9:47 Circle Progress Charts without Segments
10:11 Smaller/Compact Chart Options
⬇️DOWNLOAD the example file & Office Script here: myonlinetraininghub.com/write-excel-office-scripts-with-chatgpt
📜OFFICE SCRIPTS LICENSING REQUIREMENTS
Office Scripts is available to Excel users with the following:
1. Excel for Windows (version 2210 or higher), Excel for Mac, or Excel on the web.
2. OneDrive for Business.
3. Any commercial or educational Microsoft 365 license with access to the Microsoft 365 Office desktop apps, such as:
• Office 365 Business or Business Premium
• Office 365 ProPlus or ProPlus for Devices
• Office 365 Enterprise E3 or E5
• Office 365 A3 or A5
4. Internet connectivity with connected experiences enabled.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 What are Office Scripts
0:52 Where to find Excel Script Tools
1:24 The Scenario
1:49 Using ChatGPT to write Office Scripts
3:07 Using the Script form ChatGPT
3:42 Running the Script
4:08 Handling Errors in ChatGPT Scripts
4:38 Re-using Scripts you Create
5:04 Assigning the Script to a Button
⬇️DOWNLOAD the example file & practice data here: myonlinetraininghub.com/get-started-with-power-query
🎓 LEARN MORE in my Excel course: myonlinetraininghub.com/excel-power-query-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Introduction
0:33 Why Excel Users Don't Know This Tool
1:05 What The Tool Is
1:32 Example
2:19 Getting the Data
3:37 Cleaning the Data
8:00 Updating with One Click
Download the PDF: myonlinetraininghub.com/pro-excel-chart-formatting
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Introduction
0:26 Purpose of Charts
0:42 3D Effects
0:59 Chart Styles
1:12 Axis Starting Point
2:07 Axis Labels
2:15 Sorting
2:21 Wrong Chart Choice
2:30 Labels
2:37 Legends
2:48 Titles
3:04 Gridlines & Axis
🔖RELATED TUTORIALS: Conditional Formatting: youtube.com/watch?v=Rzz9PyfwiVQ
Original PivotTable Profit & Loss Report tutorial and file: myonlinetraininghub.com/excel-pivottable-profit-and-loss
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Format PivotTables
0:23 Custom Sort Order
1:24 Column Labels
2:19 Inserting Blank Rows
2:42 Subtotal Position
3:14 Custom Styles
5:08 Expand/Collapse Buttons
5:30 Conditional Formatting
7:58 Repeating Item Labels
8:48 Report Layouts
9:20 Hiding (blank)s
10:08 Preserving Formatting
10:37 Default PivotTable Layout
⬇️DOWNLOAD the example file here: myonlinetraininghub.com/images-in-excel-pivottables
🔖RELATED TUTORIALS
- IMAGE Function: myonlinetraininghub.com/excel-image-function
- Built-in Data Types: myonlinetraininghub.com/excel-data-types
- Power Query Custom Data Types: myonlinetraininghub.com/power-query-custom-data-types
- Power BI Organisational Data Types: myonlinetraininghub.com/power-bi-organizational-data-types-in-excel
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Display Images in PivotTables
0:32 Image Types that work with PivotTables
2:07 Building PivotTables Containing Images
5:02 Limitations of Images in PivotTables
5:48 Building PivotTables with Data Types
⬇️DOWNLOAD the macro file here: myonlinetraininghub.com/center-across-selection-macro
Easily Create a PERSONAL.XLSB Workbook: myonlinetraininghub.com/create-a-personal-macro-workbook-personal-xlsb
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to write VBA Macros with ChatGPT
0:13 The Problem with Merge & Center
0:41 The ChatGPT Prompt
1:13 The ChapGPT Macro
1:55 Inserting the ChatGPT Macro
2:48 Adding the Macro to the QAT
3:18 Using the Macro
In this video I show you how to link dynamic array formulas to form control buttons and scroll bars to control the sorting and rows visible in the table.
⬇️DOWNLOAD the template file here: myonlinetraininghub.com/excel-scroll-sort-table
🎓DASHBOARD COURSE technique for earlier versions of Excel: myonlinetraininghub.com/excel-dashboard-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Create a Scrolling Table in Excel
0:38 The data
1:06 Activating the Developer Tab
1:28 Inserting Option Buttons
3:07 Inserting the Scroll Bar
3:26 Linking Form Controls to Cells
4:33 Symbols for Sort Order
5:37 Linking Scroll Bar to a Cell
6:16 Naming Form Control Cells
6:28 Formula for Scroll & Sort Table
8:35 Conditional Formatting Selected Column
• Number alignment
• Comma separators
• Rounding
• Currency Symbols
• Merged Cells
• Angled Text
• Zoomed Out with Massive Font
• Too Many Fonts
• Too Much Colour
• Cell borders EVERYWHERE
📢 What formatting habits do you hate? Please share them in the COMMENTS.
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Top Excel Formatting Mistakes
0:24 Number alignment
0:36 Comma separators
0:43 Rounding
0:51 Currency Symbols
1:04 Merged Cells
1:42 Angled Text
1:58 Zoomed Out with Massive Font
2:17 Too Many Fonts
2:38 Too Much Colour
3:03 Cell borders EVERYWHERE
It can write formulas to split, join or rearrange text. It can write math formulas, number rows, number inventory and pretty much anything that has a pattern.
📑 TRY IT OUT here: myonlinetraininghub.com/excel-formula-by-example
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Write Excel Formulas by Example
0:23 Version Availability
0:49 Text Split
2:08 Text Rearrange
2:37 Text Join
2:55 Calculations
3:20 Dates
4:23 Row Numbering
4:49 Forward Filling
Note: you can’t actually reference images in these functions. This is just a fun way to explain how they work 😉
💬 What do you think? Please leave me a COMMENT. I read them all!
Or if you’re short of time, please click the 👍
🎁 SHARE this post and spread the Excel love.
When Power Query combines files in a folder it automatically creates a bunch of queries for you. There are two queries that are important, the sample file query and the final query.
Most people use the wrong query to make their transformations and wonder why they’re struggling.
Check out the video to see examples of when and why you should use the sample file query vs the final query.
📑 STEP BY STEP written instructions here: myonlinetraininghub.com/power-query-get-files-from-a-folder
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Combine Multiple Excel Files From a Folder
0:20 The Data & Where to Save it
1:08 Getting the Data From a Folder
3:01 The Important Queries
3:57 When to use the Sample Query
7:36 The Important Stuff
7:53 Loading the Data
8:51 Getting New Data
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🙏 Help me spread this free resource: please like, share and comment.
📢Follow me for more resources like this.
⏩If you want to get your skills up to speed quickly, please consider my courses which are 20% OFF until 18th May, 2023: myonlinetraininghub.com
15 FREE DASHBOARDS INCLUDES:
- Dynamic Project Management Dashboard
- Personal Finance Dashboard
- Budget vs Actual Expenditure Dashboard
- Orders Dashboard
- Non-financial Dashboard
- Sales & Shipping Dashboard
- HR Management Dashboard
- Sales Dashboard
- Student Demographic Dashboard
- Student Grades Dashboard
- IT Expenditure Dashboard
- Stock Portfolio Dashboard
- Dynamic Periods Project Management Dashboard
- Express Built Dashboard in less than 15 Minutes
- 3 Sales Dashboards from 1 Dataset
🙏Help me spread this free resource: please like, share and comment.
Macro to Remove Duplicate Caches: http://www.contextures.com/xlPivot11.html#removedups
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 The Pivot Cache
1:28 How to Avoid Duplicating the Cache
1:56 Detecting the Number of Caches
3:07 Removing Duplicate Caches
3:24 Pivot Cache Limitations
3:58 Workarounds to Limitations
7:36 Reducing the Cache Overhead
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/excel-linear-regression
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Excel Linear Regression
0:13 What is Linear Regression
0:52 Linear Regression with Charts
2:02 How to use the equation
3:48 How to use the R squared value
4:26 Regression with the Data Analysis Toolpak
5:50 Regression Statistics
6:33 ANOVA Statistics
6:41 Coefficients Table
7:03 Residuals
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD PDF HERE: myonlinetraininghub.com/how-to-improve-excel-performance
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Why Your Spreadsheet is Running Slowly
0:27 Data Size
0:44 PivotTables
1:01 Array Formulas
1:45 Nested Formulas
2:31 Volatile Functions
3:04 Lookup Formulas
4:00 Conditional Functions
4:39 Defined Names
5:08 Error Handling
5:21 External Links
5:46 Formatting
6:22 Redundant Formatting
7:30 Excel Tables
8:10 Passowrd Protection
8:23 UDFs
8:37 Outdated Software
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/microsoft-excel-standard-deviation-functions
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍
💬 Please leave me a COMMENT. I read them all!
🆘 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🧟♀️ CONNECT with Mynda:
LinkedIn: linkedin.com/in/myndatreacy
Instagram: instagram.com/mynda.treacy
Twitter: twitter.com/onlinetrainingh
Facebook: facebook.com/MyOnlineTrainingHub
TikTok: tiktok.com/@myndatreacy?lang=en
Pinterest: https://www.pinterest.com.au/myndatreacy/
⏲ TIMESTAMPS
0:00 How to Calculate Standard Deviation in Excel
0:16 The Data
0:45 Standard Deviation Functions
0:55 Functions to Avoid
1:03 Writing Standard Deviation Formulas
1:12 Conditional Formatting
1:20 Interpreting the Results
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD the Excel file containing the completed dashboard and steps for building it yourself: myonlinetraininghub.com/project-management-dashboard-dynamic-periods
🎓 LEARN MORE
- See the original Dashboard tutorial here: youtube.com/watch?v=5qtSioTE2wY
- Conditional Formatting with Formulas: youtube.com/watch?v=Rzz9PyfwiVQ
- Join my Excel Dashboard course here: myonlinetraininghub.com/excel-dashboard-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Excel Project Management Dashboard
0:46 The Approach
1:01 Insert Radio Buttons
3:01 Timeline Formulas
6:08 Link Formulas to Form Control
9:20 Conditional Formatting Formulas
10:15 Weekend Conditional Formats
12:28 Grand Total Row Format
13:13 Task Not Started Format
17:46 In Progress Format
19:02 Completed Work Format
20:01 Set Stop If True Conditional Format Rules
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍
💬 Please leave me a COMMENT. I read them all!
🆘 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🧟♀️ CONNECT with Mynda:
LinkedIn: linkedin.com/in/myndatreacy
Instagram: instagram.com/mynda.treacy
Twitter: twitter.com/onlinetrainingh
Facebook: facebook.com/MyOnlineTrainingHub
TikTok: tiktok.com/@myndatreacy?lang=en
Pinterest: https://www.pinterest.com.au/myndatreacy/
5 SECRET INDEX Function Features: youtube.com/watch?v=pP7AMLJa0Vc
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/excel-index-and-match-functions
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍
💬 Please leave me a COMMENT. I read them all!
🆘 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🧟♀️ CONNECT with Mynda:
LinkedIn: linkedin.com/in/myndatreacy
Instagram: instagram.com/mynda.treacy
Twitter: twitter.com/onlinetrainingh
Facebook: facebook.com/MyOnlineTrainingHub
TikTok: tiktok.com/@myndatreacy?lang=en
Pinterest: https://www.pinterest.com.au/myndatreacy/
⏲ TIMESTAMPS
0:00 How to write INDEX & MATCH Formulas
0:31 INDEX Formulas
1:11 MATCH Formulas
1:47 INDEX & MATCH Formulas
3:09 Lookup to the left
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍
💬 Please leave me a COMMENT. I read them all!
🆘 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🧟♀️ CONNECT with Mynda:
LinkedIn: linkedin.com/in/myndatreacy
Instagram: instagram.com/mynda.treacy
Twitter: twitter.com/onlinetrainingh
Facebook: facebook.com/MyOnlineTrainingHub
TikTok: tiktok.com/@myndatreacy?lang=en
Pinterest: https://www.pinterest.com.au/myndatreacy/
More on Excel Workbook Protection: myonlinetraininghub.com/excel-workbook-protection
🔗 LINKS
- Remove Passwords: youtube.com/watch?v=24rISp-naqI
- Excel Forms: youtube.com/watch?v=Eys3YTmtK2s
- Embed Excel Files in Web Pages: youtube.com/watch?v=uvA-U9FKgPw
- Information Rights Management: learn.microsoft.com/en-us/microsoft-365/compliance/set-up-irm-in-sp-admin-center?view=o365-worldwide
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Securely Share Excel Files
0:26 Password Protection
2:32 Securely Sharing Files from Excel Desktop App
3:18 Blocking Downloading
3:56 Securely Sharing Files from OneDrive
4:30 Securely Sharing from File Explorer
4:47 Allowing Data Entry & Prevent Downloading
5:06 Information Rights Management
5:34 Embedding Files in a Web Page
Tip: create named ranges with a couple of clicks: youtube.com/shorts/Ygr3hzqHi_E
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/interactive-excel-check-boxes
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Interactive Excel Reports with Check Boxes
0:48 Check Box Task List
3:02 Status Bar Linked to Task List
4:48 IF formula linked to Check Box
6:37 Conditonal Formatting linked to Check Boxes
9:58 Charts Linked to Check Boxes
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/power-query-if-statements
🎓 LEARN MORE in my Power Query course: myonlinetraininghub.com/excel-power-query-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to write if Statements in Power Query
0:29 Power Query if statements with Conditional Column
1:42 Power Query if statements with Custom Column
2:29 Power Query if or statements
3:52 Power Query if and statements
4:53 Power Query nested if statements
6:27 File Download Link
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/excel-find-and-remove-duplicates
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Remove Duplicates in Excel
0:36 Highlight Duplicates with Conditional Formatting
1:38 Identify Duplicates with Formulas
2:43 Identify Duplicates with PivotTables
3:50 Extract a distinct list with UNIQUE
4:33 Remove Duplicates Tool - One Time
5:43 Remove Duplicates with Power Query - Many Times
7:16 Remove Duplicates with Advanced Filter - One Time
8:17 Summary & File Download Link
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 How to Quickly Work with Multiple Excel Files
0:22 Navigating Multiple Files
0:54 Arranging Multiple files
1:52 Shortcut Keys
3:29 Viewing Multiple Sheets in the Same File
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/picture-fill-excel-charts
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
0:00 Introduction
0:18 Picture Fill Column Charts
2:34 Considerations for Choosing a Picture (Column Charts)
5:26 Labelling Column Charts with Picture Fill
6:44 Picture Fill Area Charts
7:24 Considerations for Choosing a Picture (Area Charts)
7:37 Defining Area with a Line
8:25 When Not to use Picture Fills
8:37 File Download
Bio link: myonlinetraininghub.com/links.htm
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🎓 LEARN MORE in my courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Introduction
0:28 Installing the add-in
1:02 AI Generated Formulas
4:17 Using AI to Understand Formulas
5:36 Simplifying Existing Formulas with AI
6:47 AI Formula Editor Limitations & Workarounds
8:16 Outro
Link to BIO: myonlinetraininghub.com/links.htm
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
🔻 CHATGPT VIDEO SCREENSHOTS: myonlinetraininghub.com/chatgpt-for-excel
🎓 LEARN MORE in my Excel Dashboard course: myonlinetraininghub.com/excel-dashboard-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Intro
0:35 Function Explanations
1:43 Formula Writing
2:42 Troubleshooting Errors
3:28 Explain Formulas
4:32 Power Query
5:25 Power Pivot
5:56 VBA
6:33 Math
7:55 Leading Questions
9:02 The Bottom Line
9:27 Outro
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
Note: Microsoft discovered unexpected behavior from having the sketch effect in charts. As a result it will not be available going forward. However, it is still available for shapes.
🔻 DOWNLOAD EXCEL FILE HERE: myonlinetraininghub.com/excel-infographic-tools
🎓 LEARN MORE in my Excel Dashboard course: myonlinetraininghub.com/excel-dashboard-course
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Introduction
0:36 Setting up the Excel file
1:16 Working with images
2:13 Creating the header
2:56 Inserting the doughnut chart
6:02 Inserting the pie chart
7:32 Inserting the bar chart
11:02 Inserting the column chart
13:41 Inserting the icons
15:47 Inserting the map chart
🎓 LEARN MORE in my Excel courses: myonlinetraininghub.com
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
Learn more in my Excel Dashboard course: myonlinetraininghub.com/excel-dashboard-course
Learn Power BI with Mynda: myonlinetraininghub.com/power-bi-course
Connect with Mynda on LinkedIn: linkedin.com/in/myndatreacy
0:00 AI Designed Dashboard Reports
0:42 Dall E Images
1:09 Using Midjourney
2:19 AI Dashboard Design with Midjourney
3:49 The downside of AI dashboard designs


