MyOnlineTrainingHubNEW - with Formula by Example Excel can now write formulas for you! Simply give it an example or two and itβll suggest a formula to complete the task.
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.
β² 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
Excel AI Formulas by Example 10x Better than Flash FillMyOnlineTrainingHub2023-05-30 | NEW - with Formula by Example Excel can now write formulas for you! Simply give it an example or two and itβll suggest a formula to complete the task.
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.
β² 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 FillingMicrosoft said it couldnt be done - Interactive Python Charts in ExcelMyOnlineTrainingHub2023-08-25 | How to build interactive Python charts in Excel using Slicers to control interactivity and connected to data in Power Query.
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.
β² 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 LimitationsExcel Python Keyboard Shortcuts for 10x Productivity #shortsMyOnlineTrainingHub2023-08-24 | Now that we can write Python in Excel, youβll find some keyboard shortcuts super handy:
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.
πFOLLOW me on LinkedIn for more tips like this: https://lnkd.in/gSfhwJKkNEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy!MyOnlineTrainingHub2023-08-22 | How to use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib, Seaborn and more. In this video I'll show you how to use Python in Excel to do data analysis and create amazing Python charts, aka Python plots.
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.
π 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.
β² 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 ExcelI dont use OFFSET Anymore! I Use Another Function Instead.MyOnlineTrainingHub2023-08-15 | Excel Dynamic Named Ranges update automatically to include new data in the ranges referenced in your formulas and PivotTables etc.
β² 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 RangesEssential Excel Functions for Financial Modelers - Incl. FREE Example FileMyOnlineTrainingHub2023-08-08 | Excel functions are the backbone of a financial modelerβs day to day work and as such, itβs essential to have a good understanding of the functions that are commonly used to build financial models. In this video I cover the top Excel functions that you must know as a financial modeler.
β² 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 FunctionsAre Your Charts BORING? Use These Progress Circle Charts Instead!MyOnlineTrainingHub2023-08-01 | Your charts are boring!
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.
β² 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 OptionsNo More VBA. ChatGPT to automates boring work with Office ScriptsMyOnlineTrainingHub2023-07-25 | Excel Office Scripts are the future of automation for Excel and other Office apps, replacing VBA and macros going forward. In this video I use ChatGPT to write an Office Script for me and the results are impressive!
π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.
β² 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 ButtonMaster Data Cleaning in Excel in 9 Minutes - The RIGHT Way!MyOnlineTrainingHub2023-07-18 | Change your life with this data cleaning tool built into Excel that most users don't know. It's easy to use and fast to learn. No programming required.
β² 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 ClickHow Pros Instantly Spot Amateur Charts - Its Enough to Drive Me to DRINK!MyOnlineTrainingHub2023-07-11 | β£οΈ 10 telltale signs that show youβre a chart amateur and the chart formatting you should use instead.
β² 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 & Axis12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!MyOnlineTrainingHub2023-07-06 | One of the downsides of PivotTables is they have a very distinctive look. Some might even say theyβre ugly. In this video I cover 12 PivotTable formatting tricks that will transform their look and feel.
β² 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 LayoutNEW - Images & Data Types in PivotTables, WOW!MyOnlineTrainingHub2023-06-27 | NEW Images inside Excel PivotTables + Data Types - bring your PivotTables to life with images and suplement PivotTables with data types and cards that can reveal more data without bloating the report.
β² 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 TypesExcel + ChatGPT - Center Across Selection Shortcut Macro!MyOnlineTrainingHub2023-06-20 | π Excel + ChatGPT Automation - No more annoying Merge & Center! Use this Center Across Selection shortcut macro to fix formatting with one click.
β² 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 MacroWOW! Dynamic Scroll & Sort Table in ExcelMyOnlineTrainingHub2023-06-13 | Dashboards have limited space, which is why tables that allow you to scroll, and sort are super handy.
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.
β² 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 ColumnExcel Formatting Habits That Drive Me CRAZY!MyOnlineTrainingHub2023-06-06 | Top 10 poor formatting habits that drive me CRAZY. Effective formatting subtly enhances usability, while poor formatting can be a distraction.
β’ 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.
β² 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 EVERYWHEREExcel Text Functions Cheat Sheet β Like Youβve NEVER Seen Before! #shortsMyOnlineTrainingHub2023-05-25 | Have some fun mastering Excel text functions with this cats, dogs and ducks cheat sheet.
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.Combine Files from a Folder with Power Query the RIGHT WAY!MyOnlineTrainingHub2023-05-23 | Most people combine files from a folder with Power Query all wrong. In this video I show you why itβs wrong and the way you should be doing it.
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.
β² 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 DataFix Slow Excel Files with ONE Click! #shortsMyOnlineTrainingHub2023-05-18 | Are your Excel files slow? Fix them with one click with this new tool from Microsoft!
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.The Secret behind Excel PivotTables - The Pivot CacheMyOnlineTrainingHub2023-05-16 | The hidden way PivotTables work, the limitations this imposes, and how to get around them.
β² 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 OverheadEssential Excel Data Entry Shortcuts Not Many People Know #shortsMyOnlineTrainingHub2023-05-11 | Skyrocket productivity with these Excel pro data entry shortcuts.
Or if youβre short of time, please click the πExcel Linear Regression The EASY Way!MyOnlineTrainingHub2023-05-08 | Excel linear regression is easy with its built-in tools. In this tutorial, we'll explore what linear regression is, why it's useful, and the Excel tools that enable you to do it with the click of a few buttons.
β² 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 ResidualsSave Time and Effort with the CTRL+. Shortcut: The Handy Excel Trick You Need to Know!MyOnlineTrainingHub2023-05-04 | Navigating large tables can be time consuming and frustrating, but with this keyboard shortcut you'll save time and effort.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumHow to Improve Excel Performance - Common Culprits & SolutionsMyOnlineTrainingHub2023-05-02 | Slow Excel files that take forever to load or recalculate are a common headache for anyone who uses spreadsheets regularly. Fortunately, there are many tips and tricks you can use to improve Excel performance. In this tutorial, we'll identify the most common causes of slow Excel files and how to speed them up so you can improve productivity.
β² 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 SoftwareStandard Deviation in Excel using the NEW FunctionsMyOnlineTrainingHub2023-04-27 | How to calculate the Standard Deviation in Excel with separate functions for the standard deviation of a sample or a population.
β² 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 ResultsBoost Your Productivity: Learn How to Display Excel Function Syntax in Cells as a Handy Reference!MyOnlineTrainingHub2023-04-25 | Displaying the function syntax in a cell is a handy tool for writing procedures for other staff to follow, or writing tutorials like me. With this shortcut you can do it in the blink of an eye.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumExcel Project Management Dashboard with Dynamic PeriodsMyOnlineTrainingHub2023-04-20 | Revolutionize Your Project Management with this Excel Dashboard - See Progress in a Whole New Way! How to build dynamic Excel Project Management Dashboards with buttons to switch between viewing the progress by day, week and month.
β² 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 Rules3 List Date Tricks That Dont Seem Possible #shortsMyOnlineTrainingHub2023-04-18 | Surprise your co-workers: create lists of dates with the DATE function and this SEQUENCE trick!
β² 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 leftDefine Excel Names with 1 Click! #shortsMyOnlineTrainingHub2023-04-12 | Save time with defined names, but don't waste time creating them one by one! Create a whole table's worth of names with 1 click!
β² 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 PageExcel Lookup formulas are REDUNDANT! Use the intersect operator instead.MyOnlineTrainingHub2023-04-04 | The intersect operator is a little known way you can lookup a cell or range of cells.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumInteractive Excel Check Boxes for Dynamic ReportsMyOnlineTrainingHub2023-03-30 | How to create interactive check boxes in Excel, which can be linked to formulas, charts, conditional formatting and other features. Check boxes can be a great way to make your spreadsheets more visually appealing, user-friendly and efficient, allowing users to quickly select options and see the results of their selections in real-time. We'll walk you through the process step-by-step.
β² 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 BoxesAngled Excel Chart Axis Labels are WRONG! Do This INSTEAD. #shortsMyOnlineTrainingHub2023-03-28 | DON'T angle chart labels, EVER! It's a terrible user experience. If you have long labels, abbreviate them. If you can't abbreviate them, use a bar chart.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumHow to Write Power Query if Statements incl. Nested ifs, if or, if and with the IF functionMyOnlineTrainingHub2023-03-23 | Power Query if statements using the Power Query if function are easier to write than those in Excel. In this video I'll teach you how to write them in both Excel and Power BI using the Custom Column tool and write Power Query if and, if or, and nested if statements.
β² 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 LinkDONT Click OK in Excel Dialog Boxes - Do This INSTEAD! #shortsMyOnlineTrainingHub2023-03-21 | Productivity Hack - Rather than clicking the option to select it and then moving the mouse to click the 'OK' button, reduce time spent in dialog boxes by double clicking your choice.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum7 Ways to Remove Duplicates in Excel , Do You Know Them ALL?MyOnlineTrainingHub2023-03-16 | Duplicates in your data can completely undermine your work. In this video I'll cover the 7 ways you can identify, and or remove duplicates in Excel. You can watch them all and choose the one right for your task, or use the time stamps in the video description to jump to the method you want.
β² 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 LinkDont Insert Totals Like This, Use a Shortcut Instead #shortsMyOnlineTrainingHub2023-03-14 | Save Time: Learn How to Insert Totals Quickly with This Excel Shortcut!
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumExcel Productivity Hacks: Master Multi-Tasking with Game-Changing Tips for Managing Multiple FilesMyOnlineTrainingHub2023-03-09 | Itβs common practice to have multiple Excel files open at the same time, but we can waste a lot of time flitting back and forth between them. In this tutorial you'll learn some game-changing tips that are guaranteed to streamline your workflow, making it easier than ever to navigate, arrange, and seamlessly work between multiple Excel files.
β² 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 FileSymbols Make Reports EASY to Read and More Enjoyable #shortsMyOnlineTrainingHub2023-03-07 | Don't make your audience work harder than necessary. Use symbols to make your reports EASY to read. For more custom number format tips like this, check out my Custom Number Format Guide: myonlinetraininghub.com/excel-custom-number-format-guide
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumCaptivating Excel Charts: Use Stylish Picture Fills to Enhance Data VisualizationMyOnlineTrainingHub2023-03-02 | Using a stylish picture fill in your Excel Charts is a simple way to make your data visualizations more captivating and memorable. I'll walk you through the tricks from selecting the right images, adjusting picture format, and the trick to get the picture to span the chart width (it's not as obvious as you might think).
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 DownloadDont Save Excel Files Like This - Use This SHORTCUT instead! #shortsMyOnlineTrainingHub2023-02-28 | Are you saving copies of files the long way? Use this shortcut instead.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumNEW AI Formula Editor INSIDE Excel WRITES FORMULAS FOR YOU!MyOnlineTrainingHub2023-02-23 | Save time with this FREE AI-aided Excel formula editor add-in that writes, edits, improves and interprets formulas for you!
β² 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 OutroNEW Windows 11 Must Have Feature - File Explorer Tabs #shortsMyOnlineTrainingHub2023-02-21 | Windows 11 Must Have Feature - File explorer tabs. Just one window with all your favourite explorer locations easily accessible. #windows11
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumChatGPT for Excel - what theyre NOT telling you!MyOnlineTrainingHub2023-02-16 | Everyoneβs talking about how great ChatGPT is and how it will increase your productivity by x%, but no oneβs talking about what itβs bad at and the dangers you should watch out for. In this video I'm going to cover the BEST uses for ChatGPT for Excel and what you should NEVER EVER use ChatGPT for.
β² 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 OutroAvoid Calc. ERRORS - Scale Numbers in Excel the RIGHT WAY - $K, $M, $B #shortsMyOnlineTrainingHub2023-02-14 | Scaling numbers to thousands, millions, billions etc. in Excel is often done the wrong way, which can lead to spreadsheet errors with massive ramifications. In this video I show you the right way to scale numbers so you won't get caught out.
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forumCreate INTRIGUE with these Hidden Chart Techniques and Get MORE People to READ Your Reports!MyOnlineTrainingHub2023-02-09 | Get more people to take interest in your reports with these eye catching graphics. These techniques are often used in infographics, but you can use them in dashboards and PowerPoint presentations too.
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.
β² 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 chartExcel Custom Formatting Tricks - Leading/Trailing Characters #shortsMyOnlineTrainingHub2023-02-07 | Cool Excel custom cell formats for creating forms, TOC and more. Check out our complete Custom Number Format guide here: myonlinetraininghub.com/excel-custom-number-format-guide
Or if youβre short of time, please click the π
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum4 x AI Dashboard Designs in 60 SECONDS!MyOnlineTrainingHub2023-02-02 | AI can design 4 dashboards in just 60 seconds. In this video I show you how, plus the cons of using AI for your dashboard designs.
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 designsNEW Excel Evaluate Formula Tooltip #shortsMyOnlineTrainingHub2023-01-31 | The new Evaluate Formula tooltip is currently available to Microsoft 365 users on the Beta channel. It saves you having to press the F9 key to evaluate components of a formula while in edit mode or the formula bar.