![The Office Lab](/img/default-banner.jpg)
- 24
- 12 718 004
The Office Lab
Germany
Приєднався 1 чер 2018
With 10+ years of experience in heavily using Excel and PowerPoint, I developed a good sense on how to combine great functionality with outstanding design in these essential tools.
I firmly believe in the transformative power of knowledge sharing for personal growth and collective success. That's why I share my knowledge and ideas through in-depth tutorials on this UA-cam channel. The tutorials cover both fundamental techniques and exciting projects such as the creation of advanced Excel and PowerPoint templates.
If you’d like to get your work done faster, check out my best-selling Excel templates: excelfind.com/templates
Angaben gemäß § 5 TMG:
Marco Seidler
Rahmannstraße 11
65760 Eschborn
Kontakt: info@excelfind.com
I firmly believe in the transformative power of knowledge sharing for personal growth and collective success. That's why I share my knowledge and ideas through in-depth tutorials on this UA-cam channel. The tutorials cover both fundamental techniques and exciting projects such as the creation of advanced Excel and PowerPoint templates.
If you’d like to get your work done faster, check out my best-selling Excel templates: excelfind.com/templates
Angaben gemäß § 5 TMG:
Marco Seidler
Rahmannstraße 11
65760 Eschborn
Kontakt: info@excelfind.com
How to create Ultimate Personal Budget in Excel
► Download Ultimate Excel Personal Budget Template: excelfind.com/ultimate-excel-personal-budget
► Discover all our Excel templates: excelfind.com/templates
How to create Ultimate Personal Budget in Excel
This Excel tutorial teaches you how to create the ultimate Personal Budget template in Excel that covers every step from a zero-based multi-period Budget Planning through an intuitive Budget Tracking up to an interactive Budget Dashboard to constantly monitor and evaluate your personal budget performance. This Excel template enables you to not only keep track of your budget for ongoing periods and analyse your budget performance of passed periods, but also to pro-actively take control over your personal finances by planning your months and years ahead with almost zero effort.
The template covers every possible aspect required to get full control over your personal money-flows and comes with a number of features that are particularly designed to address real-life issues, like the planning of inconsistent money-flows like yearly, quarterly or monthly-changing income, expense or savings categories or the option to automatically treat late income (e.g. paycheck at the end of the month) as disposable income for the next month.
The interactive Budget Dashboard is the heart of this template as it comprises both the planned and tracked budget data in an incredible smart and powerful way. It is driven by one of the most powerful composition of calculations and sets new standards in terms of interactive data visualization and UX/UI design in Excel.
This tutorial covers every single step of the template creation and is an amazing training for your set of advanced Excel skills. The final template file is available for download on excelfind.com.
*Tutorial Outline*
00:00:00 Demo
00:16:26 Budget Plan Setup
01:08:25 Budget Tracking Setup
01:54:56 Dashboard - Initial Setup
02:11:04 Dashboard - Breakdown Section
03:55:39 Dashboard - Category Distribution Charts
04:33:46 Dashboard - Tracked vs. Budget Chart
05:31:02 Dashboard - Performance KPI Tiles
06:03:38 Finishing Touches
*Resources*
Final Template Download: excelfind.com/ultimate-excel-personal-budget
Color Palette: F0E936, 40D492, F9B710, FE1684, 9237BC, 4633F2, 3285F3, 1DD7F3
*NOTE:* This video has been produced for educational purposes as I want to have my community benefit from freely accessible training material. You are free to use the knowledge provided for your own personal or business-related projects. However, the reproduction, copying, and general reuse of the video or republishing of the creative process demonstrated is not permitted. Furthermore, the unauthorized redistribution of the final template or any sort of derivate of the template (for commercial gain or without a proper license) is not permitted. A violation thereof is considered copyright infringement and is subject to legal actions.
*DISCLAIMER:* I am not a financial advisor. Nothing said in this video is financial advice. This tutorial is solely about the technical creation of a powerful personal finance tool in Excel.
Follow us on Twitter ► theofficelab
#excel #personalbudget #dashboard
► Discover all our Excel templates: excelfind.com/templates
How to create Ultimate Personal Budget in Excel
This Excel tutorial teaches you how to create the ultimate Personal Budget template in Excel that covers every step from a zero-based multi-period Budget Planning through an intuitive Budget Tracking up to an interactive Budget Dashboard to constantly monitor and evaluate your personal budget performance. This Excel template enables you to not only keep track of your budget for ongoing periods and analyse your budget performance of passed periods, but also to pro-actively take control over your personal finances by planning your months and years ahead with almost zero effort.
The template covers every possible aspect required to get full control over your personal money-flows and comes with a number of features that are particularly designed to address real-life issues, like the planning of inconsistent money-flows like yearly, quarterly or monthly-changing income, expense or savings categories or the option to automatically treat late income (e.g. paycheck at the end of the month) as disposable income for the next month.
The interactive Budget Dashboard is the heart of this template as it comprises both the planned and tracked budget data in an incredible smart and powerful way. It is driven by one of the most powerful composition of calculations and sets new standards in terms of interactive data visualization and UX/UI design in Excel.
This tutorial covers every single step of the template creation and is an amazing training for your set of advanced Excel skills. The final template file is available for download on excelfind.com.
*Tutorial Outline*
00:00:00 Demo
00:16:26 Budget Plan Setup
01:08:25 Budget Tracking Setup
01:54:56 Dashboard - Initial Setup
02:11:04 Dashboard - Breakdown Section
03:55:39 Dashboard - Category Distribution Charts
04:33:46 Dashboard - Tracked vs. Budget Chart
05:31:02 Dashboard - Performance KPI Tiles
06:03:38 Finishing Touches
*Resources*
Final Template Download: excelfind.com/ultimate-excel-personal-budget
Color Palette: F0E936, 40D492, F9B710, FE1684, 9237BC, 4633F2, 3285F3, 1DD7F3
*NOTE:* This video has been produced for educational purposes as I want to have my community benefit from freely accessible training material. You are free to use the knowledge provided for your own personal or business-related projects. However, the reproduction, copying, and general reuse of the video or republishing of the creative process demonstrated is not permitted. Furthermore, the unauthorized redistribution of the final template or any sort of derivate of the template (for commercial gain or without a proper license) is not permitted. A violation thereof is considered copyright infringement and is subject to legal actions.
*DISCLAIMER:* I am not a financial advisor. Nothing said in this video is financial advice. This tutorial is solely about the technical creation of a powerful personal finance tool in Excel.
Follow us on Twitter ► theofficelab
#excel #personalbudget #dashboard
Переглядів: 2 616 452
Відео
How to create Ultimate Excel Gantt Chart for Project Management (with Smart Dependency Engine)
Переглядів 2,7 млн2 роки тому
► Download Ultimate Excel Gantt Chart Template: excelfind.com/ultimate-excel-gantt-chart ► Discover all our Excel templates: excelfind.com/templates How to create Ultimate Excel Gantt Chart for Project Management (with Smart Dependency Engine) This Excel tutorial teaches you how to create the ultimate Excel Gantt Chart Template with many advanced and incredibly powerful features making this a p...
Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)
Переглядів 550 тис.3 роки тому
Data is everywhere! Enhance your career and acquire new skills by taking a course on DataCamp! Click here to take the first chapter of any course for FREE: bit.ly/3e03pKO (you’ll be supporting my channel too!) Drop Down Lists in Excel - Masterclass This Excel Masterclass teaches the full range of drop down list techniques in Excel. It starts with the fundamentals about drop down lists in Excel ...
How to Master the Scrolling Parallax Effect in PowerPoint | Free Course
Переглядів 182 тис.3 роки тому
How to Master the Scrolling Parallax Effect in PowerPoint | Free Course In this PowerPoint design course you will learn how to use the PowerPoint Morph Transition to create stunning Scrolling Parallax Effects in your PowerPoint presentations. This course covers the two most practical Parallax Effects for all kinds of PowerPoint presentations: The Lazy Scroll Parallax and the Sticky Scroll Paral...
Automated Control Chart in Excel (with built-in Data Simulation)
Переглядів 183 тис.4 роки тому
✅ DOWNLOAD Worksheet here ► excelfind.com/tutorials/automated-control-chart-in-excel 🔎 EXCEL FUNCTIONS used in the video ► excelfind.com/excel-functions 📌 EXCEL VERSION: Excel in Microsoft 365 ► geni.us/Office365_Microsoft Automated Control Chart in Excel (with built-in Data Simulation) In this tutorial you will learn how to create an Automated Control Chart in Excel with a dynamic chart range ...
Real-Time Multi-Column Data Search Box in Excel with FILTER function [Part 2]
Переглядів 58 тис.4 роки тому
✅ DOWNLOAD Worksheet here ► excelfind.com/tutorials/dynamic-data-search-box-in-excel-part2 📌 EXCEL VERSION: Excel in Microsoft 365 ► geni.us/Office365_Microsoft Dynamic Multi-Column Data Search Box in Excel with FILTER function [Part 2] In this tutorial you will learn how to implement multi-column search for a dynamic data search box in Excel. Based on the implementations of Part 1 (using the F...
Real-Time Data Search Box in Excel with FILTER function [Part 1]
Переглядів 171 тис.4 роки тому
✅ DOWNLOAD Worksheet here ► excelfind.com/tutorials/dynamic-data-search-box-in-excel-part1 📌 EXCEL VERSION: Excel in Microsoft 365 ► geni.us/Office365_Microsoft Dynamic Data Search Box in Excel with FILTER function [Part 1] In this tutorial you will learn how to create a dynamic data search box in Excel that allows you to filter your data in real-time as you type. It covers the basics about the...
Top 10 Excel New Features (incl. Microsoft 365)
Переглядів 70 тис.4 роки тому
✅ FULL REVIEW: Excel in Microsoft 365 ► excelfind.com/excel-in-microsoft-365-review/ 📌 EXCEL VERSION: Excel in Microsoft 365 ► geni.us/Office365_Microsoft 🔎 EXCEL FUNCTIONS DATABASE ► excelfind.com/excel-functions Top 10 Excel New Features (including Microsoft 365) Check out the top 10 newest features of Excel in Microsoft 365. This includes features added recently as well as features that will...
Top 5 PowerPoint Free Graphics Add-ins for Impressive Slide Design
Переглядів 92 тис.4 роки тому
Top 5 PowerPoint Free Graphics Add-ins for Impressive Slide Design Get to know the top 5 most helpful PowerPoint Add-ins for free access to graphical resources (like images, icons, and illustrations) and learn how to use them for impressive slide design. This is a full review of each add-in, covering the installation, functionality, and application. Note: Some of the links in this description a...
How to Create a Morph Animated Image Slider in PowerPoint
Переглядів 135 тис.4 роки тому
How to Create a Morph Animated Image Slider in PowerPoint In this PowerPoint tutorial you will learn how to create a creative image slider in PowerPoint using the morph transition feature. Morph lets you create outstanding transitions and animations across your presentation slides and is one of the most powerful tools Microsoft added to PowerPoint over the last few years. Note: Some of the link...
How to Create Interactive Settings Menu in Excel | Ultimate Excel Dashboard Ep. 7
Переглядів 56 тис.4 роки тому
✅ GET CODE here ► excelfind.com/tutorials/ultimate-excel-dashboard-interactive-settings-menu 📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft ▬▬▬▬▬▬▬▬▬▬ 🔥BIG NEWS ► Launch of excelfind.com 🔥 I just launched my new Excel Resource Website and kindly invite you to check it out. I put a lot of work and research into it to provide you with the biggest possible value!...
How to Create Interactive Dashboard Tabs in Excel | Ultimate Excel Dashboard Ep. 6
Переглядів 52 тис.4 роки тому
✅ GET CODE here ► excelfind.com/tutorials/ultimate-excel-dashboard-interactive-dashboard-tabs 📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft ▬▬▬▬▬▬▬▬▬▬ 🔥BIG NEWS ► Launch of excelfind.com 🔥 I just launched my new Excel Resource Website and kindly invite you to check it out. I put a lot of work and research into it to provide you with the biggest possible value...
How to Create an Interactive Info Button | Ultimate Excel Dashboard Ep. 5
Переглядів 62 тис.4 роки тому
✅ GET CODE here ► excelfind.com/tutorials/ultimate-excel-dashboard-interactive-info-button 📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft ▬▬▬▬▬▬▬▬▬▬ 🔥BIG NEWS ► Launch of excelfind.com 🔥 I just launched my new Excel Resource Website and kindly invite you to check it out. I put a lot of work and research into it to provide you with the biggest possible value! M...
Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4
Переглядів 82 тис.4 роки тому
✅ GET CODE here ► excelfind.com/tutorials/ultimate-excel-dashboard-auto-refresh-pivot-charts 📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft ▬▬▬▬▬▬▬▬▬▬ 🔥BIG NEWS ► Launch of excelfind.com 🔥 I just launched my new Excel Resource Website and kindly invite you to check it out. I put a lot of work and research into it to provide you with the biggest possible value!...
How to Create A Modern Pivot Slicer Design | Ultimate Excel Dashboard Ep. 3
Переглядів 129 тис.4 роки тому
✅ LEARN MORE here ► excelfind.com/tutorials/ultimate-excel-dashboard-modern-slicer-design 📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft ▬▬▬▬▬▬▬▬▬▬ 🔥BIG NEWS ► Launch of excelfind.com 🔥 I just launched my new Excel Resource Website and kindly invite you to check it out. I put a lot of work and research into it to provide you with the biggest possible value! Ma...
How to Create Beautiful Dashboard Background and Tile Design | Ultimate Excel Dashboard Ep. 2
Переглядів 352 тис.4 роки тому
How to Create Beautiful Dashboard Background and Tile Design | Ultimate Excel Dashboard Ep. 2
How to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1
Переглядів 2,3 млн4 роки тому
How to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1
How to create a Morph Animated 3D Carousel Agenda Slide in PowerPoint
Переглядів 272 тис.5 років тому
How to create a Morph Animated 3D Carousel Agenda Slide in PowerPoint
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part III]
Переглядів 64 тис.5 років тому
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part III]
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part II]
Переглядів 71 тис.5 років тому
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part II]
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part I]
Переглядів 206 тис.5 років тому
How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part I]
How to build a Well-Designed and Interactive Excel Dashboard with Pivot Tables and Pivot Charts
Переглядів 1,7 млн5 років тому
How to build a Well-Designed and Interactive Excel Dashboard with Pivot Tables and Pivot Charts
Create A Beautiful Morph Transition Guideline in PowerPoint
Переглядів 465 тис.6 років тому
Create A Beautiful Morph Transition Guideline in PowerPoint
Amazing PowerPoint Dashboard With Dynamic Excel Backend
Переглядів 55 тис.6 років тому
Amazing PowerPoint Dashboard With Dynamic Excel Backend
Mission completed and absolutely worth it. Thank you so much for this, what a wonderful result.
At 2:49:00 I keep getting the #SPILL! error when selecting an especific month. Has anyone been experiencing the same issue?
The Milestone symbol isn't showing up for me like it does at 56.06. The formula gets copied across but no diamond appears. I've tried a few times and not sure what I'm doing wrong. I also don't know how he gets rid of the 0's and 1's to enter a new formula, without deleting the formula in the cells. Currently stuck, if anyone knows, please help. Thanks
how can i use this tool in the real case of mounting the process ?
The formula for "Balance" column in Budget Tracking does not work for me properly. Does anyone else have this problem? The function is the same as in the video: =SUMPRODUCT([Amount], ([Date]<=[@Date])*1, ([Type]<>"Income") * (-1) + ([Type] = "Income")).
I've been using this without a hitch for the past few years. Thank you! However, I've encountered a problem recently. Whenever I add a new category to the income, expenses, or savings, the Dashboard's Period Tracking Balance shows "N/A" while the Period Savings Rate shows a blank percentage. What could be causing this and how do I fix it?
Amazing tutorial! Thanks so much for sharing. I will be using this to actually start keeping up with my budget. One tiny change I'd suggest: 1:26:15 - This formula can be simplified by replacing the third argument in SUMPRODUCT with: 2*([Type]="Income")-1
Honestly it's almost perfect, the only thing I would add is debt tracking.
If we were to buy this document, can 2 people work on this ? As in, can my wife and I both work on this document from seperate systems ?
Guys I"m completely stuck at 1:15:12 of the video! Guess INDIRECT Formula does not work like shown on this tutorial, cant figure it out how!
For the Shift late income, if you also have Expenses/savings that come out after your salary, but before the end of the month, and want these to be counted for the followong month, on the Tracking tab, edit the formula to just read [@Type] and remove ="Income" Then everything, Income, Expenses, Savings, put in SHOULD be shifted if they are dated between the shift late income date and the end of the month
Thanks so much for the video, this was very well taught. I have one question though… for savings I want to have the ability to see the total amount I have added to savings over how ever many years and also be able to deduct money from savings when I need to. Is there a way to add a savings balance? Also… I haven’t finished the whole video yet but if you don’t spend the budgeted amount then does it carry over or go into savings and if not then how can I do that. For example if I budget 100 for food and I only spend 80 then I want there to be some indicator that says I have an extra 20 I can add to savings since I didn’t spend it. Thanks ❤
I am new to Excel and do not know if what I am thinking is viable. Has anybody tried to automate the budget planning section with formulas so that the only part in which you have to enter data is exclusively the budget tracking section, does it make sense?
Amazing work. After finishing it and using it for a while I am considering changing a few things, such as the Budget tracking section, wouldn't it be more efficient to just add the transactions and make them automatically populate in the budget planning section in that way you do not have to enter the same information again and also, let's say that I add 12 different body care - medicine expenses in a single month, I would have to add them up and put them on the Budget planning, I think it would be if the excel just did it automatically. I wonder what others have changed or improved upon this template.
No, that completely defeats the purpose of a budget planner. Your suggestion will just tell you how much you’ve spent in each category, but this is for managing how much you want to spend (ie: your budget)
What if the rank is not available and has been replaced by Rank EQ. and rank Avg. ??
I was wondering if you would may help me with some of the formulas, as they are not working, even though I’ve copied them verbatim from your screen?
thank you very much
2:39:49 I can't use this formula in conditional formatting =AND(display="Plan vs Base"; item_in_base; NOT(item_in plan); type=IR)
Anyone that has a question, or an error, just put the excel line that gives you an error into chatgpt or any AI and ask it to identify what is wrong. Use all your resources not just youtube.
Wow cant say how grateful I am. You Sir have really shown me what is posible. I was able to reproduce your steps and I gotta say 6 hours of amazing information like this IS AMAZING. I appreciate everything!
When i write =IF(is_empty, "",IF(is_header, "Tracked", INDEX($K:$K, MATCH(row_id, $X:$X)))) it returns tracked numbers for income and expenses, but not for savings, its just a blank cell and causes remaining and excess to return #VALUE! in cell as a result. I use the exact same code but doesn't work for savings, why could this be happening? Lost at this point.
I'm half way through this and got stuck at 2:54:30. When i enter the formula it only displays the Total Year Period, when i change to other options i got #N/A. I really appreciate if anyone know how to fix this. This is my first time trying to create something this big and this is the best tutorial i've ever seen on YT. Thank you.
Same for me!! I get the value for Total year and January, but nothing else! @TheOfficeLab ??
Check the Budget Planning tab, and for the months, each one should be =D$5, X, 1 (where is in the number of the month). I had the same issue as you and this fixed it for me. The formula for the month was shifting the column over as well. So I was getting E$5, X, 1 for February. Change this all to D$5 and you SHOULD be ok. Hope it works
OMG I can't believe I did it myself based on your instructions!!! I did not want to buy it because first I wanted to create a version in Polish and second I am cheap. It took me 4xmore time so around 24hrs in total. I watched it in slo-mo to catch up.
Love to heat that ☺ I hope you enjoyed the process and learned a thing or two along the way.
Thank you for you hard work, this template is awesome! I have just one point: at about 1:26:13 the formula for the Balance column in the Budget Tracking table is shown. If I put more than one row for the same date, the balance will change for every row with that specific date, and not scale with every transaction, is this intended?
Excellent and in-depth explanation how to develop a stunning and flexible Project Management Gantt plan in Excel. I learnt so many new tricks and features of Excel that I was not aware of. Well done a comprehensive guide.
Hey everyone! I'm working on the Excel project and at 1:15:00 came across an issue I could use some help with. I'm trying to create a dynamic data validation list that references different tables using the INDIRECT function. The dropdown in one cell lets me select between tables named 'Income,' 'expenses,' and 'savings,' which are set up as named ranges. When I select a table, the INDIRECT function should display the corresponding list, but instead, I’m getting a 'spill error' and the list appears in an array format with curly braces like {"Item1"; "Item2"; "Item3"}. Has anyone experienced this before? Could it be related to how Excel handles dynamic arrays or the way the tables are structured? I'd love to hear your thoughts and any solutions you might suggest!
this doesn't work anymore in 2024. i tried everything, but nothing works.
I'm stuck at 3:24:27 when thr Period is 'Total Year', it works fine... but when it is changed to Months, the tracked and budget columns show #values for some of the rows. Please help.
Same here, just the rows for savings and some on expenses. Managed to fix the expenses ones by not using the autocomplete function and just pasting the formula manually for the tracked and budget columns, but still no luck with the savings...
@theofficelab please help
Can I get this template on a discounted amount because $39.00 is a bit too much FOR ME. I also tried to make the template on my own but after started working not able to get time to put into making it on my own. Please, Help. Thankyou So much!!!!!!!! 🙂🙂🙂🙂
2:40:47 any one can share the formula for this 2019 excel
2:40:47 any can help please. I am stuck here #value error is showing.
Finally made this budget for 2025 to 2034. From next year my money management will go 📈. But the problem is I don't have any income source. 😐
Hey guys, I am facing a problem in 5:05:21. When using the =1*$E$49 formula, it shows a VALUE warning instead of a 1, but idk why. Have someone else faced this issue before, and if so, how did you solved it?
If you are talking about the checkbox. Don't multiply by 1 just reference the cell $E$49 inside the format window cell link option.
Quick question in the Budget Tracking Setup, after finish data validation and the conditional formating for the Amount Column it does not goes to the left. did i miss something?
Thank you for sharing your knowledge. Having a background as a Financial Analys excel was the main tool of my work, however your tutorial has taught me a lot of new things concerning the capabilities of this amazing and powerful tool. I followed you on every step and completed the Template, ready to track my personal finances with style!!! Perhaps it would be a good idea for someone to proceed in further processing of the template so to secure every cell that contains a formula to avoid any modifications by mistake that a user could do.
Fantastic lecture
Hi there, I really enjoyed watching it and thank you so much for such wonderful video. Is there any possible discount ?! and is it editable ?!
hi! is there any excel file available to share with us? anyone ?
How do you add the unicode icons to cell B10? Thank you
Errors are occurring at 02:54. The results appear correct when "Total Year” and “January" is selected, but the error "#N/A" shows up when any other month is selected. The formula I applied is provided below: =IF(OR(is_header,is_empty),"", INDEX('Budget Planning'!$E:$FA,row_id, MATCH(IF(selected_period="Total Year",selected_year,DATE(selected_year,selected_period,1)),'Budget Planning'!$E$9:$FA$9,0) ))
I get the same result! Did you manage to find a fix?
I both it because honestly I have not time to do it so its save my time it’s incredible thank so much its amazing
Hi..can someone help me. At 1:40:00, I don't get the records this year as 3. I got 7600. why is that?
6 hours later and wow. Honestly I've probably learned more about Excel from this UA-cam video than my whole life combined! Can't thank you enough honestly. Here's to a better financial future!
2:05:12 I can not seem to make this formula to work. Does not show current year but 1905 =IF('Budget Dashboard'!$AQ$6="Current Year";YEAR(current_date);'Budget Dashboard'!$AQ$6) can anyone help me with this problem? Thanks edit : Nevermind, just format the cell as General or Number with zero decimal places
after seven days. i finally done. thankyou so much
I finally finished it😅 but do you know how difficult is to do this with all the formulas is Spanish??? Todo mi entorno es en español así que no me quedó de otra que traducir todo.
5:42:33 i have a value of false when selecting the total year on selected_year, what happened and anyone have solution for this?
It took me approx. 1 month to go through your masterpiece tutorial and reproduce the template along with you. I have learned an excellent, well-structured way to work using Excel. Hardly any words can express my gratitude for your efforts. Thank you, Sifu :). Now will go for my production works.
amazing! thanks for share all your knowledge :)
from 02:58:10 I did not understand anything. Also, I am getting errors (#REF!) in tracked_rank, budget_range, budget_rank, comb_rank, comb_rank_range, comb_rank_norm, comb_rank_norm_run_range, comb_rank_unique. Can someone please help with this, I have been stuck here for the past 23 days
Same problem ( #value)
Hi, office lab! Please, can you help me, or maybe someone else who reads my question? Example: I have sheet 1 and sheet 2. In sheet 1 the plan (gantt) with 3 rows with the 3 Id of each task (Task1, Task2 and Task3, and sheet 2 with a table with the tasks that I will repeat In each day, So, every time I repeat each task in different dates it continuous in plan in the same line. Is this possible and if so, how could I do that? Thanks a lot!