Python in Excel: a Powerful Combination for Data Analysis and Visualization
Microsoft Excel Tips and Tricks Python in Excel combines Python’s powerful data analysis and visualization libraries with Excel’s features you[…]
Read moreTag: excel
New Python in Excel – Python + Excel + ChatGPT = Easy!
Microsoft Excel Tips and Tricks How to use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib, Seaborn and[…]
Read more
Excel Table of Contents for Sheet Tabs with Hyperlinks | Create Automatically | Office Script Macro
Microsoft Excel Tips and Tricks In this Microsoft Excel video I tutorial I explain how to use an Office Script[…]
Read more
Introducing Python in Excel
Microsoft Excel Tips and Tricks You can use Python INSIDE Excel now 😱 In this video I’ll introduce this game[…]
Read moreHow to Make Paragraphs in Excel | Move Down a Line Within a Cell | Fit Large Amount of Text in Cell
Microsoft Excel Tips and Tricks Welcome to my step-by-step guide on making paragraphs in Excel. If you’ve ever been stumped[…]
Read more
Excel – Create a Custom Sort List
Microsoft Excel Tips and Tricks Excel sorts by numbers, dates, text, and color. Excel will also sort by Custom List.[…]
Read moreUnlocking Financial Insights: Excel Formulas for Top 10 KPIs
Microsoft Excel Tips and Tricks Learn how to calculate Quick Ratio, Inventory Turnover, IRR, ARPU, CAGR and many other accounting[…]
Read moreVBA Macro: Split Excel Worksheet into Multiple Worksheets Based on Column Value
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate my VBA macro that will split data,[…]
Read more
Running Total Formula in Excel Using SUM or SCAN | Year to Date (YTD) Calculations in a Table
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate how to create a running totals or[…]
Read more
Essential Excel Functions for Financial Modelers – Incl. FREE Example File
Microsoft Excel Tips and Tricks Excel functions are the backbone of a financial modeler’s day to day work and as[…]
Read more
Group Rows and Columns in Excel With Expand & Collapse Buttons | Include Summary and Subtotals
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to group rows and/or columns. This[…]
Read more
How to make an elegant, fun & useful payroll & pay slip generator with Excel
Microsoft Excel Tips and Tricks Need to create a payroll calculator & payslip generator with Excel? Watch this video. Credit[…]
Read moreFormula to Combine Date and Time in One Cell in Excel | Date and Time With AM/PM Format
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to combine date and time in[…]
Read moreExcel Chart Showing DATES NOT IN DATA Problem | Only Show Dates With Data | Excel Graph With Dates
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to solve a problem with dates[…]
Read more
Quickly Select a Large Dataset in Excel
Microsoft Excel Tips and Tricks Quickly Select a Large Dataset in Excel Credit Technology for Teachers and Students
Read more